/// <summary> /// 保存采购单主表 /// </summary> /// <param name="model"></param> /// <param name="logedinUser"></param> /// <param name="transaction"></param> public void SaveOrdPurchaseModel(OrdPurchaseModel model, LogedInUser logedinUser, DbTransaction transaction) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"Insert Into HC_ORD_PURCHASE ( ID, BUYER_ID, CODE, TYPE, TOTAL_SUM, PURCHASE_DATE, CREATE_USER_ID, CREATE_USER_NAME, STATE, AUDIT_USER_ID, AUDIT_USER_NAME, AUDIT_DATE, MODIFY_USER_ID, MODIFY_USER_NAME, MODIFY_DATE, QUICKSEND_LEVEL, CREATE_DATE, SYNC_STATE )"); strSql.Append(" Values ("); strSql.AppendFormat("{0},", model.Id); strSql.AppendFormat("{0},", model.Buyer_Id); strSql.AppendFormat("'{0}',", model.Code); strSql.AppendFormat("'{0}',", model.Type); strSql.AppendFormat("{0},", model.Total_Sum); strSql.AppendFormat("'{0}',", model.Purchase_Date); strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Id); strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Name); strSql.AppendFormat("'{0}',", model.State); strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Id); strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Name); strSql.AppendFormat("'{0}',", DateTime.Now.ToString()); strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Id); strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Name); strSql.AppendFormat("'{0}',", DateTime.Now.ToString()); strSql.Append("'1',"); strSql.AppendFormat("'{0}',", DateTime.Now.ToString()); strSql.Append("'0'"); strSql.Append(")"); try { base.DbFacade.SQLExecuteNonQuery(strSql.ToString(), transaction); } catch (Exception ex) { throw ex; } }
/// <summary> /// 【发货流程】 操作表有(采购单、采购单明细、订单表、订单明细、备货表、到货表、订单结果表、日志) /// </summary> /// <param name="Listmodel"></param> /// <param name="ordPurchaseModel"></param> /// <param name="logedinUser"></param> public void OrdInvoiceFrom(List <OrdSecondAyrlnvUseModel> Listmodel, OrdPurchaseModel ordPurchaseModel, OrdOrderModel ordOrderModel, LogedInUser logedinUser) { try { dao.OrdInvoiceFrom(Listmodel, ordPurchaseModel, ordOrderModel, logedinUser); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取发货流程 使用列表 /// </summary> /// <returns></returns> private List <OrdSecondAyrlnvUseModel> GetListOrdSecondAyrlnvUseModelToAudi() { if (ListOrdSecondAyrlnvUseModel != null) { ListOrdSecondAyrlnvUseModel.Clear(); } decimal total_Num = 0; DataTable dttemp = NoSend_OrdInvoiceFromItemDt.DefaultView.ToTable(); dttemp.DefaultView.RowFilter = "Sel='1'"; DataTable dt = dttemp.DefaultView.ToTable(); dt = RefreshDt(dt); foreach (DataRow dr in dt.Rows) { string strSel = dr["Sel"].ToString(); if (strSel.Equals("1")) { OrdSecondAyrlnvUseModel model = GetOrdSecondAyrlnvUseModelToAudi(dr); total_Num += model.Fact_Sum; ListOrdSecondAyrlnvUseModel.Add(model); } } //采购单对象 ordPurchaseModel = null; ordPurchaseModel = new OrdPurchaseModel(); ordPurchaseModel.Buyer_Id = CurrentUser.UserOrg.Id; //买方ID ordPurchaseModel.Type = "2"; //采购单类型:发货流程 ordPurchaseModel.Purchase_Date = DateTime.Now.ToString(); //采购日期 ordPurchaseModel.Total_Sum = total_Num; //采购单金额 ordPurchaseModel.State = "4"; //采购单状态:发送状态 //订单对象 ordOrderModel = null; ordOrderModel = new OrdOrderModel(); ordOrderModel.Buyer_Id = CurrentUser.UserOrg.Id; //买方ID ordOrderModel.Buyer_Name = CurrentUser.UserOrg.Name; //买方名称 ordOrderModel.Buyer_Name_Abbr = CurrentUser.UserOrg.Abbr; //买方简称 ordOrderModel.State = "5"; //订单状态:完成 ordOrderModel.Type = "2"; //订单 :发货类型 ordOrderModel.Purchase_Date = ordPurchaseModel.Purchase_Date; //采购日期 ordOrderModel.Quicksend_Level = "1"; //紧急程度 1为“普通” return(ListOrdSecondAyrlnvUseModel); }
/// <summary> /// 获取二级库存使用单对象列表 /// </summary> /// <returns></returns> private List <OrdSecondAyrlnvUseModel> GetListOrdSecondAyrlnvUseModelToAudi() { ListOrdSecondAyrlnvUseModel.Clear(); decimal total_Num = 0; DataTable dttemp = ConsumeCommDt.DefaultView.ToTable(); dttemp.DefaultView.RowFilter = "Sel='1'"; DataTable dt = dttemp.DefaultView.ToTable(); dt = RefreshDt(dt); foreach (DataRow dr in dt.Rows) { string strSel = dr["Sel"].ToString(); if (strSel.Equals("1")) { OrdSecondAyrlnvUseModel model = GetOrdSecondAyrlnvUseModelToAudi(dr); total_Num += model.Fact_Sum; ListOrdSecondAyrlnvUseModel.Add(model); } } ordPurchaseModel = null; ordPurchaseModel = new OrdPurchaseModel(); ordPurchaseModel.Buyer_Id = CurrentUser.UserOrg.Id; ordPurchaseModel.Type = "3"; ordPurchaseModel.Purchase_Date = DateTime.Now.ToShortDateString(); ordPurchaseModel.Total_Sum = total_Num; ordPurchaseModel.State = "4";//采购单状态 发送状态 ordOrderModel = null; ordOrderModel = new OrdOrderModel(); ordOrderModel.Buyer_Id = CurrentUser.UserOrg.Id; ordOrderModel.Buyer_Name = CurrentUser.UserOrg.Name; ordOrderModel.Buyer_Name_Abbr = CurrentUser.UserOrg.Abbr; //ordOrderModel.Total_Sum = total_Num; //ordOrderModel.Over_Sum = total_Num; ordOrderModel.State = "5"; ordOrderModel.Type = "3";//备货类型 ordOrderModel.Purchase_Date = ordPurchaseModel.Purchase_Date; ordOrderModel.Quicksend_Level = "1"; return(ListOrdSecondAyrlnvUseModel); }
/// <summary> /// 页面加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void UseOddAudiForm_Load(object sender, EventArgs e) { CurrentUser = base.CurrentUser; //绑定表格中下拉框(库房) InitGrid_Cmb(); //绑定库存商品列表数据集 DataBindAyplnv(); //绑定消耗商品列表数据集 DataBindConsume(); ListOrdSecondAyrlnvUseModel = new List <OrdSecondAyrlnvUseModel>(); ordPurchaseModel = new OrdPurchaseModel(); ordOrderModel = new OrdOrderModel(); }