/// <summary> /// 保存(传入事务处理) /// </summary> /// <param name="p_Entity"></param> /// <param name="p_BE"></param> /// <param name="sqlTrans"></param> public void RSave(ItemBuyForm p_Entity, BaseEntity[] p_BE, IDBTransAccess sqlTrans) { try { string sql = "DELETE FROM Buy_ItemBuyFormDts WHERE MainID=" + p_Entity.ID.ToString(); sql += " AND ID NOT IN" + string.Format("({0})", GetIDExist(p_BE)); sqlTrans.ExecuteNonQuery(sql);//删除原单据里应该删除的明细数据,即数据库里有但是UI里已经删除的数据 for (int i = 0; i < p_BE.Length; i++) { ItemBuyFormDts entitydts = (ItemBuyFormDts)p_BE[i]; if (entitydts.ID != 0)//ID不为0说明数据库中已经存在 { this.RUpdate(entitydts, sqlTrans); } else { entitydts.MainID = p_Entity.ID; this.RAdd(entitydts, sqlTrans); } } } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 获得实体 /// </summary> /// <returns></returns> private ItemBuyForm EntityGet() { ItemBuyForm entity = new ItemBuyForm(); entity.ID = HTDataID; return(entity); }
/// <summary> /// 保存资金明细 /// </summary> /// <param name="p_BE">要新增的实体</param> public void RSaveBuyCap(ItemBuyForm p_BEMain) { try { IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess(); try { sqlTrans.OpenTrans(); this.RSaveBuyCap(p_BEMain, sqlTrans); sqlTrans.CommitTrans(); } catch (Exception TE) { sqlTrans.RollbackTrans(); throw TE; } } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 删除 /// </summary> public override void EntityDelete() { ItemBuyFormRule rule = new ItemBuyFormRule(); ItemBuyForm entity = EntityGet(); rule.RDelete(entity); }
/// <summary> /// 获得实体 /// </summary> /// <returns></returns> private ItemBuyForm EntityGet() { ItemBuyForm entity = new ItemBuyForm(); entity.ID = HTDataID; entity.SelectByID(); entity.FormNo = txtFormNo.Text.Trim(); entity.MakeOPName = txtMakeOPName.Text.Trim(); entity.MakeDate = txtMakeDate.DateTime.Date; entity.FormDate = txtFormDate.DateTime.Date; entity.ReqDate = txtReqDate.DateTime.Date; entity.OrderFormNo = txtOrderFormNo.Text.Trim(); entity.TotalQty = SysConvert.ToDecimal(txtTotalQty.Text.Trim()); entity.TotalAmount = SysConvert.ToDecimal(txtTotalAmount.Text.Trim()); entity.PayMethodFlag = SysConvert.ToInt32(drpPayMothodFlag.EditValue); entity.Remark = SysConvert.ToString(txtRemark.Text.Trim()); entity.ShopID = SysConvert.ToString(drpVendorID.EditValue); entity.OrderFormNo = txtOrderFormNo.Text.Trim(); entity.OrderDate = txtOrderDate.DateTime; entity.ContractDesc = txtContractDesc.Text.Trim(); entity.SaleOPID = SysConvert.ToString(drpSaleOPID.EditValue); entity.CGOPID = SysConvert.ToString(drpCGOPID.EditValue); entity.FormAID = this.FormListAID; entity.MLType = (int)EnumMLType.辅料; return(entity); }
/// <summary> /// 新增(传入事务处理) /// </summary> /// <param name="p_BE">要新增的实体</param> /// <param name="sqlTrans">事务类</param> public void RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); ItemBuyForm entity = (ItemBuyForm)p_BE; string sql = "SELECT FormNo FROM Buy_ItemBuyForm WHERE FormNo=" + SysString.ToDBString(entity.FormNo); DataTable dt = sqlTrans.Fill(sql); if (dt.Rows.Count > 0) { throw new BaseException("采购单号已存在,请重新生成"); } ItemBuyFormCtl control = new ItemBuyFormCtl(sqlTrans); entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Buy_ItemBuyForm, sqlTrans); control.AddNew(entity); FormNoControlRule fnrule = new FormNoControlRule(); fnrule.RAddSort("Buy_ItemBuyForm", "FormNo", entity.FormAID, sqlTrans); } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 设置 /// </summary> public override void EntitySet() { ItemBuyForm entity = new ItemBuyForm(); entity.ID = HTDataID; bool findFlag = entity.SelectByID(); HTDataFormNo = entity.FormNo; txtFormNo.Text = entity.FormNo.ToString(); txtMakeOPName.Text = entity.MakeOPName.ToString(); txtMakeDate.DateTime = entity.MakeDate; txtFormDate.DateTime = entity.FormDate; txtReqDate.DateTime = entity.ReqDate; txtTotalQty.Text = entity.TotalQty.ToString(); txtTotalAmount.Text = entity.TotalAmount.ToString(); drpPayMothodFlag.EditValue = entity.PayMethodFlag; txtRemark.Text = entity.Remark.ToString(); drpVendorID.EditValue = entity.ShopID; txtOrderFormNo.Text = entity.OrderFormNo.ToString(); HTDataSubmitFlag = entity.SubmitFlag; HTDataDelFlag = entity.DelFlag; txtContractDesc.Text = entity.ContractDesc; txtOrderDate.DateTime = entity.OrderDate; drpCGOPID.EditValue = entity.CGOPID; drpSaleOPID.EditValue = entity.SaleOPID; if (!findFlag) { } BindGridDts(); BindOrderInfo(); }
/// <summary> /// 修改 /// </summary> /// <param name="p_BE">要修改的实体</param> /// <param name="sqlTrans">事务类</param> public void RUpdate(BaseEntity p_BE, BaseEntity[] p_BE2, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); ItemBuyForm entity = (ItemBuyForm)p_BE; ItemBuyFormCtl control = new ItemBuyFormCtl(sqlTrans); control.Update(entity); ItemBuyFormDtsRule rule = new ItemBuyFormDtsRule(); rule.RSave(entity, p_BE2, sqlTrans); //string sql = "DELETE Buy_ItemBuyFormDts WHERE MainID="+SysString.ToDBString(entity.ID); //sqlTrans.ExecuteNonQuery(sql); //for (int i = 0; i < p_BE2.Length; i++) //{ // ItemBuyFormDtsRule rule = new ItemBuyFormDtsRule(); // ItemBuyFormDts entityDts = (ItemBuyFormDts)p_BE2[i]; // entityDts.MainID = entity.ID; // entityDts.Seq = i + 1; // rule.RAdd(entityDts, sqlTrans); //} ItemBuyCapDtsRule capRule = new ItemBuyCapDtsRule(); capRule.RSaveBuyCap(entity, sqlTrans);//保存资金计划明细 } 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 { ItemBuyForm MasterEntity = (ItemBuyForm)p_Entity; if (MasterEntity.ID == 0) { return(0); } //删除主表数据 string Sql = ""; Sql = "DELETE FROM Buy_ItemBuyForm 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(BaseEntity p_BE, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); ItemBuyForm entity = (ItemBuyForm)p_BE; ItemBuyFormCtl control = new ItemBuyFormCtl(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, BaseEntity[] p_BE2, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); ItemBuyForm entity = (ItemBuyForm)p_BE; this.RAdd(entity, sqlTrans); for (int i = 0; i < p_BE2.Length; i++) { ItemBuyFormDtsRule rule = new ItemBuyFormDtsRule(); ItemBuyFormDts entityDts = (ItemBuyFormDts)p_BE2[i]; entityDts.MainID = entity.ID; entityDts.Seq = i + 1; rule.RAdd(entityDts, sqlTrans); } //FormNoControlRule rulest = new FormNoControlRule(); //switch (entity.FormAID) //注意各采购窗体的配置 //{ // case 0: // rulest.RAddSort((int)FormNoControlEnum.销售合同采购单号, sqlTrans); //采购成品面料 // break; // case 1: // rulest.RAddSort((int)FormNoControlEnum.坯布采购单号, sqlTrans); // break; // case 2: // rulest.RAddSort((int)FormNoControlEnum.纱线采购单号, sqlTrans); // break; // default: // rulest.RAddSort((int)FormNoControlEnum.销售合同采购单号, sqlTrans); // break; //} ItemBuyCapDtsRule capRule = new ItemBuyCapDtsRule(); capRule.RSaveBuyCap(entity, sqlTrans);//保存资金计划明细 } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 修改 /// </summary> public override void EntityUpdate() { ItemBuyFormRule rule = new ItemBuyFormRule(); ItemBuyForm entity = EntityGet(); ItemBuyFormDts[] entitydts = EntityDtsGet(); decimal totalqty = 0; decimal totalAmount = 0; for (int i = 0; i < entitydts.Length; i++) { totalqty += SysConvert.ToDecimal(entitydts[i].Qty); totalAmount += SysConvert.ToDecimal(entitydts[i].Amount); } entity.TotalQty = totalqty; entity.TotalAmount = totalAmount; entity.SubmitFlag = this.HTSubmitFlagUpdateGet(); rule.RUpdate(entity, entitydts); }
private void frmItemBuyFormEdit_FormClosing(object sender, FormClosingEventArgs e) { try { if (HTDataID > 0) { ItemBuyForm entity = new ItemBuyForm(); entity.ID = HTDataID; entity.SelectByID(); if (entity.SubmitFlag == 0) { if (DialogResult.Yes != ShowConfirmMessage(this.Text + Environment.NewLine + "没有提交单据,是否确认关闭窗体")) { e.Cancel = true; } } } } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 保存资金明细(传入事务处理) /// </summary> /// <param name="p_BE">要新增的实体</param> /// <param name="sqlTrans">事务类</param> public void RSaveBuyCap(ItemBuyForm p_BEMain, IDBTransAccess sqlTrans) { try { string sql = string.Empty; sql = "SELECT * FROM Buy_ItemBuyCapDts WHERE MainID=" + p_BEMain.ID + " ORDER BY Seq"; DataTable dtOld = sqlTrans.Fill(sql);//找到原始的ID sql = "SELECT * FROM Data_PayMethodDts WHERE MainID=" + SysConvert.ToInt32(p_BEMain.PayMethodFlag) + " ORDER BY Seq"; DataTable dtPayMethodDts = sqlTrans.Fill(sql);//付款方式明细 sql = "SELECT ItemCode,SUM(Amount) Amount FROM Buy_ItemBuyFormDts WHERE MainID=" + p_BEMain.ID + " GROUP BY ItemCode"; DataTable dtBuyDts = sqlTrans.Fill(sql);//采购单品种明细 //根据不同品种生成独立的付款明细 ItemBuyCapDts[] entityDts = new ItemBuyCapDts[dtPayMethodDts.Rows.Count * dtBuyDts.Rows.Count];//初始化资金明细实体数组 int ci = 0; for (int i = 0; i < dtPayMethodDts.Rows.Count; i++) { for (int m = 0; m < dtBuyDts.Rows.Count; m++)//多个品种生成独立的资金计划 { entityDts[ci] = new ItemBuyCapDts(); if (dtOld.Rows.Count > ci) { entityDts[ci].ID = SysConvert.ToInt32(dtOld.Rows[ci]["ID"]); } entityDts[ci].MainID = p_BEMain.ID; entityDts[ci].Seq = ci + 1; entityDts[ci].CapName = dtPayMethodDts.Rows[i]["Name"].ToString();//名称 entityDts[ci].PayStepTypeID = SysConvert.ToInt32(dtPayMethodDts.Rows[i]["PayStepTypeID"]); entityDts[ci].PayPer = SysConvert.ToDecimal(dtPayMethodDts.Rows[i]["PayPer"]); switch (SysConvert.ToInt32(dtPayMethodDts.Rows[i]["PayDateTypeInt"]))//根据付款判断日期类型类型 { case (int)EnumPayDateType.依据合同签署日: entityDts[ci].PayLimitDate = p_BEMain.FormDate.AddDays(SysConvert.ToInt32(dtPayMethodDts.Rows[i]["DelayDayNum"])).Date; //合同日延后多少天 break; case (int)EnumPayDateType.依据发货日: //备注下发货日;读取默认交期;后续发货后回填实际日期 entityDts[ci].Remark = "根据发货日"; entityDts[ci].PayLimitDate = p_BEMain.ReqDate.AddDays(SysConvert.ToInt32(dtPayMethodDts.Rows[i]["DelayDayNum"])).Date; break; } entityDts[ci].ItemCode = dtBuyDts.Rows[m]["ItemCode"].ToString(); entityDts[ci].PayAmount = SysConvert.ToDecimal(dtBuyDts.Rows[m]["Amount"]) * entityDts[ci].PayPer;//付款金额 ci++; } } this.RSave(p_BEMain, entityDts, sqlTrans);//保存明细 } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 检查将要操作的数据是否符合业务规则 /// </summary> /// <param name="p_BE"></param> private void CheckCorrect(BaseEntity p_BE) { ItemBuyForm entity = (ItemBuyForm)p_BE; }
/// <summary> /// 审核 /// </summary> /// <param name="p_FormID">单据ID</param> /// <param name="p_Type">0/1/2/3:弃审/审核</param> public void RSubmit(int p_FormID, int p_Type, IDBTransAccess sqlTrans) { try { int p_TempType = p_Type;//处理状态 string sql = string.Empty; ItemBuyForm entity = new ItemBuyForm(sqlTrans); entity.ID = p_FormID; entity.SelectByID(); if (entity.SubmitFlag == p_Type)//如果相同异常 { throw new Exception("单据状态重复设置,请关闭程序重新打开操作"); } if (p_Type == (int)ConfirmFlag.未提交) //撤销提交验证 { if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5609))) //采购单有仓库单据不允许修改 { bool allowOPFlag = true; string refuseMessage = string.Empty; DataTable dtSOFlow; if (allowOPFlag) { //仓库流程单据 sql = "SELECT TOP 1 ID,FormNo FROM UV1_WH_IOFormDts WHERE DtsSO=" + SysString.ToDBString(entity.FormNo); dtSOFlow = SysUtils.Fill(sql); if (dtSOFlow.Rows.Count != 0) { allowOPFlag = false; refuseMessage = "此单已有仓库单据(单号):" + dtSOFlow.Rows[0]["FormNo"].ToString() + ",不允许撤销"; } } if (!allowOPFlag)//不允许操作 { throw new Exception(refuseMessage); } } } sql = "UPDATE Buy_ItemBuyForm SET SubmitFlag=" + SysString.ToDBString(p_Type); //if (p_Type == (int)ConfirmFlag.审核通过 || p_Type == (int)ConfirmFlag.审核拒绝) //{ //sql += ",SubmitOPID=" + SysString.ToDBString(ParamConfig.LoginName) + ",SubmitTime=" + SysString.ToDBString(DateTime.Now); //} sql += " WHERE ID=" + p_FormID.ToString();//更新单据主表审核状态 sqlTrans.ExecuteNonQuery(sql); int tempSaleProcedureID = 0; switch (entity.FormAID)//1/2/3/4/5:成品,坯布,纱线,色坯,辅料 { case 1: tempSaleProcedureID = (int)EnumSaleProcedure.成品采购单; break; case 2: tempSaleProcedureID = (int)EnumSaleProcedure.坯布采购单; break; case 3: tempSaleProcedureID = (int)EnumSaleProcedure.纱线采购单; break; case 4: tempSaleProcedureID = (int)EnumSaleProcedure.坯布采购单; break; case 5: //辅料 tempSaleProcedureID = (int)EnumSaleProcedure.辅料采购单; break; } if (p_Type == (int)YesOrNo.Yes) { if (tempSaleProcedureID != (int)EnumSaleProcedure.坯布采购单) { sql = "SELECT DtsSO,ItemCode,ColorNum,ColorName FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID; DataTable dtDts = sqlTrans.Fill(sql); SaleOrderRule salerule = new SaleOrderRule(); foreach (DataRow dr in dtDts.Rows) { salerule.RUpdateStep(dr["DtsSO"].ToString(), dr["ItemCode"].ToString(), dr["ColorNum"].ToString(), dr["ColorName"].ToString(), tempSaleProcedureID, 0, 0, 0, p_Type, true, sqlTrans); } } else //坯布采购加载订单时候 将订单里的 ItemCode 加载到 CPItemCode { sql = "SELECT DtsSO,CPItemCode,ColorNum,ColorName FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID; DataTable dtDts = sqlTrans.Fill(sql); SaleOrderRule salerule = new SaleOrderRule(); foreach (DataRow dr in dtDts.Rows) { salerule.RUpdateStep(dr["DtsSO"].ToString(), dr["CPItemCode"].ToString(), dr["ColorNum"].ToString(), dr["ColorName"].ToString(), tempSaleProcedureID, 0, 0, 0, p_Type, true, sqlTrans); } } } //#region 回填采购完成数 //if (p_Type == (int)YesOrNo.Yes)//提交 //{ // if (entity.MLType == (int)EnumMLType.纱线 || entity.MLType == (int)EnumMLType.白坯) // { // decimal TotalQty = 0m; // sql = "SELECT SUM(Qty) Qty FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID; // DataTable dtDts = sqlTrans.Fill(sql); // if (dtDts.Rows.Count != 0) // { // TotalQty = SysConvert.ToDecimal(dtDts.Rows[0]["Qty"]); // } // sql = "SELECT ID FROM Sale_SaleOrderDts WHERE MainID=(SELECT ID FROM Sale_SaleOrder WHERE FormNo=" + SysString.ToDBString(entity.OrderFormNo) + ")"; // DataTable dtorder = sqlTrans.Fill(sql);//寻找原始订单 // if (dtorder.Rows.Count != 0) // { // while (TotalQty > 0m)//开始回填 // { // for (int i = 0; i < dtorder.Rows.Count;i++ ) // { // SaleOrderDts orderentity = new SaleOrderDts(sqlTrans); // orderentity.ID = SysConvert.ToInt32(dtorder.Rows[i]["ID"]); // bool findR=orderentity.SelectByID(); // if (i == dtorder.Rows.Count - 1) // { // switch (entity.MLType) // { // case (int)EnumMLType.纱线: // orderentity.PSCGQty += TotalQty; // TotalQty = 0; // break; // case (int)EnumMLType.白坯: // orderentity.PBCGQty += TotalQty; // TotalQty = 0; // break; // default: // break; // } // } // else // { // // decimal HTQty = DifQty <= TotalQty ? DifQty : TotalQty; // switch (entity.MLType) // { // case (int)EnumMLType.纱线: // decimal DifPSQty = orderentity.Qty - orderentity.PSCGQty; // if (TotalQty <= DifPSQty) // { // orderentity.PSCGQty += TotalQty; // TotalQty = 0; // break; // } // else // { // if (DifPSQty > 0) // { // orderentity.PSCGQty += DifPSQty; // TotalQty -= DifPSQty; // break; // } // } // break; // case (int)EnumMLType.白坯: // decimal DifPBQty = orderentity.Qty - orderentity.PBCGQty; // if (TotalQty <= DifPBQty) // { // orderentity.PBCGQty += TotalQty; // TotalQty = 0; // break; // } // else // { // if (DifPBQty > 0) // { // orderentity.PBCGQty += DifPBQty; // TotalQty -= DifPBQty; // break; // } // } // break; // default: // break; // } // } // if (findR) // { // SaleOrderDtsRule rule = new SaleOrderDtsRule(); // rule.RUpdate(orderentity, sqlTrans); // } // } //For循环结尾 // } //While结尾 // } // else // { // throw new Exception("数据出现异常未找到原始订单"); // } // } // if (entity.MLType == (int)EnumMLType.成品) // { // sql = "SELECT ItemCode,ColorNum,ColorName,Qty FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID; // DataTable dtDts1 = sqlTrans.Fill(sql); // foreach(DataRow dr in dtDts1.Rows) // { // sql = "SELECT DtsID FROM UV1_Sale_SaleOrderDts WHERE FormNo=" + SysString.ToDBString(entity.OrderFormNo); // sql += " AND ItemCode=" + SysString.ToDBString(dr["ItemCode"].ToString()); // sql += " AND ColorNum=" + SysString.ToDBString(dr["ColorNum"].ToString()); // sql += " AND ColorName=" + SysString.ToDBString(dr["ColorName"].ToString()); // DataTable dtorder = sqlTrans.Fill(sql);//寻找原始订单 // if (dtorder.Rows.Count == 1) // { // SaleOrderDts orderentity = new SaleOrderDts(sqlTrans); // orderentity.ID = SysConvert.ToInt32(dtorder.Rows[0]["DtsID"]); // bool findR=orderentity.SelectByID(); // orderentity.CPCGQty += SysConvert.ToDecimal(dr["Qty"]); // if (findR) // { // SaleOrderDtsRule rule = new SaleOrderDtsRule(); // rule.RUpdate(orderentity, sqlTrans); // } // } // else // { // throw new Exception("数据出现异常未找到原始订单 订单号:"+entity.FormNo); // } // } // } //} //else //撤销提交回填数量 //{ // if (entity.MLType == (int)EnumMLType.纱线 || entity.MLType == (int)EnumMLType.白坯) // { // decimal TotalQty = 0m; // sql = "SELECT SUM(Qty) Qty FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID; // DataTable dtDts = sqlTrans.Fill(sql); // if (dtDts.Rows.Count != 0) // { // TotalQty = SysConvert.ToDecimal(dtDts.Rows[0]["Qty"]); // } // sql = "SELECT ID FROM Sale_SaleOrderDts WHERE MainID=(SELECT ID FROM Sale_SaleOrder WHERE FormNo=" + SysString.ToDBString(entity.OrderFormNo) + ")"; // DataTable dtorder = sqlTrans.Fill(sql);//寻找原始订单 // if (dtorder.Rows.Count != 0) // { // while (TotalQty > 0m)//开始回填 // { // for (int i = 0; i < dtorder.Rows.Count; i++) // { // SaleOrderDts orderentity = new SaleOrderDts(sqlTrans); // orderentity.ID = SysConvert.ToInt32(dtorder.Rows[i]["ID"]); // bool findR=orderentity.SelectByID(); // if (i == dtorder.Rows.Count - 1) // { // switch (entity.MLType) // { // case (int)EnumMLType.纱线: // orderentity.PSCGQty -= TotalQty; // //if (orderentity.PSCGQty < 0) // //{ // // orderentity.PSCGQty = 0; // //} // TotalQty = 0; // break; // case (int)EnumMLType.白坯: // orderentity.PBCGQty -= TotalQty; // //if (orderentity.PBCGQty < 0) // //{ // // orderentity.PBCGQty = 0; // //} // TotalQty = 0; // break; // default: // break; // } // } // else // { // switch (entity.MLType) // { // case (int)EnumMLType.纱线: // // decimal DifPSQty = orderentity.Qty - orderentity.PSCGQty; // if (TotalQty <= orderentity.PSCGQty) // { // orderentity.PSCGQty -= TotalQty; // TotalQty = 0; // break; // } // else // { // if (orderentity.PSCGQty > 0) // { // TotalQty -= orderentity.PSCGQty; // orderentity.PSCGQty =0; // break; // } // } // break; // case (int)EnumMLType.白坯: // //decimal DifPBQty = orderentity.Qty - orderentity.PBCGQty; // if (TotalQty <= orderentity.PBCGQty) // { // orderentity.PBCGQty -= TotalQty; // TotalQty = 0; // break; // } // else // { // if (orderentity.PBCGQty > 0) // { // TotalQty -= orderentity.PBCGQty; // orderentity.PBCGQty= 0; // break; // } // } // break; // default: // break; // } // } // if (findR) // { // SaleOrderDtsRule rule = new SaleOrderDtsRule(); // rule.RUpdate(orderentity, sqlTrans); // } // } //For循环结尾 // } //While结尾 // } // else // { // throw new Exception("数据出现异常未找到原始订单"); // } // } // if (entity.MLType == (int)EnumMLType.成品) // { // sql = "SELECT ItemCode,ColorNum,ColorName,Qty FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID; // DataTable dtDts1 = sqlTrans.Fill(sql); // foreach (DataRow dr in dtDts1.Rows) // { // sql = "SELECT DtsID FROM UV1_Sale_SaleOrderDts WHERE FormNo=" + SysString.ToDBString(entity.OrderFormNo); // sql += " AND ItemCode=" + SysString.ToDBString(dr["ItemCode"].ToString()); // sql += " AND ColorNum=" + SysString.ToDBString(dr["ColorNum"].ToString()); // sql += " AND ColorName=" + SysString.ToDBString(dr["ColorName"].ToString()); // DataTable dtorder = sqlTrans.Fill(sql);//寻找原始订单 // if (dtorder.Rows.Count == 1) // { // SaleOrderDts orderentity = new SaleOrderDts(sqlTrans); // orderentity.ID = SysConvert.ToInt32(dtorder.Rows[0]["DtsID"]); // bool findR= orderentity.SelectByID(); // orderentity.CPCGQty -= SysConvert.ToDecimal(dr["Qty"]); // if (findR) // { // SaleOrderDtsRule rule = new SaleOrderDtsRule(); // rule.RUpdate(orderentity, sqlTrans); // } // } // else // { // throw new Exception("数据出现异常未找到原始订单 订单号:" + entity.FormNo); // } // } // } //} //#endregion } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 新增 /// </summary> /// <param name="p_Entity">实体类</param> /// <returns>操作影响的记录行数</returns> public override int AddNew(BaseEntity p_Entity) { try { ItemBuyForm MasterEntity = (ItemBuyForm)p_Entity; if (MasterEntity.ID == 0) { return(0); } //新增主表数据 StringBuilder MasterField = new StringBuilder(); StringBuilder MasterValue = new StringBuilder(); MasterField.Append("INSERT INTO Buy_ItemBuyForm("); MasterValue.Append(" VALUES("); MasterField.Append("ID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.ID) + ","); MasterField.Append("FormNo" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.FormNo) + ","); MasterField.Append("OrderCode" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.OrderCode) + ","); MasterField.Append("CustomerStyleNo" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.CustomerStyleNo) + ","); MasterField.Append("MakeOPID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.MakeOPID) + ","); MasterField.Append("MakeOPName" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.MakeOPName) + ","); MasterField.Append("MakeDate" + ","); if (MasterEntity.MakeDate != SystemConfiguration.DateTimeDefaultValue) { MasterValue.Append(SysString.ToDBString(MasterEntity.MakeDate.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("CheckOPID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.CheckOPID) + ","); 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("SubmitFlag" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.SubmitFlag) + ","); MasterField.Append("DelFlag" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.DelFlag) + ","); MasterField.Append("ShopID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.ShopID) + ","); MasterField.Append("VendorID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.VendorID) + ","); MasterField.Append("FormDate" + ","); if (MasterEntity.FormDate != SystemConfiguration.DateTimeDefaultValue) { MasterValue.Append(SysString.ToDBString(MasterEntity.FormDate.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("ReqDate" + ","); if (MasterEntity.ReqDate != SystemConfiguration.DateTimeDefaultValue) { MasterValue.Append(SysString.ToDBString(MasterEntity.ReqDate.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("OrderFormNo" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.OrderFormNo) + ","); MasterField.Append("TotalQty" + ","); if (MasterEntity.TotalQty != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.TotalQty) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("TotalAmount" + ","); if (MasterEntity.TotalAmount != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.TotalAmount) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("PayMethodID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.PayMethodID) + ","); MasterField.Append("Remark" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.Remark) + ","); MasterField.Append("OrderDate" + ","); if (MasterEntity.OrderDate != SystemConfiguration.DateTimeDefaultValue) { MasterValue.Append(SysString.ToDBString(MasterEntity.OrderDate.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("ContractDesc" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.ContractDesc) + ","); MasterField.Append("PayMethodFlag" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.PayMethodFlag) + ","); MasterField.Append("StatusFlag" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.StatusFlag) + ","); MasterField.Append("StatusName" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.StatusName) + ","); MasterField.Append("MLType" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.MLType) + ","); MasterField.Append("FormAID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.FormAID) + ","); MasterField.Append("FKFlag" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.FKFlag) + ","); MasterField.Append("SaleOPID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.SaleOPID) + ","); MasterField.Append("CGOPID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.CGOPID) + ","); MasterField.Append("BuyTypeID" + ")"); MasterValue.Append(SysString.ToDBString(MasterEntity.BuyTypeID) + ")"); //执行 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); } }
/// <summary> /// 修改 /// </summary> /// <param name="p_Entity">实体类</param> /// <returns>操作影响的记录行数</returns> public override int Update(BaseEntity p_Entity) { try { ItemBuyForm MasterEntity = (ItemBuyForm)p_Entity; if (MasterEntity.ID == 0) { return(0); } //更新主表数据 StringBuilder UpdateBuilder = new StringBuilder(); UpdateBuilder.Append("UPDATE Buy_ItemBuyForm SET "); UpdateBuilder.Append(" ID=" + SysString.ToDBString(MasterEntity.ID) + ","); UpdateBuilder.Append(" FormNo=" + SysString.ToDBString(MasterEntity.FormNo) + ","); UpdateBuilder.Append(" OrderCode=" + SysString.ToDBString(MasterEntity.OrderCode) + ","); UpdateBuilder.Append(" CustomerStyleNo=" + SysString.ToDBString(MasterEntity.CustomerStyleNo) + ","); UpdateBuilder.Append(" MakeOPID=" + SysString.ToDBString(MasterEntity.MakeOPID) + ","); UpdateBuilder.Append(" MakeOPName=" + SysString.ToDBString(MasterEntity.MakeOPName) + ","); if (MasterEntity.MakeDate != SystemConfiguration.DateTimeDefaultValue) { UpdateBuilder.Append(" MakeDate=" + SysString.ToDBString(MasterEntity.MakeDate.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { UpdateBuilder.Append(" MakeDate=null,"); } UpdateBuilder.Append(" CheckOPID=" + SysString.ToDBString(MasterEntity.CheckOPID) + ","); 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(" SubmitFlag=" + SysString.ToDBString(MasterEntity.SubmitFlag) + ","); UpdateBuilder.Append(" DelFlag=" + SysString.ToDBString(MasterEntity.DelFlag) + ","); UpdateBuilder.Append(" ShopID=" + SysString.ToDBString(MasterEntity.ShopID) + ","); UpdateBuilder.Append(" VendorID=" + SysString.ToDBString(MasterEntity.VendorID) + ","); if (MasterEntity.FormDate != SystemConfiguration.DateTimeDefaultValue) { UpdateBuilder.Append(" FormDate=" + SysString.ToDBString(MasterEntity.FormDate.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { UpdateBuilder.Append(" FormDate=null,"); } if (MasterEntity.ReqDate != SystemConfiguration.DateTimeDefaultValue) { UpdateBuilder.Append(" ReqDate=" + SysString.ToDBString(MasterEntity.ReqDate.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { UpdateBuilder.Append(" ReqDate=null,"); } UpdateBuilder.Append(" OrderFormNo=" + SysString.ToDBString(MasterEntity.OrderFormNo) + ","); if (MasterEntity.TotalQty != 0) { UpdateBuilder.Append(" TotalQty=" + SysString.ToDBString(MasterEntity.TotalQty) + ","); } else { UpdateBuilder.Append(" TotalQty=null,"); } if (MasterEntity.TotalAmount != 0) { UpdateBuilder.Append(" TotalAmount=" + SysString.ToDBString(MasterEntity.TotalAmount) + ","); } else { UpdateBuilder.Append(" TotalAmount=null,"); } UpdateBuilder.Append(" PayMethodID=" + SysString.ToDBString(MasterEntity.PayMethodID) + ","); UpdateBuilder.Append(" Remark=" + SysString.ToDBString(MasterEntity.Remark) + ","); if (MasterEntity.OrderDate != SystemConfiguration.DateTimeDefaultValue) { UpdateBuilder.Append(" OrderDate=" + SysString.ToDBString(MasterEntity.OrderDate.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { UpdateBuilder.Append(" OrderDate=null,"); } UpdateBuilder.Append(" ContractDesc=" + SysString.ToDBString(MasterEntity.ContractDesc) + ","); UpdateBuilder.Append(" PayMethodFlag=" + SysString.ToDBString(MasterEntity.PayMethodFlag) + ","); UpdateBuilder.Append(" StatusFlag=" + SysString.ToDBString(MasterEntity.StatusFlag) + ","); UpdateBuilder.Append(" StatusName=" + SysString.ToDBString(MasterEntity.StatusName) + ","); UpdateBuilder.Append(" MLType=" + SysString.ToDBString(MasterEntity.MLType) + ","); UpdateBuilder.Append(" FormAID=" + SysString.ToDBString(MasterEntity.FormAID) + ","); UpdateBuilder.Append(" FKFlag=" + SysString.ToDBString(MasterEntity.FKFlag) + ","); UpdateBuilder.Append(" SaleOPID=" + SysString.ToDBString(MasterEntity.SaleOPID) + ","); UpdateBuilder.Append(" CGOPID=" + SysString.ToDBString(MasterEntity.CGOPID) + ","); UpdateBuilder.Append(" BuyTypeID=" + SysString.ToDBString(MasterEntity.BuyTypeID)); 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); } }