/// <summary>
/// 删除单据
/// </summary>
/// <param name="UserCode"></param>
/// <param name="PlainPassword"></param>
/// <param name="StrAccID"></param>
/// <param name="AccYear"></param>
/// <param name="Act"></param>
/// <param name="entity"></param>
/// <param name="success"></param>
/// <returns></returns>
public string DelDispatchList(string UserCode, string PlainPassword,
string StrAccID, int AccYear, string Act, EntityDispatchListHead entity, out int success)
{
success = 1;
string msg = "";
DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, PlainPassword);
if (bll.GetGlmendFlag(entity.dDate.Year, entity.dDate.Month, "bflag_SA") == true)
{
success = 0;
return(string.Format("U8单据{0}日期所在月份已经结账!", entity.cDLCode));
}
if (GetDispatchList(entity.cDLCode) != 0)
{
if (DispatchListChecked(entity.cDLCode) == 0)
{
msg = string.Format("U8中发/退货单:{0} 已审核,不允许删除!", entity.cDLCode);
success = 0;
}
else
{
//执行删除发货单操作
DeleteDispatchList(entity.cDLCode);
msg = string.Format("U8中发/退货单:{0} 已删除!", entity.cDLCode);
success = 1;
}
}
else
{
msg = string.Format("U8中发/退货单:{0} 不存在!", entity.cDLCode);
}
return(msg);
}
/// <summary>
/// 获取发货单实体类数据
/// </summary>
/// <param name="cDLCode"></param>
/// <returns></returns>
public EntityDispatchListHead GetEntityDispatchListHead(string cDLCode)
{
EntityDispatchListHead entity = new EntityDispatchListHead();
List <EntityDispatchListBody> listBody = new List <EntityDispatchListBody>();
string sqlHead = "SELECT cDLCode ,dDate,cDepCode,cCusCode,cDefine1,cSTCode,cDefine14,ccusperson,cShipAddress,cDefine8,cDefine3,cMemo FROM DispatchList WHERE cDLCode=@cDLCode ";
string sqlBody = "SELECT cInvCode ,cWhCode ,iQuantity,iQuotedPrice,iSum,iTaxRate,cBatch FROM DispatchLists where DLID = (SELECT DLID FROM DispatchList WHERE cDLCode = @cDLCode )";
SqlParameter[] paras =
{
new SqlParameter("@cDLCode", cDLCode)
};
SqlDataReader drHead = DB_SqlHelper.ExecuteReader(CommandType.Text, sqlHead, paras);
SqlDataReader drBody = DB_SqlHelper.ExecuteReader(CommandType.Text, sqlBody, paras);
while (drBody.Read())
{
EntityDispatchListBody body = new EntityDispatchListBody();
body.cInvCode = drBody["cInvCode"].ToString();
body.cWhCode = drBody["cWhCode"].ToString();
body.iQuantity = ConvertToDecimal(drBody["iQuantity"]);
body.iQuotedPrice = ConvertToDecimal(drBody["iQuotedPrice"]);
body.iSum = ConvertToDecimal(drBody["iSum"]);
body.iTaxRate = ConvertToDecimal(drBody["iTaxRate"]);
body.cBatch = drBody["cBatch"].ToString();
listBody.Add(body);
}
if (drHead.Read())
{
entity.cDLCode = cDLCode;
entity.dDate = Convert.ToDateTime(drHead["dDate"]);
entity.cDepCode = drHead["cDepCode"].ToString();
entity.cCusCode = drHead["cCusCode"].ToString();
entity.cDefine1 = drHead["cDefine1"].ToString();
entity.cSTCode = drHead["cSTCode"].ToString();
entity.cDefine14 = drHead["cDefine14"].ToString();
entity.ccusperson = drHead["ccusperson"].ToString();
entity.cShipAddress = drHead["cShipAddress"].ToString();
entity.cDefine8 = drHead["cDefine8"].ToString();
entity.cDefine3 = drHead["cDefine3"].ToString();
entity.cMemo = drHead["cMemo"].ToString();
entity.Details = listBody;
}
return(entity);
}
public string DeleteModels(string UserCode, string CipherPassword, int ModelType,
string StrAccID, string Act, string Entity)
{
string plainPassword = DefineEncryptDecrypt.Decrypt(CipherPassword);
int AccYear = U8BllBase.GetBeginYear(StrAccID);
if (AccYear == 0)
{
return(ControllerHelp.GetReturnStr(0, string.Format("没有找到账套号:{0}", StrAccID)));
}
int success = 0;
ModelsType mt = (ModelsType)ModelType;
switch (mt)
{
case ModelsType.RdRecord01: //采购入库单
{
if (Act == "delete")
{
EntityRdRecord01Head entity = JsonConvert.DeserializeObject <EntityRdRecord01Head>(Entity);
RdRecord01Bll bll = new RdRecord01Bll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.DelRdRecord01(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.DispatchList2: //发货单
if (Act == "delete")
{
EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity);
DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.DelDispatchList(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
return(ControllerHelp.GetReturnStr(0, "DeleteModels中没有找到可对应的操作项"));
}
public string InsertDispatchList(EntityDispatchListHead DispatchListHead)
{
int?DispatchListHeadID;
#region 验证
if (DispatchListHead == null || DispatchListHead.Details == null || DispatchListHead.Details.Count == 0)
{
throw new JRException("新增失败!没有数据!");
}
CreateDHColumn("DispatchLists");
#endregion
// 得到主表ID和从表ID
int detailCount = DispatchListHead.Details.Count;
int head_id = 0;
int body_end_Id = 0;
GetId("00", "DISPATCH", detailCount, out head_id, out body_end_Id);
string sql = string.Format(@"
insert into DispatchList(DLID,cVouchType,cSTCode,dDate,cDepCode,cexch_name,
iExchRate,bFirst,bReturnFlag,bSettleAll,iVTid,cCusCode,cBusType,cDLCode,cSOCode,
cDefine1,cMaker,cCusName,cSysBarCode,
iNetLock,ioutgolden,bCredit,ireturncount,bsigncreate,
bcashsale,bmustbook,bneedbill,baccswitchflag,bsaleoutcreatebill,iTaxRate,cDefine3,cMemo,cinvoicecompany,cDefine8,ccusperson,cShipAddress,cDefine14
)VALUES(@DLID,@cVouchType,@cSTCode,@dDate,@cDepCode,@cexch_name,
@iExchRate,@bFirst,@bReturnFlag,@bSettleAll,@iVTid,@cCusCode,@cBusType,@cDLCode,@cSOCode,
@cDefine1,@cMaker,@cCusName,@cSysBarCode,
null,null,0,null,0,
0,0,1,0,0,@iTaxRate,@cDefine3,left(@cMemo,255),@cCusCode,@cDefine8,@ccusperson,@cShipAddress,@cDefine14
)");
SqlParameter[] para =
{
new SqlParameter("@cVouchType", GetDBValue(DispatchListHead.cVouchType)),
new SqlParameter("@cSTCode", GetDBValue(DispatchListHead.cSTCode)),
new SqlParameter("@dDate", DispatchListHead.dDate.ToShortDateString()),
new SqlParameter("@cDepCode", DispatchListHead.cDepCode),
new SqlParameter("@cexch_name", GetDBValue(DispatchListHead.cexch_name)),
new SqlParameter("@iExchRate", DispatchListHead.iExchRate),
new SqlParameter("@bFirst", DispatchListHead.bFirst),
new SqlParameter("@bReturnFlag", DispatchListHead.bReturnFlag),
new SqlParameter("@bSettleAll", DispatchListHead.bSettleAll),
new SqlParameter("@iVTid", DispatchListHead.iVTid),
new SqlParameter("@cCusCode", DispatchListHead.cCusCode),
new SqlParameter("@cBusType", GetDBValue(DispatchListHead.cBusType)),
new SqlParameter("@cDLCode", DispatchListHead.cDLCode),
new SqlParameter("@cSOCode", GetDBValue(DispatchListHead.cSOCode)),
new SqlParameter("@cDefine1", GetDBValue(DispatchListHead.cDefine1)),
new SqlParameter("@cMaker", GetDBValue(DispatchListHead.cMaker)),
new SqlParameter("@cCusName", GetDBValue(DispatchListHead.cCusName)),
new SqlParameter("@cSysBarCode", GetDBValue(DispatchListHead.cSysBarCode)),
new SqlParameter("@DLID", head_id),
new SqlParameter("@iTaxRate", DispatchListHead.Details[0].iTaxRate),
new SqlParameter("@cDefine3", GetDBValue(DispatchListHead.cDefine3)), //计入任务
new SqlParameter("@cMemo", GetDBValue(DispatchListHead.cMemo)),
new SqlParameter("@cDefine8", GetDBValue(DispatchListHead.cDefine8)),
new SqlParameter("@ccusperson", GetDBValue(DispatchListHead.ccusperson)),
new SqlParameter("@cShipAddress", GetDBValue(DispatchListHead.cShipAddress)),
new SqlParameter("@cDefine14", GetDBValue(DispatchListHead.cDefine14)),
};
int headCount = this.DB_SqlHelper.ExecuteNonQuery(sql, para);
if (headCount > 0)
{
try
{
List <ExecuteHelp> sqlList = new List <ExecuteHelp>();
DispatchListHeadID = GetDispatchListID(DispatchListHead.cDLCode);
if (DispatchListHeadID == null)
{
throw new JRException("表头新增失败!");
}
string getCurrentStockSql = GetCurrentStockSql("Dis");
// 组装SQL语句
for (int i = 0; i < detailCount; i++)
{
EntityDispatchListBody body = DispatchListHead.Details[i];
string bodySql = string.Format(@"
insert into DispatchLists(bcosting,DLID,cInvCode,bSettleAll,iDLsID,bQANeedCheck,bQAUrgency,bQAChecking,bQAChecked,
cWhCode,iQuantity,iUnitPrice,
iSum,iTaxRate,iTaxUnitPrice,iTax,iNatUnitPrice,iNatMoney,
iNatTax,iNatSum,iNatDisCount,iDisCount,
iQuotedPrice,cInvName,iMoney,KL,KL2,fSaleCost,fSalePrice,irowno,cbSysBarCode,
iCorID,iNum,iSettleNum,iSettleQuantity,iBatch,TBQuantity,iSOsID,fOutQuantity,
fOutNum,fEnSettleQuan,fEnSettleSum,iSettlePrice,cMassUnit,iQAQuantity,iQANum,fsumsignquantity,
fsumsignnum,fcusminprice,iExpiratDateCalcu,bneedsign,bsignover,bneedloss,
frlossqty,bsaleprice,bgift,bmpforderclosed,bIAcreatebill,DHID,cSoCode,cBatch,cDefine28
)
VALUES(@bcosting,@DLID,@cInvCode,@bSettleAll,@iDLsID,@bQANeedCheck,@bQAUrgency,@bQAChecking,@bQAChecked,
@cWhCode,@iQuantity,@iUnitPrice,
@iSum,@iTaxRate,@iTaxUnitPrice,@iTax,@iNatUnitPrice,@iNatMoney,
@iNatTax,@iNatSum,@iNatDisCount,@iDisCount,
@iQuotedPrice,@cInvName,@iMoney,@KL,@KL2,@fSaleCost,@fSalePrice,@irowno,@cbSysBarCode,
null,null,null,null,null,0,null,null,
null,null,null,0,0,0,0,null,
null,0,0,0,0,0,
0,1,0,0,0,@DHID,@cSOCode,@cBatch,@cDefine28
);
{0}
IF (@bReturnFlag=0 AND ISNULL(@cSOCode,'') <>'')
BEGIN
UPDATE SO_SODetails SET iFHQuantity=isnull(iFHQuantity,0)+@iQuantity,iFHMoney=isnull(iFHMoney,0)+@iSum WHERE cSOCode=@cSOCode and cInvCode=@cInvCode and DHID=@DHID
UPDATE a SET a.iSOsID=b.iSOsID FROM DispatchLists a inner join SO_SODetails b on a.cSOCode=b.cSOCode and a.cInvCode=b.cInvCode and a.DHID=b.DHID WHERE a.cSOCode=@cSOCode
END
", getCurrentStockSql);
SqlParameter[] bodyPara =
{
new SqlParameter("@bcosting", body.bcosting),
new SqlParameter("@DLID", DispatchListHeadID),
new SqlParameter("@cInvCode", body.cInvCode),
new SqlParameter("@bSettleAll", body.bSettleAll),
new SqlParameter("@iDLsID", (body_end_Id - detailCount + i + 1)),
new SqlParameter("@bQANeedCheck", body.bQANeedCheck),
new SqlParameter("@bQAUrgency", body.bQAUrgency),
new SqlParameter("@bQAChecking", body.bQAChecking),
new SqlParameter("@bQAChecked", body.bQAChecked),
new SqlParameter("@cWhCode", GetDBValue(body.cWhCode)),
new SqlParameter("@iQuantity", body.iQuantity),
new SqlParameter("@iUnitPrice", body.iUnitPrice),
new SqlParameter("@DHID", GetDBValue(body.DHID)),
new SqlParameter("@iSum", ConvertToDecimal(body.iSum)),
new SqlParameter("@iTaxRate", body.iTaxRate),
new SqlParameter("@iTaxUnitPrice", body.iTaxUnitPrice),
new SqlParameter("@iTax", body.iTax),
new SqlParameter("@iNatUnitPrice", body.iNatUnitPrice),
new SqlParameter("@iNatMoney", body.iNatMoney),
new SqlParameter("@iNatTax", body.iNatTax),
new SqlParameter("@iNatSum", body.iNatSum),
new SqlParameter("@iNatDisCount", body.iNatDisCount),
new SqlParameter("@iDisCount", body.iDisCount),
new SqlParameter("@iQuotedPrice", ConvertToDecimal(body.iQuotedPrice)),
new SqlParameter("@cInvName", GetDBValue(body.cInvName)),
new SqlParameter("@KL", body.KL),
new SqlParameter("@KL2", body.KL2),
new SqlParameter("@iMoney", body.iMoney),
new SqlParameter("@fSaleCost", body.fSaleCost),
new SqlParameter("@fSalePrice", body.fSalePrice),
new SqlParameter("@irowno", body.iRowNo),
new SqlParameter("@cbSysBarCode", body.cbSysBarCode),
new SqlParameter("@bReturnFlag", DispatchListHead.bReturnFlag),
new SqlParameter("@cSOCode", GetDBValue(DispatchListHead.cSOCode)),
new SqlParameter("@cBatch", GetDBValue(body.cBatch)),
new SqlParameter("@cDefine28", GetDBValue(body.cDefine28))
};
sqlList.Add(new ExecuteHelp()
{
SQL = bodySql, Parameters = bodyPara
});
}
// 执行SQL
int bodyCount = this.DB_SqlHelper.ExecuteNonQuery(sqlList);
}
catch (Exception ex)
{
// 表体执行错误，表头也要回滚
DeleteDispatchList(DispatchListHead.cDLCode);
throw ex;
}
}
else
{
throw new JRException("表头新增失败!");
}
return(DispatchListHeadID == null ? null : DispatchListHeadID.ToString());
}
/// <summary>
/// 新增退货单
/// </summary>
/// <param name="UserCode"></param>
/// <param name="PlainPassword"></param>
/// <param name="StrAccID"></param>
/// <param name="AccYear"></param>
/// <param name="Act"></param>
/// <param name="Kind">0：普通销售 1：委托代销</param>
/// <param name="entity"></param>
/// <param name="success"></param>
/// <returns></returns>
public string AddDispatchList(string UserCode, string PlainPassword,
string StrAccID, int AccYear, string Act, int Kind, EntityDispatchListHead entity, out int success)
{
success = 0;
DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, PlainPassword);
// 必填项验证
string msg = "";
if (!entity.CheckEntity(out msg))
{
return(msg);
}
foreach (EntityDispatchListBody entitybody in entity.Details)
{
if (!entity.CheckEntity(out msg))
{
return(msg);
}
}
#region 验证
if (bll.GetGlmendFlag(entity.dDate.Year, entity.dDate.Month, "bflag_SA") == true)
{
return(string.Format("U8单据{0}日期所在月份已经结账!", entity.cDLCode));
}
// 客户编号
string cusName = bll.GetCustomerName(entity.cCusCode);
if (string.IsNullOrWhiteSpace(cusName))
{
return(string.Format("U8中不存在客户编号:{0}!", entity.cCusCode));
}
entity.cCusName = cusName;
// 部门
string deptName = bll.GetDepartmentName(entity.cDepCode);
if (string.IsNullOrWhiteSpace(deptName))
{
return(string.Format("U8中不存在部门编码:{0},或者部门编码非末级!", entity.cDepCode));
}
//销售类型
if (string.IsNullOrWhiteSpace(GetStName(entity.cSTCode)))
{
return(string.Format("U8中不存在销售类型编码:{0}!", entity.cSTCode));
}
if (GetDispatchList(entity.cDLCode) != 0)
{
return(string.Format("U8中已存在该退货单号{0}!", entity.cDLCode));
}
#endregion
if (entity.Details == null || entity.Details.Count == 0)
{
return("表体中存货信息不能为空，至少要有一条记录!");
}
var inventorys = GetInventorys("'" + string.Join("','", entity.Details.Select(p => p.cInvCode).Distinct()) + "'");
for (int i = 0; i < entity.Details.Count; i++)
{
EntityDispatchListBody body = entity.Details[i];
#region 验证单据明细
var invInfo = inventorys.FirstOrDefault(p => p.cInvCode == body.cInvCode);
// 存货编号
string invName = bll.GetInventoryName(body.cInvCode);
if (invInfo == null)
{
return(string.Format("U8中不存在存货编码:{0}!", body.cInvCode));
}
if (body.iQuantity > 0)
{
return("退货数量不能大于0!");
}
if (body.iQuantity != 0 && body.iSum > 0)
{
return("退货单价税合计不能大于0");
}
if (!string.IsNullOrWhiteSpace(body.cBatch) && bll.GetInventoryName(body.cInvCode, 4) == "0")
{
return(string.Format("U8中存货编码:{0}未启用批次管理，批次信息必须为空!", body.cInvCode));
}
if (string.IsNullOrWhiteSpace(body.cBatch) && bll.GetInventoryName(body.cInvCode, 4) == "1")
{
body.cBatch = bll.GetInvBatch(body.cWhCode, body.cInvCode);
if (string.IsNullOrWhiteSpace(body.cBatch))
{
return(string.Format("U8中存货编码:{0}启用批次管理，批次信息不能为空!", body.cInvCode));
}
}
body.cInvName = invName;
int bInvType = GetbInvType(body.cInvCode);
if (body.iQuantity == 0 && bInvType == 0)
{
return(string.Format("非折扣属性商品发货数量不能等于0"));
}
#endregion
#region 单据明细计算
body.bcosting = 1;//标志 是否记账
if (bInvType == 1)
{
body.cWhCode = null; body.bcosting = 0; body.iQuantity = 0; body.iQuotedPrice = 0;
}
body.iRowNo = (i + 1);
body.KL = 100;
//当数量为正数时，求其绝对值转换为负数
if (body.iQuantity > 0)
{
body.iQuantity = -body.iQuantity;
}
body.bSettleAll = 0; //结算标志
body.bQAChecked = 0; //是否报险
body.bQAUrgency = 0; //是否急料
body.bQAChecking = 0; //是否再检
body.bQAChecked = 0; //是否报险
body.bQANeedCheck = 0; //是否质检
decimal isum = body.iSum.HasValue ? body.iSum.Value : 0;
body.cbSysBarCode = string.Format("||SA03|{0}|{1}", entity.cDLCode, body.iRowNo);
body.iTaxUnitPrice = body.iQuantity == 0 ? 0 : isum / body.iQuantity;
body.iUnitPrice = body.iQuantity == 0 ? 0 : Math.Round(body.iTaxUnitPrice / ((body.iTaxRate / 100) + 1), 2);
body.iMoney = Math.Round(isum / ((body.iTaxRate / 100) + 1), 2);
body.iTax = isum - body.iMoney;
body.KL2 = body.iQuotedPrice == 0 || !body.iQuotedPrice.HasValue ? 100 : (isum / (body.iQuotedPrice.Value * body.iQuantity)) * 100;
body.fSaleCost = body.fSaleCost != 0 ? body.fSaleCost : bll.GetSA_InvPrice(body.cInvCode);
body.fSalePrice = body.fSaleCost * body.iQuantity;
body.iDisCount = body.iQuotedPrice == 0 || !body.iQuotedPrice.HasValue ? 0 : body.iQuotedPrice.Value * body.iQuantity - isum;
body.iNatMoney = body.iMoney;
body.iNatSum = isum;
body.iNatTax = body.iTax;
body.iNatUnitPrice = body.iUnitPrice;
body.iNatDisCount = body.iDisCount;
#endregion
}
//设置默认值
entity.bFirst = 0; //销售期初标志
entity.bReturnFlag = 1; //退货标志
entity.bSettleAll = 0; //结算标志
entity.iExchRate = 1; //汇率
entity.cBusType = Kind == 0 ? "普通销售" : "委托代销"; // 业务类型
entity.cexch_name = "人民币"; //币种名称
entity.cVouchType = Kind == 0 ? "05" : "06"; //单据类型编码
entity.iVTid = Kind == 0 ? 75 : 51; //单据模板号
entity.cSysBarCode = Kind == 0 ? string.Format("||SA03|{0}", entity.cDLCode) : string.Format("||SA54|{0}", entity.cDLCode);
entity.cMaker = bll.GetUserName(UserCode);
string id = string.Empty;
id = bll.InsertDispatchList(entity);
success = string.IsNullOrWhiteSpace(id) ? 0 : 1;
return(id);
}
public string AddModels(string UserCode, string CipherPassword, int ModelType,
string StrAccID, string Act, string Entity)
{
//Entity = System.Web.HttpUtility.UrlDecode(Entity);
string plainPassword = DefineEncryptDecrypt.Decrypt(CipherPassword);
int AccYear = U8BllBase.GetBeginYear(StrAccID);
if (AccYear == 0)
{
return(ControllerHelp.GetReturnStr(0, string.Format("没有找到账套号:{0}", StrAccID)));
}
int success = 0;
ModelsType mt = (ModelsType)ModelType;
switch (mt)
{
case ModelsType.Sale: // 销售订单
lock (SaleLock)
{
if (Act == "add")
{
EntitySaleHead entity = JsonConvert.DeserializeObject <EntitySaleHead>(Entity);
SoMainBll bll = new SoMainBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddSale(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.RdRecord09: // 配送出库单(其他出库单)
lock (RdRecord09Lock)
{
if (Act == "add")
{
EntityRdRecord09Head entity = JsonConvert.DeserializeObject <EntityRdRecord09Head>(Entity);
RdRecord09Bll bll = new RdRecord09Bll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddRdRecord09(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.DispatchList1: //销售退货单
case ModelsType.DispatchList4: //委托代销退货单
lock (DispatchList1Lock)
{
if (Act == "add")
{
EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity);
DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddDispatchList(UserCode, plainPassword, StrAccID, AccYear, Act, ModelsType.DispatchList1 == mt ? 0 : 1, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.DispatchList2: //销售发货单
case ModelsType.DispatchList3: //委托代销发货单
lock (DispatchList2Lock)
{
if (Act == "add")
{
EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity);
DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddDispatchList(UserCode, plainPassword, ModelType, StrAccID, AccYear, Act, ModelsType.DispatchList2 == mt ? 0 : 1, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.Ap_CloseBill: //收款单
lock (Ap_CloseBillLock)
{
if (Act == "add")
{
EntityAp_CloseBillHead entity = JsonConvert.DeserializeObject <EntityAp_CloseBillHead>(Entity);
Ap_CloseBillBll bll = new Ap_CloseBillBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddAp_CloseBill(UserCode, plainPassword, StrAccID, AccYear, Act, ModelType, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.Ap_Vouch: //其他应付款
lock (Ap_VouchLock)
{
if (Act == "add")
{
EntityAp_VouchHead entity = JsonConvert.DeserializeObject <EntityAp_VouchHead>(Entity);
Ap_VouchBll bll = new Ap_VouchBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddAp_Vouch(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.PO_Pomain: //采购订单
lock (PO_PomainLock)
{
if (Act == "add")
{
EntityPO_Pomain entity = JsonConvert.DeserializeObject <EntityPO_Pomain>(Entity);
PO_PomainBll bll = new PO_PomainBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddPO_Pomain(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.RdRecord01: //采购入库单
lock (RdRecord01Lock)
{
if (Act == "add")
{
EntityRdRecord01Head entity = JsonConvert.DeserializeObject <EntityRdRecord01Head>(Entity);
RdRecord01Bll bll = new RdRecord01Bll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddRdRecord01(UserCode, plainPassword, StrAccID, AccYear, Act, 0, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.PayAp_CloseBill: //付款单
lock (PayAp_CloseBillLock)
{
if (Act == "add")
{
EntityAp_CloseBillHead entity = JsonConvert.DeserializeObject <EntityAp_CloseBillHead>(Entity);
Ap_CloseBillBll bll = new Ap_CloseBillBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddAp_CloseBill(UserCode, plainPassword, StrAccID, AccYear, Act, ModelType, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.ST_AppTransVouch: //调拨申请单
lock (ST_AppTransVouchLock)
{
if (Act == "add")
{
EntityST_AppTransVouch entity = JsonConvert.DeserializeObject <EntityST_AppTransVouch>(Entity);
ST_AppTransVouchBll bll = new ST_AppTransVouchBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddST_AppTransVouch(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.TransVouch: //调拨单
lock (TransVouchLock)
{
if (Act == "add")
{
EntityTransVouch entity = JsonConvert.DeserializeObject <EntityTransVouch>(Entity);
TransVouchBll bll = new TransVouchBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddTransVouch(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.Vendor: //供应商
lock (VendorLock)
{
if (Act == "add")
{
EntityVendor entity = JsonConvert.DeserializeObject <EntityVendor>(Entity);
VendorBll bll = new VendorBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddVendor(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.CheckVouch: //盘点单
lock (VendorLock)
{
if (Act == "add")
{
EntityCheckVouchHead entity = JsonConvert.DeserializeObject <EntityCheckVouchHead>(Entity);
CheckVouchBll bll = new CheckVouchBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddCheckVouch(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.InventoryClass: //存货分类
lock (InventoryClassLock)
{
if (Act == "add")
{
EntityInventoryClass entity = JsonConvert.DeserializeObject <EntityInventoryClass>(Entity);
InventoryClassBll bll = new InventoryClassBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddInventoryClass(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.Inventory: //存货档案
lock (InventoryLock)
{
if (Act == "add")
{
EntityInventory entity = JsonConvert.DeserializeObject <EntityInventory>(Entity);
InventoryBll bll = new InventoryBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddInventory(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.WareHouse: //仓库档案
lock (WareHouseLock)
{
if (Act == "add")
{
EntityWareHouse entity = JsonConvert.DeserializeObject <EntityWareHouse>(Entity);
WareHouseBll bll = new WareHouseBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddWareHouse(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.Customer: //客户档案
lock (CustomerLock)
{
if (Act == "add")
{
EntityCustomer entity = JsonConvert.DeserializeObject <EntityCustomer>(Entity);
CustomerBll bll = new CustomerBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddCustomer(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.RdRecord01T: //红字采购入库单
lock (RdRecord01TLock)
{
if (Act == "add")
{
EntityRdRecord01Head entity = JsonConvert.DeserializeObject <EntityRdRecord01Head>(Entity);
RdRecord01Bll bll = new RdRecord01Bll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddRdRecord01(UserCode, plainPassword, StrAccID, AccYear, Act, 1, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
}
return(ControllerHelp.GetReturnStr(0, "AddModels中没有找到可对应的操作项"));
}
public string GetModels(string UserCode, string CipherPassword, int ModelType,
string StrAccID, string Act, string Entity, string dModifyDate)
{
//Entity = System.Web.HttpUtility.UrlDecode(Entity);
string plainPassword = DefineEncryptDecrypt.Decrypt(CipherPassword);
int AccYear = U8BllBase.GetBeginYear(StrAccID);
if (AccYear == 0)
{
return(ControllerHelp.GetReturnStr(0, string.Format("没有找到账套号{0}", StrAccID)));
}
ModelsType mt = (ModelsType)ModelType;
string msg = "";
switch (mt)
{
case ModelsType.CurrentStock: // 库存量查询
if (Act == "get")
{
EntityCurrentStock entity = JsonConvert.DeserializeObject <EntityCurrentStock>(Entity);
CurrentStockBll bll = new CurrentStockBll(StrAccID, AccYear, UserCode, plainPassword);
List <EntityCurrentStock> list = bll.GetCurrentStock(entity, out msg);
return(ControllerHelp.GetReturnStr(string.IsNullOrWhiteSpace(msg) ? 1 : 0, "", list));
}
break;
case ModelsType.Sale: // 查询销售订单是否存在 1表示不存在，2表示存在
if (Act == "query")
{
SoMainBll bll = new SoMainBll(StrAccID, AccYear, UserCode, plainPassword);
EntitySaleHead entity = JsonConvert.DeserializeObject <EntitySaleHead>(Entity);
int num = bll.QuerySale(entity.cSOCode);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
case ModelsType.DispatchList1: //退货单 1表示不存在，2表示存在
if (Act == "query")
{
DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword);
EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity);
int num = bll.QueryDispatchList(entity.cDLCode);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
case ModelsType.DispatchList2: //发货单 1表示不存在，2表示存在
if (Act == "query")
{
DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword);
EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity);
int num = bll.QueryDispatchList(entity.cDLCode);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
case ModelsType.RdRecord09: // 配送出库单(其他出库单) 1表示不存在，2表示存在
if (Act == "query")
{
RdRecord09Bll bll = new RdRecord09Bll(StrAccID, AccYear, UserCode, plainPassword);
EntityRdRecord09Head entity = JsonConvert.DeserializeObject <EntityRdRecord09Head>(Entity);
int num = bll.QueryRdRecord09(entity.cCode);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
case ModelsType.Ap_CloseBill: //收款单（汇款通知单）1表示不存在，2表示存在
if (Act == "query")
{
Ap_CloseBillBll bll = new Ap_CloseBillBll(StrAccID, AccYear, UserCode, plainPassword);
EntityAp_CloseBillHead entity = JsonConvert.DeserializeObject <EntityAp_CloseBillHead>(Entity);
int num = bll.QueryAp_CloseBill(entity.cVouchID);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
case ModelsType.PayAp_CloseBill: //付款单（汇款通知单）1表示不存在，2表示存在
if (Act == "query")
{
Ap_CloseBillBll bll = new Ap_CloseBillBll(StrAccID, AccYear, UserCode, plainPassword);
EntityAp_CloseBillHead entity = JsonConvert.DeserializeObject <EntityAp_CloseBillHead>(Entity);
int num = bll.QueryAp_CloseBill(entity.cVouchID);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
case ModelsType.ReturnAnalysis: //退货分析表查询
if (Act == "get")
{
ReturnAnalysisBll bll = new ReturnAnalysisBll(StrAccID, AccYear, UserCode, plainPassword);
EntityReturnAnalysisRQC entity = JsonConvert.DeserializeObject <EntityReturnAnalysisRQC>(Entity);
List <EntityReturnAnalysisReport> list = bll.GetReturnAnalysis(entity);
return(ControllerHelp.GetReturnStr(1, "", list));
}
break;
case ModelsType.Customer: //客户档案
if (Act == "get")
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
EntityCustomer entity = JsonConvert.DeserializeObject <EntityCustomer>(Entity);
List <EntityCustomer> customer = bll.GetCustomer(entity.cCusCode);
return(ControllerHelp.GetReturnStr(1, "", customer));
}
break;
case ModelsType.Vendor: //供应商档案
if (Act == "get")
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
List <EntityVendor> vendor = bll.GetVendor();
return(ControllerHelp.GetReturnStr(1, "", vendor));
}
break;
case ModelsType.PurchaseType: //采购类型
if (Act == "get")
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
List <EntityPurchaseType> purchasetype = bll.GetPurchaseType();
return(ControllerHelp.GetReturnStr(1, "", purchasetype));
}
break;
case ModelsType.Inventory: //存货档案
if (Act == "get")
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
List <EntityInventory> inventory = new List <EntityInventory>();
if (string.IsNullOrWhiteSpace(dModifyDate))
{
inventory = bll.GetInventory();
}
else
{
inventory = bll.GetInventory(Convert.ToDateTime(dModifyDate));
}
return(ControllerHelp.GetReturnStr(1, "", inventory));
}
break;
case ModelsType.WareHouse: //仓库档案（入库仓库）
if (Act == "get")
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
List <EntityWareHouse> warehouse = bll.GetWareHouse();
return(ControllerHelp.GetReturnStr(1, "", warehouse));
}
break;
case ModelsType.rd_Style: //入库类别档案
if (Act == "get")
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
List <Entityrd_Style> rd_style = bll.Getrd_Style();
return(ControllerHelp.GetReturnStr(1, "", rd_style));
}
break;
case ModelsType.SettleStyle: //结算方式
if (Act == "get")
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
List <EntitySettleStyle> settlestyle = bll.GetSettleStyle();
return(ControllerHelp.GetReturnStr(1, "", settlestyle));
}
break;
case ModelsType.CustomerProperty: //经营属性
if (Act == "get")
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
string cuscode = Entity;
var customer = bll.GetCustomerProperty(cuscode);
return(ControllerHelp.GetReturnStr(1, "", customer));
}
break;
case ModelsType.InventoryPrice: //存货入库含税单价
if (Act == "get")
{
if (!string.IsNullOrWhiteSpace(Entity))
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
EntityInventoryPrice entity = JsonConvert.DeserializeObject <EntityInventoryPrice>(Entity);
var inventoryPrice = bll.GetInventoryPrice(entity.cVenCode, entity.cInvCode);
return(ControllerHelp.GetReturnStr(1, "", inventoryPrice));
}
}
break;
case ModelsType.PO_Pomain: //采购订单
if (Act == "query")
{
PO_PomainBll bll = new PO_PomainBll(StrAccID, AccYear, UserCode, plainPassword);
EntityPO_Pomain entity = JsonConvert.DeserializeObject <EntityPO_Pomain>(Entity);
int num = bll.GetPO_Pomain(entity.cPOID);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
case ModelsType.RdRecord01: //采购入库单
if (Act == "query")
{
RdRecord01Bll bll = new RdRecord01Bll(StrAccID, AccYear, UserCode, plainPassword);
EntityRdRecord01Head entity = JsonConvert.DeserializeObject <EntityRdRecord01Head>(Entity);
int num = bll.GetRdRecord01(entity.cCode);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
case ModelsType.Ap_Vouch: //其他应付单
if (Act == "query")
{
Ap_VouchBll bll = new Ap_VouchBll(StrAccID, AccYear, UserCode, plainPassword);
EntityAp_VouchHead entity = JsonConvert.DeserializeObject <EntityAp_VouchHead>(Entity);
int num = bll.GetAp_Vouch(entity.cVouchID);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
}
return(ControllerHelp.GetReturnStr(0, "GetModels(查询)中没有找到可对应的操作项"));
}
