private void bt_CheckVouch_Click(object sender, EventArgs e)
{
EntityCheckVouchHead doc = new EntityCheckVouchHead();
doc.cCVCode = "TSZ000000000001";
doc.dCVDate = DateTime.Parse("2017-7-1");
doc.cWhCode = "K001";
doc.dACDate = DateTime.Parse("2017-7-1");
doc.cMaker = "";
doc.cCVMemo = "测试接口";
List <EntityCheckVouchBody> list = new List <EntityCheckVouchBody>();
list.Add(new EntityCheckVouchBody
{
cInvCode = "1020208009",
iCVQuantity = 0,
iCVCQuantity = 2
});
list.Add(new EntityCheckVouchBody
{
cInvCode = "1020208010",
iCVQuantity = 0,
iCVCQuantity = 1
});
doc.Details = list;
string entity = JsonConvert.SerializeObject(doc);
string postUrl = string.Format(@"{0}={1}&ModelType=8022", addpara, entity);
string result = SendHttpRequest(addurl, postUrl, "POST");
textBox1.Text = result;
}
/// <summary>
/// 新增盘点单
/// </summary>
/// <param name="checkVouchHead"></param>
/// <returns></returns>
public string InsertCheckVouch(EntityCheckVouchHead checkVouchHead)
{
int?checkVouchHeadId;
if (checkVouchHead == null || checkVouchHead.Details == null || checkVouchHead.Details.Count == 0)
{
throw new JRException("盘点单新增失败!没有盘点单数据!");
}
#region 验证
int num = 0;
string cmdText = "select count(*) as Num from CheckVouch where cCVCode=@cCVCode";
SqlParameter[] paras =
{
new SqlParameter("@cCVCode", checkVouchHead.cCVCode)
};
DataTable dt = this.DB_SqlHelper.ExecuteDataTable(cmdText, paras);
if (dt != null && dt.Rows.Count > 0)
{
num = int.Parse(dt.Rows[0]["Num"].ToString());
}
if (num > 0)
{
throw new JRException("数据传递有误，已存在该盘点单号!");
}
#endregion
// 得到主表ID和从表ID
int detailCount = checkVouchHead.Details.Count;
int head_id = 0;
int body_end_Id = 0;
GetId("00", "ch", detailCount, out head_id, out body_end_Id);
string sql = string.Format(@"
Insert Into CheckVouch(ccvcode,dcvdate,cdepcode,cpersoncode,cirdcode,cordcode,cwhcode,ccvbatch,ccvmemo,cdefine1,cdefine2,cdefine3,cdefine4,cdefine5,
cdefine6,cdefine7,cdefine8,cdefine9,cdefine10,caccounter,cmaker,cposition,dacdate,id,vt_id,btransflag,cdefine11,cdefine12,cdefine13,cdefine14,
cdefine15,cdefine16,ccvtype,ccvperiod,csource,bposcheck,ireturncount,iverifystate,iswfcontrolled,cmodifyperson,dmodifydate,dnmaketime,dnmodifytime,
dnverifytime,dveridate,cbustype,csourcecodels,iprintcount,csysbarcode,ccurrentauditor)
Values (@ccvcode,@dcvdate,Null,Null,@cirdcode,@cordcode,@cwhcode,Null,@ccvmemo,Null,Null,Null,Null,Null,
Null,Null,Null,Null,Null,Null,@cmaker,Null,@dacdate,@id,29,0,Null,Null,Null,Null,
Null,Null,N'普通仓库盘点',Null,N'1',N'0',Null,Null,0,Null,Null,getdate(),Null ,Null ,Null,Null,Null,0,@csysbarcode,Null)
");
SqlParameter[] para =
{
new SqlParameter("@ccvcode", checkVouchHead.cCVCode),
new SqlParameter("@dcvdate", checkVouchHead.dCVDate.ToShortDateString()),
new SqlParameter("@cirdcode", GetDBValue(checkVouchHead.cIRdCode)),
new SqlParameter("@cordcode", GetDBValue(checkVouchHead.cORdCode)),
new SqlParameter("@cwhcode", checkVouchHead.cWhCode),
new SqlParameter("@ccvmemo", GetDBValue(checkVouchHead.cCVMemo)),
new SqlParameter("@cmaker", checkVouchHead.cMaker),
new SqlParameter("@dacdate", checkVouchHead.dACDate),
new SqlParameter("@id", head_id),
new SqlParameter("@csysbarcode", checkVouchHead.cSysbarCode),
};
int headCount = this.DB_SqlHelper.ExecuteNonQuery(sql, para);
if (headCount > 0)
{
try
{
List <ExecuteHelp> sqlList = new List <ExecuteHelp>();
checkVouchHeadId = GetCheckVouchID(checkVouchHead.cCVCode);
if (checkVouchHeadId == null)
{
throw new JRException("盘点单表头新增失败!");
}
// 组装SQL语句
for (int i = 0; i < detailCount; i++)
{
EntityCheckVouchBody body = checkVouchHead.Details[i];
string bodySql = string.Format(@"
Insert Into CheckVouchs(ccvcode,cinvcode,rdsid,icvnum,icvquantity,icvcnum,icvcquantity,ccvbatch,cfree1,cfree2,ccvreason,ddisdate,ijhdj,ijhje,isjdj,
isjje,cposition,cdefine22,cdefine23,cdefine24,cdefine25,cdefine26,cdefine27,citemcode,citem_class,cname,citemcname,autoid,id,cbarcode,iadinquantity,
iadinnum,iadoutquantity,iadoutnum,iallowwaste,iactualwaste,cfree3,cfree4,cfree5,cfree6,cfree7,cfree8,cfree9,cfree10,cdefine28,cdefine29,cdefine30,
cdefine31,cdefine32,cdefine33,cdefine34,cdefine35,cdefine36,cdefine37,cassunit,cbvencode,cinvouchcode,imassdate,dmadedate,cmassunit,isotype,isodid,
cvmivencode,iinvexchrate,iexpiratdatecalcu,cexpirationdate,dexpirationdate,cbatchproperty1,cbatchproperty2,cbatchproperty3,cbatchproperty4,
cbatchproperty5,cbatchproperty6,cbatchproperty7,cbatchproperty8,cbatchproperty9,cbatchproperty10,cciqbookcode,cbmemo,cwhpersoncode,cwhpersonname,
irowno,cinvouchtype,strowguid,cbsysbarcode,bneedrecheck,recheckstatus,checkcode,checkautoid)
Values (@ccvcode,@cinvcode,Null,0,@icvquantity,0,@icvcquantity,@ccvbatch,Null,Null,@ccvreason,Null,Null,Null,Null,
Null,Null,Null,Null,Null,Null,@cdefine26,NULL,Null,Null,Null,Null,@autoid,@id,Null,@iadinquantity,
0,@iadoutquantity,0,Null,@iactualwaste,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,
Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,
Null,Null,0,Null,Null,Null,Null,Null,Null,
Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,
@irowno,Null,Null,@cbsysbarcode,Null,Null,Null,Null)
");
SqlParameter[] bodyPara =
{
new SqlParameter("@ccvcode", checkVouchHead.cCVCode),
new SqlParameter("@cinvcode", body.cInvCode),
new SqlParameter("@icvquantity", body.iCVQuantity),
new SqlParameter("@cdefine26", body.cDefine26),
new SqlParameter("@icvcquantity", body.iCVCQuantity),
new SqlParameter("@ccvreason", GetDBValue(body.cCVReason)),
new SqlParameter("@autoid", (body_end_Id - detailCount + i + 1)),
new SqlParameter("@id", checkVouchHeadId),
new SqlParameter("@iadinquantity", body.iAdInQuantity),
new SqlParameter("@iadoutquantity", body.iAdOutQuantity),
new SqlParameter("@iactualwaste", body.iActualWaste),
new SqlParameter("@irowno", i + 1),
new SqlParameter("@cbsysbarcode", checkVouchHead.cSysbarCode + "|" + (i + 1)),
new SqlParameter("@ccvbatch", GetDBValue(body.cBatch)),
};
sqlList.Add(new ExecuteHelp()
{
SQL = bodySql, Parameters = bodyPara
});
}
// 执行SQL
this.DB_SqlHelper.ExecuteNonQuery(sqlList);
}
catch (Exception ex)
{
// 表体执行错误，表头也要回滚
DeleteCheckVouch(checkVouchHead.cCVCode);
throw ex;
}
}
else
{
throw new JRException("盘点单表头新增失败!");
}
return(checkVouchHeadId == null ? null : checkVouchHeadId.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="entity"></param>
/// <returns></returns>
public string AddCheckVouch(string UserCode, string PlainPassword,
string StrAccID, int AccYear, string Act, EntityCheckVouchHead entity, out int success)
{
success = 0;
CheckVouchBll bll = new CheckVouchBll(StrAccID, AccYear, UserCode, PlainPassword);
#region 验证
// 字段必填项验证
string msg = "";
if (!entity.CheckEntity(out msg))
{
return(msg);
}
foreach (EntityCheckVouchBody entitybody in entity.Details)
{
if (!entitybody.CheckEntity(out msg))
{
return(msg);
}
}
if (bll.GetGlmendFlag(entity.dCVDate.Year, entity.dCVDate.Month, "bflag_ST") == true)
{
return(string.Format("U8单据{0}日期所在月份已经结账!", entity.cCVCode));
}
// 仓库
string warehouseName = GetWarehouseName(entity.cWhCode);
if (string.IsNullOrWhiteSpace(warehouseName))
{
return(string.Format("U8中不存在仓库编码:{0}!", entity.cWhCode));
}
entity.cORdCode = GetRdCode(18, 0);
entity.cIRdCode = GetRdCode(18, 1);
// 出库类别编码
if (string.IsNullOrWhiteSpace(entity.cORdCode) || string.IsNullOrWhiteSpace(GetRdStyleName(entity.cORdCode)))
{
return(string.Format("U8中不存在收发类别编码:{0}!", entity.cORdCode));
}
// 入库类别编码
if (string.IsNullOrWhiteSpace(entity.cIRdCode) && string.IsNullOrWhiteSpace(GetRdStyleName(entity.cIRdCode, 1)))
{
return(string.Format("U8中不存在收发类别编码:{0}!", entity.cIRdCode));
}
#endregion
entity.cSysbarCode = "||st18|" + entity.cCVCode;
//获取存货档案信息
var inventorys = GetInventorys("'" + string.Join("','", entity.Details.Select(p => p.cInvCode).Distinct()) + "'");
//获取库存信息
EntityCurrentStock xclEntity = new EntityCurrentStock();
xclEntity.cWhCode = entity.cWhCode;
xclEntity.cInvCode = string.Join(",", entity.Details.Select(p => p.cInvCode).Distinct());
CurrentStockBll csBll = new CurrentStockBll(StrAccID, AccYear, UserCode, PlainPassword);
var csData = csBll.GetCurrentStock(xclEntity, out msg);
for (int i = 0; i < entity.Details.Count; i++)
{
EntityCheckVouchBody body = entity.Details[i];
#region 验证单据明细
var invInfo = inventorys.FirstOrDefault(p => p.cInvCode == body.cInvCode);
// 存货编号
if (invInfo == null)
{
return(string.Format("U8中不存在存货编码:{0}!", body.cInvCode));
}
if (!string.IsNullOrWhiteSpace(body.cBatch) && invInfo.bInvBatch == "0")
{
return(string.Format("U8中存货编码:{0}未启用批次管理，批次信息必须为空!", body.cInvCode));
}
if (string.IsNullOrWhiteSpace(body.cBatch) && invInfo.bInvBatch == "1")
{
return(string.Format("U8中存货编码:{0}启用批次管理，批次信息不能为空!", body.cInvCode));
}
// int bInvType = GetbInvType(body.cInvCode);
if (body.iCVCQuantity < 0)
{
return(string.Format("盘点数量不能为小于0!"));
}
#endregion
#region 明细栏目计算
body.iCVQuantity = csData.Where(p => p.cInvCode == body.cInvCode).Sum(p => p.iQuantity);
body.iAdInQuantity = 0;
body.iAdOutQuantity = 0;
body.iActualWaste = 0; //盈亏比例%：=盈亏数量/账面调整数*100
#endregion
}
// 设置默认值
entity.cMaker = string.IsNullOrWhiteSpace(entity.cMaker) ? bll.GetUserName(UserCode) : entity.cMaker;
string id = InsertCheckVouch(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中没有找到可对应的操作项"));
}
