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, "");
}
