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