/// <summary>
/// 检验结束
/// </summary>
/// <param name="p_BE"></param>
/// <param name="entity"></param>
/// <param name="p_PackID"></param>
/// <param name="Qty">码表数量</param>
/// <param name="YMQty">原码数量，暂不使用</param>
/// <param name="JarNo">缸号</param>
/// <returns></returns>
public int RJYEnd(int p_BE, BProductCheckDts entity, int p_PackID, decimal Qty, decimal YMQty, int JarNo)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
int tempID = this.RJYEnd(p_BE, entity, p_PackID, Qty, YMQty, JarNo, sqlTrans);
sqlTrans.CommitTrans();
return(tempID);
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_BE">要新增的实体</param>
public int RSaveFault(BProductCheckDtsFault p_BE, BProductCheckDts entity, int MainID, int PackDtsID)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
int TempID = this.RSaveFault(p_BE, entity, MainID, PackDtsID, sqlTrans);
sqlTrans.CommitTrans();
return(TempID);
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Delete(BaseEntity p_Entity)
{
try
{
BProductCheckDts MasterEntity=(BProductCheckDts)p_Entity;
if (MasterEntity.ID==0)
{
return 0;
}
//删除主表数据
string Sql="";
Sql="DELETE FROM WO_BProductCheckDts WHERE "+ "ID="+SysString.ToDBString(MasterEntity.ID);
//执行
int AffectedRows=0;
if(!this.sqlTransFlag)
{
AffectedRows=this.ExecuteNonQuery(Sql);
}
else
{
AffectedRows=sqlTrans.ExecuteNonQuery(Sql);
}
return AffectedRows;
}
catch(BaseException E)
{
throw new BaseException(E.Message,E);
}
catch(Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBDelete),E);
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="p_BE">要删除的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RDelete(int p_BE, IDBTransAccess sqlTrans)
{
try
{
BProductCheckDtsFault entity = new BProductCheckDtsFault(sqlTrans);
entity.ID = p_BE;
entity.SelectByID();
RDelete(entity, sqlTrans);
BProductCheckDts en = new BProductCheckDts(sqlTrans);
en.ID = entity.MainID;
en.SelectByID();
en.CY -= entity.CYQty;
string sql = "";
en.RCKF = 0m;
en.CJRC = 0m;
en.FMRC = 0m;
en.ZCKF = 0m;
en.CJZC = 0m;
en.FMZC = 0m;
en.MQty3 = 0m;
#region 统计合计数据
sql = "SELECT SUM(DQuantity) DQuantity,SUM(Deduction) Deduction,SUM(DYM) DYM,B.CDType FROM WO_BProductCheckDtsFault AS A,Data_CDGL AS B WHERE A.FaultDes=B.Code AND A.MainID=" + entity.MainID + " GROUP BY B.CDType";
DataTable dt = sqlTrans.Fill(sql);
foreach (DataRow dr in dt.Rows)
{
if (dr["CDType"].ToString() == "染疵")
{
// DQuantity// 放码
//Deduction扣分
//DYM 裁剪
en.RCKF = SysConvert.ToDecimal(dr["Deduction"]);
en.CJRC = SysConvert.ToDecimal(dr["DYM"]);
en.FMRC = SysConvert.ToDecimal(dr["DQuantity"]);
}
else if (dr["CDType"].ToString() == "织疵")
{
en.ZCKF = SysConvert.ToDecimal(dr["Deduction"]);
en.CJZC = SysConvert.ToDecimal(dr["DYM"]);
en.FMZC = SysConvert.ToDecimal(dr["DQuantity"]);
}
else
{
en.MQty3 = SysConvert.ToDecimal(dr["DQuantity"]);
}
}
BProductCheckDtsRule rulebp2 = new BProductCheckDtsRule();
rulebp2.RUpdate(en, sqlTrans);
#endregion
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 修改条码状态
/// </summary>
/// <param name="p_BE">要新增的实体</param>
public void ModifyLog(BProductCheckDts p_BE, BProductCheckDtsModifyLog p_BE2)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.ModifyLog(p_BE, p_BE2, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
private void CalcQty(BProductCheckDts entity)
{
//==entity.KF25=1 开匹后新增加条码，entity.KF20 = 1，被开匹过的条码
if (entity.KF25 != 1 && entity.KF20 != 1) //不是开匹的才计算
{
entity.KF = entity.RCKF + entity.ZCKF; //合计扣分=织疵点+染疵点
entity.Qty = entity.SM - entity.CJRC - entity.CJZC - entity.FMZC - entity.FMRC - entity.CY - entity.MQty3;
entity.MQty4 = entity.SM - entity.CJRC - entity.CJZC - entity.FMZC - entity.FMRC - entity.CY - entity.MQty3;
if (entity.Qty != 0m)
{
entity.BMKF = entity.KF / entity.Qty;
}
if (entity.MQty4 != 0m)
{
entity.FMQty = SysConvert.ToDecimal(entity.MQty4 * 1.0936132983377m);
}
else
{
entity.FMQty = SysConvert.ToDecimal(entity.Qty * 1.0936132983377m);
}
if (!SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(6428)))//仓库出库选择客户直接带出该客户相关单据
{
entity.Qty = GetChangeQty(entity.Qty);
entity.FMQty = GetChangeQty(entity.FMQty);
}
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="p_BE">要删除的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RDelete(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
BProductCheckDts entity = (BProductCheckDts)p_BE;
BProductCheckDtsCtl control = new BProductCheckDtsCtl(sqlTrans);
control.Delete(entity);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
BProductCheckDts entity = (BProductCheckDts)p_BE;
if (entity.ID == 0)
{
BProductCheckDtsCtl control = new BProductCheckDtsCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.WO_BProductCheckDts, sqlTrans);
if (entity.Seq == 0)
{
entity.StatusID = (int)EnumBoxStatus.未入库;
entity.DISN = GetDISN(sqlTrans);
entity.Seq = GetMaxSeq(entity.MainID, entity.JarNum, sqlTrans);
}
//CalcQty(entity);
control.AddNew(entity);
}
else
{
if (entity.StatusID != (int)EnumBoxStatus.未入库)//已经入库的条码不能修改
{
throw new Exception("条码不是初始状态不能修改");
}
RUpdate(entity, sqlTrans);
}
///RCalcMZJZ(entity, sqlTrans);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RAdd2(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
BProductCheckDts entity = (BProductCheckDts)p_BE;
BProductCheckDtsCtl control = new BProductCheckDtsCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.WO_BProductCheckDts, sqlTrans);
control.AddNew(entity);
RCalcMZJZ(entity, sqlTrans);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RSubmitInWH(List <BProductCheckDts> p_BE, string WHID, string SectionID, IDBTransAccess sqlTrans)
{
try
{
string CheckItem = GetListID(p_BE);
//1检验是否入库
string sql = "SELECT StatusID,ID FROM WO_BProductCheckDts WHERE StatusID>" + (int)EnumBoxStatus.未入库 + " AND ID IN (" + CheckItem + ")";
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count != 0)
{
BProductCheckDts entity = new BProductCheckDts(sqlTrans);
entity.ID = SysConvert.ToInt32(dt.Rows[0]["ID"]);
entity.SelectByID();
throw new Exception("条码" + entity.DISN + " 已经入库请检查");
}
//2校验通过，开始创建入库单。
sql = "SELECT ItemCode,ItemName,ItemStd,ItemModel,ColorNum,ColorName,JarNum,MF,KZ,ShopID,VendorID,SUM(Qty) Qty,SUM(YQty) Weight,DLever,CompactNo,SaleOPID,JSUnit FROM UV1_WO_BProductCheckDts WHERE DID IN(" + CheckItem + ")";
sql += " GROUP BY ItemCode,ItemName,ItemStd,ItemModel,ColorNum,ColorName,JarNum,MF,KZ,ShopID,VendorID,DLever,CompactNo,SaleOPID,JSUnit";
dt = sqlTrans.Fill(sql);
sql = "SELECT DISTINCT ShopID FROM UV1_WO_BProductCheckDts WHERE DID IN(" + CheckItem + ")";
DataTable dtshop = sqlTrans.Fill(sql);//本次勾选的是那几家染厂的数据
sql = "SELECT * FROM UV1_WO_BProductCheckDts WHERE DID IN(" + CheckItem + ")";
DataTable dtall = sqlTrans.Fill(sql);
foreach (DataRow drshop in dtshop.Rows)//一家染厂一个入库单
{
IOForm IOentity = new IOForm(sqlTrans);
IOentity.FormDate = DateTime.Now.Date;
IOentity.WHID = WHID;
IOentity.WHType = WHID;
IOentity.HeadType = 11;
IOentity.SubType = 1107;
IOentity.VendorID = drshop["ShopID"].ToString();
FormNoControlRule ruleno = new FormNoControlRule();
IOentity.FormNo = ruleno.RGetWHFormNo(IOentity.HeadType, IOentity.SubType, IOentity.WHID, sqlTrans);
IOentity.Remark = "检验后入库";
DataRow[] Shopinwh = dt.Select("ShopID=" + SysString.ToDBString(drshop["ShopID"].ToString()));//一家染厂多个缸号或品种
IOFormDts[] entitydts = new IOFormDts[Shopinwh.Length];
ArrayList List = new ArrayList();
int i = 0;
foreach (DataRow drinwh in Shopinwh)//一家染厂多个缸号或品种
{
entitydts[i] = new IOFormDts(sqlTrans);
entitydts[i].Seq = i + 1;
entitydts[i].WHID = IOentity.WHID;
entitydts[i].SectionID = SectionID;
entitydts[i].SBitID = "";
entitydts[i].ItemCode = drinwh["ItemCode"].ToString();
//entitydts[i].CPItemCode = entitydts[i].ItemCode;
entitydts[i].ItemName = drinwh["ItemName"].ToString();
entitydts[i].ItemModel = drinwh["ItemName"].ToString();
entitydts[i].ItemStd = drinwh["ItemStd"].ToString();
entitydts[i].ItemModel = drinwh["ItemModel"].ToString();
entitydts[i].ColorNum = drinwh["ColorNum"].ToString();
entitydts[i].ColorName = drinwh["ColorName"].ToString();
entitydts[i].JarNum = drinwh["JarNum"].ToString();
entitydts[i].MWeight = SysConvert.ToDecimal(drinwh["KZ"]);
entitydts[i].MWidth = SysConvert.ToDecimal(drinwh["MF"]);
entitydts[i].DtsSO = drinwh["CompactNo"].ToString();
entitydts[i].DtsOrderFormNo = drinwh["CompactNo"].ToString();
//entitydts[i].DtsOrderFormNo = drinwh["SO"].ToString();
//entitydts[i].InSO = drinwh["SO"].ToString();
entitydts[i].InSaleOPID = drinwh["SaleOPID"].ToString();
entitydts[i].DtsVendorID = drinwh["VendorID"].ToString();
entitydts[i].GoodsLevel = drinwh["DLever"].ToString();
entitydts[i].Qty = SysConvert.ToDecimal(drinwh["Qty"]);
entitydts[i].Weight = SysConvert.ToDecimal(drinwh["Weight"]);
entitydts[i].Remark = "检验入成品库";
entitydts[i].Unit = drinwh["JSUnit"].ToString();
entitydts[i].PackFlag = 1;//细码标志
// ItemCode,ItemName,ItemStd,ColorNum,ColorName,JarNum,ShopID,VendorID,SUM(Qty) Qty,SUM(YQty) Weight,DLever,CompactNo,SO,SaleOPID
// ,,,,,,,,SUM(Qty) Qty,SUM(YQty) Weight,,,,
DataRow[] ISN = dtall.Select("ISNULL(ItemCode,'')=" + SysString.ToDBString(drinwh["ItemCode"].ToString())
+ " AND ISNULL(ItemName,'')=" + SysString.ToDBString(drinwh["ItemName"].ToString())
+ " AND ISNULL(ItemStd,'')=" + SysString.ToDBString(drinwh["ItemStd"].ToString())
+ " AND ISNULL(ItemModel,'')=" + SysString.ToDBString(drinwh["ItemModel"].ToString())
+ " AND ISNULL(ColorName,'')=" + SysString.ToDBString(drinwh["ColorName"].ToString())
+ " AND ISNULL(ColorNum,'')=" + SysString.ToDBString(drinwh["ColorNum"].ToString())
+ " AND ISNULL(JarNum,'')=" + SysString.ToDBString(drinwh["JarNum"].ToString())
//+ " AND ISNULL(MF,'')=" + SysString.ToDBString(drinwh["MF"].ToString())
// + " AND ISNULL(KZ,'')=" + SysString.ToDBString(drinwh["KZ"].ToString())
+ " AND ISNULL(ShopID,'')=" + SysString.ToDBString(dt.Rows[i]["ShopID"].ToString())
+ " AND ISNULL(VendorID,'')=" + SysString.ToDBString(dt.Rows[i]["VendorID"].ToString())
+ " AND ISNULL(DLever,'')=" + SysString.ToDBString(dt.Rows[i]["DLever"].ToString())
+ " AND ISNULL(CompactNo,'')=" + SysString.ToDBString(dt.Rows[i]["CompactNo"].ToString())
+ " AND ISNULL(SaleOPID,'')=" + SysString.ToDBString(dt.Rows[i]["SaleOPID"].ToString()));
entitydts[i].PieceQty = ISN.Length;
int m = 0;
foreach (DataRow dr in ISN)
{
IOFormDtsPack entity = new IOFormDtsPack(sqlTrans);
entity.Seq = i + 1;
entity.SubSeq = m + 1;
entity.BoxNo = dr["DISN"].ToString();
entity.Qty = SysConvert.ToDecimal(dr["Qty"]);
entity.Remark = "检验入成品库";
List.Add(entity);
m++;
}
i++;
}
decimal TotalQty = 0;
for (int j = 0; j < entitydts.Length; j++)
{
TotalQty += entitydts[j].Qty;
}
IOentity.TotalQty = TotalQty;
IOFormRule rule2 = new IOFormRule();
rule2.RAdd(IOentity, entitydts, List, sqlTrans);
rule2.RSubmit(IOentity.ID, (int)ConfirmFlag.已提交, sqlTrans);
}
//3更新条码状态（这步动作是在入库提交的时候处理）
sql = "Update WO_BProductCheckDts Set InWHFlag=1 WHERE ID IN(" + CheckItem + ")";
sqlTrans.ExecuteNonQuery(sql);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 检验结束
/// </summary>
/// <param name="p_BE">要删除的实体</param>
/// <param name="sqlTrans">事务类</param>
public int RJYEnd(int p_BE, BProductCheckDts entity2, int p_PackID, decimal Qty, decimal YMQty, int JarNo, IDBTransAccess sqlTrans)
{
try
{
if (p_BE == 0)//如果是0 则表示没有疵点
{
entity2.MainID = p_PackID;
BProductCheckDtsRule rulebp = new BProductCheckDtsRule();
rulebp.RAdd(entity2, sqlTrans);
p_BE = entity2.ID;
}
BProductCheckDts entity = new BProductCheckDts(sqlTrans);
entity.ID = p_BE;
entity.SelectByID();
entity.MainID = p_PackID;
entity.YM = YMQty;
entity.SM = Qty; //码表数量
entity.FMQty = entity2.FMQty; //放码数量
entity.KZ = entity2.KZ; //克重
entity.MF = entity2.MF; //门幅
entity.WX = entity2.WX; //纬斜
entity.PrintCD = entity2.PrintCD; //打印疵点项目
entity.ColorName = entity2.ColorName; //颜色
entity.ColorNum = entity2.ColorNum; //色号
entity.GoodsLevel = entity2.GoodsLevel; //等级
entity.Qty = entity2.SM - entity2.FMQty; //数量=码表数量-放码数量
string sqls = "Select ISNULL(Max(JarNo),0) From WO_BProductCheckDts where JarNum=" + SysString.ToDBString(SysConvert.ToString(entity.JarNum));
sqls += " AND ItemCode=" + SysString.ToDBString(SysConvert.ToString(entity.ItemCode));
sqls += " AND ColorNum=" + SysString.ToDBString(SysConvert.ToString(entity.ColorNum));
DataTable dts = sqlTrans.Fill(sqls);
if ((SysConvert.ToInt32(dts.Rows[0][0]) + 1) != JarNo)
{
entity.JarNo = SysConvert.ToInt32(dts.Rows[0][0]) + 1;//卷号
}
else
{
entity.JarNo = JarNo;//卷号
}
entity.ShopID = entity2.ShopID;
entity.YQty = SysConvert.ToDecimal(Qty * 1.0936132983377m, 2);//米数转码数
BProductCheckDtsRule rule = new BProductCheckDtsRule();
rule.RUpdate(entity, sqlTrans);
#region 统计合计数据
entity.RCKF = 0m;
entity.CJRC = 0m;
entity.FMRC = 0m;
entity.ZCKF = 0m;
entity.CJZC = 0m;
entity.FMZC = 0m;
entity.MQty3 = 0m;
string sql = "SELECT SUM(DQuantity) DQuantity,SUM(Deduction) Deduction,SUM(DYM) DYM,B.CDType FROM WO_BProductCheckDtsFault AS A,Data_CDGL AS B WHERE A.FaultDes=B.Code AND A.MainID=" + p_BE + " GROUP BY B.CDType";
DataTable dt = sqlTrans.Fill(sql);
foreach (DataRow dr in dt.Rows)
{
if (dr["CDType"].ToString() == "染疵")
{
entity.RCKF = SysConvert.ToDecimal(dr["Deduction"]);
entity.CJRC = SysConvert.ToDecimal(dr["DYM"]);
entity.FMRC = SysConvert.ToDecimal(dr["DQuantity"]);
}
else if (dr["CDType"].ToString() == "织疵")
{
entity.ZCKF = SysConvert.ToDecimal(dr["Deduction"]);
entity.CJZC = SysConvert.ToDecimal(dr["DYM"]);
entity.FMZC = SysConvert.ToDecimal(dr["DQuantity"]);
}
else
{
//entity.MQty3 = SysConvert.ToDecimal(dr["DQuantity"]);
entity.ZCKF = SysConvert.ToDecimal(dr["Deduction"]);
entity.CJZC = SysConvert.ToDecimal(dr["DYM"]);
entity.FMZC = SysConvert.ToDecimal(dr["DQuantity"]);
}
}
entity.SJQty = SysConvert.ToDecimal(entity.SM - entity.CJZC - entity.CJRC - entity.FMQty, 1);//实际数量=码表数量-裁剪数量-放码数量
BProductCheckDtsRule rulebp2 = new BProductCheckDtsRule();
rulebp2.RUpdate(entity, sqlTrans);
#endregion
#region 合计检验米数汇总到待检清单
sql = "Select SUM(Qty) Qty from WO_BProductCheckDts where MainID=" + p_PackID;
DataTable dtS = sqlTrans.Fill(sql);
if (dtS.Rows.Count != 0)
{
sql = "Update WO_PackOrderDts Set CheckQty=" + SysConvert.ToDecimal(dtS.Rows[0]["Qty"]);
sql += " where ID=" + p_PackID;
sqlTrans.ExecuteNonQuery(sql);
}
#endregion
return(p_BE);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public int RSaveFault(BProductCheckDtsFault p_BE, BProductCheckDts entityMain, int MainID, int PackDtsID, IDBTransAccess sqlTrans)
{
try
{
if (PackDtsID == 0)
{
throw new Exception("请先选择检验指示单");
}
BProductCheckDtsFault entity = p_BE as BProductCheckDtsFault;
if (MainID == 0)
{
entityMain.MainID = PackDtsID;
BProductCheckDtsRule rulebp = new BProductCheckDtsRule();
if (entity.DQuantity == 0m && entity.Deduction == 0m && entity.DYM == 0m && entity.CYQty == 0m)//统匹毛病
{
entityMain.VColorName = entity.FaultDes;
entity.Position = "统匹";
}
entityMain.CY += entity.CYQty;
rulebp.RAdd(entityMain, sqlTrans);
entity.MainID = entityMain.ID;
}
else
{
BProductCheckDtsRule rulebp = new BProductCheckDtsRule();
if (entity.DQuantity == 0m && entity.Deduction == 0m && entity.DYM == 0m && entity.CYQty == 0m)//统匹毛病
{
entityMain.VColorName = entity.FaultDes;
entity.Position = "统匹";
}
entityMain.CY += entity.CYQty;
rulebp.RUpdate(entityMain, sqlTrans);
}
RAdd(entity, sqlTrans);
string sql = "";
#region 统计合计数据
sql = "SELECT SUM(DQuantity) DQuantity,SUM(Deduction) Deduction,SUM(DYM) DYM,B.CDType,SUM(CYQty) CYQty FROM WO_BProductCheckDtsFault AS A,Data_CDGL AS B WHERE A.FaultDes=B.Code AND A.MainID=" + entityMain.ID + " GROUP BY B.CDType";
DataTable dt = sqlTrans.Fill(sql);
entityMain.RCKF = 0m;
entityMain.CJRC = 0m;
entityMain.FMRC = 0m;
entityMain.ZCKF = 0m;
entityMain.CJZC = 0m;
entityMain.FMZC = 0m;
entityMain.MQty3 = 0m;
foreach (DataRow dr in dt.Rows)
{
if (dr["CDType"].ToString() == "染疵")
{
// DQuantity// 放码
//Deduction扣分
//DYM 裁剪
entityMain.RCKF = SysConvert.ToDecimal(dr["Deduction"]);
entityMain.CJRC = SysConvert.ToDecimal(dr["DYM"]);
entityMain.FMRC = SysConvert.ToDecimal(dr["DQuantity"]);
}
else if (dr["CDType"].ToString() == "织疵")
{
entityMain.ZCKF = SysConvert.ToDecimal(dr["Deduction"]);
entityMain.CJZC = SysConvert.ToDecimal(dr["DYM"]);
entityMain.FMZC = SysConvert.ToDecimal(dr["DQuantity"]);
}
else
{
entityMain.MQty3 = SysConvert.ToDecimal(dr["DQuantity"]);
}
}
BProductCheckDtsRule rulebp2 = new BProductCheckDtsRule();
rulebp2.RUpdate(entityMain, sqlTrans);
#endregion
return(entity.MainID);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void ModifyLog(BProductCheckDts p_BE, BProductCheckDtsModifyLog p_BE2, IDBTransAccess sqlTrans)
{
try
{
if (p_BE.StatusID != (int)EnumBoxStatus.未入库)
{
throw new Exception("不是已经出库的条码，不能修改");
}
if (p_BE.KF24 == 1)
{
throw new Exception("此匹布已经修改过一次了，不能在此修改");
}
#region 备份的老条码
BProductCheckDts entityold = new BProductCheckDts(sqlTrans);
entityold.ID = p_BE.ID;
entityold.SelectByID();//复制的老条码
#endregion
#region 更新老的条码为新的条码，只换条码号，和修改的内容，其他信息不变
if (p_BE2.CompactNo != string.Empty)
{
p_BE2.OldCompactNo = p_BE.CompactNo;
p_BE.CompactNo = p_BE2.CompactNo;
string sqlcheck = "SELECT ID FROM Sale_SaleOrder WHERE FormNo=" + SysString.ToDBString(p_BE2.CompactNo) + " AND SubmitFlag=1";
DataTable dtcheck = sqlTrans.Fill(sqlcheck);
if (dtcheck.Rows.Count != 1)
{
throw new Exception("变更的合同号不存在，请检查");
}
}
if (p_BE2.JarNum != string.Empty)
{
p_BE2.OldJarNum = p_BE.JarNum;
p_BE.JarNum = p_BE2.JarNum;
}
if (p_BE2.Seq != 0)
{
p_BE2.OldSeq = p_BE.Seq;
p_BE.Seq = p_BE2.Seq;
}
p_BE.KF24 = 0;
p_BE.KF22 = 1;//退货冲销后产生的新的条码
p_BE.DISN = GetDISN(sqlTrans);
p_BE.StatusID = (int)EnumBoxStatus.未入库;
RUpdate2(p_BE, sqlTrans);
#endregion
#region 备份老的条码，标志为不可修改，并增加Log日志
p_BE2.ModifyID = p_BE.ID;
entityold.StatusID = (int)EnumBoxStatus.未入库;
entityold.KF24 = 1;//修改后新产生条码
entityold.ID = 0;
RAdd2(entityold, sqlTrans);
p_BE2.NewISNID = entityold.ID;//新产生条码的ID
BProductCheckDtsModifyLogRule rule = new BProductCheckDtsModifyLogRule();
rule.RAdd(p_BE2, sqlTrans);
#endregion
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 检查将要操作的数据是否符合业务规则
/// </summary>
/// <param name="p_BE"></param>
private void CheckCorrect(BaseEntity p_BE)
{
BProductCheckDts entity = (BProductCheckDts)p_BE;
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Update(BaseEntity p_Entity)
{
try
{
BProductCheckDts MasterEntity=(BProductCheckDts)p_Entity;
if (MasterEntity.ID==0)
{
return 0;
}
//更新主表数据
StringBuilder UpdateBuilder=new StringBuilder();
UpdateBuilder.Append("UPDATE WO_BProductCheckDts SET ");
UpdateBuilder.Append(" ID="+SysString.ToDBString(MasterEntity.ID)+",");
UpdateBuilder.Append(" MainID="+SysString.ToDBString(MasterEntity.MainID)+",");
UpdateBuilder.Append(" Seq="+SysString.ToDBString(MasterEntity.Seq)+",");
UpdateBuilder.Append(" DISN="+SysString.ToDBString(MasterEntity.DISN)+",");
UpdateBuilder.Append(" StatusID="+SysString.ToDBString(MasterEntity.StatusID)+",");
UpdateBuilder.Append(" Fault="+SysString.ToDBString(MasterEntity.Fault)+",");
UpdateBuilder.Append(" ItemCode="+SysString.ToDBString(MasterEntity.ItemCode)+",");
UpdateBuilder.Append(" ItemName="+SysString.ToDBString(MasterEntity.ItemName)+",");
if(MasterEntity.Qty!=0)
{
UpdateBuilder.Append(" Qty="+SysString.ToDBString(MasterEntity.Qty)+",");
}
else
{
UpdateBuilder.Append(" Qty=null,");
}
if(MasterEntity.YQty!=0)
{
UpdateBuilder.Append(" YQty="+SysString.ToDBString(MasterEntity.YQty)+",");
}
else
{
UpdateBuilder.Append(" YQty=null,");
}
if(MasterEntity.Weight!=0)
{
UpdateBuilder.Append(" Weight="+SysString.ToDBString(MasterEntity.Weight)+",");
}
else
{
UpdateBuilder.Append(" Weight=null,");
}
if(MasterEntity.YWeight!=0)
{
UpdateBuilder.Append(" YWeight="+SysString.ToDBString(MasterEntity.YWeight)+",");
}
else
{
UpdateBuilder.Append(" YWeight=null,");
}
if(MasterEntity.CJQty!=0)
{
UpdateBuilder.Append(" CJQty="+SysString.ToDBString(MasterEntity.CJQty)+",");
}
else
{
UpdateBuilder.Append(" CJQty=null,");
}
if(MasterEntity.FMQty!=0)
{
UpdateBuilder.Append(" FMQty="+SysString.ToDBString(MasterEntity.FMQty)+",");
}
else
{
UpdateBuilder.Append(" FMQty=null,");
}
UpdateBuilder.Append(" SO="+SysString.ToDBString(MasterEntity.SO)+",");
UpdateBuilder.Append(" CompactNo="+SysString.ToDBString(MasterEntity.CompactNo)+",");
UpdateBuilder.Append(" DLever="+SysString.ToDBString(MasterEntity.DLever)+",");
if(MasterEntity.Deduction!=0)
{
UpdateBuilder.Append(" Deduction="+SysString.ToDBString(MasterEntity.Deduction)+",");
}
else
{
UpdateBuilder.Append(" Deduction=null,");
}
if(MasterEntity.MQty1!=0)
{
UpdateBuilder.Append(" MQty1="+SysString.ToDBString(MasterEntity.MQty1)+",");
}
else
{
UpdateBuilder.Append(" MQty1=null,");
}
if(MasterEntity.MQty2!=0)
{
UpdateBuilder.Append(" MQty2="+SysString.ToDBString(MasterEntity.MQty2)+",");
}
else
{
UpdateBuilder.Append(" MQty2=null,");
}
if(MasterEntity.MQty3!=0)
{
UpdateBuilder.Append(" MQty3="+SysString.ToDBString(MasterEntity.MQty3)+",");
}
else
{
UpdateBuilder.Append(" MQty3=null,");
}
if(MasterEntity.MQty4!=0)
{
UpdateBuilder.Append(" MQty4="+SysString.ToDBString(MasterEntity.MQty4)+",");
}
else
{
UpdateBuilder.Append(" MQty4=null,");
}
if(MasterEntity.MQty5!=0)
{
UpdateBuilder.Append(" MQty5="+SysString.ToDBString(MasterEntity.MQty5)+",");
}
else
{
UpdateBuilder.Append(" MQty5=null,");
}
UpdateBuilder.Append(" RepairFlag="+SysString.ToDBString(MasterEntity.RepairFlag)+",");
if(MasterEntity.RepairCount!=0)
{
UpdateBuilder.Append(" RepairCount="+SysString.ToDBString(MasterEntity.RepairCount)+",");
}
else
{
UpdateBuilder.Append(" RepairCount=null,");
}
UpdateBuilder.Append(" InitialISN="+SysString.ToDBString(MasterEntity.InitialISN)+",");
UpdateBuilder.Append(" Remark="+SysString.ToDBString(MasterEntity.Remark)+",");
UpdateBuilder.Append(" RepairReason="+SysString.ToDBString(MasterEntity.RepairReason)+",");
UpdateBuilder.Append(" ItemStd="+SysString.ToDBString(MasterEntity.ItemStd)+",");
UpdateBuilder.Append(" JarNum="+SysString.ToDBString(MasterEntity.JarNum)+",");
UpdateBuilder.Append(" ShopID="+SysString.ToDBString(MasterEntity.ShopID)+",");
UpdateBuilder.Append(" VendorID="+SysString.ToDBString(MasterEntity.VendorID)+",");
if(MasterEntity.JarCount!=0)
{
UpdateBuilder.Append(" JarCount="+SysString.ToDBString(MasterEntity.JarCount)+",");
}
else
{
UpdateBuilder.Append(" JarCount=null,");
}
if(MasterEntity.MaXIndex!=0)
{
UpdateBuilder.Append(" MaXIndex="+SysString.ToDBString(MasterEntity.MaXIndex)+",");
}
else
{
UpdateBuilder.Append(" MaXIndex=null,");
}
UpdateBuilder.Append(" ColorName="+SysString.ToDBString(MasterEntity.ColorName)+",");
UpdateBuilder.Append(" ColorNum="+SysString.ToDBString(MasterEntity.ColorNum)+",");
UpdateBuilder.Append(" VColorName="+SysString.ToDBString(MasterEntity.VColorName)+",");
UpdateBuilder.Append(" VColorNum="+SysString.ToDBString(MasterEntity.VColorNum)+",");
if(MasterEntity.CheckDate!=SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" CheckDate="+SysString.ToDBString(MasterEntity.CheckDate.ToString("yyyy-MM-dd HH:mm:ss"))+",");
}
else
{
UpdateBuilder.Append(" CheckDate=null,");
}
UpdateBuilder.Append(" CheckOPID="+SysString.ToDBString(MasterEntity.CheckOPID)+",");
UpdateBuilder.Append(" MF="+SysString.ToDBString(MasterEntity.MF)+",");
if(MasterEntity.KZ!=0)
{
UpdateBuilder.Append(" KZ="+SysString.ToDBString(MasterEntity.KZ)+",");
}
else
{
UpdateBuilder.Append(" KZ=null,");
}
UpdateBuilder.Append(" ZNMF="+SysString.ToDBString(MasterEntity.ZNMF)+",");
if(MasterEntity.XMQty!=0)
{
UpdateBuilder.Append(" XMQty="+SysString.ToDBString(MasterEntity.XMQty)+",");
}
else
{
UpdateBuilder.Append(" XMQty=null,");
}
if(MasterEntity.BMKF!=0)
{
UpdateBuilder.Append(" BMKF="+SysString.ToDBString(MasterEntity.BMKF)+",");
}
else
{
UpdateBuilder.Append(" BMKF=null,");
}
if(MasterEntity.JYBZ!=0)
{
UpdateBuilder.Append(" JYBZ="+SysString.ToDBString(MasterEntity.JYBZ)+",");
}
else
{
UpdateBuilder.Append(" JYBZ=null,");
}
if(MasterEntity.CY!=0)
{
UpdateBuilder.Append(" CY="+SysString.ToDBString(MasterEntity.CY)+",");
}
else
{
UpdateBuilder.Append(" CY=null,");
}
if(MasterEntity.CJZC!=0)
{
UpdateBuilder.Append(" CJZC="+SysString.ToDBString(MasterEntity.CJZC)+",");
}
else
{
UpdateBuilder.Append(" CJZC=null,");
}
if(MasterEntity.CJRC!=0)
{
UpdateBuilder.Append(" CJRC="+SysString.ToDBString(MasterEntity.CJRC)+",");
}
else
{
UpdateBuilder.Append(" CJRC=null,");
}
if(MasterEntity.WX!=0)
{
UpdateBuilder.Append(" WX="+SysString.ToDBString(MasterEntity.WX)+",");
}
else
{
UpdateBuilder.Append(" WX=null,");
}
if(MasterEntity.ZCKF!=0)
{
UpdateBuilder.Append(" ZCKF="+SysString.ToDBString(MasterEntity.ZCKF)+",");
}
else
{
UpdateBuilder.Append(" ZCKF=null,");
}
if(MasterEntity.RCKF!=0)
{
UpdateBuilder.Append(" RCKF="+SysString.ToDBString(MasterEntity.RCKF)+",");
}
else
{
UpdateBuilder.Append(" RCKF=null,");
}
if(MasterEntity.KF!=0)
{
UpdateBuilder.Append(" KF="+SysString.ToDBString(MasterEntity.KF)+",");
}
else
{
UpdateBuilder.Append(" KF=null,");
}
if(MasterEntity.PF!=0)
{
UpdateBuilder.Append(" PF="+SysString.ToDBString(MasterEntity.PF)+",");
}
else
{
UpdateBuilder.Append(" PF=null,");
}
UpdateBuilder.Append(" FactoryCode="+SysString.ToDBString(MasterEntity.FactoryCode)+",");
if(MasterEntity.JarNumCount!=0)
{
UpdateBuilder.Append(" JarNumCount="+SysString.ToDBString(MasterEntity.JarNumCount)+",");
}
else
{
UpdateBuilder.Append(" JarNumCount=null,");
}
if(MasterEntity.YM!=0)
{
UpdateBuilder.Append(" YM="+SysString.ToDBString(MasterEntity.YM)+",");
}
else
{
UpdateBuilder.Append(" YM=null,");
}
if(MasterEntity.SM!=0)
{
UpdateBuilder.Append(" SM="+SysString.ToDBString(MasterEntity.SM)+",");
}
else
{
UpdateBuilder.Append(" SM=null,");
}
UpdateBuilder.Append(" JSUnit="+SysString.ToDBString(MasterEntity.JSUnit)+",");
UpdateBuilder.Append(" PT="+SysString.ToDBString(MasterEntity.PT)+",");
UpdateBuilder.Append(" ZG="+SysString.ToDBString(MasterEntity.ZG)+",");
UpdateBuilder.Append(" GZ="+SysString.ToDBString(MasterEntity.GZ)+",");
if(MasterEntity.FMZC!=0)
{
UpdateBuilder.Append(" FMZC="+SysString.ToDBString(MasterEntity.FMZC)+",");
}
else
{
UpdateBuilder.Append(" FMZC=null,");
}
if(MasterEntity.FMRC!=0)
{
UpdateBuilder.Append(" FMRC="+SysString.ToDBString(MasterEntity.FMRC)+",");
}
else
{
UpdateBuilder.Append(" FMRC=null,");
}
UpdateBuilder.Append(" SectionID="+SysString.ToDBString(MasterEntity.SectionID)+",");
UpdateBuilder.Append(" WHID="+SysString.ToDBString(MasterEntity.WHID)+",");
if(MasterEntity.MQty!=0)
{
UpdateBuilder.Append(" MQty="+SysString.ToDBString(MasterEntity.MQty)+",");
}
else
{
UpdateBuilder.Append(" MQty=null,");
}
if(MasterEntity.MWeight!=0)
{
UpdateBuilder.Append(" MWeight="+SysString.ToDBString(MasterEntity.MWeight)+",");
}
else
{
UpdateBuilder.Append(" MWeight=null,");
}
if(MasterEntity.KF20!=0)
{
UpdateBuilder.Append(" KF20="+SysString.ToDBString(MasterEntity.KF20)+",");
}
else
{
UpdateBuilder.Append(" KF20=null,");
}
if(MasterEntity.KF22!=0)
{
UpdateBuilder.Append(" KF22="+SysString.ToDBString(MasterEntity.KF22)+",");
}
else
{
UpdateBuilder.Append(" KF22=null,");
}
if(MasterEntity.KF24!=0)
{
UpdateBuilder.Append(" KF24="+SysString.ToDBString(MasterEntity.KF24)+",");
}
else
{
UpdateBuilder.Append(" KF24=null,");
}
if(MasterEntity.KF25!=0)
{
UpdateBuilder.Append(" KF25="+SysString.ToDBString(MasterEntity.KF25)+",");
}
else
{
UpdateBuilder.Append(" KF25=null,");
}
UpdateBuilder.Append(" InWHFlag="+SysString.ToDBString(MasterEntity.InWHFlag)+",");
if(MasterEntity.SJQty!=0)
{
UpdateBuilder.Append(" SJQty="+SysString.ToDBString(MasterEntity.SJQty)+",");
}
else
{
UpdateBuilder.Append(" SJQty=null,");
}
if(MasterEntity.JarNo!=0)
{
UpdateBuilder.Append(" JarNo="+SysString.ToDBString(MasterEntity.JarNo)+",");
}
else
{
UpdateBuilder.Append(" JarNo=null,");
}
UpdateBuilder.Append(" GoodsLevel="+SysString.ToDBString(MasterEntity.GoodsLevel)+",");
UpdateBuilder.Append(" PrintItemName="+SysString.ToDBString(MasterEntity.PrintItemName)+",");
UpdateBuilder.Append(" PrintGoodsCode="+SysString.ToDBString(MasterEntity.PrintGoodsCode)+",");
UpdateBuilder.Append(" PrintCD="+SysString.ToDBString(MasterEntity.PrintCD)+",");
UpdateBuilder.Append(" PrintRemark1="+SysString.ToDBString(MasterEntity.PrintRemark1)+",");
UpdateBuilder.Append(" PrintRemark2="+SysString.ToDBString(MasterEntity.PrintRemark2)+",");
UpdateBuilder.Append(" PrintRemark3="+SysString.ToDBString(MasterEntity.PrintRemark3)+",");
UpdateBuilder.Append(" PrintRemark4="+SysString.ToDBString(MasterEntity.PrintRemark4));
UpdateBuilder.Append(" WHERE "+ "ID="+SysString.ToDBString(MasterEntity.ID));
//执行
int AffectedRows=0;
if(!this.sqlTransFlag)
{
AffectedRows=this.ExecuteNonQuery(UpdateBuilder.ToString());
}
else
{
AffectedRows=sqlTrans.ExecuteNonQuery(UpdateBuilder.ToString());
}
return AffectedRows;
}
catch(BaseException E)
{
throw new BaseException(E.Message,E);
}
catch(Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBUpdate),E);
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int AddNew(BaseEntity p_Entity)
{
try
{
BProductCheckDts MasterEntity=(BProductCheckDts)p_Entity;
if (MasterEntity.ID==0)
{
return 0;
}
//新增主表数据
StringBuilder MasterField=new StringBuilder();
StringBuilder MasterValue=new StringBuilder();
MasterField.Append("INSERT INTO WO_BProductCheckDts(");
MasterValue.Append(" VALUES(");
MasterField.Append("ID"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ID)+",");
MasterField.Append("MainID"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MainID)+",");
MasterField.Append("Seq"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Seq)+",");
MasterField.Append("DISN"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.DISN)+",");
MasterField.Append("StatusID"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.StatusID)+",");
MasterField.Append("Fault"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Fault)+",");
MasterField.Append("ItemCode"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ItemCode)+",");
MasterField.Append("ItemName"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ItemName)+",");
MasterField.Append("Qty"+",");
if(MasterEntity.Qty!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.Qty)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("YQty"+",");
if(MasterEntity.YQty!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.YQty)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("Weight"+",");
if(MasterEntity.Weight!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.Weight)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("YWeight"+",");
if(MasterEntity.YWeight!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.YWeight)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("CJQty"+",");
if(MasterEntity.CJQty!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.CJQty)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("FMQty"+",");
if(MasterEntity.FMQty!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.FMQty)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("SO"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.SO)+",");
MasterField.Append("CompactNo"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.CompactNo)+",");
MasterField.Append("DLever"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.DLever)+",");
MasterField.Append("Deduction"+",");
if(MasterEntity.Deduction!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.Deduction)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("MQty1"+",");
if(MasterEntity.MQty1!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.MQty1)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("MQty2"+",");
if(MasterEntity.MQty2!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.MQty2)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("MQty3"+",");
if(MasterEntity.MQty3!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.MQty3)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("MQty4"+",");
if(MasterEntity.MQty4!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.MQty4)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("MQty5"+",");
if(MasterEntity.MQty5!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.MQty5)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("RepairFlag"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.RepairFlag)+",");
MasterField.Append("RepairCount"+",");
if(MasterEntity.RepairCount!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.RepairCount)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("InitialISN"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.InitialISN)+",");
MasterField.Append("Remark"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Remark)+",");
MasterField.Append("RepairReason"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.RepairReason)+",");
MasterField.Append("ItemStd"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ItemStd)+",");
MasterField.Append("JarNum"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.JarNum)+",");
MasterField.Append("ShopID"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ShopID)+",");
MasterField.Append("VendorID"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.VendorID)+",");
MasterField.Append("JarCount"+",");
if(MasterEntity.JarCount!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.JarCount)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("MaXIndex"+",");
if(MasterEntity.MaXIndex!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.MaXIndex)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("ColorName"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ColorName)+",");
MasterField.Append("ColorNum"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ColorNum)+",");
MasterField.Append("VColorName"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.VColorName)+",");
MasterField.Append("VColorNum"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.VColorNum)+",");
MasterField.Append("CheckDate"+",");
if(MasterEntity.CheckDate!=SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.CheckDate.ToString("yyyy-MM-dd HH:mm:ss"))+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("CheckOPID"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.CheckOPID)+",");
MasterField.Append("MF"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MF)+",");
MasterField.Append("KZ"+",");
if(MasterEntity.KZ!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.KZ)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("ZNMF"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ZNMF)+",");
MasterField.Append("XMQty"+",");
if(MasterEntity.XMQty!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.XMQty)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("BMKF"+",");
if(MasterEntity.BMKF!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.BMKF)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("JYBZ"+",");
if(MasterEntity.JYBZ!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.JYBZ)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("CY"+",");
if(MasterEntity.CY!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.CY)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("CJZC"+",");
if(MasterEntity.CJZC!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.CJZC)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("CJRC"+",");
if(MasterEntity.CJRC!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.CJRC)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("WX"+",");
if(MasterEntity.WX!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.WX)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("ZCKF"+",");
if(MasterEntity.ZCKF!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.ZCKF)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("RCKF"+",");
if(MasterEntity.RCKF!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.RCKF)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("KF"+",");
if(MasterEntity.KF!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.KF)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("PF"+",");
if(MasterEntity.PF!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.PF)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("FactoryCode"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.FactoryCode)+",");
MasterField.Append("JarNumCount"+",");
if(MasterEntity.JarNumCount!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.JarNumCount)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("YM"+",");
if(MasterEntity.YM!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.YM)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("SM"+",");
if(MasterEntity.SM!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.SM)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("JSUnit"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.JSUnit)+",");
MasterField.Append("PT"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.PT)+",");
MasterField.Append("ZG"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ZG)+",");
MasterField.Append("GZ"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.GZ)+",");
MasterField.Append("FMZC"+",");
if(MasterEntity.FMZC!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.FMZC)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("FMRC"+",");
if(MasterEntity.FMRC!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.FMRC)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("SectionID"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.SectionID)+",");
MasterField.Append("WHID"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.WHID)+",");
MasterField.Append("MQty"+",");
if(MasterEntity.MQty!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.MQty)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("MWeight"+",");
if(MasterEntity.MWeight!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.MWeight)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("KF20"+",");
if(MasterEntity.KF20!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.KF20)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("KF22"+",");
if(MasterEntity.KF22!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.KF22)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("KF24"+",");
if(MasterEntity.KF24!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.KF24)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("KF25"+",");
if(MasterEntity.KF25!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.KF25)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("InWHFlag"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.InWHFlag)+",");
MasterField.Append("SJQty"+",");
if(MasterEntity.SJQty!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.SJQty)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("JarNo"+",");
if(MasterEntity.JarNo!=0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.JarNo)+",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("GoodsLevel"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.GoodsLevel)+",");
MasterField.Append("PrintItemName"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.PrintItemName)+",");
MasterField.Append("PrintGoodsCode"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.PrintGoodsCode)+",");
MasterField.Append("PrintCD"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.PrintCD)+",");
MasterField.Append("PrintRemark1"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.PrintRemark1)+",");
MasterField.Append("PrintRemark2"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.PrintRemark2)+",");
MasterField.Append("PrintRemark3"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.PrintRemark3)+",");
MasterField.Append("PrintRemark4"+")");
MasterValue.Append(SysString.ToDBString(MasterEntity.PrintRemark4)+")");
//执行
int AffectedRows=0;
if(!this.sqlTransFlag)
{
AffectedRows=this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
else
{
AffectedRows=sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
return AffectedRows;
}
catch(BaseException E)
{
throw new BaseException(E.Message,E);
}
catch(Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert),E);
}
}
