public void LoadControlInfo(tb_parts_purchase_order_2 yt_purchaseorder_model) { CommonFuncCall.SetShowControlValue(this, yt_purchaseorder_model, "View"); if (!string.IsNullOrEmpty(lblreq_delivery_time.Text)) { long ticks = Convert.ToInt64(lblreq_delivery_time.Text); lblreq_delivery_time.Text = Convert.ToDateTime(Common.UtcLongToLocalDateTime(ticks).ToString()).ToShortDateString(); } }
/// <summary> 添加情况下组装sql的方法 /// </summary> /// <param name="listSql"></param> /// <param name="purchase_order_yt_id"></param> private void AddPurchaseOrderSqlString(List<SysSQLString> listSql, string purchase_order_yt_id, string HandleType) { SysSQLString sysStringSql = new SysSQLString(); sysStringSql.cmdType = CommandType.Text; Dictionary<string, string> dicParam = new Dictionary<string, string>();//参数 decimal application_count = 0; decimal conf_count = 0; string parts_codes=string.Empty; string parts_names = string.Empty; GetBuesinessCountPartsInfo(ref application_count, ref conf_count, ref parts_codes, ref parts_names); ddtorder_date.Value = Convert.ToDateTime(ddtorder_date.Value.ToShortDateString() + " 23:59:59"); tb_parts_purchase_order_2 model = new tb_parts_purchase_order_2(); CommonFuncCall.SetModelObjectValue(this, model); if (model.crm_bill_id == ".") { model.crm_bill_id = string.Empty; } model.order_type_name = ddlorder_type.SelectedItem.ToString(); if (ddlorder_type.SelectedValue.ToString() == "order_type_100000001")//配件需求订单 { xuqiu.GetControlInfo(model); } else if (ddlorder_type.SelectedValue.ToString() == "order_type_100000005")//产品升级订单 { shengji.GetControlInfo(model); } else if (ddlorder_type.SelectedValue.ToString() == "order_type_100000004")//新三包调件订单 { sanbao.GetControlInfo(model); } model.application_count = application_count; model.conf_count = conf_count; model.purchase_order_yt_id = purchase_order_yt_id; model.create_by = GlobalStaticObj.UserID; model.create_name = GlobalStaticObj.UserName; model.create_time = Common.LocalDateTimeToUtcLong(DateTime.Now); model.operators = GlobalStaticObj.UserID; model.operator_name = GlobalStaticObj.UserName; model.com_id = GlobalStaticObj.CurrUserCom_Id;//公司ID model.com_code = GlobalStaticObj.CurrUserCom_Code;//公司编码 model.com_name = GlobalStaticObj.CurrUserCom_Name;//公司名称 if (!string.IsNullOrEmpty(ddlorg_id.SelectedValue.ToString())) { model.org_id = ddlorg_id.SelectedValue.ToString(); model.org_name = ddlorg_id.SelectedItem.ToString(); } if (!string.IsNullOrEmpty(ddlhandle.SelectedValue.ToString())) { model.handle = ddlhandle.SelectedValue.ToString(); model.handle_name = ddlhandle.SelectedItem.ToString(); } model.parts_codes = parts_codes; model.parts_names = parts_names; model.enable_flag = "1"; if (HandleType == "保存") { model.order_status = Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString(); model.order_status_name = DataSources.GetDescription(DataSources.EnumAuditStatus.DRAFT, true); } else if (HandleType == "提交") { model.order_status = Convert.ToInt32(DataSources.EnumAuditStatus.SUBMIT).ToString(); model.order_status_name = DataSources.GetDescription(DataSources.EnumAuditStatus.SUBMIT, true); } if (model != null) { StringBuilder sb = new StringBuilder(); sb.Append(" Insert Into tb_parts_purchase_order_2( "); StringBuilder sp = new StringBuilder(); StringBuilder sb_prame = new StringBuilder(); foreach (PropertyInfo info in model.GetType().GetProperties()) { string name = info.Name; //外部加入的属性 if (name == "listDetails") { break; } object value = info.GetValue(model, null); sb_prame.Append("," + name); sp.Append(",@" + name); dicParam.Add(name, value == null ? "" : value.ToString()); } sb.Append(sb_prame.ToString().Substring(1, sb_prame.ToString().Length - 1) + ") Values ("); sb.Append(sp.ToString().Substring(1, sp.ToString().Length - 1) + ")").Append(";"); sysStringSql.sqlString = sb.ToString(); sysStringSql.Param = dicParam; listSql.Add(sysStringSql); } }
/// <summary> 通过审核后向宇通发送宇通采购订单信息 /// </summary> /// <param name="listField">宇通采购订单号集合</param> void DealPurascherToYT(List<string> listField) { try { if (listField.Count > 0) { for (int a = 0; a < listField.Count; a++) { DataTable dt = DBHelper.GetTable("查看一条宇通采购订单信息", "tb_parts_purchase_order_2", "*", " purchase_order_yt_id='" + listField[a] + "'", "", ""); if (dt != null && dt.Rows.Count > 0) { yt_purchaseorder_model = new tb_parts_purchase_order_2(); yt_purchaseorder_model.listDetails = new List<tb_parts_purchase_order_p_2>(); CommonFuncCall.SetModlByDataTable(yt_purchaseorder_model, dt); DataTable dt_parts = DBHelper.GetTable("查看宇通采购订单配件信息", "tb_parts_purchase_order_p_2", "*", " purchase_order_yt_id='" + listField[a] + "'", "", ""); if (dt_parts != null && dt_parts.Rows.Count > 0) { for (int i = 0; i < dt_parts.Rows.Count; i++) { yt_partsorder_model = new tb_parts_purchase_order_p_2(); CommonFuncCall.SetModlByDataTable(yt_partsorder_model, dt_parts, i); yt_purchaseorder_model.listDetails.Add(yt_partsorder_model); } } if (yt_purchaseorder_model.crm_bill_id == ".") { yt_purchaseorder_model.crm_bill_id = string.Empty; } DBHelper.WebServHandler("", EnumWebServFunName.UpLoadPartPurchase, yt_purchaseorder_model); } } } } catch (Exception ex) { } }
public void GetControlInfo(tb_parts_purchase_order_2 model) { if (!string.IsNullOrEmpty(ddtreq_delivery_time.Value)) { ddtreq_delivery_time.Value = Convert.ToDateTime(ddtreq_delivery_time.Value).ToShortDateString() + " 23:59:59"; } CommonFuncCall.SetModelObjectValue(this, model); if (!string.IsNullOrEmpty(ddlemergency_level.SelectedValue.ToString())) { model.emergency_level_name = ddlemergency_level.SelectedItem.ToString(); } if (!string.IsNullOrEmpty(ddlcenter_library.SelectedValue.ToString())) { model.center_library_name = ddlcenter_library.SelectedItem.ToString(); } if (!string.IsNullOrEmpty(ddlallot_type.SelectedValue.ToString())) { model.allot_type_name = ddlallot_type.SelectedItem.ToString(); } if (!string.IsNullOrEmpty(ddlreq_delivery.SelectedValue.ToString())) { model.req_delivery_name = ddlreq_delivery.SelectedItem.ToString(); } if (!string.IsNullOrEmpty(ddlconsignee_code.SelectedValue.ToString())) { model.consignee = ddlconsignee_code.Text.ToString(); } }
public void LoadControlInfo(tb_parts_purchase_order_2 model) { CommonFuncCall.SetShowControlValue(this, model, ""); }