/// <summary> 创建出入库单配件信息 /// </summary> /// <param name="stock_inout_id">出入库单ID</param> /// <param name="parts_model">采购开单配件信息</param> bool CreateIntoPartsStock(string stock_inout_id, tb_parts_purchase_billing_p parts_model) { tb_parts_stock_inout_p PartsInoutModel = new tb_parts_stock_inout_p(); Dictionary <string, string> dicParam = new Dictionary <string, string>();//参数 PartsInoutModel.stock_inout_parts_id = Guid.NewGuid().ToString(); PartsInoutModel.stock_inout_id = stock_inout_id; PartsInoutModel.wh_id = parts_model.wh_id; PartsInoutModel.num = parts_model.num; PartsInoutModel.parts_num = parts_model.parts_code; PartsInoutModel.parts_name = parts_model.parts_name; PartsInoutModel.drawing_num = parts_model.drawing_num; PartsInoutModel.unit = parts_model.unit_id; PartsInoutModel.unit_name = parts_model.unit_name; PartsInoutModel.parts_brand = parts_model.parts_brand; PartsInoutModel.count = parts_model.storage_count;//入库数量 PartsInoutModel.is_gift = parts_model.is_gift; PartsInoutModel.remark = parts_model.remark; PartsInoutModel.create_by = GlobalStaticObj.UserID; PartsInoutModel.create_name = GlobalStaticObj.UserName; PartsInoutModel.create_time = Common.LocalDateTimeToUtcLong(DateTime.Now); foreach (PropertyInfo info in PartsInoutModel.GetType().GetProperties()) { string name = info.Name; object value = info.GetValue(PartsInoutModel, null); dicParam.Add(name, value == null ? "" : value.ToString()); } return(DBHelper.Submit_AddOrEdit("出入库配件表添加信息", "tb_parts_stock_inout_p", "stock_inout_parts_id", "", dicParam)); }
/// <summary> /// 审核通过后需要自动生成的单子的方法 /// </summary> void CreateBill(List <string> listField) { if (listField.Count > 0) { for (int i = 0; i < listField.Count; i++) { DataTable dt = DBHelper.GetTable("", "tb_parts_purchase_billing", "*", string.Format("purchase_billing_id='{0}'", listField[i]), "", ""); if (dt != null && dt.Rows.Count > 0) { tb_parts_purchase_billing model = new tb_parts_purchase_billing(); CommonFuncCall.SetModlByDataTable(model, dt); #region 当金额大于0时,自动生成预付款单 if (model.this_payment > 0) { tb_bill_receivable a = new tb_bill_receivable(); tb_balance_documents b = new tb_balance_documents(); tb_payment_detail c = new tb_payment_detail(); a.cust_id = model.sup_id; //供应商ID a.order_num = CommonUtility.GetNewNo(DataSources.EnumProjectType.PAYMENT); //订单号 a.order_type = (int)DataSources.EnumOrderType.PAYMENT; a.payment_type = (int)DataSources.EnumPaymentType.PAYMENT; a.org_id = model.org_id; b.billing_money = model.this_payment; //开单金额 b.documents_date = model.order_date; //单据日期 b.documents_id = model.purchase_billing_id; //单据ID b.documents_name = "采购开单"; //单据名称 b.documents_num = model.order_num; //单据编码 c.money = model.this_payment; //金额 c.balance_way = model.balance_way; //结算方式 c.check_number = model.check_number; //票号 DBOperation.AddBillReceivable(a, b, c); } #endregion #region 自动生产出入库单 #region 一:采购收货单-->自动生成入库单 if (model.order_type == DataSources.EnumPurchaseOrderType.PurchaseReceive.ToString()) { string stock_inout_id = string.Empty; //1.生成入库单 if (CreateIntoStock("入库单", model, ref stock_inout_id)) { //2.查询配件信息,生成配件信息入库单 DataTable dt_parts = DBHelper.GetTable("查询采购开单配件信息表", "tb_parts_purchase_billing_p", "*", " purchase_billing_id='" + model.purchase_billing_id + "'", "", ""); if (dt_parts != null && dt_parts.Rows.Count > 0) { for (int a = 0; a < dt_parts.Rows.Count; a++) { tb_parts_purchase_billing_p bill_p_model = new tb_parts_purchase_billing_p(); CommonFuncCall.SetModlByDataTable(bill_p_model, dt_parts, a); CreateIntoPartsStock(stock_inout_id, bill_p_model); } } } } #endregion #region 二:采购退货-->自动生成出库单 else if (model.order_type == DataSources.EnumPurchaseOrderType.PurchaseBack.ToString()) { string stock_inout_id = string.Empty; //1.生成出库单 if (CreateIntoStock("出库单", model, ref stock_inout_id)) { //2.查询配件信息,生成配件信息出库单 DataTable dt_parts = DBHelper.GetTable("查询采购开单配件信息表", "tb_parts_purchase_billing_p", "*", " purchase_billing_id='" + model.purchase_billing_id + "'", "", ""); if (dt_parts != null && dt_parts.Rows.Count > 0) { for (int a = 0; a < dt_parts.Rows.Count; a++) { tb_parts_purchase_billing_p bill_p_model = new tb_parts_purchase_billing_p(); CommonFuncCall.SetModlByDataTable(bill_p_model, dt_parts, a); CreateIntoPartsStock(stock_inout_id, bill_p_model); } } } } #endregion #region :采购换货-->自动生成出、入库单(数量大于0是入库,小于0是出库) else if (model.order_type == DataSources.EnumPurchaseOrderType.PurchaseExchange.ToString()) { string stock_in_id = string.Empty; string stock_out_id = string.Empty; //1.生成入库单 if (CreateIntoStock("入库单", model, ref stock_in_id)) { //2.查询配件入库数量大于0的,生成配件信息入库单 DataTable dt_parts = DBHelper.GetTable("查询采购开单配件信息表", "tb_parts_purchase_billing_p", "*", " purchase_billing_id='" + model.purchase_billing_id + "' and storage_count>0 ", "", ""); if (dt_parts != null && dt_parts.Rows.Count > 0) { for (int a = 0; a < dt_parts.Rows.Count; a++) { tb_parts_purchase_billing_p bill_p_model = new tb_parts_purchase_billing_p(); CommonFuncCall.SetModlByDataTable(bill_p_model, dt_parts, a); CreateIntoPartsStock(stock_in_id, bill_p_model); } } } //3.生成出库单 if (CreateIntoStock("出库单", model, ref stock_out_id)) { //4.查询配件入库数量小于0的,生成配件信息出库单 DataTable dt_parts = DBHelper.GetTable("查询采购开单配件信息表", "tb_parts_purchase_billing_p", "*", " purchase_billing_id='" + model.purchase_billing_id + "' and storage_count<0 ", "", ""); if (dt_parts != null && dt_parts.Rows.Count > 0) { for (int a = 0; a < dt_parts.Rows.Count; a++) { tb_parts_purchase_billing_p bill_p_model = new tb_parts_purchase_billing_p(); CommonFuncCall.SetModlByDataTable(bill_p_model, dt_parts, a); CreateIntoPartsStock(stock_out_id, bill_p_model); } } } } #endregion #endregion #region 向宇通发送配送单号 if (!string.IsNullOrEmpty(model.ration_send_code)) { //DBHelper.WebServHandler("审核通过入库时发送配送单号到宇通系统", EnumWebServFunName.UpLoadPartPutStore, model.ration_send_code); DBHelper.WebServHandler("", EnumWebServFunName.LoadPartInStore, model.ration_send_code); } #endregion } } } }