public string AddTransVouch(string UserCode, string PlainPassword,
string StrAccID, int AccYear, string Act, EntityTransVouch entity, out int success)
{
success = 0;
TransVouchBll bll = new TransVouchBll(StrAccID, AccYear, UserCode, PlainPassword);
#region 验证
if (entity == null || entity.Details == null || entity.Details.Count == 0)
{
throw new JRException("调拨单新增失败!没有数据!");
}
// 字段必填项验证
string msg = "";
if (!entity.CheckEntity(out msg))
{
return(msg);
}
foreach (EntityTransVouchBody entitybody in entity.Details)
{
if (!entitybody.CheckEntity(out msg))
{
return(msg);
}
}
if (bll.GetGlmendFlag(entity.dTvDate.Year, entity.dTvDate.Month, "bflag_ST") == true)
{
return(string.Format("U8单据{0}日期所在月份已经结账!", entity.cTvCode));
}
// 调出仓库
if (string.IsNullOrWhiteSpace(GetWarehouseName(entity.cOutWhCode)))
{
return(string.Format("U8中不存在仓库编码:{0}!", entity.cOutWhCode));
}
// 调入仓库
if (string.IsNullOrWhiteSpace(GetWarehouseName(entity.cInWhCode)))
{
return(string.Format("U8中不存在仓库编码:{0}!", entity.cInWhCode));
}
//调出部门
if (string.IsNullOrWhiteSpace(GetDepartmentName(entity.cOutDepCode)))
{
return(string.Format("U8中不存在部门编码:{0},或者部门编码非末级!", entity.cOutDepCode));
}
//调入部门
if (string.IsNullOrWhiteSpace(GetDepartmentName(entity.cInDepCode)))
{
return(string.Format("U8中不存在部门编码:{0},或者部门编码非末级!", entity.cInDepCode));
}
entity.cOutRdCode = GetRdCode(12, 0);
entity.cInRdCode = GetRdCode(12, 1);
// 出库类别编码
if (string.IsNullOrWhiteSpace(entity.cOutRdCode) || string.IsNullOrWhiteSpace(GetRdStyleName(entity.cOutRdCode)))
{
return(string.Format("U8中不存在收发类别编码:{0}!", entity.cOutRdCode));
}
// 入库类别编码
if (string.IsNullOrWhiteSpace(entity.cInRdCode) || string.IsNullOrWhiteSpace(GetRdStyleName(entity.cInRdCode, 1)))
{
return(string.Format("U8中不存在收发类别编码:{0}!", entity.cInRdCode));
}
// 客户
string cusName = GetCustomerName(entity.cCusCode);
if (string.IsNullOrWhiteSpace(cusName))
{
return(string.Format("U8中不存在客户编号:{0}!", entity.cCusCode));
}
int num = 0;
string cmdText = "select count(*) as Num from TransVouch where ctvcode=@ctvcode";
SqlParameter[] paras =
{
new SqlParameter("@ctvcode", entity.cTvCode)
};
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("数据传递有误，ERP中已存在该调拨单号!");
}
var inventorys = GetInventorys("'" + string.Join("','", entity.Details.Select(p => p.cInvCode).Distinct()) + "'");
for (int i = 0; i < entity.Details.Count; i++)
{
EntityTransVouchBody body = entity.Details[i];
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));
}
if (body.iTvQuantity == 0)
{
return(string.Format("申请数量不能为0!"));
}
if (body.iTvaCost * body.iTvQuantity != body.iTvaPrice || body.iTvQuantity * body.cDefine26 != body.cDefine27)
{
return(string.Format("存货编码:{0}金额异常!", body.cInvCode));
}
}
#endregion
entity.cMaker = string.IsNullOrWhiteSpace(entity.cMaker) ? GetUserName(UserCode) : entity.cMaker;
string id = InsertTransVouch(entity);
success = string.IsNullOrWhiteSpace(id) ? 0 : 1;
return(id);
}
public string InsertTransVouch(EntityTransVouch Head)
{
// 得到主表ID和从表ID
int detailCount = Head.Details.Count;
int head_id = 0;
int body_end_Id = 0;
GetId("00", "tr", detailCount, out head_id, out body_end_Id);
string cSysBarCode = "||st12|" + Head.cTvCode;
string sql = string.Format(@"
insert into TransVouch(ctvcode,dtvdate,cowhcode,ciwhcode,codepcode,cidepcode,cpersoncode,cirdcode,cordcode,ctvmemo,cdefine1,cdefine2,cdefine3,cdefine4,cdefine5,
cdefine6,cdefine7,cdefine8,cdefine9,cdefine10,caccounter,cmaker,id,vt_id,cverifyperson,dverifydate,cpspcode,cmpocode,iquantity,btransflag,cdefine11,cdefine12,
cdefine13,cdefine14,cdefine15,cdefine16,iproorderid,cordertype,ctranrequestcode,cversion,bomid,cfree1,cfree2,cfree3,cfree4,cfree5,cfree6,cfree7,cfree8,cfree9,cfree10,
csource,itransflag,cmodifyperson,dmodifydate,dnmaketime,dnmodifytime,dnverifytime,ireturncount,iverifystate,iswfcontrolled,cbustype,csourcecodels,iprintcount,
csourceguid,csysbarcode,ccurrentauditor)
Values (@ctvcode,@dtvdate,@cowhcode,@ciwhcode,@codepcode,@cidepcode,Null,@cirdcode,@cordcode,@ctvmemo,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,@cmaker,
@id,89,Null,Null,Null,Null,0,Null,@cdefine11,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,N'1',N'正向',Null,
Null,getdate(),Null ,Null ,Null,Null,0,Null,Null,0,Null,@csysbarcode,Null)
");
SqlParameter[] para =
{
new SqlParameter("@ctvcode", Head.cTvCode),
new SqlParameter("@dtvdate", Head.dTvDate.ToShortDateString()),
new SqlParameter("@cowhcode", Head.cOutWhCode),
new SqlParameter("@ciwhcode", Head.cInWhCode),
new SqlParameter("@codepcode", Head.cOutDepCode),
new SqlParameter("@cidepcode", Head.cInDepCode),
new SqlParameter("@cirdcode", GetDBValue(Head.cInRdCode)),
new SqlParameter("@cordcode", GetDBValue(Head.cOutRdCode)),
new SqlParameter("@ctvmemo", GetDBValue(Head.cTvMemo)),
new SqlParameter("@cmaker", Head.cMaker),
new SqlParameter("@id", head_id),
new SqlParameter("@csysbarcode", cSysBarCode),
new SqlParameter("@cdefine11", Head.cCusCode),
};
int headCount = this.DB_SqlHelper.ExecuteNonQuery(sql, para);
if (headCount > 0)
{
try
{
List <ExecuteHelp> sqlList = new List <ExecuteHelp>();
// 组装SQL语句
for (int i = 0; i < detailCount; i++)
{
EntityTransVouchBody body = Head.Details[i];
string bodySql = string.Format(@"
Insert Into TransVouchs(ctvcode,cinvcode,rdsid,itvnum,itvquantity,itvacost,itvaprice,itvpcost,itvpprice,ddisdate,cfree1,cfree2,cdefine22,cdefine23,cdefine24,
cdefine25,cdefine26,cdefine27,citemcode,citem_class,fsalecost,fsaleprice,cname,citemcname,autoid,id,imassdate,cbarcode,cassunit,cfree3,cfree4,cfree5,cfree6,cfree7,
cfree8,cfree9,cfree10,cdefine28,cdefine29,cdefine30,cdefine31,cdefine32,cdefine33,cdefine34,cdefine35,cdefine36,cdefine37,impoids,cbvencode,cinvouchcode,dmadedate,
cmassunit,itrids,issotype,issodid,idsotype,idsodid,bcosting,cvmivencode,cinposcode,coutposcode,iinvsncount,iinvexchrate,comcode,cmocode,invcode,imoseq,iomids,imoids,
corufts,iexpiratdatecalcu,cexpirationdate,dexpirationdate,cbatchproperty1,cbatchproperty2,cbatchproperty3,cbatchproperty4,cbatchproperty5,cbatchproperty6,
cbatchproperty7,cbatchproperty8,cbatchproperty9,cbatchproperty10,cciqbookcode,cbmemo,irowno,strowguid,cinvouchtype,cbsourcecodels,cmolotcode,cinvoucherlineid,
cinvouchercode,cinvouchertype,cbsysbarcode,cTVBatch)
Values (@ctvcode,@cinvcode,Null,Null,@itvquantity,@itvacost,@itvaprice,Null,Null,Null,Null,Null,Null,Null,Null,Null,@cdefine26,@cdefine27,Null,Null,0,0,Null,
Null,@autoid,@id,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,
Null,Null,Null,1,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,1,Null,Null,Null,
Null,Null,Null,Null,@cbsysbarcode,@cTVBatch);
Update CurrentStock set fTransInQuantity = fTransInQuantity + @itvquantity where cWhCode = @ciwhcode and cInvCode = @cinvcode and isnull(cBatch,'') = isnull(@cTVBatch,'');
Update CurrentStock set fTransOutQuantity = fTransOutQuantity + @itvquantity where cWhCode = @cowhcode and cInvCode = @cinvcode and isnull(cBatch,'') = isnull(@cTVBatch,'');
");
SqlParameter[] bodyPara =
{
new SqlParameter("@ctvcode", Head.cTvCode),
new SqlParameter("@cinvcode", body.cInvCode),
new SqlParameter("@itvquantity", body.iTvQuantity),
new SqlParameter("@itvacost", body.iTvaCost),
new SqlParameter("@itvaprice", body.iTvaPrice),
new SqlParameter("@autoid", body_end_Id - detailCount + i + 1),
new SqlParameter("@id", head_id),
new SqlParameter("@cdefine26", body.cDefine26),
new SqlParameter("@cdefine27", body.cDefine27),
new SqlParameter("@irowno", i + 1),
new SqlParameter("@cbsysbarcode", cSysBarCode + "|" + (i + 1)),
new SqlParameter("@cowhcode", Head.cOutWhCode),
new SqlParameter("@ciwhcode", Head.cInWhCode),
new SqlParameter("@cTVBatch", GetDBValue(body.cBatch)),
};
sqlList.Add(new ExecuteHelp()
{
SQL = bodySql, Parameters = bodyPara
});
}
// 执行SQL
int bodyCount = this.DB_SqlHelper.ExecuteNonQuery(sqlList);
}
catch (Exception ex)
{
// 表体执行错误，表头也要回滚
DeleteTransVouch(Head.cTvCode);
throw ex;
}
}
else
{
throw new JRException("调拨单新增失败!");
}
return(head_id == 0 ? null : head_id.ToString());
}
