/// <summary> /// 获取二级库存使用表对象 删除使用 /// </summary> /// <param name="dr"></param> /// <returns></returns> private OrdSecondAyrlnvUseModel GetOrdSecondAyrlnvUseModelToDel(DataRow dr) { OrdSecondAyrlnvUseModel model = new OrdSecondAyrlnvUseModel(); //二级库存使用表ID model.Id = dr["ID"].ToString(); return(model); }
/// <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> /// 修改二级库存表状态 (状态:0 禁用 1 正常) /// </summary> /// <param name="HitCommID"></param> /// <returns></returns> public void ModifyOrdSecondAyplnvState(OrdSecondAyrlnvUseModel model, string State, LogedInUser logedinUser, DbTransaction transaction) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat(@"Update HC_ORD_SECOND_AYRLNV Set SYNC_STATE='0',STATE='{0}',MODIFY_USER_ID='{1}',MODIFY_USER_NAME='{2}',MODIFY_DATE='{3}' Where ID='{4}'", State, logedinUser.UserInfo.Id, logedinUser.UserInfo.Name, DateTime.Now.ToString(), model.SecondId); try { base.DbFacade.SQLExecuteNonQuery(strSql.ToString(), transaction); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取二级库存使用单对象列表 删除使用 /// </summary> /// <returns></returns> private List <OrdSecondAyrlnvUseModel> GetListOrdSecondAyrlnvUseModelByToDel() { ListOrdSecondAyrlnvUseModel.Clear(); DataTable dt = ConsumeCommDt.DefaultView.ToTable(); foreach (DataRow dr in dt.Rows) { string strSel = dr["Sel"].ToString(); if (strSel.Equals("1")) { OrdSecondAyrlnvUseModel model = GetOrdSecondAyrlnvUseModelToDel(dr); ListOrdSecondAyrlnvUseModel.Add(model); } } return(ListOrdSecondAyrlnvUseModel); }
/// <summary> /// 获取二级库存使用单对象列表 /// </summary> /// <returns></returns> private List <OrdSecondAyrlnvUseModel> GetListOrdSecondAyrlnvUseModel() { ListOrdSecondAyrlnvUseModel.Clear(); DataTable dt = OrdSecondAyplnvDt.DefaultView.ToTable(); foreach (DataRow dr in dt.Rows) { string strSel = dr["Sel"].ToString(); if (strSel.Equals("1")) { string strError = string.Empty; OrdSecondAyrlnvUseModel model = GetOrdSecondAyrlnvUseModel(dr); ListOrdSecondAyrlnvUseModel.Add(model); } } return(ListOrdSecondAyrlnvUseModel); }
/// <summary> /// 获取二级库存使用单对象 /// </summary> /// <param name="dr"></param> /// <returns></returns> private OrdSecondAyrlnvUseModel GetOrdSecondAyrlnvUseModel(DataRow dr) { OrdSecondAyrlnvUseModel model = new OrdSecondAyrlnvUseModel(); //二级库存ID model.SecondId = dr["ID"].ToString(); model.Data_Product_Id = dr["DATA_PRODUCT_ID"].ToString(); model.Project_Id = dr["PROJECT_ID"].ToString(); model.Project_Product_Id = dr["PROJECT_PROD_ID"].ToString(); model.Goods_No = dr["GOODS_NO"].ToString(); model.Barcode = dr["BARCODE"].ToString(); if (string.IsNullOrEmpty(model.Barcode)) { model.Barcode = " "; } if (!dr["PBNO"].ToString().Equals("-")) { model.Pbno = dr["PBNO"].ToString(); } model.Send_Batch_No = dr["SEND_BATCH_NO"].ToString(); model.Instore_Batch_No = dr["INSTORE_BATCH_NO"].ToString(); model.Store_Room_Id = dr["STORE_ROOM_ID"].ToString(); model.Store_Room_Name = dr["STORE_ROOM_NAME"].ToString(); model.Arrive_Date = dr["CREATE_DATE"].ToString(); model.Price = dr["PRICE"].ToString(); model.Fact_Amount = Convert.ToInt16(dr["FACT_AMOUNT"].ToString()); model.Fact_Sum = Convert.ToDecimal(model.Fact_Amount) * Convert.ToDecimal(model.Price); model.Status = "1";//使用标记 model.Buyer_Id = this.CurrentUser.UserOrg.Id; model.Sender_Id = dr["SENDER_ID"].ToString(); model.Descriptions = ""; //库存数量 model.Stock_Num = Convert.ToDecimal(dr["NUM"].ToString()); return(model); }
/// <summary> /// 获取二级库存使用单对象 用于操作 采购单表、采购明细表、订单表、订单明细表 /// </summary> /// <param name="dr"></param> /// <returns></returns> private OrdSecondAyrlnvUseModel GetOrdSecondAyrlnvUseModelToAudi(DataRow dr) { OrdSecondAyrlnvUseModel model = new OrdSecondAyrlnvUseModel(); //model.Id = dr["ID"].ToString(); model.Data_Product_Id = dr["DATA_PRODUCT_ID"].ToString(); model.Project_Id = dr["PROJECT_ID"].ToString(); model.Project_Product_Id = dr["PROJECT_PRODUCT_ID"].ToString(); model.Common_Name = dr["COMMON_NAME"].ToString(); model.Product_Name = dr["PRODUCT_NAME"].ToString(); model.Product_Code = dr["PRODUCT_CODE"].ToString(); model.Goods_No = dr["GOODS_NO"].ToString(); model.Spec_Id = dr["SPEC_ID"].ToString(); model.Model_Id = dr["MODEL_ID"].ToString(); model.Spec = dr["SPEC"].ToString(); model.Model = dr["MODEL"].ToString(); model.Brand = dr["BRAND"].ToString(); model.Batch_No = dr["BATCH_NO"].ToString(); model.Saler_Id = dr["SALER_ID"].ToString(); model.Saler_Name = dr["SALER_NAME"].ToString(); model.Saler_Name_Abbr = dr["SALER_NAME_ABBR"].ToString(); model.Sender_Id = dr["SENDER_ID"].ToString(); model.Sender_Name = dr["SENDER_NAME"].ToString(); model.Sender_Name_Abbr = dr["SENDER_NAME_ABBR"].ToString(); model.Manu_Id = dr["MANU_ID"].ToString(); model.Manu_Name = dr["MANU_NAME"].ToString(); model.Manu_Name_Abbr = dr["MANU_NAME_ABBR"].ToString(); model.Barcode = dr["BARCODE"].ToString(); model.Arrive_Date = DateTime.Now.ToShortDateString(); //dr["CREATE_DATE"].ToString(); model.Price = dr["PRICE"].ToString(); //单价 //实际到货数量 model.Fact_Amount = Convert.ToDecimal(dr["OVERAMOUNT"].ToString()); //实际到货金额 model.Fact_Sum = Convert.ToDecimal(model.Fact_Amount) * Convert.ToDecimal(model.Price); //基础计量单位 model.Base_Measure = dr["BASE_MEASURE"].ToString(); //基础单位规格 model.Base_Measure_Spec = dr["BASE_MEASURE_SPEC"].ToString(); //基础单位包装材质 model.Base_Measure_Mate = dr["BASE_MEASURE_MATER"].ToString(); //配送计量单位 model.Send_Measure = dr["SEND_MEASURE"].ToString(); //配送转换率 model.Send_Measure_Ex = dr["SEND_MEASURE_EX"].ToString(); //卖方发货人ID model.Send_Operator_Id = dr["Send_Operator_Id"].ToString(); model.Send_Operator_Name = dr["Send_Operator_Name"].ToString(); model.Send_Operate_Date = dr["Send_Operate_Date"].ToString(); //买方ID model.Buyer_Id = CurrentUser.UserOrg.Id; model.Buyer_Name = CurrentUser.UserOrg.Name; model.Buyer_Name_Abbr = CurrentUser.UserOrg.Abbr; if (!dr["PBNO"].ToString().Equals("-")) { model.Pbno = dr["PBNO"].ToString(); } model.Send_Batch_No = dr["SEND_BATCH_NO"].ToString(); model.Instore_Batch_No = dr["INSTORE_BATCH_NO"].ToString(); model.Start_Sender_Flag = dr["StartFlag"].ToString() == "1" ? true : false; model.Over_Sender_Flag = dr["EndFlag"].ToString() == "1" ? true : false; //状态 //model.Status = dr["STATUS"].ToString(); //库房ID model.Store_Room_Id = dr["STORE_ROOM_ID"].ToString(); model.Store_Room_Name = dr["STORE_ROOM_NAME"].ToString(); return(model); }