/// <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); } }