using Model;
using Newtonsoft.Json.Linq;
using System;
using Pub_Class;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using WebAPI;
using WebAPI.Models;
namespace WebAPI.Controllers
{
/**
* 委外入库Controller
*/
public class Kf_EntrustInBillController : ApiController
{
public Int64 HDeptID;//部门ID
public Int64 HSupID;//供应商ID
public Int64 HWhID;//仓库ID
public Int64 HSPID;//仓位ID
public string HSupName;
public string HDeptName;
public string HWhName;
public Int64 HInterID;//本单ID
public string HBillNo;
public string HSourceBillNo;
public string HBillType = "1210";//单据类型
public string sBillCode = "ICStockBill";
public string sTranType = "5";
public bool sRedBlueFlag = false;
public bool SourceFlag = false;
//public string sSourceType = "1601";
// public bool sRedBlue = false;
public WebServer webserver = new WebServer();
public DataSet ds = new DataSet();
public ClsGy_BarCodeBill_WMS_Model_View oView = new ClsGy_BarCodeBill_WMS_Model_View();
public ClsKF_PonderationBillMain_Temp model = new ClsKF_PonderationBillMain_Temp();
public ClsKf_ICStockBill_WMS oBar = new Model.ClsKf_ICStockBill_WMS();
private json objJsonResult = new json();
public DAL.ClsCg_POInStockBill BillOld = new DAL.ClsCg_POInStockBill();
public WebS.WebService1 oWebs = new WebS.WebService1();
public WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS();
public SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
public DBUtility.ClsPub.Enum_BillStatus BillStatus;//单据状态（新增，修改，浏览，更新单价，变更）
///
/// 委外入库/扫条码/直接调webservice
///
///
[Route("Kf_EntrustInBill/get_CheckTypeByBarCode_Json")]
[HttpGet]
public Object get_CheckTypeByBarCode_Json(string sCode, Int64 sInterID, string sBillNo, string sMaker, Int64 WhID, Int64 SPID, Double sQty, bool sRedBlue, bool SourceFlag, string sSourceBillNo, string sSourceType, Int64 HOWNERID)
{
//oBar = webserver.get_CheckTypeByBarCode(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, ref DBUtility.ClsPub.sErrInfo);
string sExpressNumber = "";
// get_CheckTypeByBarCode_All
WebSoBar = oWebs.get_CheckTypeByBarCode_All(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, sExpressNumber, ref DBUtility.ClsPub.sErrInfo);
if (WebSoBar == null)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
objJsonResult.data = null;
return objJsonResult;
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
objJsonResult.data = oBar;
return objJsonResult;
}
}
[Route("Kf_EntrustInBill/DisBillEntryList_Mate_Webs_Json")]
[HttpGet]
public object DisBillEntryList_Webs_Json(string HBillType, string sWhere)
{
try
{
ds = webserver.GetKf_PonderationBillMain_TempList(HBillType, sWhere);
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "获取信息成功！";
objJsonResult.data = ds.Tables[0];
return objJsonResult;
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
///
/// 一键扫码 红字
///
///
[Route("Kf_EntrustInBill/get_CheckTypeByBarCode_All_Json")]
[HttpGet]
public Object get_CheckTypeByBarCode_All_Json(string sCode, Int64 sInterID, string sBillNo, string sMaker, Int64 WhID, Int64 SPID, Double sQty, bool sRedBlue, bool SourceFlag, string sSourceBillNo, string sSourceType, Int64 HOWNERID, string sExpressNumber)
{
oBar = webserver.get_CheckTypeByBarCode_All(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, sExpressNumber, ref DBUtility.ClsPub.sErrInfo);
if (oBar == null)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
objJsonResult.data = null;
return objJsonResult;
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
objJsonResult.data = oBar;
return objJsonResult;
}
}
///
/// 委外入库/返回出入库条码临时表/直接调用webservice
///
///
[Route("Kf_EntrustInBill/DisBillEntryList_Webs_Json")]
[HttpGet]
public object DisBillEntryList_Webs_Json(long HBillID, string HBillType, string sWhere)
{
try
{
//ds = webserver.GetKf_PonderationBillMain_Temp(HBillID, HBillType, sWhere);
WebS.WebService1 oWebs = new WebS.WebService1();
ds = oWebs.GetKf_PonderationBillMain_Temp(HBillID, HBillType, sWhere);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！";
objJsonResult.data = null;
return objJsonResult;
//DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "获取信息成功！";
objJsonResult.data = ds.Tables[0];
return objJsonResult;
}
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
///
/// 生成委外入库单
///
///
[Route("Kf_EntrustInBill/set_SaveEntrustInBill_Json")]
[HttpPost]
public object set_SaveEntrustInBill_Json([FromBody] JObject oMain)
{
var _value = oMain["oMain"].ToString();
string msg1 = _value.ToString();
try
{
List lsmain = new List();
ListModels oListModels = new ListModels();
lsmain = oListModels.getEntrustInBillMainByJson(msg1);
lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));
lsmain[0].HBillType = "1210";
WebAPI.WebS.ClsKf_EntrustInBillMain websLsmain = new WebS.ClsKf_EntrustInBillMain();
websLsmain.HInterID = lsmain[0].HInterID;
websLsmain.HInnerBillNo = "";
websLsmain.HDate = lsmain[0].HDate;
websLsmain.HBillNo = lsmain[0].HBillNo;
websLsmain.HBillType = lsmain[0].HBillType;
websLsmain.HBillerID = DBUtility.ClsPub.isLong(DBUtility.ClsPub.CurUserID);
websLsmain.HDeptID = lsmain[0].HDeptID;
websLsmain.HEmpID = lsmain[0].HEmpID;
websLsmain.HRemark = "";
websLsmain.HRedBlueFlag = lsmain[0].HRedBlueFlag;
websLsmain.HMaker = lsmain[0].HMaker;
websLsmain.HSupID = lsmain[0].HSupID;
websLsmain.HSecManagerID = lsmain[0].HSecManagerID;
websLsmain.HSCWHID = lsmain[0].HSCWHID;
websLsmain.HKeeperID = lsmain[0].HKeeperID;
websLsmain.HMainSourceBillType = "1103";
websLsmain.HMangerID = lsmain[0].HMangerID;
websLsmain.HWHID = lsmain[0].HWHID;
websLsmain.HExplanation = "";
string sSourceBillType = "1103";
if (webserver.set_SaveEntrustInBill_New(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo))
{
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "生成委外入库单成功！单据号为：";
objJsonResult.data = null;
return objJsonResult;
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "上传失败！" + DBUtility.ClsPub.sErrInfo;
objJsonResult.data = websLsmain;
return objJsonResult;
}
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "上传失败！异常" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
///
/// 委外入库/提交/直接调用webservice
///
///
[Route("Kf_EntrustInBill/set_SaveEntrustInBill_New_Json")]
[HttpPost]
public object set_SaveEntrustInBill_New_Json([FromBody] JObject oMain)
{
var _value = oMain["oMain"].ToString();
string msg1 = _value.ToString();
try
{
List lsmain = new List();
ListModels oListModels = new ListModels();
lsmain = oListModels.getEntrustInBillMainByJson(msg1);
lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));
lsmain[0].HBillType = "1210";
WebAPI.WebS.ClsKf_EntrustInBillMain websLsmain = new WebS.ClsKf_EntrustInBillMain();
websLsmain.HInterID = lsmain[0].HInterID;
websLsmain.HInnerBillNo = "";
websLsmain.HDate = lsmain[0].HDate;
websLsmain.HBillNo = lsmain[0].HBillNo;
websLsmain.HBillType = lsmain[0].HBillType;
websLsmain.HBillerID = lsmain[0].HBillerID;
websLsmain.HDeptID = lsmain[0].HDeptID;
websLsmain.HEmpID = lsmain[0].HEmpID;
websLsmain.HRemark = "";
websLsmain.HRedBlueFlag = lsmain[0].HRedBlueFlag;
websLsmain.HMaker = lsmain[0].HMaker;
websLsmain.HSupID = lsmain[0].HSupID;
websLsmain.HSecManagerID = lsmain[0].HSecManagerID;
websLsmain.HSCWHID = lsmain[0].HSCWHID;
websLsmain.HKeeperID = lsmain[0].HKeeperID;
websLsmain.HMainSourceBillType = "1103";
websLsmain.HMangerID = lsmain[0].HMangerID;
websLsmain.HWHID = lsmain[0].HWHID;
websLsmain.HExplanation = lsmain[0].HExplanation;
string sSourceBillType = "1103";
if (webserver.set_SaveEntrustInBill_New(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //成功！
//objJsonResult.Message = "生成委外入库单成功！单据号为：";
objJsonResult.data = null;
return objJsonResult;
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //失败！
//objJsonResult.Message = "上传失败！" + DBUtility.ClsPub.sErrInfo;
objJsonResult.data = websLsmain;
return objJsonResult;
}
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "上传失败！异常" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
///
/// 委外入库 扫描源单，将源单信息写入条码临时表
///
///
///
[Route("Kf_EntrustInBill/set_SavePonderationBillMain_Temp_Source_Fast_Json")]
[HttpGet]
public object set_SavePonderationBillMain_Temp_Source_Fast_Json(string HSourceBillType, string HSourceBillNo, Int64 sInterID, string sBillNo)
{
try
{
// DataSet ds = new DataSet();
// WebServer webserver = new WebServer();
string sWhere = " Where 单据号 like '%" + HSourceBillNo.Trim() + "%'";
//if (HSourceBillType == "1601")
//{
if (HSourceBillType == "1103")
{
//ds = webserver.GetWW_WWOrderBillList (sWhere + " ");
ds = webserver.GetCg_PoInStockBillList(sWhere + " and isnull(HBillSubType,0)=12511 ");
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录,源单类型有错误！";
objJsonResult.data = null;
return objJsonResult; ;
}
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！";
objJsonResult.data = null;
return objJsonResult;
//DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
}
else
{
HSupID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HSupID"]);
HSupName = Convert.ToString(ds.Tables[0].Rows[0]["HSupName"]);
HDeptID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HDeptID"]);
HDeptName = Convert.ToString(ds.Tables[0].Rows[0]["HDeptName"]);
if (webserver.set_SavePonderationBillMain_Temp_Source_Fast(sInterID, sBillNo, HBillType, HSourceBillNo, HSourceBillType, "蓝字", ref DBUtility.ClsPub.sErrInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "返回记录成功！";
objJsonResult.data = ds.Tables[0];
return objJsonResult;
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "写入临时表失败！" + DBUtility.ClsPub.sErrInfo;
objJsonResult.data = null;
return objJsonResult;
}
}
}
catch (Exception ex)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
///
/// 生成委外入库单(红字)
///
///
[Route("Kf_EntrustInBill/set_SaveEntrustInBackBill_Json")]
[HttpPost]
public object set_SaveEntrustInBackBill_Json([FromBody] JObject oMain)
{
var _value = oMain["oMain"].ToString();
string msg1 = _value.ToString();
try
{
List lsmain = new List();
ListModels oListModels = new ListModels();
lsmain = oListModels.getICStockBillMainByJson(msg1);
lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));
string sSourceBillType = lsmain[0].HBillType;
WebAPI.WebS.ClsKf_ICStockBillMain websLsmain = new WebS.ClsKf_ICStockBillMain();
websLsmain.HInterID = lsmain[0].HInterID;
websLsmain.HDate = lsmain[0].HDate;
websLsmain.HBillNo = lsmain[0].HBillNo;
websLsmain.HDeptID = lsmain[0].HDeptID;
websLsmain.HEmpID = lsmain[0].HEmpID;
websLsmain.HRemark = lsmain[0].HRemark;
websLsmain.HMaker = lsmain[0].HMaker;
if (webserver.set_SaveEntrustInBackBill_New(websLsmain, "-1", ref DBUtility.ClsPub.sErrInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //成功！
//objJsonResult.Message = "生成委外入库(红字)单成功！单据号为：";
objJsonResult.data = null;
return objJsonResult;
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //失败！
//objJsonResult.Message = "上传失败！" + DBUtility.ClsPub.sErrInfo;
objJsonResult.data = null;
return objJsonResult;
}
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "上传失败！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#region 委外加工入库单
public DAL.ClsKf_EntrustInBill BillIn = new DAL.ClsKf_EntrustInBill();
public DAL.ClsKf_EntrustOutBill BillOut = new DAL.ClsKf_EntrustOutBill();
#region 委外入库单列表
[Route("Kf_EntrustInBill/GetEntrustInBill1")]
[HttpGet]
public object GetEntrustInBill(string sWhere, string user)
{
try
{
//判断是否有查询权限
if (!DBUtility.ClsPub.Security_Log("Kf_EntrustInBillQuery", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "无权限查询!";
objJsonResult.data = null;
return objJsonResult;
}
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("select * from h_v_Kf_EntrustInBillList where 1=1 order by hmainid desc", "h_v_Kf_EntrustInBillList");
}
else
{
string sql = "select * from h_v_Kf_EntrustInBillList where 1 = 1 " + sWhere + " order by hmainid desc";
ds = oCN.RunProcReturn(sql, "h_v_Kf_EntrustInBillList");
}
//if (ds.Tables[0].Rows.Count != 0 || ds != null)
//{
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "Sucess！";
objJsonResult.data = ds.Tables[0];
return objJsonResult;
//}
//else
//{
//objJsonResult.code = "0";
//objJsonResult.count = 0;
//objJsonResult.Message = "无数据";
//objJsonResult.data = null;
//return objJsonResult;
//}
}
catch (Exception ex)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#endregion
#region 委外入库单列表 获取编辑列表数据
///
/// 获取编辑列表数据
///
///
///
///
[Route("Kf_EntrustInBill/GetEntrustInBillDetail")]
[HttpGet]
public object GetEntrustInBillDetail(long HInterID, string User)
{
try
{
List tableList = new List();
//查看权限
if (!DBUtility.ClsPub.Security_Log("Kf_EntrustInBill_Edit", 1, false, User))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "查询失败!";
objJsonResult.data = null;
return objJsonResult;
}
if (HInterID == null || HInterID.Equals(""))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "HInterID不能为空！";
objJsonResult.data = null;
return objJsonResult;
}
ds = oCN.RunProcReturn("exec h_p_Kf_ICStockBillAll_Edit " + HInterID, "h_p_Kf_ICStockBillAll_Edit");
tableList.Add(ds.Tables[0]);
tableList.Add(ds.Tables[1]);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "false！";
objJsonResult.data = null;
return objJsonResult;
}
else
{
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "Sucess！";
objJsonResult.data = tableList;
return objJsonResult;
}
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "Exception！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#endregion
#region 委外加工入库单 删除
///
[Route("Kf_EntrustInBill/DeleteKf_EntrustInBill")]
[HttpGet]
public object DeleteKf_EntrustInBill(string HInterID, string user)
{
try
{
string s = "";
DAL.ClsKf_EntrustInBill oBill = new DAL.ClsKf_EntrustInBill();
//查看权限
if (!DBUtility.ClsPub.Security_Log("Kf_EntrustInBill_Drop", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "无删除权限！";
objJsonResult.data = null;
return objJsonResult;
}
if (HInterID == null || HInterID.Equals(""))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "HInterID不能为空！";
objJsonResult.data = null;
return objJsonResult;
}
if (oBill.ShowBill(long.Parse(HInterID), ref s) == false)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "此单据有误！";
objJsonResult.data = 1;
return objJsonResult;
}
//判断是否可编辑
if (oBill.omodel.HChecker != "" && oBill.omodel.HChecker != null)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "此单据已经被审核，不允许删除！";
objJsonResult.data = 1;
return objJsonResult;
}
//进行 会计期间 结账 的判断和控制
int sYear = 0;
int sPeriod = 0;
DateTime HDate = DateTime.Now;
if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
{
objJsonResult.Message = s;
return objJsonResult;
}
oCN.BeginTran();
oCN.RunProc("delete from Kf_ICStockBillMain where HInterID = " + HInterID);
oCN.RunProc("delete from Kf_ICStockBillSub where HInterID= " + HInterID);
oCN.Commit();
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "删除成功";
objJsonResult.data = null;
return objJsonResult;
}
catch (Exception e)
{
oCN.RollBack();
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "Exception！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#endregion
#region 委外加工入库单 审核/反审核
///
///
///
/// 单据ID
/// 审核(1),反审核(2)
/// 审核人
///
[Route("Kf_EntrustInBill/AuditKf_EntrustInBill")]
[HttpGet]
public object AuditKf_EntrustInBill(string HInterID, int Type, string user)
{
try
{
//判断是否有审核权限
if (!DBUtility.ClsPub.Security_Log("Kf_EntrustInBill_Check", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "无权限审核!";
objJsonResult.data = null;
return objJsonResult;
}
if (string.IsNullOrWhiteSpace(HInterID))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "HInterID为空！";
objJsonResult.data = null;
return objJsonResult;
}
//进行 会计期间 结账 的判断和控制
string s = "";
int sYear = 0;
int sPeriod = 0;
DateTime HDate = DateTime.Now;
if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
{
objJsonResult.Message = s;
return objJsonResult;
}
DAL.ClsKf_EntrustInBill oBill = new DAL.ClsKf_EntrustInBill();
ClsPub.CurUserName = user;
oBill.MvarItemKey = "Kf_ICStockBillMain";
oCN.BeginTran();//开始事务
//Type 1 审核 2 反审核
if (Type == 1)
{
//判断单据是否已经审核
DataSet ds;
string sql = "select * from " + oBill.MvarItemKey + " where HinterID = " + HInterID;
ds = oCN.RunProcReturn(sql, oBill.MvarItemKey);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据不存在！";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["HCloseMan"] != null && ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已关闭!不能再次审核！";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已作废!不能再次审核！";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已审核!不能再次审核！";
objJsonResult.data = null;
return objJsonResult;
}
//审核单据
if (!oBill.CheckBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;
objJsonResult.data = null;
return objJsonResult;
}
}
}
else
{
//判断单据是否已经反审核
DataSet ds;
string sql = "select * from " + oBill.MvarItemKey + " where HinterID = " + HInterID;
ds = oCN.RunProcReturn(sql, oBill.MvarItemKey);
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["HCloseMan"] != null && ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已关闭!不能进行反审核！";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已作废!不能进行反审核！";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0].Rows[0]["HChecker"] == null || ds.Tables[0].Rows[0]["HChecker"].ToString() == "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据未审核!不需要反审核!";
objJsonResult.data = null;
return objJsonResult;
}
//反审核单据
if (!oBill.AbandonCheck(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "反审核失败!原因:" + ClsPub.sExeReturnInfo;
objJsonResult.data = null;
return objJsonResult;
}
}
}
oCN.Commit();//提交事务
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "执行成功！";
objJsonResult.data = null;
return objJsonResult; ;
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "执行失败！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#endregion
#region 委外加工入库单 关闭/反关闭功能
[Route("Kf_EntrustInBill/CloseKf_EntrustInBill")]
[HttpGet]
public object CloseKf_EntrustInBill(string HInterID, int Type, string user)
{
try
{
//判断是否有删除权限
if (!DBUtility.ClsPub.Security_Log("Kf_EntrustInBill_Close", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "无权限关闭!";
objJsonResult.data = null;
return objJsonResult;
}
if (string.IsNullOrWhiteSpace(HInterID))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "HInterID为空！";
objJsonResult.data = null;
return objJsonResult;
}
ClsPub.CurUserName = user;
DAL.ClsKf_EntrustInBill oBill = new DAL.ClsKf_EntrustInBill();
oBill.MvarItemKey = "Kf_ICStockBillMain";
oCN.BeginTran();//开始事务
//Type 1 关闭 2 反关闭
if (Type == 1)
{
//判断单据是否已经关闭
DataSet ds;
string sql = "select * from " + oBill.MvarItemKey + " where HinterID = " + HInterID;
ds = oCN.RunProcReturn(sql, oBill.MvarItemKey);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据不存在！";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已作废!不能进行关闭!";
objJsonResult.data = null;
return objJsonResult;
}
//if (ds.Tables[0].Rows[0]["HChecker"] == null || ds.Tables[0].Rows[0]["HChecker"].ToString() == "")
//{
// objJsonResult.code = "0";
// objJsonResult.count = 0;
// objJsonResult.Message = "单据未审核!不能进行关闭!";
// objJsonResult.data = null;
// return objJsonResult;
//}
if (ds.Tables[0].Rows[0]["HCloseMan"] != null && ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已关闭!不能再次关闭!";
objJsonResult.data = null;
return objJsonResult;
}
//关闭单据
if (!oBill.CloseBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "关闭失败!原因:" + ClsPub.sExeReturnInfo;
objJsonResult.data = null;
return objJsonResult;
}
}
}
else
{
//判断单据是否已经反关闭
DataSet ds;
string sql = "select * from " + oBill.MvarItemKey + " where HinterID = " + HInterID;
ds = oCN.RunProcReturn(sql, oBill.MvarItemKey);
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已作废!不能进行关闭!";
objJsonResult.data = null;
return objJsonResult;
}
//if (ds.Tables[0].Rows[0]["HChecker"] == null || ds.Tables[0].Rows[0]["HChecker"].ToString() == "")
//{
// objJsonResult.code = "0";
// objJsonResult.count = 0;
// objJsonResult.Message = "单据未审核!不能进行关闭!";
// objJsonResult.data = null;
// return objJsonResult;
//}
if (ds.Tables[0].Rows[0]["HCloseMan"] == null || ds.Tables[0].Rows[0]["HCloseMan"].ToString() == "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据未关闭!不需要再反关闭!";
objJsonResult.data = null;
return objJsonResult;
}
//反关闭单据
if (!oBill.CancelClose(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "反关闭失败!原因:" + ClsPub.sExeReturnInfo;
objJsonResult.data = null;
return objJsonResult;
}
}
}
oCN.Commit();//提交事务
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "执行成功！";
objJsonResult.data = null;
return objJsonResult; ;
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "执行失败！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#endregion
#region 委外加工入库单 作废/反作废功能
[Route("Kf_EntrustInBill/DropKf_EntrustInBill")]
[HttpGet]
public object DropKf_EntrustInBill(string HInterID, int Type, string user)
{
try
{
//判断是否有作废权限
if (!DBUtility.ClsPub.Security_Log("Kf_EntrustInBill_Drop", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "无权限作废!";
objJsonResult.data = null;
return objJsonResult;
}
if (string.IsNullOrWhiteSpace(HInterID))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "HInterID为空！";
objJsonResult.data = null;
return objJsonResult;
}
ClsPub.CurUserName = user;
DAL.ClsKf_EntrustInBill oBill = new DAL.ClsKf_EntrustInBill();
oBill.MvarItemKey = "Kf_ICStockBillMain";
oCN.BeginTran();//开始事务
//Type 1 作废 2 反作废
if (Type == 1)
{
//判断单据是否已经作废
DataSet ds;
string sql = "select * from " + oBill.MvarItemKey + " where HinterID = " + HInterID;
ds = oCN.RunProcReturn(sql, oBill.MvarItemKey);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据不存在！";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已审核!不能进行作废!";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已作废!不需要再作废!";
objJsonResult.data = null;
return objJsonResult;
}
//作废单据
if (!oBill.Cancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "作废失败!原因:" + ClsPub.sExeReturnInfo;
objJsonResult.data = null;
return objJsonResult;
}
}
}
else
{
//判断单据是否已经反作废
DataSet ds;
string sql = "select * from " + oBill.MvarItemKey + " where HinterID = " + HInterID;
ds = oCN.RunProcReturn(sql, oBill.MvarItemKey);
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已审核!不能进行作废!";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0].Rows[0]["HDeleteMan"] == null || ds.Tables[0].Rows[0]["HDeleteMan"].ToString() == "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据未作废!不需要再反作废!";
objJsonResult.data = null;
return objJsonResult;
}
//反作废单据
if (!oBill.AbandonCancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "反作废失败!原因:" + ClsPub.sExeReturnInfo;
objJsonResult.data = null;
return objJsonResult;
}
}
}
oCN.Commit();//提交事务
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "执行成功！";
objJsonResult.data = null;
return objJsonResult; ;
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "执行失败！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#endregion
#region 委外加工入库单 保存/编辑
///
/// 委外加工入库单
///
///
///
[Route("Kf_EntrustInBill/SaveKf_EntrustInBill")]
[HttpPost]
public object SaveKf_EntrustInBill([FromBody] JObject sMainSub)
{
var _value = sMainSub["sMainSub"].ToString();
string msg1 = _value.ToString();
string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
string msg2 = sArray[0].ToString();
string msg3 = sArray[1].ToString(); //子表
string refSav = sArray[2].ToString();//操作方式数据类型 1添加 3修改 2 复制
string user = sArray[3].ToString();//用户名
string UserName = "";
string s = "";
ListModels oListModels = new ListModels();
try
{
//保存权限
if (!DBUtility.ClsPub.Security_Log_second("Kf_EntrustInBill_Edit", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！无权限！";
objJsonResult.data = null;
return objJsonResult;
}
DAL.ClsKf_EntrustInBill oBill = new DAL.ClsKf_EntrustInBill();
List lsmain = new List();
msg2 = msg2.Replace("\\", "");
msg2 = msg2.Replace("\n", ""); //\n
//序列化主表数据
var jsonString = "[" + msg2.ToString() + "]";
lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject>(jsonString);
foreach (Model.ClsKf_EntrustInBillMain oItem in lsmain)
{
if (refSav == "Add")
{
//单据号是否重复
if (BillIn.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据号重复！不允许保存！";
objJsonResult.data = 1;
return objJsonResult;
}
}
if (refSav == "Update")
{
if (BillIn.ShowBill(oItem.HInterID, ref s) == false)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "此单据有误！";
objJsonResult.data = 1;
return objJsonResult;
}
//判断是否可编辑
if (BillIn.omodel.HChecker != "" && BillIn.omodel.HChecker != null)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "此单据已经被审核，不允许修改！";
objJsonResult.data = 1;
return objJsonResult;
}
if (BillIn.omodel.HBillStatus > 1)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "此单据处于不可编辑状态，不允许修改！";
objJsonResult.data = 1;
return objJsonResult;
}
}
UserName = oItem.HMaker; //制单人
oItem.HBillType = "1210";
oItem.HBillSubType = "1210";
//oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
oItem.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month);
oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
objJsonResult.data = 1;
return objJsonResult;
}
oBill.omodel = oItem;
}
// 表体数据
//按 },{来拆分数组 //去掉【和】
msg3 = msg3.Substring(1, msg3.Length - 2);
msg3 = msg3.Replace("\\", "");
msg3 = msg3.Replace("\n", ""); //\n
List ls = new List();
jsonString = "[" + msg3.ToString() + "]";
ls = Newtonsoft.Json.JsonConvert.DeserializeObject>(jsonString);
int i = 0;
foreach (Model.ClsKf_EntrustInBillSub oItemSub in ls)
{
i++;
oItemSub.HEntryID = i;
oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
oItemSub.HCloseType = false; //关闭类型
oBill.DetailColl.Add(oItemSub);
}
//保存
//保存完毕后处理
bool bResult;
if (refSav == "Add")
{
bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
}
else if (refSav == "Update")
{
bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
}
else
{
bResult = false;
}
if (bResult)
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "保存成功！";
objJsonResult.data = 1;
return objJsonResult;
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
objJsonResult.data = 1;
return objJsonResult;
}
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！" + e.ToString();
objJsonResult.data = 1;
return objJsonResult;
}
}
#endregion
#endregion
#region 委外加工出库单
#region 委外加工出库单列表
[Route("Kf_EntrustOutBill/GetEntrustOutBill")]
[HttpGet]
public object GetEntrustOutBill(string sWhere, string user)
{
try
{
//判断是否有查询权限
if (!DBUtility.ClsPub.Security_Log("Kf_EntrustOutBillQuery", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "无权限查询!";
objJsonResult.data = null;
return objJsonResult;
}
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("select * from h_v_Kf_EntrustOutBillList where 1=1 order by hmainid desc", "h_v_Kf_EntrustOutBillList");
}
else
{
string sql = "select * from h_v_Kf_EntrustOutBillList where 1 = 1 " + sWhere + " order by hmainid desc";
ds = oCN.RunProcReturn(sql, "h_v_Kf_EntrustOutBillList");
}
//if (ds.Tables[0].Rows.Count != 0 || ds != null)
//{
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "Sucess！";
objJsonResult.data = ds.Tables[0];
return objJsonResult;
//}
//else
//{
//objJsonResult.code = "0";
//objJsonResult.count = 0;
//objJsonResult.Message = "无数据";
//objJsonResult.data = null;
//return objJsonResult;
//}
}
catch (Exception ex)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#endregion
#region 委外出库单列表 获取编辑列表数据
///
/// 获取编辑列表数据
///
///
///
///
[Route("Kf_EntrustOutBill/GetEntrustOutBillDetail")]
[HttpGet]
public object GetEntrustOutBillDetail(long HInterID, string User)
{
try
{
List tableList = new List();
//查看权限
if (!DBUtility.ClsPub.Security_Log("Kf_EntrustOutBill_Edit", 1, false, User))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "查询失败!";
objJsonResult.data = null;
return objJsonResult;
}
if (HInterID == null || HInterID.Equals(""))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "HInterID不能为空！";
objJsonResult.data = null;
return objJsonResult;
}
ds = oCN.RunProcReturn("exec h_p_Kf_ICStockBillAll_Edit " + HInterID, "h_p_Kf_ICStockBillAll_Edit");
tableList.Add(ds.Tables[0]);
tableList.Add(ds.Tables[1]);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "false！";
objJsonResult.data = null;
return objJsonResult;
}
else
{
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "Sucess！";
objJsonResult.data = tableList;
return objJsonResult;
}
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "Exception！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#endregion
#region 委外加工出库单 删除
///
[Route("Kf_EntrustOutBill/DeleteKf_EntrustOutBill")]
[HttpGet]
public object DeleteKf_EntrustOutBill(string HInterID, string user)
{
try
{
string s = "";
DAL.ClsKf_EntrustOutBill oBill = new DAL.ClsKf_EntrustOutBill();
//查看权限
if (!DBUtility.ClsPub.Security_Log("Kf_EntrustOutBill_Drop", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "无删除权限！";
objJsonResult.data = null;
return objJsonResult;
}
if (HInterID == null || HInterID.Equals(""))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "HInterID不能为空！";
objJsonResult.data = null;
return objJsonResult;
}
if (oBill.ShowBill(long.Parse(HInterID), ref s) == false)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "此单据有误！";
objJsonResult.data = 1;
return objJsonResult;
}
//判断是否可编辑
if (oBill.omodel.HChecker != "" && oBill.omodel.HChecker != null)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "此单据已经被审核，不允许删除！";
objJsonResult.data = 1;
return objJsonResult;
}
//进行 会计期间 结账 的判断和控制
int sYear = 0;
int sPeriod = 0;
DateTime HDate = DateTime.Now;
if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
{
objJsonResult.Message = s;
return objJsonResult;
}
oCN.BeginTran();
oCN.RunProc("delete from Kf_ICStockBillMain where HInterID = " + HInterID);
oCN.RunProc("delete from Kf_ICStockBillSub where HInterID= " + HInterID);
oCN.Commit();
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "删除成功";
objJsonResult.data = null;
return objJsonResult;
}
catch (Exception e)
{
oCN.RollBack();
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "Exception！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#endregion
#region 委外加工出库单 审核/反审核
///
///
///
/// 单据ID
/// 审核(1),反审核(2)
/// 审核人
///
[Route("Kf_EntrustOutBill/AuditKf_EntrustOutBill")]
[HttpGet]
public object AuditKf_EntrustOutBill(string HInterID, int Type, string user)
{
try
{
//判断是否有审核权限
if (!DBUtility.ClsPub.Security_Log("Kf_EntrustOutBill_Check", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "无权限审核!";
objJsonResult.data = null;
return objJsonResult;
}
if (string.IsNullOrWhiteSpace(HInterID))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "HInterID为空！";
objJsonResult.data = null;
return objJsonResult;
}
//进行 会计期间 结账 的判断和控制
string s = "";
int sYear = 0;
int sPeriod = 0;
DateTime HDate = DateTime.Now;
if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
{
objJsonResult.Message = s;
return objJsonResult;
}
DAL.ClsKf_EntrustOutBill oBill = new DAL.ClsKf_EntrustOutBill();
ClsPub.CurUserName = user;
oBill.MvarItemKey = "Kf_ICStockBillMain";
oCN.BeginTran();//开始事务
//Type 1 审核 2 反审核
if (Type == 1)
{
//判断单据是否已经审核
DataSet ds;
string sql = "select * from " + oBill.MvarItemKey + " where HinterID = " + HInterID;
ds = oCN.RunProcReturn(sql, oBill.MvarItemKey);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据不存在！";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["HCloseMan"] != null && ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已关闭!不能再次审核！";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已作废!不能再次审核！";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已审核!不能再次审核！";
objJsonResult.data = null;
return objJsonResult;
}
//审核单据
if (!oBill.CheckBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;
objJsonResult.data = null;
return objJsonResult;
}
}
}
else
{
//判断单据是否已经反审核
DataSet ds;
string sql = "select * from " + oBill.MvarItemKey + " where HinterID = " + HInterID;
ds = oCN.RunProcReturn(sql, oBill.MvarItemKey);
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["HCloseMan"] != null && ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已关闭!不能进行反审核！";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已作废!不能进行反审核！";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0].Rows[0]["HChecker"] == null || ds.Tables[0].Rows[0]["HChecker"].ToString() == "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据未审核!不需要反审核!";
objJsonResult.data = null;
return objJsonResult;
}
//反审核单据
if (!oBill.AbandonCheck(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "反审核失败!原因:" + ClsPub.sExeReturnInfo;
objJsonResult.data = null;
return objJsonResult;
}
}
}
oCN.Commit();//提交事务
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "执行成功！";
objJsonResult.data = null;
return objJsonResult; ;
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "执行失败！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#endregion
#region 委外加工出库单 关闭/反关闭功能
[Route("Kf_EntrustOutBill/CloseKf_EntrustOutBill")]
[HttpGet]
public object CloseKf_EntrustOutBill(string HInterID, int Type, string user)
{
try
{
//判断是否有删除权限
if (!DBUtility.ClsPub.Security_Log("Kf_EntrustOutBill_Close", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "无权限关闭!";
objJsonResult.data = null;
return objJsonResult;
}
if (string.IsNullOrWhiteSpace(HInterID))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "HInterID为空！";
objJsonResult.data = null;
return objJsonResult;
}
ClsPub.CurUserName = user;
DAL.ClsKf_EntrustOutBill oBill = new DAL.ClsKf_EntrustOutBill();
oBill.MvarItemKey = "Kf_ICStockBillMain";
oCN.BeginTran();//开始事务
//Type 1 关闭 2 反关闭
if (Type == 1)
{
//判断单据是否已经关闭
DataSet ds;
string sql = "select * from " + oBill.MvarItemKey + " where HinterID = " + HInterID;
ds = oCN.RunProcReturn(sql, oBill.MvarItemKey);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据不存在！";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已作废!不能进行关闭!";
objJsonResult.data = null;
return objJsonResult;
}
//if (ds.Tables[0].Rows[0]["HChecker"] == null || ds.Tables[0].Rows[0]["HChecker"].ToString() == "")
//{
// objJsonResult.code = "0";
// objJsonResult.count = 0;
// objJsonResult.Message = "单据未审核!不能进行关闭!";
// objJsonResult.data = null;
// return objJsonResult;
//}
if (ds.Tables[0].Rows[0]["HCloseMan"] != null && ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已关闭!不能再次关闭!";
objJsonResult.data = null;
return objJsonResult;
}
//关闭单据
if (!oBill.CloseBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "关闭失败!原因:" + ClsPub.sExeReturnInfo;
objJsonResult.data = null;
return objJsonResult;
}
}
}
else
{
//判断单据是否已经反关闭
DataSet ds;
string sql = "select * from " + oBill.MvarItemKey + " where HinterID = " + HInterID;
ds = oCN.RunProcReturn(sql, oBill.MvarItemKey);
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已作废!不能进行关闭!";
objJsonResult.data = null;
return objJsonResult;
}
//if (ds.Tables[0].Rows[0]["HChecker"] == null || ds.Tables[0].Rows[0]["HChecker"].ToString() == "")
//{
// objJsonResult.code = "0";
// objJsonResult.count = 0;
// objJsonResult.Message = "单据未审核!不能进行关闭!";
// objJsonResult.data = null;
// return objJsonResult;
//}
if (ds.Tables[0].Rows[0]["HCloseMan"] == null || ds.Tables[0].Rows[0]["HCloseMan"].ToString() == "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据未关闭!不需要再反关闭!";
objJsonResult.data = null;
return objJsonResult;
}
//反关闭单据
if (!oBill.CancelClose(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "反关闭失败!原因:" + ClsPub.sExeReturnInfo;
objJsonResult.data = null;
return objJsonResult;
}
}
}
oCN.Commit();//提交事务
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "执行成功！";
objJsonResult.data = null;
return objJsonResult; ;
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "执行失败！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#endregion
#region 委外加工出库单 作废/反作废功能
[Route("Kf_EntrustOutBill/DropKf_EntrustOutBill")]
[HttpGet]
public object DropKf_EntrustOutBill(string HInterID, int Type, string user)
{
try
{
//判断是否有作废权限
if (!DBUtility.ClsPub.Security_Log("Kf_EntrustOutBill_Drop", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "无权限作废!";
objJsonResult.data = null;
return objJsonResult;
}
if (string.IsNullOrWhiteSpace(HInterID))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "HInterID为空！";
objJsonResult.data = null;
return objJsonResult;
}
ClsPub.CurUserName = user;
DAL.ClsKf_EntrustOutBill oBill = new DAL.ClsKf_EntrustOutBill();
oBill.MvarItemKey = "Kf_ICStockBillMain";
oCN.BeginTran();//开始事务
//Type 1 作废 2 反作废
if (Type == 1)
{
//判断单据是否已经作废
DataSet ds;
string sql = "select * from " + oBill.MvarItemKey + " where HinterID = " + HInterID;
ds = oCN.RunProcReturn(sql, oBill.MvarItemKey);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据不存在！";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已审核!不能进行作废!";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已作废!不需要再作废!";
objJsonResult.data = null;
return objJsonResult;
}
//作废单据
if (!oBill.Cancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "作废失败!原因:" + ClsPub.sExeReturnInfo;
objJsonResult.data = null;
return objJsonResult;
}
}
}
else
{
//判断单据是否已经反作废
DataSet ds;
string sql = "select * from " + oBill.MvarItemKey + " where HinterID = " + HInterID;
ds = oCN.RunProcReturn(sql, oBill.MvarItemKey);
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据已审核!不能进行作废!";
objJsonResult.data = null;
return objJsonResult;
}
if (ds.Tables[0].Rows[0]["HDeleteMan"] == null || ds.Tables[0].Rows[0]["HDeleteMan"].ToString() == "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据未作废!不需要再反作废!";
objJsonResult.data = null;
return objJsonResult;
}
//反作废单据
if (!oBill.AbandonCancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "反作废失败!原因:" + ClsPub.sExeReturnInfo;
objJsonResult.data = null;
return objJsonResult;
}
}
}
oCN.Commit();//提交事务
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "执行成功！";
objJsonResult.data = null;
return objJsonResult; ;
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "执行失败！" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#endregion
#region 委外加工出库单 保存/编辑
///
/// 委外加工出库单
///
///
///
[Route("Kf_EntrustOutBill/SaveKf_EntrustOutBill")]
[HttpPost]
public object SaveKf_EntrustOutBill([FromBody] JObject sMainSub)
{
var _value = sMainSub["sMainSub"].ToString();
string msg1 = _value.ToString();
string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
string msg2 = sArray[0].ToString();
string msg3 = sArray[1].ToString(); //子表
string refSav = sArray[2].ToString();//操作方式数据类型 1添加 3修改 2 复制
string user = sArray[3].ToString();//用户名
string UserName = "";
string s = "";
ListModels oListModels = new ListModels();
try
{
//保存权限
if (!DBUtility.ClsPub.Security_Log_second("Kf_EntrustOutBill_Edit", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！无权限！";
objJsonResult.data = null;
return objJsonResult;
}
DAL.ClsKf_EntrustOutBill oBill = new DAL.ClsKf_EntrustOutBill();
List lsmain = new List();
msg2 = msg2.Replace("\\", "");
msg2 = msg2.Replace("\n", ""); //\n
//序列化主表数据
var jsonString = "[" + msg2.ToString() + "]";
lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject>(jsonString);
foreach (Model.ClsKf_EntrustOutBillMain oItem in lsmain)
{
if (refSav == "Add")
{
//单据号是否重复
if (BillOut.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "单据号重复！不允许保存！";
objJsonResult.data = 1;
return objJsonResult;
}
}
if (refSav == "Update")
{
if (BillOut.ShowBill(oItem.HInterID, ref s) == false)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "此单据有误！";
objJsonResult.data = 1;
return objJsonResult;
}
//判断是否可编辑
if (BillOut.omodel.HChecker != "" && BillIn.omodel.HChecker != null)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "此单据已经被审核，不允许修改！";
objJsonResult.data = 1;
return objJsonResult;
}
if (BillOut.omodel.HBillStatus > 1)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "此单据处于不可编辑状态，不允许修改！";
objJsonResult.data = 1;
return objJsonResult;
}
}
UserName = oItem.HMaker; //制单人
oItem.HBillType = "1211";
oItem.HBillSubType = "1211";
//oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
oItem.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month);
oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！没有单据日期，无法保存！";
objJsonResult.data = 1;
return objJsonResult;
}
oBill.omodel = oItem;
}
// 表体数据
//按 },{来拆分数组 //去掉【和】
msg3 = msg3.Substring(1, msg3.Length - 2);
msg3 = msg3.Replace("\\", "");
msg3 = msg3.Replace("\n", ""); //\n
List ls = new List();
jsonString = "[" + msg3.ToString() + "]";
ls = Newtonsoft.Json.JsonConvert.DeserializeObject>(jsonString);
int i = 0;
foreach (Model.ClsKf_EntrustOutBillSub oItemSub in ls)
{
i++;
oItemSub.HEntryID = i;
oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
oItemSub.HCloseType = false; //关闭类型
oBill.DetailColl.Add(oItemSub);
}
//保存
//保存完毕后处理
bool bResult;
if (refSav == "Add")
{
bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
}
else if (refSav == "Update")
{
bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
}
else
{
bResult = false;
}
if (bResult)
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "保存成功！";
objJsonResult.data = 1;
return objJsonResult;
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
objJsonResult.data = 1;
return objJsonResult;
}
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "保存失败！" + e.ToString();
objJsonResult.data = 1;
return objJsonResult;
}
}
#endregion
#endregion
#region 委外出库
///
/// 委外出库/提交/直接调用webservice
///
///
[Route("Kf_EntrustInBill/set_SaveEntrustOutBill_Json")]
[HttpPost]
public object set_SaveEntrustOutBill_Json([FromBody] JObject oMain)
{
var _value = oMain["oMain"].ToString();
string msg1 = _value.ToString();
try
{
List lsmain = new List();
ListModels oListModels = new ListModels();
lsmain = oListModels.getEntrustInBillMainByJson(msg1);
lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));
lsmain[0].HBillType = "1211";
WebAPI.WebS.ClsKf_EntrustInBillMain websLsmain = new WebS.ClsKf_EntrustInBillMain();
websLsmain.HInterID = lsmain[0].HInterID;
websLsmain.HInnerBillNo = "";
websLsmain.HDate = lsmain[0].HDate;
websLsmain.HBillNo = lsmain[0].HBillNo;
websLsmain.HBillType = lsmain[0].HBillType;
websLsmain.HBillerID = DBUtility.ClsPub.isLong(DBUtility.ClsPub.CurUserID);
websLsmain.HDeptID = lsmain[0].HDeptID;
websLsmain.HEmpID = lsmain[0].HEmpID;
websLsmain.HRemark = "";
websLsmain.HRedBlueFlag = lsmain[0].HRedBlueFlag;
websLsmain.HMaker = lsmain[0].HMaker;
websLsmain.HSupID = lsmain[0].HSupID;
websLsmain.HSecManagerID = lsmain[0].HSecManagerID;
websLsmain.HSCWHID = lsmain[0].HSCWHID;
websLsmain.HKeeperID = lsmain[0].HKeeperID;
websLsmain.HMainSourceBillType = "1604";
websLsmain.HMangerID = lsmain[0].HMangerID;
websLsmain.HWHID = lsmain[0].HWHID;
websLsmain.HExplanation = lsmain[0].HExplanation;
websLsmain.HBillType = "1211";//固定值
string sSourceBillType = "1604";
if (webserver.set_SaveEntrustInBill_New(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "生成委外出库单成功！单据号为：";
objJsonResult.data = null;
return objJsonResult;
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "上传失败！" + DBUtility.ClsPub.sErrInfo;
objJsonResult.data = websLsmain;
return objJsonResult;
}
}
catch (Exception e)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "上传失败！异常" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
///
/// 委外出库 扫描源单，将源单信息写入条码临时表
///
///
///
[Route("Kf_EntrustInBill/GetWW_PPBomBillMainByHSourceBillNo")]
[HttpGet]
public object GetWW_PPBomBillMainByHSourceBillNo(string HSourceBillType, string HSourceBillNo, Int64 sInterID, string sBillNo)
{
try
{
string sWhere = " Where 单据号 like '%" + HSourceBillNo.Trim() + "%'";
if (HSourceBillType == "1604")
{
ds = oCN.RunProcReturn("Select HBillNo,HSupID,s.HName HSupName from WW_PPBomBillMain a left join Gy_Supplier s on a.HSupID=s.HItemID Where HBillNo='" + HSourceBillNo+"'", "WW_PPBomBillMain");
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录,源单类型有错误！";
objJsonResult.data = null;
return objJsonResult; ;
}
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！";
objJsonResult.data = null;
return objJsonResult;
//DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
}
else
{
if (webserver.set_SavePonderationBillMain_Temp_Source_Fast(sInterID, sBillNo, "1211", HSourceBillNo, HSourceBillType, "蓝字", ref DBUtility.ClsPub.sErrInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "返回记录成功！";
objJsonResult.data = ds.Tables[0];
return objJsonResult;
}
else
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "写入临时表失败！" + DBUtility.ClsPub.sErrInfo;
objJsonResult.data = null;
return objJsonResult;
}
}
}
catch (Exception ex)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#endregion
}
}