protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
{
Mod_TMO_ORDER mod = tmo_order.GetModel(Request.QueryString["ID"]);
if (mod != null)
{
Mod_TMO_CON conmod = tmo_con.GetModel(mod.C_CON_NO);
if (conmod != null)
{
var list = trc_roll_prodcut.Check_OrderAndRoll(mod.C_CON_NO);
if (list.Result)
{
if (list.Flag == 0)
{
lbl_msg.Text = "当前合同存在排产计划，请谨慎操作！";
}
else
{
lbl_msg.Text = "当前合同存在线材库存，请谨慎操作！";
}
}
ltlConNO.Text = conmod.C_CON_NO;
ltlcustno.Text = conmod.C_CUST_NO;
ltlcustname.Text = conmod.C_CUSTNAME;
ltlarea.Text = conmod.C_AREA;
}
}
}
}
}
/// <summary>
/// 绑定合同相关信息
/// </summary>
private void BindConInfo()
{
if (!string.IsNullOrEmpty(txtConNO.Text))
{
Mod_TMO_CON mod = con.GetModel(txtConNO.Text);
if (mod != null)
{
dropCurrType.SelectedIndex = dropCurrType.Items.IndexOf(dropCurrType.Items.FindByText(mod.C_CURRENCY_TYPE));
txtDate.Value = Convert.ToDateTime(mod.D_CONSING_DT).ToString("yyy-MM-dd");
txtStart.Value = Convert.ToDateTime(mod.D_CONEFFE_DT).ToString("yyy-MM-dd");
txtEnd.Value = Convert.ToDateTime(mod.D_CONINVALID_DT).ToString("yyy-MM-dd");
dropConType.SelectedIndex = dropConType.Items.IndexOf(dropConType.Items.FindByText(mod.C_CON_TYPE));
txtConNO.Text = mod.C_CON_NO;
txtConName.Text = mod.C_CON_NAME;
txtCustName.Text = mod.C_CUST_NAME;
dropShipVia.SelectedIndex = dropShipVia.Items.IndexOf(dropShipVia.Items.FindByText(mod.C_SHIPVIA));
dropConArea.SelectedIndex = dropConArea.Items.IndexOf(dropConArea.Items.FindByText(mod.C_CON_AREA));
txtState.Text = GetOrderState(Convert.ToInt32(mod.N_CON_STATUS));
hidState.Value = mod.N_CON_STATUS.ToString();
bool status = mod.N_CON_STATUS.ToString() == "-1" ? true : false;
btnSave.Enabled = status;
btnAdd.Disabled = mod.N_CON_STATUS.ToString() == "-1" ? false : true;
btnEdit.Disabled = mod.N_CON_STATUS.ToString() == "-1" ? false : true;
btnDel.Enabled = status;
btnSubmit.Enabled = status;
}
BindConOrder();
}
}
//合同变更
protected void btnConBg_Click(object sender, EventArgs e)
{
try
{
#region //新增变更合同
List <Mod_TMO_ORDER> orderList = new List <Mod_TMO_ORDER>();
#region //添加合同基本信息
int NO = Convert.ToInt32(ltlcon_bgNo.Text) + 1;
Mod_TMO_CON modCon = tmo_con.GetModel(txtConNO.Text);
modCon.C_CON_NO = modCon.C_CON_NO + "-" + NO.ToString();
modCon.C_CON_NAME = modCon.C_CON_NAME;
modCon.N_STATUS = -1; //客户待提交
modCon.D_CONSING_DT = DateTime.Now; //合同签署日期
modCon.D_CONEFFE_DT = Convert.ToDateTime(DateTime.Now); //计划生效日期
modCon.D_CONINVALID_DT = Convert.ToDateTime(DateTime.Now).AddDays(60); //计划失效日期
modCon.C_CON_NO_OLD = txtConNO.Text; //原始合同号
modCon.N_CHANGENUM = NO; //变更次数
#endregion
#region //添加合同明细
Bll_RandomNumber randomnumber = new Bll_RandomNumber(); //流水号
DataTable dtOrder = tmo_order.GetConOrderList(txtConNO.Text, "", "", "", "", "").Tables[0];
for (int i = 0; i < dtOrder.Rows.Count; i++)
{
Mod_TMO_ORDER modOrder = tmo_order.GetModel(dtOrder.Rows[i]["C_ID"].ToString()); //订单表
string order_no = randomnumber.CreateOrderNo(modCon.C_CON_NO); //订单号
modOrder.C_ORDER_NO = order_no;
modOrder.C_CON_NO = modCon.C_CON_NO; //合同号
modOrder.C_CON_NAME = modCon.C_CON_NAME; //合同名称
modOrder.C_CUST_NO = modCon.C_CUST_NO; //客户编码
modOrder.C_CUST_NAME = modCon.C_CUSTNAME; //客户名称
modOrder.C_RECEIPTCORPID = modCon.C_CRECEIPTCUSTOMERID; //收货单位
modOrder.N_STATUS = -1; //客户待提交
modOrder.C_SFPJ = "N"; //是否评价
modOrder.N_EXEC_STATUS = -2; //未提报
modOrder.N_WGT = modOrder.N_WGT; //原合同数量
modOrder.C_ORDER_NO_OLD = dtOrder.Rows[i]["C_ORDER_NO"].ToString(); //原合同号
orderList.Add(modOrder);
}
#endregion
#endregion
if (tmo_con.InsertConOrder(modCon, orderList))
{
string url = "ConEdit_BG.aspx?ID=" + modCon.C_CON_NO + "&YID=" + txtConNO.Text;
Response.Redirect(url);
}
}
catch (Exception ex)
{
WebMsg.MessageBox(ex.Message);
}
}
/// <summary>
/// 获取合同信息
/// </summary>
private void GetCon()
{
Mod_TMO_CON mod = con.GetModel(ltlConN0.Text);
if (mod != null)
{
txtTitle.Text = mod.C_CON_NAME;
txtContent.Text = mod.C_DESC;
}
}
/// <summary>
/// 获取合同信息
/// </summary>
private void GetCon()
{
Mod_TMO_CON mod = tmo_con.GetModel(ltlConN0.Text);
if (mod != null)
{
txtTitle.Text = mod.C_CON_NO;
txtContent.Text = mod.C_REAMRK;
}
}
/// <summary>
/// 加载合同信息
/// </summary>
private void GetConInfo()
{
if (!string.IsNullOrEmpty(ltlTaskID.Text))
{
try
{
#region //加载合同基本信息
Mod_TMO_CON modcon = con.GetModel(ltlTaskID.Text);
if (modcon != null)
{
hidcon.Value = modcon.C_CON_NO;
ltlConNo.Text = modcon.C_CON_NO;
ltlConName.Text = modcon.C_CON_NAME;
ltlConType.Text = GetDic(modcon.C_CONTYPEID);
ltlCustName.Text = modcon.C_CUSTNAME;
ltlD_CONSING_DT.Text = Convert.ToDateTime(modcon.D_CONSING_DT).ToString("yyy-MM-dd");
ltlD_CONEFFE_DT.Text = Convert.ToDateTime(modcon.D_CONEFFE_DT).ToString("yyy-MM-dd");
ltlD_CONINVALID_DT.Text = Convert.ToDateTime(modcon.D_CONINVALID_DT).ToString("yyy-MM-dd");
Mod_TMB_FLOWINFO modFlow = tmb_flowinfo.GetModel(modcon.C_FLOWID);
ltlC_APPROVER_FLOW.Text = modFlow?.C_NAME ?? "";
ltlC_SHIPVIA.Text = GetDic(modcon.C_TRANSMODEID); //发运方式
ltlC_CURRENCY_TYPE.Text = GetDic(modcon.C_CURRENCYTYPEID); //货币类型
ltlC_BUSINESS_TYPE.Text = GetDic(modcon.C_BIZTYPE); //业务类型
Mod_TS_DEPT modDept = ts_dept.GetModel(modcon.C_DEPTID);
if (modDept != null)
{
ltlDept.Text = modDept.C_NAME;//部门
}
ltlSaleUser.Text = ts_user.GetSaleName(modcon.C_EMPLOYEEID); //业务员
ltlC_SALE_DEPT.Text = GetDic(modcon.C_SALECORPID); //销售组织
ltlC_CGC.Text = GetCust(modcon.C_CRECEIPTCUSTOMERID); //收货单位
ltlC_OTC.Text = GetCust(modcon.C_CRECEIPTCORPID); //开票单位
ltlC_STATION.Text = modcon.C_STATION;
ltlConArea.Text = modcon.C_AREA;
ltlConState.Text = StringFormat.GetOrderState(modcon.N_STATUS);
ltlDESC.Text = modcon.C_REAMRK;
//加载合同订单列表
GetOrderList();
}
#endregion
}
catch (Exception ex)
{
WebMsg.MessageBox(ex.Message);
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region //保存
Mod_TMO_CON mod = con.GetModel(txtConNO.Value);
if (mod != null)
{
mod.C_CON_NAME = txtConName.Value;
mod.C_CON_TYPE = dropConType.SelectedItem.Text;
mod.D_CONSING_DT = Convert.ToDateTime(txtQianDanDT.Value);
mod.D_CONEFFE_DT = Convert.ToDateTime(txtPlanStartDT.Value);
mod.D_CONINVALID_DT = Convert.ToDateTime(txtPlanEndDT.Value);
mod.C_SHIPVIA = dropFaYun.SelectedItem.Text;
mod.C_CURRENCY_TYPE = dropBiZhong.SelectedItem.Text;
mod.C_BUSINESS_TYPE = dropYeWuType.SelectedItem.Text;
mod.C_DEPT_ID = hidDeptID.Value;
mod.C_SALESMAN = hidEmpID.Value;
mod.C_SALE_DEPT = dropSale.SelectedValue;
mod.N_FLAG = Convert.ToInt32(dropClass.SelectedValue);
mod.C_STOCK_DEPT = txtKC.Value;
mod.C_CON_AREA = dropArea.SelectedValue;
mod.C_ISSHIP = chkIsFaYun.Checked == true ? "1" : "0";
mod.C_DESC = txtDESC.Value;
mod.N_FLAG = Convert.ToInt32(GetConFlag(dropClass.SelectedItem.Text));
var BaseUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
if (BaseUser != null)
{
mod.C_XG_MODIFY = BaseUser.Id;
mod.C_XG_MODEIFY_DT = DateTime.Now;
}
if (con.Update(mod))
{
#region //更新订单等级
int lev = Convert.ToInt32(dropClass.SelectedValue);
if (condetails.UpdateOrderLEV(txtConNO.Value, lev))
{
WebMsg.MessageBox("保存成功");
GetConInfo();//重新加载
}
#endregion
}
}
#endregion
}
/// <summary>
/// 加载合同信息
/// </summary>
private void GetConInfo()
{
if (!string.IsNullOrEmpty(ltlTaskID.Text))
{
Mod_TMO_CON modcon = con.GetModel(ltlTaskID.Text);
if (modcon != null)
{
txtConNO.Value = ltlTaskID.Text;
txtConName.Value = modcon.C_CON_NAME;
dropConType.Items.Insert(0, new ListItem(modcon.C_CON_TYPE, modcon.C_CON_TYPE));
txtCustName.Value = modcon.C_CUST_NAME;
txtQianDanDT.Value = Convert.ToDateTime(modcon.D_CONSING_DT).ToString("yyy-MM-dd");
txtPlanStartDT.Value = Convert.ToDateTime(modcon.D_CONEFFE_DT).ToString("yyy-MM-dd");
txtPlanEndDT.Value = Convert.ToDateTime(modcon.D_CONINVALID_DT).ToString("yyy-MM-dd");
txtSysPlanEndDT.Value = Convert.ToDateTime(modcon.D_SYS_CONINVALID_DT).ToString("yyy-MM-dd");
txtCustLEV.Value = modcon.N_CUST_LEV.ToString() == "1" ? "优先" : "普通";
dropFaYun.Items.Insert(0, new ListItem(modcon.C_SHIPVIA, modcon.C_SHIPVIA));
dropBiZhong.Items.Insert(0, new ListItem(modcon.C_CURRENCY_TYPE, modcon.C_CURRENCY_TYPE));
dropYeWuType.Items.Insert(0, new ListItem(modcon.C_BUSINESS_TYPE, modcon.C_BUSINESS_TYPE));
string flag = GetConFlag(Convert.ToInt32(modcon.N_FLAG));
dropClass.Items.Insert(0, new ListItem(flag, flag));
#region //收货单位/收货地址/开票单位
DataTable dt1 = condetails.GetCGC_OTC(txtConNO.Value).Tables[0];
if (dt1.Rows.Count > 0)
{
txtShuoHuoCompany.Value = dt1.Rows[0]["C_CGC"].ToString();
txtShuoHuoAddr.Value = dt1.Rows[0]["C_CGADDR"].ToString();
txtKaiPiaoCompany.Value = dt1.Rows[0]["C_OTC"].ToString();
}
#endregion
dropArea.Items.Insert(0, new ListItem(modcon.C_CON_AREA, modcon.C_CON_AREA));
txtState.Value = StringFormat.GetOrderState(modcon.N_CON_STATUS);
if (!string.IsNullOrEmpty(modcon.C_ISSHIP))
{
chkIsFaYun.Checked = modcon.C_ISSHIP == "0" ? false : true;
}
txtDESC.Value = modcon.C_DESC;
GetOrderList();//加载合同明细
}
}
}
private void BindInfo()
{
if (!string.IsNullOrEmpty(txtconno.Text))
{
#region //合同搜索
Mod_TMO_CON modCon = tmo_con.GetModel(txtconno.Text);
if (modCon != null)
{
droparea.SelectedIndex = droparea.Items.IndexOf(droparea.Items.FindByText(modCon.C_AREA));
txtC_CONNO.Text = modCon.C_CON_NO;
txtC_DH_COMPANY.Text = modCon.C_CUSTNAME;
txtC_SH_COMPANY.Text = modCon.C_CUSTNAME;
txtC_STATION.Text = modCon.C_STATION;
txtC_CUSTNO.Text = modCon.C_CUST_NO;
Mod_TS_CUSTFILE mod = ts_custfile.GetModelCode(modCon.C_CUST_NO);
if (mod != null)
{
txtC_CUSTNAME.Text = mod.C_NAME; //客户名称
txtC_KH_BANK.Text = mod.C_EXTEND1; //开户行
txtC_TAXNO.Text = mod.C_TAXPAYERNO; //税号
txtC_ACCOUNT.Text = mod.C_EXTEND2; //账号
txtC_ADDRESS.Text = mod.C_EXTEND3; //地址
txtC_TEL.Text = mod.C_EXTEND4; //电话
}
}
#endregion
}
if (!string.IsNullOrEmpty(txtcustno.Text))
{
#region //客户编码搜索
Mod_TS_CUSTFILE mod = ts_custfile.GetModelCode(txtcustno.Text);
if (mod != null)
{
txtC_CUSTNO.Text = mod.C_NO;
txtC_CUSTNAME.Text = mod.C_NAME; //客户名称
txtC_KH_BANK.Text = mod.C_EXTEND1; //开户行
txtC_TAXNO.Text = mod.C_TAXPAYERNO; //税号
txtC_ACCOUNT.Text = mod.C_EXTEND2; //账号
txtC_ADDRESS.Text = mod.C_EXTEND3; //地址
txtC_TEL.Text = mod.C_EXTEND4; //电话
}
#endregion
}
}
//提交合同
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtConNO.Text) && !string.IsNullOrEmpty(txtCustName.Text))
{
if (rptList.Items.Count > 0)
{
Mod_TMO_CON modcon = con.GetModel(txtConNO.Text);
modcon.N_CON_STATUS = 0; //更新合同状态
modcon.D_CONINVALID_DT = Convert.ToDateTime(txtEnd.Value);
modcon.D_SYS_CONINVALID_DT = Convert.ToDateTime(ltlSysDate.Text); //系统计划失效日期
if (con.Update(modcon))
{
#region//获取发货上允差
decimal range = 0;
DataTable dt = comdiff.GetRangeList(Convert.ToDecimal(lblSum.Text)).Tables[0];
if (dt.Rows.Count > 0)
{
range = Convert.ToDecimal(dt.Rows[0]["C_RANGE"]);
}
#endregion
//更新每个订单状态和发货上允差
bool result = false;
foreach (RepeaterItem rpt in rptList.Items)
{
HtmlInputCheckBox chkSelect = (HtmlInputCheckBox)rpt.FindControl("chkSelect");
result = condetails.UpdateGC(range, chkSelect.Value);
}
if (result)
{
WebMsg.MessageBox("提交成功", "MyCon.aspx");
}
}
}
else
{
WebMsg.MessageBox("请添加订单");
return;
}
}
else
{
WebMsg.MessageBox("请输入合同名称，再点击保存");
}
}
public AjaxResult GetOldOrderAdd([FromBody] dynamic Json)
{
#region //参数
string ConNo = Json.ConNo; //合同号
JArray OrderList = (JArray)Json.OrderList; //.OrderNo
#endregion
#region 数据操作
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
List <Mod_TMO_ORDER> ListOrder = new List <Mod_TMO_ORDER>();
Mod_TMO_CON modCon = tmo_con.GetModel(ConNo);
for (int i = 0; i < OrderList.Count; i++)
{
#region //添加订单
Mod_TMO_ORDER modOrder = tmo_order.GetOrderModel(OrderList[i]["OrderNo"].ToString());
string order_no = randomnumber.CreateOrderNo(ConNo); //订单号
modOrder.C_ORDER_NO = order_no;
modOrder.C_CON_NO = ConNo; //合同号
modOrder.C_CON_NAME = modCon.C_CON_NAME; //合同名称
modOrder.C_AREA = modCon.C_AREA; //区域
//modOrder.D_NEED_DT = modCon.D_CONINVALID_DT;//需求日期
modOrder.D_DELIVERY_DT = modCon.D_CONINVALID_DT; //计划收货日期
modOrder.D_DT = DateTime.Now; //订单日期
modOrder.C_RECEIPTAREAID = modCon.C_CRECEIPTAREAID; //收货地区
modOrder.C_RECEIVEADDRESS = modCon.C_ADDRESS; //收货地址
modOrder.C_RECEIPTCORPID = modCon.C_CRECEIPTCUSTOMERID; //收货单位
modOrder.C_CURRENCYTYPEID = modCon.C_CURRENCYTYPEID; //货币
modOrder.N_USER_LEV = modCon.N_CUST_LEV; //客户等级
modOrder.C_REMARK = modCon.C_REAMRK;
ListOrder.Add(modOrder);
#endregion
}
result.Result = tmo_con.InsertConOrder(modCon, ListOrder) == true ? "提交成功" : "提交失败";
#endregion
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
if (vUser != null)
{
ltlC_EMP_ID.Text = vUser.Id;
ltlC_EMP_NAME.Text = vUser.Name;
if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
{
ltlCon_No.Text = Request.QueryString["ID"];//合同号
Mod_TMO_CON modCon = tmo_con.GetModel(ltlCon_No.Text);
ltlCustNo.Text = modCon.C_CUST_NO;
}
}
else
{
WebMsg.CheckUserLogin();
}
}
}
//销售订单导入NC
protected void Button1_Click(object sender, EventArgs e)
{
#region //导入NC
Mod_TMO_CON mod = tmo_con.GetModel(txtCON.Text);
List <ApiOrderDto> orderDto = new List <ApiOrderDto>();
ApiOrderDto dto = new ApiOrderDto();
dto.NC_ID = "";
dto.SaleCode = txtConNo.Text;
dto.ConNO = mod.C_CON_NO;
dto.D_NC_DATE = mod.D_MOD_DT.ToString();
orderDto.Add(dto);
string result = "";
string filePath = "~/FileInterface/download/" + txtConNo.Text + ".xml";
string xmlFileName = System.Web.HttpContext.Current.Server.MapPath(filePath);
List <string> resList = apisaleorder.SendXmlOrder(orderDto, xmlFileName, "");
#endregion
string jg = resList[0].ToString().ToString() == "1" ? "导入NC成功" : GetNCError(resList);
result = "单据号：" + txtConNo.Text + ",结果：" + jg;
WebMsg.MessageBox(result);
}
/// <summary>
/// 绑定合同相关信息
/// </summary>
private void BindConInfo()
{
if (!string.IsNullOrEmpty(txtConNO.Text))
{
Mod_TMO_CON mod = con.GetModel(txtConNO.Text);
if (mod != null)
{
dropCurrType.SelectedIndex = dropCurrType.Items.IndexOf(dropCurrType.Items.FindByText(mod.C_CURRENCY_TYPE));
txtDate.Value = Convert.ToDateTime(mod.D_CONSING_DT).ToString("yyy-MM-dd");
txtStart.Value = Convert.ToDateTime(mod.D_CONEFFE_DT).ToString("yyy-MM-dd");
txtEnd.Value = Convert.ToDateTime(mod.D_CONINVALID_DT).ToString("yyy-MM-dd");
dropConType.SelectedIndex = dropConType.Items.IndexOf(dropConType.Items.FindByText(mod.C_CON_TYPE));
txtConNO.Text = mod.C_CON_NO;
txtConName.Text = mod.C_CON_NAME;
txtCustName.Text = mod.C_CUST_NAME;
dropShipVia.SelectedIndex = dropShipVia.Items.IndexOf(dropShipVia.Items.FindByText(mod.C_SHIPVIA));
dropConArea.SelectedIndex = dropConArea.Items.IndexOf(dropConArea.Items.FindByText(mod.C_CON_AREA));
txtState.Text = GetOrderState(mod.N_CON_STATUS);
hidState.Value = mod.N_CON_STATUS.ToString();
BindConOrder();
}
}
}
/// <summary>
/// 加载客户默认地址与开票单位
/// </summary>
private void BindUserInfo()
{
Mod_TMO_CON modCON = tmo_con.GetModel(hidconNo.Value);
if (modCON != null)
{
hidConName.Value = modCON.C_CON_NAME;
hidCurrType.Value = modCON.C_CURRENCY_TYPE;
hidConArea.Value = modCON.C_CON_AREA;
hidShipVia.Value = modCON.C_SHIPVIA;
//客户档案
Mod_TS_CUSTFILE mod = custfile.GetCustModel(modCON.C_CUST_NO);
if (mod != null)
{
hidCustNO.Value = mod.C_NO;
hidCustName.Value = mod.C_NAME;
hidCustLEV.Value = mod.N_LEVEL.ToString();
hidCustType.Value = mod.N_TYPE.ToString() == "1" ? "经销" : "直销";
}
//默认收货单位
DataTable dt = custaddr.GetAddrList(mod.C_ID, "1").Tables[0];
if (dt.Rows.Count > 0)
{
txtAddress.Value = dt.Rows[0]["C_CGC"].ToString();
hidAddrID.Value = dt.Rows[0]["C_ID"].ToString();
}
//默认开票单位
DataTable dtc = custcompany.GetList(mod.C_ID).Tables[0];
if (dtc.Rows.Count > 0)
{
txtOTCompany.Value = dtc.Rows[0]["C_OTCOMPANY"].ToString();
}
}
}
/// <summary>
/// 加载合同信息
/// </summary>
private void GetConInfo()
{
if (!string.IsNullOrEmpty(txtConNO.Value))
{
Mod_TMO_CON modcon = tmo_con.GetModel(txtConNO.Value);
if (modcon != null)
{
#region //变更合同量控制
DataTable dtfywgt = GetData("DM002");
if (dtfywgt.Rows.Count > 0)
{
decimal num = 0;
if (!string.IsNullOrEmpty(dtfywgt.Rows[0]["C_DETAILCODE"].ToString()))
{
num = Convert.ToDecimal(dtfywgt.Rows[0]["C_DETAILCODE"].ToString());
decimal fywgt = Convert.ToDecimal(txtoldconwgt.Text);
decimal fd = fywgt * num;
hidsf.Value = Convert.ToString(fywgt + fd); //上幅数
hidxf.Value = Convert.ToString(fywgt - fd); //下幅数
hidmsg.Value = dtfywgt.Rows[0]["C_DETAILNAME"].ToString();
}
}
else
{
hidsf.Value = txtoldconwgt.Text;
}
#endregion
Mod_TS_CUSTFILE modCust = ts_custfile.GetCustModel(modcon.C_CUSTOMERID);
ltlCustNo.Text = modCust?.C_NO;
ltlN_CON_STATUS.Text = modcon.N_STATUS.ToString();
hidstatus.Value = modcon.N_STATUS.ToString();
#region //根据合同状态显示按钮
switch (modcon.N_STATUS.ToString())
{
case "0": //待审
btnAdd.Disabled = false; //产品
btnCheck.Enabled = true; //送审
btncondel.Visible = true;
btncancel.Visible = true; //撤回客户
break;
default:
btncondel.Visible = false;
btncancel.Visible = false;
break;
}
#endregion
txtConName.Value = modcon.C_CON_NAME;
dropConType.SelectedIndex = dropConType.Items.IndexOf(dropConType.Items.FindByValue(modcon.C_CONTYPEID));
txtCustName.Value = modcon.C_CUSTNAME;
txtQianDanDT.Value = Convert.ToDateTime(modcon.D_CONSING_DT).ToString("yyy-MM-dd");
txtPlanStartDT.Value = Convert.ToDateTime(modcon.D_CONEFFE_DT).ToString("yyy-MM-dd");
txtPlanEndDT.Value = Convert.ToDateTime(modcon.D_CONINVALID_DT).ToString("yyy-MM-dd");
dropFaYun.SelectedIndex = dropFaYun.Items.IndexOf(dropFaYun.Items.FindByValue(modcon.C_TRANSMODEID));
dropBiZhong.SelectedIndex = dropBiZhong.Items.IndexOf(dropBiZhong.Items.FindByValue(modcon.C_CURRENCYTYPEID));
dropYeWuType.SelectedIndex = dropYeWuType.Items.IndexOf(dropYeWuType.Items.FindByValue(modcon.C_BIZTYPE));
#region//收货地址
DataTable dtaddr = ts_custaddr.GetAddr("", "", modcon.C_CUSTOMERID, "", "").Tables[0];
if (dtaddr.Rows.Count > 0)
{
dropAddr.DataSource = dtaddr;
dropAddr.DataTextField = "C_CGAREA";
dropAddr.DataValueField = "C_CGAREA";
dropAddr.DataBind();
dropAddr.SelectedIndex = dropAddr.Items.IndexOf(dropAddr.Items.FindByText(modcon.C_ADDRESS));
}
#endregion
#region //部门
Mod_TS_DEPT modDept = ts_dept.GetModel(modcon.C_DEPTID);
if (modDept != null)
{
txtDept.Value = modDept.C_NAME;
hidC_DEPT_ID.Value = modcon.C_DEPTID;
}
#endregion
#region //业务员
txtSaleUser.Value = ts_user.GetSaleName(modcon.C_EMPLOYEEID);
hidC_SALESMAN.Value = modcon.C_EMPLOYEEID;
#endregion
dropSale.SelectedIndex = dropSale.Items.IndexOf(dropSale.Items.FindByValue(modcon.C_SALECORPID));
txtShuoHuoCompany.Value = GetCust(modcon.C_CRECEIPTCUSTOMERID);
txtKaiPiaoCompany.Value = GetCust(modcon.C_CRECEIPTCORPID);
txtC_STATION.Value = modcon.C_STATION;
txtState.Value = StringFormat.GetOrderState(modcon.N_STATUS);
txtDESC.Value = modcon.C_REAMRK;
txtZhiDanRen.Value = GetUserName(modcon.C_COPERATORID);
txtZhiDanTime.Value = modcon.D_DMAKEDATE.ToString();
#region //最后修改人/最后修改时间
txtC_APPROVEID.Value = GetUserName(modcon.C_APPROVEID);
txtD_APPROVEDATE.Value = modcon.D_APPROVEDATE.ToString();
txtLastEditUser.Value = GetUserName(modcon.C_EDITEMPLOYEEID);
txtLastEditTime.Value = modcon.D_EDITDATE.ToString();
#endregion
GetOrderList();
}
}
}
/// <summary>
/// 添加发运单
/// </summary>
/// <returns></returns>
private bool InsertFyd()
{
decimal fyzs = 0;
decimal fywgt = 0;
string sendcode = randomnumber.CreateDispID(); //发运单据号
#region //表体
List <Mod_TMD_DISPATCHDETAILS> item = new List <Mod_TMD_DISPATCHDETAILS>();
for (int i = 0; i < rptList.Items.Count; i++)
{
HtmlInputCheckBox chkOrder = (HtmlInputCheckBox)rptList.Items[i].FindControl("chkOrder"); //订单主键
HtmlInputText txtfyzs = (HtmlInputText)rptList.Items[i].FindControl("txtfyzs"); //发运支数
HtmlInputText txtjhfyl = (HtmlInputText)rptList.Items[i].FindControl("txtjhfyl"); //发运数量
HtmlInputHidden hidC_CGID = (HtmlInputHidden)rptList.Items[i].FindControl("hidC_CGID"); //收货单位
HtmlInputHidden hidshdq = (HtmlInputHidden)rptList.Items[i].FindControl("hidshdq"); //收货地区
TextBox txtPack_Code = (TextBox)rptList.Items[i].FindControl("txtPack_Code"); //包装要求
DropDownList dropzldj = (DropDownList)rptList.Items[i].FindControl("dropzldj"); //质量等级
DropDownList dropshdz = (DropDownList)rptList.Items[i].FindControl("dropshdz"); //收货地址
Literal ltlpkplan = (Literal)rptList.Items[i].FindControl("ltlpkplan"); //日计划主键
Literal ltlcustno = (Literal)rptList.Items[i].FindControl("ltlcustno"); //客户编码
HtmlInputHidden hidckid = (HtmlInputHidden)rptList.Items[i].FindControl("hidckid"); //仓库ID
HtmlInputText txtckname = (HtmlInputText)rptList.Items[i].FindControl("txtckname"); //仓库名称
HtmlInputText txtqtyq = (HtmlInputText)rptList.Items[i].FindControl("txtqtyq"); //其他要求
HtmlInputText txtremark = (HtmlInputText)rptList.Items[i].FindControl("txtremark"); //行备注
TextBox txtStd_Code = (TextBox)rptList.Items[i].FindControl("txtStd_Code"); //执行标准
TextBox txtC_FREE1 = (TextBox)rptList.Items[i].FindControl("txtC_FREE1"); //自由项1
TextBox txtC_FREE2 = (TextBox)rptList.Items[i].FindControl("txtC_FREE2"); //自由项2
Mod_TMO_ORDER modOrder = tmo_order.GetModel(chkOrder.Value);
if (modOrder != null)
{
fyzs += Convert.ToDecimal(txtfyzs.Value ?? "0");
fywgt += Convert.ToDecimal(txtjhfyl.Value ?? "0");
Mod_TMD_DISPATCHDETAILS modfyditem = new Mod_TMD_DISPATCHDETAILS();
modfyditem.C_DISPATCH_ID = sendcode; //发运单单据号
modfyditem.C_MAT_CODE = modOrder.C_MAT_CODE; //物料编码
modfyditem.C_MAT_NAME = modOrder.C_MAT_NAME; //物料名称
modfyditem.C_SPEC = modOrder.C_SPEC; //规格
modfyditem.C_STL_GRD = modOrder.C_STL_GRD; //钢种
modfyditem.C_QUALIRY_LEV = dropzldj.SelectedItem.Value; //质量等级主键-发运单
modfyditem.C_JUDGE_LEV_ZH = dropzldj.SelectedItem.Text; //质量等级编码
modfyditem.C_FREE_TERM = txtC_FREE1.Text; //自由项
modfyditem.C_FREE_TERM2 = txtC_FREE2.Text; //自由项
modfyditem.C_PACK = txtPack_Code.Text; //包装要求
modfyditem.C_STD_CODE = txtStd_Code.Text; //执行标准
modfyditem.C_ELSENEED = txtqtyq.Value; //其他要求?
modfyditem.C_REMARK = txtremark.Value; //行备注*****
modfyditem.N_COM_AMOUNT_WGT = modOrder.N_FNUM; //原始订单辅数量
modfyditem.N_WGT = modOrder.N_WGT; //原始订单数量
modfyditem.C_EQUATION_FACTOR = modOrder.N_HSL.ToString(); //换算率
modfyditem.C_UNITIS = modOrder.C_UNITID; //主计量单位ID
modfyditem.C_ORGO_CUST = modOrder.C_CUST_NAME; //订货客户
modfyditem.C_CGC = hidC_CGID.Value; //收货单位-发运单
modfyditem.C_ORDER_TYPE = modOrder.N_TYPE.ToString() == "8" ? "805" : modOrder.N_TYPE.ToString(); //订单类型 8线材 6钢坯 831废乱材 841焦化产品 851渣
modfyditem.C_SEND_AREA = hidshdq.Value; //到货地区-发运单
modfyditem.C_AREA = dropshdz.SelectedItem?.Value ?? ""; //到货地址-发运单
modfyditem.C_EMP_ID = ltlempid.Text;
modfyditem.C_EMP_NAME = ltlempname.Text;
modfyditem.C_CON_NO = modOrder.C_CON_NO; //合同号
modfyditem.C_PLAN_ID = ltlpkplan.Text; //日计划主键
modfyditem.C_NO = modOrder.C_ORDER_NO; //订单号
modfyditem.C_ORDERPK = modOrder.C_ID; //订单主键
modfyditem.C_CUSTNO = ltlcustno.Text; //客户编码
modfyditem.N_FYZS = Convert.ToDecimal(txtfyzs.Value == "" ? "0" : txtfyzs.Value); //发运支数
modfyditem.N_FYWGT = Convert.ToDecimal(txtjhfyl.Value == "" ? "0" : txtjhfyl.Value); //发运数量
modfyditem.C_SEND_STOCK = txtckname.Value; //发运仓库名称
modfyditem.C_SEND_STOCK_PK = hidckid.Value; //发运仓库ID
modfyditem.C_PRODUCT_ID = ""; //库存产品ID
modfyditem.C_AU_UNITIS = modOrder.C_FUNITID; //辅单位
modfyditem.N_PRICE = 0; //到货地点费用
item.Add(modfyditem);
}
}
#endregion
#region//表头
Mod_TMD_DISPATCH modfyd = new Mod_TMD_DISPATCH();
modfyd.C_ID = sendcode; //发运单单据号
modfyd.C_GPS_NO = txtgps.Text; //GPS号
modfyd.D_DISP_DT = Convert.ToDateTime(txtfydt.Text); //发运日期
modfyd.C_SHIPVIA = dropfyfs.SelectedItem.Value; //发运方式
modfyd.C_COMCAR = dropcys.SelectedItem.Value; //承运商
modfyd.C_IS_WIRESALE = dropsfxc.SelectedItem.Text; //汉字是否线材
modfyd.C_IS_WIRESALE_ID = dropsfxc.SelectedItem.Value; //是否线材主键
modfyd.C_LIC_PLA_NO = txtcph.Text; //车牌号
modfyd.C_ATSTATION = txtdz.Text; //到站
modfyd.C_CREATE_ID = ltlempid.Text; //制单人
modfyd.C_EMP_ID = ltlempid.Text; //修改人ID
modfyd.C_EMP_NAME = ltlempname.Text; //修改人
modfyd.C_EXTEND5 = ltltype.Text; //订单类型 8线材 6钢坯 831废乱材 841焦化产品 851渣
modfyd.C_CUSTNAME = ltlcustname.Text; //客户
modfyd.C_CON_NO = ltlcon_no.Text; //合同号
modfyd.N_QUA = fyzs; //发运支数
modfyd.N_WGT = fywgt; //发运量
modfyd.N_IS_EXPORT = 0; //是否包到价
modfyd.C_EXTEND2 = txtcph.Text; //虚拟车号
Mod_TMO_CON modCon = tmo_con.GetModel(ltlcon_no.Text);
if (modCon != null)
{
modfyd.C_BUSINESS_DEPT = modCon.C_DEPTID; //业务部门
modfyd.C_BUSINESS_ID = modCon.C_EMPLOYEEID; //业务员
}
#endregion
if (tmd_dispatch.InsertFYD(modfyd, item))
{
txtsendcode.Text = sendcode;
return(true);
}
else
{
return(false);
}
}
//添加
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
Mod_TMO_CON modCon = tmo_con.GetModel(ltlCon_No.Text);
Mod_TS_CUSTFILE modCust = ts_custfile.GetCustModel(modCon.C_CUSTOMERID);
List <Mod_TMO_ORDER> orderList = new List <Mod_TMO_ORDER>();
for (int i = 0; i < rptList.Items.Count; i++)
{
HtmlInputCheckBox cbxSelect = (HtmlInputCheckBox)rptList.Items[i].FindControl("chkMat_Code"); //物料ID
Literal ltlmatcode = (Literal)rptList.Items[i].FindControl("ltlmatcode"); //物料编码
Literal ltlmatname = (Literal)rptList.Items[i].FindControl("ltlmatname"); //物料名称
Literal ltlstlgrd = (Literal)rptList.Items[i].FindControl("ltlstlgrd"); //钢种
Literal ltlspec = (Literal)rptList.Items[i].FindControl("ltlspec"); //规格
Literal ltlC_CUST_TECH_PROT = (Literal)rptList.Items[i].FindControl("ltlC_CUST_TECH_PROT"); //客户协议
Literal ltlC_STD_CODE = (Literal)rptList.Items[i].FindControl("ltlC_STD_CODE"); //执行标准
Literal ltlzyx1 = (Literal)rptList.Items[i].FindControl("ltlzyx1"); //自由项1
Literal ltlzyx2 = (Literal)rptList.Items[i].FindControl("ltlzyx2"); //自由项2
Literal ltlC_IS_BXG = (Literal)rptList.Items[i].FindControl("ltlC_IS_BXG"); //是否不锈钢
if (cbxSelect.Checked)
{
#region Insert
Mod_TB_MATRL_MAIN modMat = tb_matrl_main.GetModel(cbxSelect.Value);
Mod_TMO_ORDER modOrder = new Mod_TMO_ORDER();
string order_no = randomnumber.CreateOrderNo(ltlCon_No.Text); //订单号
modOrder.C_ORDER_NO = order_no;
modOrder.C_CON_NO = modCon.C_CON_NO; //合同号
modOrder.C_CON_NAME = modCon.C_CON_NAME; //合同名称
modOrder.C_AREA = modCon.C_AREA; //区域
modOrder.C_INVBASDOCID = modMat.C_PK_INVBASDOC; //存货档案主键
modOrder.C_INVENTORYID = modMat.C_PK_INVMANDOC; //存货管理档案主键
modOrder.C_PROD_NAME = modMat.C_PROD_NAME; //品名
modOrder.C_PROD_KIND = modMat.C_PROD_KIND; //品种
modOrder.C_MAT_CODE = modMat.C_MAT_CODE; //物料编码
modOrder.C_MAT_NAME = modMat.C_MAT_NAME; //物料名称
modOrder.C_SPEC = modMat.C_SPEC; //规格
modOrder.C_STL_GRD = modMat.C_STL_GRD; //钢种
modOrder.C_FUNITID = modMat.C_FJLDW; // "jlda0000000000000041";//辅单位
modOrder.C_UNITID = modMat.C_PK_MEASDOC; //主计量单位
//modOrder.D_NEED_DT = modCon.D_CONINVALID_DT;//需求日期
modOrder.D_DELIVERY_DT = modCon.D_CONINVALID_DT; //计划收货日期
modOrder.D_DT = DateTime.Now; //订单日期
modOrder.C_TECH_PROT = ltlC_CUST_TECH_PROT.Text; //客户协议号
modOrder.C_FREE1 = ltlzyx1.Text; //自由项1
modOrder.C_FREE2 = ltlzyx2.Text; //自由项2
modOrder.C_STD_CODE = ltlC_STD_CODE.Text; //执行标准
modOrder.C_BY4 = ltlC_IS_BXG.Text; //是否不锈钢
//modOrder.C_PACK = pack;//包装要求
decimal N_WGT = 0;
modOrder.N_WGT = N_WGT; //数量
modOrder.N_HSL = modMat.N_HSL == null ? 0 : modMat.N_HSL; //换算率
modOrder.N_FNUM = modMat.N_HSL == null ? 1 : N_WGT / modMat.N_HSL; //辅数量
modOrder.C_RECEIPTCORPID = modCon.C_CRECEIPTAREAID; //收货地区
modOrder.C_RECEIVEADDRESS = modCon.C_ADDRESS; //收货地址
modOrder.C_RECEIPTCORPID = modCon.C_CRECEIPTCUSTOMERID; //收货单位
modOrder.C_CURRENCYTYPEID = modCon.C_CURRENCYTYPEID; //货币
modOrder.N_TYPE = Convert.ToDecimal(modMat.C_MAT_TYPE);
modOrder.N_USER_LEV = modCon.N_CUST_LEV; //客户等级
modOrder.C_CUST_SQ = modCon.C_REAMRK; //客户要求
modOrder.C_EMP_ID = ltlC_EMP_ID.Text; //操作人ID
modOrder.C_EMP_NAME = ltlC_EMP_NAME.Text; //操作人姓名
modOrder.C_CUST_NO = modCon.C_CUST_NO; //客户编码
modOrder.C_CUST_NAME = modCon.C_CUSTNAME; //客户名称
modOrder.C_SALE_CHANNEL = modCust.N_TYPE == 1 ? "经销" : "直销";
modOrder.C_LEV = GetLev("STL_GRD_Lev"); //钢种等级
modOrder.C_ORDER_LEV = GetLev("Order_Lev"); //订单等级
modOrder.N_COST = 0; //成本
modOrder.N_STATUS = 0; //待审
Mod_TMB_TAXITEMS modTaxi = tmb_taxitems.GetModel(modMat.C_PK_TAXITEMS);
modOrder.N_TAXRATE = modTaxi.N_TAXRATIO; //税率
modOrder.C_VDEF1 = modMat.C_MAT_TYPE == "6" ? "1001NC100000000052Z3" : "1016NC10000000000V1A"; //质量等级
#region //获取钢种单价-折扣-税率
decimal Price = 0;
decimal N_TAXRATE = Convert.ToDecimal(modOrder.N_TAXRATE) + 1; //税率
decimal N_ORIGINALCURPRICE = Convert.ToDecimal(Price) / N_TAXRATE; //原币无税单价
decimal N_ORIGINALCURTAXPRICE = Convert.ToDecimal(Price); //原币含税单价
decimal N_ORIGINALCURMNY = decimal.Round(N_WGT * N_ORIGINALCURPRICE, 2); //原币无税金额
decimal N_ORIGINALCURSUMMNY = N_WGT * N_ORIGINALCURTAXPRICE; //原币价税合计
decimal N_ORIGINALCURTAXMNY = decimal.Round(N_ORIGINALCURSUMMNY - N_ORIGINALCURMNY, 2); //原币税额
modOrder.N_ORIGINALCURPRICE = N_ORIGINALCURPRICE; //原币无税单价
modOrder.N_ORIGINALCURTAXPRICE = N_ORIGINALCURTAXPRICE; //原币含税单价
modOrder.N_ORIGINALCURTAXMNY = N_ORIGINALCURTAXMNY; //原币税额
modOrder.N_ORIGINALCURMNY = N_ORIGINALCURMNY; //原币无税金额
modOrder.N_ORIGINALCURSUMMNY = N_ORIGINALCURSUMMNY; //原币价税合计
#endregion
orderList.Add(modOrder);
#endregion
}
}
if (tmo_con.InsertFirstOrder(orderList))
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "window.parent.document.getElementById('imgbtnJz').click();window.parent.close();", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('" + ex.Message + "')", true);
}
}
public AjaxResult ConChange([FromBody] dynamic Json)
{
#region //参数
string conNO = Json.conNO; //合同号
#endregion
#region //数据操作
AjaxResult result = new AjaxResult();
try
{
if (!string.IsNullOrEmpty(conNO))
{
#region //新增变更合同
List <Mod_TMO_ORDER> orderList = new List <Mod_TMO_ORDER>();
#region //添加合同基本信息
Mod_TMO_CON modCon = tmo_con.GetModel(conNO);
int NO = Convert.ToInt32(modCon.N_CHANGENUM.ToString()) + 1;
modCon.C_CON_NO = modCon.C_CON_NO + "-" + NO.ToString();
modCon.C_CON_NAME = modCon.C_CON_NAME;
modCon.N_STATUS = -1; //客户待提交
modCon.D_CONSING_DT = DateTime.Now; //合同签署日期
modCon.D_CONEFFE_DT = Convert.ToDateTime(DateTime.Now); //计划生效日期
modCon.D_CONINVALID_DT = Convert.ToDateTime(DateTime.Now).AddDays(60); //计划失效日期
modCon.C_CON_NO_OLD = conNO; //原始合同号
modCon.N_CHANGENUM = NO; //变更次数
#endregion
#region //添加合同明细
Bll_RandomNumber randomnumber = new Bll_RandomNumber(); //流水号
DataTable dtOrder = tmo_order.GetConOrderList(conNO, "", "", "", "", "").Tables[0];
for (int i = 0; i < dtOrder.Rows.Count; i++)
{
Mod_TMO_ORDER modOrder = tmo_order.GetModel(dtOrder.Rows[i]["C_ID"].ToString()); //订单表
string order_no = randomnumber.CreateOrderNo(modCon.C_CON_NO); //订单号
modOrder.C_ORDER_NO = order_no;
modOrder.C_CON_NO = modCon.C_CON_NO; //合同号
modOrder.C_CON_NAME = modCon.C_CON_NAME; //合同名称
modOrder.N_STATUS = -1; //客户待提交
modOrder.C_SFPJ = "N"; //是否评价
modOrder.N_EXEC_STATUS = -2; //未提报
modOrder.N_WGT = modOrder.N_WGT; //原合同数量
modOrder.C_ORDER_NO_OLD = dtOrder.Rows[i]["C_ORDER_NO"].ToString(); //原合同号
orderList.Add(modOrder);
}
#endregion
#endregion
if (tmo_con.InsertConOrder(modCon, orderList))
{
result.Code = DoResult.Success;
result.Result = "变更成功";
}
}
else
{
result.Code = DoResult.Success;
result.Result = "合同为空，无法操作";
}
}
catch (Exception ex)
{
result.Code = DoResult.Success;
result.Result = ex.Message;
}
#endregion
return(result);
}
private bool Add(int N_STATUS)
{
bool result = true;
List <Mod_TMO_ORDER> orderList = new List <Mod_TMO_ORDER>();
#region //修改合同基本信息
Mod_TMO_CON modCon = tmo_con.GetModel(txtConNO.Text);
modCon.C_CON_NO = txtConNO.Text;
modCon.C_CON_NAME = txtConName.Text;
modCon.C_CONTYPEID = dropConType.SelectedItem.Value; //合同类型
modCon.C_EMPLOYEEID = hidsaleempid.Value; //业务员
modCon.C_DEPTID = hiddeptid.Value; //业务部门
modCon.C_CURRENCYTYPEID = dropCurrType.SelectedValue; //货币类型
modCon.D_CONSING_DT = Convert.ToDateTime(txtDate.Value); //签约日期
modCon.D_CONEFFE_DT = Convert.ToDateTime(txtStart.Value); //计划生效日期
modCon.D_CONINVALID_DT = Convert.ToDateTime(txtEnd.Value); //计划失效日期
modCon.D_NEED_DT = Convert.ToDateTime(txtEnd.Value).AddDays(-30); //需求日期
modCon.C_TRANSMODEID = dropShipVia.SelectedValue; //发运方式
modCon.N_STATUS = N_STATUS;
Mod_TS_DEPT modDept = ts_dept.GetModel(hiddeptid.Value);
if (modDept != null)
{
modCon.C_AREA = modDept.C_NAME;//合同区域
}
if (!string.IsNullOrEmpty(hidC_CGID.Value))
{
Mod_TS_CUSTFILE modCust = ts_custfile.GetCustModel(hidC_CGID.Value);
modCon.C_CRECEIPTCUSTOMERID = hidC_CGID.Value; //收货单位
modCon.C_ADDRESS = txtAddr.Value; //收货地址
modCon.C_CRECEIPTAREAID = modCust.C_AREATYPE; //收货地区
}
modCon.C_STATION = txtC_STATION.Value;
modCon.C_REAMRK = txtReamrk.Value;
#endregion
#region//修改合同明细
for (int i = 0; i < rptList.Items.Count; i++)
{
Literal ltlC_NO = (Literal)rptList.Items[i].FindControl("ltlC_NO");
TextBox txtPack_Code = (TextBox)rptList.Items[i].FindControl("txtPack_Code"); //包装要求
TextBox txtWgt = (TextBox)rptList.Items[i].FindControl("txtWgt"); //数量
TextBox txtC_PRO_USE = (TextBox)rptList.Items[i].FindControl("txtC_PRO_USE"); //用途
TextBox txtC_CUST_SQ = (TextBox)rptList.Items[i].FindControl("txtC_CUST_SQ"); //特殊要求
TextBox txtN_ORIGINALCURTAXPRICE = (TextBox)rptList.Items[i].FindControl("txtN_ORIGINALCURTAXPRICE"); //含税单价
DropDownList dropZL = (DropDownList)rptList.Items[i].FindControl("dropZL"); //质量
if (string.IsNullOrEmpty(txtPack_Code.Text) && tqb_pack.Exists(txtPack_Code.Text))
{
result = false;
break;
}
Mod_TMO_ORDER modOrder = tmo_order.GetModel(ltlC_NO.Text);
modOrder.C_CON_NAME = modCon.C_CON_NAME; //合同名称
modOrder.C_AREA = modCon.C_AREA; //合同区域
//modOrder.D_NEED_DT = modCon.D_NEED_DT;//需求日期
modOrder.D_DELIVERY_DT = modCon.D_CONINVALID_DT; //计划收货日期
modOrder.C_VDEF1 = dropZL.SelectedItem.Value; //质量主键
modOrder.C_PACK = txtPack_Code.Text.Trim(); //包装要求
decimal N_WGT = 0;
if (!string.IsNullOrEmpty(txtWgt.Text))
{
N_WGT = Convert.ToDecimal(txtWgt.Text);
modOrder.N_WGT = N_WGT; //数量
}
modOrder.N_FNUM = modOrder.N_HSL == 0 ? 1 : N_WGT / modOrder.N_HSL; //辅数量
#region //获取钢种单价-折扣-税率
if (!string.IsNullOrEmpty(txtN_ORIGINALCURTAXPRICE.Text))
{
decimal N_TAXRATE = Convert.ToDecimal(modOrder.N_TAXRATE) + 1; //税率
decimal N_ORIGINALCURPRICE = Convert.ToDecimal(txtN_ORIGINALCURTAXPRICE.Text) / N_TAXRATE; //原币无税单价
decimal N_ORIGINALCURTAXPRICE = Convert.ToDecimal(txtN_ORIGINALCURTAXPRICE.Text); //原币含税单价
decimal N_ORIGINALCURMNY = decimal.Round(N_WGT * N_ORIGINALCURPRICE, 2); //原币无税金额
decimal N_ORIGINALCURSUMMNY = N_WGT * N_ORIGINALCURTAXPRICE; //原币价税合计
decimal N_ORIGINALCURTAXMNY = decimal.Round(N_ORIGINALCURSUMMNY - N_ORIGINALCURMNY, 2); //原币税额
modOrder.N_ORIGINALCURPRICE = N_ORIGINALCURPRICE; //原币无税单价
modOrder.N_ORIGINALCURTAXPRICE = N_ORIGINALCURTAXPRICE; //原币含税单价
modOrder.N_ORIGINALCURTAXMNY = N_ORIGINALCURTAXMNY; //原币税额
modOrder.N_ORIGINALCURMNY = N_ORIGINALCURMNY; //原币无税金额
modOrder.N_ORIGINALCURSUMMNY = N_ORIGINALCURSUMMNY; //原币价税合计
}
#endregion
modOrder.C_RECEIPTAREAID = modCon.C_CRECEIPTAREAID; //收货地区
modOrder.C_RECEIVEADDRESS = modCon.C_ADDRESS; //收货地址
modOrder.C_RECEIPTCORPID = modCon.C_CRECEIPTCUSTOMERID; //收货单位
modOrder.C_CURRENCYTYPEID = modCon.C_CURRENCYTYPEID; //货币
modOrder.C_CUST_SQ = txtC_CUST_SQ.Text; //客户要求
modOrder.C_PRO_USE = txtC_PRO_USE.Text; //产品用途
modOrder.C_TRANSMODE = dropShipVia.SelectedItem.Text; //发运方式
modOrder.C_TRANSMODEID = dropShipVia.SelectedItem.Value; //发运主键
modOrder.C_YWY = txtSaleUser.Value; //业务员
modOrder.N_STATUS = N_STATUS; //订单状态
modOrder.N_EXEC_STATUS = -2; //订单状态
orderList.Add(modOrder);
}
#endregion
return(result == true?tmo_con.UpdateConOrder(modCon, orderList) : result);
}
/// <summary>
/// 保存合同
/// </summary>
/// <param name="state">状态</param>
/// <returns></returns>
private bool SaveCon(int state)
{
List <Mod_TMO_ORDER> orderList = new List <Mod_TMO_ORDER>();
#region //修改合同基本信息
Mod_TMO_CON modCon = tmo_con.GetModel(hidconno.Value);
if (hidconno.Value != txtConNO.Value)
{
modCon.C_CON_NEW = txtConNO.Value; //合同号
}
modCon.N_STATUS = state; //合同状态
modCon.C_CON_NAME = txtConName.Value; //合同名称
modCon.C_CONTYPEID = dropConType.SelectedValue; //合同类型
modCon.C_CURRENCYTYPEID = dropBiZhong.SelectedValue; //货币类型
modCon.D_CONSING_DT = Convert.ToDateTime(txtQianDanDT.Value); //签署日期
modCon.D_CONEFFE_DT = Convert.ToDateTime(txtPlanStartDT.Value); //生效日期
modCon.D_CONINVALID_DT = Convert.ToDateTime(txtPlanEndDT.Value); //失效日期
modCon.C_TRANSMODEID = dropFaYun.SelectedItem.Value; //发运方式
modCon.C_SALECORPID = dropSale.SelectedItem.Value; //销售组织-
modCon.C_AREA = txtDept.Value; //合同区域
modCon.C_REAMRK = txtDESC.Value; //备注
modCon.C_STATION = txtC_STATION.Value; //站点
modCon.C_BIZTYPE = dropYeWuType.SelectedItem.Value; //业务类型-
modCon.C_DEPTID = hidC_DEPT_ID.Value; //业务部门-
modCon.C_EMPLOYEEID = hidC_SALESMAN.Value; //业务员
modCon.C_EDITEMPLOYEEID = ltlC_EMP_ID.Text; //修改人
modCon.D_EDITDATE = DateTime.Now; //修改时间
modCon.C_ADDRESS = dropAddr.SelectedItem?.Text ?? ""; //收货地址
string C_PCLX = dropYeWuType.SelectedItem.Text == "1001NC10000000005EI8" ? "1" : "0"; //1出口材，0普通材
modCon.C_CRECEIPTCUSTOMERID = hidC_CGID.Value; //收货单位
modCon.C_CRECEIPTCORPID = hidC_OTCID.Value; //开票单位
modCon.N_FLAG = dropClass.SelectedValue;
#endregion
#region //修改合同明细
for (int i = 0; i < rptList.Items.Count; i++)
{
DropDownList dropZL = (DropDownList)rptList.Items[i].FindControl("dropZL");
DropDownList dropzxzt = (DropDownList)rptList.Items[i].FindControl("dropzxzt");
DropDownList dropsfjk = (DropDownList)rptList.Items[i].FindControl("dropsfjk");
TextBox txtWgt = (TextBox)rptList.Items[i].FindControl("txtWgt"); //数量
TextBox txtN_ORIGINALCURTAXPRICE = (TextBox)rptList.Items[i].FindControl("txtN_ORIGINALCURTAXPRICE"); //原币含税单价
TextBox txtPack_Code = (TextBox)rptList.Items[i].FindControl("txtPack_Code");
TextBox txtRemark = (TextBox)rptList.Items[i].FindControl("txtRemark");//行备注
Literal ltlC_NO = (Literal)rptList.Items[i].FindControl("ltlC_NO");
HtmlInputText txtD_DELIVERY_DT = (HtmlInputText)rptList.Items[i].FindControl("txtD_DELIVERY_DT"); //订单交货日期
HtmlInputText txtN_TAXRATE = (HtmlInputText)rptList.Items[i].FindControl("txtN_TAXRATE"); //税率
HtmlInputText txtStd_Code = (HtmlInputText)rptList.Items[i].FindControl("txtStd_Code"); //执行标准
HtmlInputText txtC_FREE1 = (HtmlInputText)rptList.Items[i].FindControl("txtC_FREE1"); //自由项1
HtmlInputText txtC_FREE2 = (HtmlInputText)rptList.Items[i].FindControl("txtC_FREE2"); //自由项2
Mod_TMO_ORDER modOrder = tmo_order.GetModel(ltlC_NO.Text);
if (hidconno.Value != txtConNO.Value)
{
modOrder.C_CON_NO = modCon.C_CON_NEW; //新合同号
}
modOrder.C_CON_NAME = txtConName.Value; //合同名称
modOrder.C_AREA = txtDept.Value; //区域
modOrder.C_CUST_SQ = txtDESC.Value;
modOrder.C_PCLX = C_PCLX; //1出口材，0普通材
modOrder.N_EXEC_STATUS = Convert.ToDecimal(dropzxzt.SelectedItem.Value); //执行状态
//modOrder.D_NEED_DT = modCon.D_NEED_DT;//需求日期
modOrder.D_DELIVERY_DT = Convert.ToDateTime(txtD_DELIVERY_DT.Value); //计划订单交货日期
modOrder.C_YWY = txtSaleUser.Value; //业务员姓名
modOrder.C_CURRENCYTYPEID = dropBiZhong.SelectedValue; //货币
modOrder.C_STD_CODE = txtStd_Code.Value; //执行标准
modOrder.C_FREE1 = txtC_FREE1.Value; //自由项1
modOrder.C_FREE2 = txtC_FREE2.Value; //自由项2
modOrder.C_PACK = txtPack_Code.Text; //包装要求
modOrder.C_LEV = ""; //等级
modOrder.C_ORDER_LEV = ""; //级别
modOrder.C_VDEF1 = dropZL.SelectedValue; //质量等级
modOrder.C_STL_GRD_CLASS = ""; //钢种大类
modOrder.C_SFJK = dropsfjk.SelectedItem.Text; //监控钢种
modOrder.C_RECEIPTAREAID = modCon.C_CRECEIPTAREAID; //收货地区
modOrder.C_RECEIVEADDRESS = modCon.C_ADDRESS; // 收货地址
modOrder.C_RECEIPTCORPID = modCon.C_CRECEIPTCUSTOMERID; //收货单位
modOrder.C_REMARK = txtRemark.Text; //行备注
decimal N_WGT = 0;
if (!string.IsNullOrEmpty(txtWgt.Text))
{
N_WGT = Convert.ToDecimal(txtWgt.Text);
}
modOrder.N_WGT = N_WGT; //数量
modOrder.N_FNUM = modOrder.N_HSL == 0 ? 1 : N_WGT / modOrder.N_HSL; //辅数量
#region //获取钢种单价-折扣-税率
if (!string.IsNullOrEmpty(txtN_ORIGINALCURTAXPRICE.Text))
{
decimal shuolv = Convert.ToDecimal(txtN_TAXRATE.Value == "" ? "0" : txtN_TAXRATE.Value);//税率
if (Convert.ToDecimal(shuolv) >= 1)
{
shuolv = shuolv / 100;
}
decimal N_TAXRATE = shuolv + 1; //税率
decimal N_ORIGINALCURPRICE = Convert.ToDecimal(txtN_ORIGINALCURTAXPRICE.Text) / N_TAXRATE; //原币无税单价
decimal N_ORIGINALCURTAXPRICE = Convert.ToDecimal(txtN_ORIGINALCURTAXPRICE.Text); //原币含税单价
decimal N_ORIGINALCURMNY = decimal.Round(N_WGT * N_ORIGINALCURPRICE, 2); //原币无税金额
decimal N_ORIGINALCURSUMMNY = N_WGT * N_ORIGINALCURTAXPRICE; //原币价税合计
decimal N_ORIGINALCURTAXMNY = decimal.Round(N_ORIGINALCURSUMMNY - N_ORIGINALCURMNY, 2); //原币税额
modOrder.N_TAXRATE = shuolv; //税率
modOrder.N_ORIGINALCURPRICE = N_ORIGINALCURPRICE; //原币无税单价
modOrder.N_ORIGINALCURTAXPRICE = N_ORIGINALCURTAXPRICE; //原币含税单价
modOrder.N_ORIGINALCURTAXMNY = N_ORIGINALCURTAXMNY; //原币税额
modOrder.N_ORIGINALCURMNY = N_ORIGINALCURMNY; //原币无税金额
modOrder.N_ORIGINALCURSUMMNY = N_ORIGINALCURSUMMNY; //原币价税合计
}
#endregion
orderList.Add(modOrder);
}
#endregion
return(tmo_con.UpdateConOrder(modCon, orderList));
}
/// <summary>
/// 插入销售订单
/// </summary>
/// <param name="parem">合同参数列表,返回DataTable:ID,CODE</param>
/// <returns></returns>
public DataTable InsertSaleOrder(List <string> parem)
{
//初始化DataTable
DataTable dt = new DataTable();
dt.Columns.Add("ID", typeof(string)); //主键
dt.Columns.Add("CODE", typeof(string)); //单据号
Dal_TMO_CON tmo_con = new Dal_TMO_CON();
Dal_TMO_CONDETAILS tmo_condetails = new Dal_TMO_CONDETAILS();
ArrayList strSql = new ArrayList();
if (parem.Count > 0)
{
for (int i = 0; i < parem.Count; i++)
{
Mod_TMO_CON modCon = tmo_con.GetModel(parem[i]);
Mod_TMO_SALEORDER modSale = new Mod_TMO_SALEORDER();
#region //销售订单主表
string pk_mainid = Guid.NewGuid().ToString("N"); //主键ID
string code = Dal_RandomNumber.GetSaleCode(); //销售单据号
dt.Rows.Add(new object[] { pk_mainid, code });
StringBuilder cmdText = new StringBuilder();
cmdText.Append("insert into TMO_SALEORDER(");
cmdText.Append("C_ID,C_CODE,C_CONNO,C_INITIALIZE_ID,C_BIZTYPE,D_BILLDATE,C_CUSTOMERID,C_DEPTID,C_EMPLOYEEID,C_OPERATORID,C_SALECORPID,C_RECEIPTCUSTOMERID,C_RECEIVEADDRESS,C_RECEIPTCORPID,C_TRANSMODEID,D_MAKEDATE,C_APPROVEID,D_APPROVEDATE)");
cmdText.Append(" values (");
cmdText.Append("'" + pk_mainid + "',"); //主键ID
cmdText.Append("'" + code + "',"); //销售单据号
cmdText.Append("'" + modCon.C_CON_NO + "',"); //合同号
cmdText.Append("'',"); //方案表主键
cmdText.Append("'" + modCon.C_BIZTYPE + "',"); //业务类型ID
cmdText.Append("to_date('" + DateTime.Now + "','yyyy-mm-dd hh24:mi:ss'),"); //单据日期
cmdText.Append("'" + modCon.C_CUSTOMERID + "',"); //客户ID-NC客商管理档案主键
cmdText.Append("'" + modCon.C_DEPTID + "',"); //部门ID
cmdText.Append("'" + modCon.C_EMPLOYEEID + "',"); //业务员ID
cmdText.Append("'" + modCon.C_COPERATORID + "',"); //制单人ID
cmdText.Append("'" + modCon.C_SALECORPID + "',"); //销售组织ID
cmdText.Append("'" + modCon.C_CRECEIPTCUSTOMERID + "',"); //收货单位
cmdText.Append("'" + modCon.C_ADDRESS + "',"); //收货地址
cmdText.Append("'" + modCon.C_CRECEIPTAREAID + "',"); //开票单位ID-来源与客户档案信息
cmdText.Append("'" + modCon.C_TRANSMODEID + "',"); //发运方式ID
cmdText.Append("to_date('" + modCon.D_DMAKEDATE + "','yyyy-mm-dd hh24:mi:ss'),"); //制单日期
cmdText.Append("'" + modCon.C_APPROVEID + "',"); //审批人
cmdText.Append("to_date('" + modCon.D_APPROVEDATE + "','yyyy-mm-dd hh24:mi:ss')"); //审批日期
cmdText.Append(")");
strSql.Add(cmdText.ToString());
#endregion
DataTable dtOrder = tmo_condetails.GetConOrderList(parem[i], "").Tables[0];
if (dtOrder.Rows.Count > 0)
{
for (int k = 0; k < dtOrder.Rows.Count; k++)
{
#region //插入销售订单子表
Mod_TMO_CONDETAILS modOrder = tmo_condetails.GetModel(dtOrder.Rows[k]["C_NO"].ToString());
string pk_itemid = Guid.NewGuid().ToString("N"); //主键
StringBuilder cmdText2 = new StringBuilder();
cmdText2.Append("insert into TMO_SALEORDERITEM(");
cmdText2.Append("C_ID,C_BILLID,C_ORDERNO,C_CONNO,C_INVBASDOCID,C_INVENTORYID,C_UNITID,C_FUNITID,N_NUMBER,D_CONSIGNDATE,D_DELIVERDATE,C_CURRENCYTYPEID,N_TAXRATE,N_ORIGINALCURPRICE,N_ORIGINALCURTAXPRICE,N_ORIGINALCURTAXMNY,N_ORIGINALCURMNY,N_ORIGINALCURSUMMNY,C_RECEIPTAREAID,C_RECEIVEADDRESS,C_RECEIPTCORPID,C_VFREE1,C_VFREE2,C_VFREE3,C_VDEF1)");
cmdText2.Append(" values (");
cmdText2.Append("'" + pk_itemid + "',"); //主键
cmdText2.Append("'" + pk_mainid + "',"); //来源销售主表ID
cmdText2.Append("'" + modOrder.C_NO + "',"); //订单号
cmdText2.Append("'" + modOrder.C_CON_NO + "',"); //合同号
cmdText2.Append("'" + modOrder.C_INVBASDOCID + "',"); //存货档案主键
cmdText2.Append("'" + modOrder.C_INVENTORYID + "',"); //存货管理档案主键
cmdText2.Append("'" + modOrder.C_UNITID + "',"); //主计量单位
cmdText2.Append("'" + modOrder.C_PACKUNITID + "',"); //辅单位
cmdText2.Append("" + modOrder.N_WGT + ","); //数量
cmdText2.Append("to_date('" + modOrder.D_DELIVERY_DT + "','yyyy-mm-dd hh24:mi:ss'),"); //发货日期
cmdText2.Append("to_date('" + modOrder.D_DELIVERY_DT + "','yyyy-mm-dd hh24:mi:ss'),"); //交货日期
cmdText2.Append("'" + modOrder.C_CURRENCYTYPEID + "',"); //货币
cmdText2.Append("" + modOrder.N_TAXRATE + ","); //税率
cmdText2.Append("" + modOrder.N_ORIGINALCURPRICE + ","); //原币无税单价
cmdText2.Append("" + modOrder.N_ORIGINALCURTAXPRICE + ","); //原币含税单价
cmdText2.Append("" + modOrder.N_ORIGINALCURTAXMNY + ","); //原币税额
cmdText2.Append("" + modOrder.N_ORIGINALCURMNY + ","); //原币无税金额
cmdText2.Append("" + modOrder.N_ORIGINALCURSUMMNY + ","); //原币价税合计
cmdText2.Append("'" + modCon.C_CRECEIPTAREAID + "',"); //收货地区
cmdText2.Append("'" + modCon.C_ADDRESS + "',"); //收货地址
cmdText2.Append("'" + modCon.C_CRECEIPTCORPID + "',"); //收货单位
cmdText2.Append("'" + modOrder.C_FREE_TERM + "',"); //自由项1
cmdText2.Append("'" + modOrder.C_FREE_TERM2 + "',"); //自由项2
cmdText2.Append("'" + modOrder.C_PACK + "',"); //包装要求
cmdText2.Append("'" + modOrder.C_VDEF1 + "'"); //质量等级
cmdText2.Append(")");
strSql.Add(cmdText2.ToString());
#endregion
#region //日计划
string dayCode = Dal_RandomNumber.GetDayPlanCode(); //日计划单据号
StringBuilder cmdText3 = new StringBuilder();
cmdText3.Append("insert into TMP_DAYPLAN(");
cmdText3.Append(@"C_PLCODE,
C_PKBILLB,
C_PKBILLH,
C_CONNO,
C_ORDERNO,
C_PKINV,
C_PKASSISTMEASURE,
N_ASSISTNUM,
N_NUM,
N_UNITPRICE,
N_MONEY,
D_PLANDATE,
D_ORDSNDATE,
D_REQUIREDATE,
D_SNDDATE,
C_PKCUST,
C_PKSENDTYPE,
C_PKSALEORG,
C_PKOPERATOR,
C_PKOPRDEPART,
C_PKPLANPERSON,
C_PKAPPRPERSON,
D_APPRDATE,
C_PKARRIVEAREA,
C_DESTADDRESS,
C_RECEIPTCORPID,
C_BIZTYPE,
C_UNITID,
C_VFREE1,
C_VFREE2,
C_VFREE3,
C_VFREE4,
C_SALECODE)");
cmdText3.Append(" values (");
cmdText3.Append("'" + dayCode + "',"); //日计划单据号
cmdText3.Append("'" + pk_itemid + "',"); //来源销售订单子表ID
cmdText3.Append("'" + pk_mainid + "',"); //来源销售订单主表ID
cmdText3.Append("'" + modOrder.C_CON_NO + "',"); //合同号
cmdText3.Append("'" + modOrder.C_NO + "',"); //订单号
cmdText3.Append("'" + modOrder.C_INVENTORYID + "',"); //存货主键
cmdText3.Append("'" + modOrder.C_PACKUNITID + "',"); //辅计量单位ID
cmdText3.Append("" + modOrder.N_FNUM + ","); //辅数量
cmdText3.Append("" + modOrder.N_WGT + ","); //主数量
cmdText3.Append("" + modOrder.N_ORIGINALCURTAXPRICE + ","); //单价
cmdText3.Append("" + modOrder.N_ORIGINALCURSUMMNY + ","); //订单金额
cmdText3.Append("to_date('" + modOrder.D_DT + "','yyyy-mm-dd hh24:mi:ss'),"); //日计划日期
cmdText3.Append("to_date('" + modOrder.D_DELIVERY_DT + "','yyyy-mm-dd hh24:mi:ss'),"); //定单要求发货日期
cmdText3.Append("to_date('" + modOrder.D_DELIVERY_DT + "','yyyy-mm-dd hh24:mi:ss'),"); //定单要求到货日期
cmdText3.Append("to_date('" + modOrder.D_DELIVERY_DT + "','yyyy-mm-dd hh24:mi:ss'),"); //实际发货日期
cmdText3.Append("'" + modOrder.C_RECEIPTCORPID + "',"); //客户ID
cmdText3.Append("'" + modCon.C_TRANSMODEID + "',"); //发运方式ID
cmdText3.Append("'" + modCon.C_SALECORPID + "',"); //销售组织ID
cmdText3.Append("'" + modCon.C_EMPLOYEEID + "',"); //业务员ID
cmdText3.Append("'" + modCon.C_DEPTID + "',"); //业务部门ID
cmdText3.Append("'" + modCon.C_COPERATORID + "',"); //计划人ID
cmdText3.Append("'" + modCon.C_APPROVEID + "',"); //审批人ID
cmdText3.Append("to_date('" + modCon.D_APPROVEDATE + "','yyyy-mm-dd hh24:mi:ss'),"); //审批日期
cmdText3.Append("'" + modCon.C_CRECEIPTAREAID + "',"); //到货地区ID
cmdText3.Append("'" + modCon.C_ADDRESS + "',"); //到货地址
cmdText3.Append("'" + modCon.C_CRECEIPTCUSTOMERID + "',"); //收货单位ID
cmdText3.Append("'" + modCon.C_BIZTYPE + "',"); //业务类型ID
cmdText3.Append("'" + modOrder.C_UNITID + "',"); //计量单位ID
cmdText3.Append("'" + modOrder.C_FREE_TERM + "',"); //自由项1
cmdText3.Append("'" + modOrder.C_FREE_TERM2 + "',"); //自由项2
cmdText3.Append("'" + modOrder.C_PACK + "',"); //包装要求
cmdText3.Append("'" + modOrder.C_VDEF1 + "',"); //质量等级
cmdText3.Append("'" + code + "'"); //销售单据号
cmdText3.Append(")");
strSql.Add(cmdText3);
#endregion
}
}
}
DbHelperOra.ExecuteSqlTran(strSql);
}
return(dt);
}
public AjaxResult OrderAdd([FromBody] dynamic Json)
{
#region //参数
string ConNo = Json.ConNo; //合同号
string MatID = Json.MatID; //物料ID
string TechProt = Json.TechProt; //客户协议号
string StdCode = Json.StdCode; //执行标准
string Pack = Json.Pack; //包装要求
string Wgt = Json.Wgt; //重量
string Price = Json.Price; //含税单价
string VdefID = Json.VdefID; //质量ID
#endregion
#region 数据操作
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
Mod_TS_USER modUser = GetUserID();
Mod_TMO_CON modCon = tmo_con.GetModel(ConNo);
Mod_TB_MATRL_MAIN modMat = tb_matrl_main.GetModel(MatID);
Mod_TS_CUSTFILE modCust = ts_custfile.GetModel(modUser.C_CUST_ID);
Mod_TMO_ORDER modOrder = new Mod_TMO_ORDER();
DataTable dt = tb_matrl_main.GetCustStlGrd(modCust.C_NO, modMat.C_MAT_CODE, modMat.C_STL_GRD, modMat.C_SPEC, TechProt, StdCode).Tables[0];
string order_no = randomnumber.CreateOrderNo(ConNo); //订单号
modOrder.C_ORDER_NO = order_no;
modOrder.C_CON_NO = modCon.C_CON_NO; //合同号
modOrder.C_CON_NAME = modCon.C_CON_NAME; //合同名称
modOrder.C_AREA = modCon.C_AREA; //区域
modOrder.C_INVBASDOCID = modMat.C_PK_INVBASDOC; //存货档案主键
modOrder.C_INVENTORYID = modMat.C_PK_INVMANDOC; //存货管理档案主键
modOrder.C_PROD_NAME = modMat.C_PROD_NAME; //品名
modOrder.C_PROD_KIND = modMat.C_PROD_KIND; //品种
modOrder.C_MAT_CODE = modMat.C_MAT_CODE; //物料编码
modOrder.C_MAT_NAME = modMat.C_MAT_NAME; //物料名称
modOrder.C_SPEC = modMat.C_SPEC; //规格
modOrder.C_STL_GRD = modMat.C_STL_GRD; //钢种
modOrder.C_FUNITID = modMat.C_FJLDW; //辅单位
modOrder.C_UNITID = modMat.C_PK_MEASDOC; //主计量单位
modOrder.D_DELIVERY_DT = modCon.D_CONINVALID_DT; //计划交货日期
modOrder.D_DT = modCon.D_CONSING_DT; //订单日期//签单日期
modOrder.C_VDEF1 = VdefID; //质量主键ID
modOrder.C_SFPJ = "N";
modOrder.C_TECH_PROT = TechProt; //客户协议号
modOrder.C_FREE1 = dt?.Rows[0]["C_ZYX1"].ToString() ?? ""; //自由项1
modOrder.C_FREE2 = dt?.Rows[0]["C_ZYX2"].ToString() ?? ""; //自由项2
modOrder.C_STD_CODE = StdCode; //执行标准
modOrder.C_BY4 = dt?.Rows[0]["C_IS_BXG"].ToString() ?? ""; //是否不锈钢
modOrder.N_TYPE = Convert.ToDecimal(modMat.C_MAT_TYPE); //订单类型
modOrder.C_PACK = Pack;//包装要求
Mod_TMB_TAXITEMS modTaxi = tmb_taxitems.GetModel(modMat.C_PK_TAXITEMS);
modOrder.N_TAXRATE = modTaxi.N_TAXRATIO;//税率
decimal N_WGT = 0;
if (!string.IsNullOrEmpty(Wgt))
{
N_WGT = Convert.ToDecimal(Wgt);
}
modOrder.N_WGT = N_WGT; //数量
modOrder.N_HSL = modMat.N_HSL == null ? 0 : modMat.N_HSL; //换算率
modOrder.N_FNUM = modMat.N_HSL == null ? 1 : N_WGT / modMat.N_HSL; //辅数量
#region //获取钢种单价-税率
if (!string.IsNullOrEmpty(Price))
{
decimal N_TAXRATE = Convert.ToDecimal(modOrder.N_TAXRATE) + 1; //税率
decimal N_ORIGINALCURPRICE = Convert.ToDecimal(Price) / N_TAXRATE; //原币无税单价
decimal N_ORIGINALCURTAXPRICE = Convert.ToDecimal(Price); //原币含税单价
decimal N_ORIGINALCURMNY = decimal.Round(N_WGT * N_ORIGINALCURPRICE, 2); //原币无税金额
decimal N_ORIGINALCURSUMMNY = N_WGT * N_ORIGINALCURTAXPRICE; //原币价税合计
decimal N_ORIGINALCURTAXMNY = decimal.Round(N_ORIGINALCURSUMMNY - N_ORIGINALCURMNY, 2); //原币税额
modOrder.N_ORIGINALCURPRICE = N_ORIGINALCURPRICE; //原币无税单价
modOrder.N_ORIGINALCURTAXPRICE = N_ORIGINALCURTAXPRICE; //原币含税单价
modOrder.N_ORIGINALCURTAXMNY = N_ORIGINALCURTAXMNY; //原币税额
modOrder.N_ORIGINALCURMNY = N_ORIGINALCURMNY; //原币无税金额
modOrder.N_ORIGINALCURSUMMNY = N_ORIGINALCURSUMMNY; //原币价税合计
}
#endregion
modOrder.C_RECEIPTAREAID = modCon.C_CRECEIPTAREAID; //收货地区
modOrder.C_RECEIVEADDRESS = modCon.C_ADDRESS; //收货地址
modOrder.C_RECEIPTCORPID = modCon.C_CRECEIPTCUSTOMERID; //收货单位
modOrder.C_CURRENCYTYPEID = modCon.C_CURRENCYTYPEID; //货币
modOrder.N_USER_LEV = modCon.N_CUST_LEV; //客户等级
modOrder.C_CUST_SQ = modCon.C_REAMRK; //客户要求
modOrder.C_EMP_ID = modCon.C_EMP_ID;
modOrder.C_EMP_NAME = modCon.C_EMP_NAME;
modOrder.C_CUST_NO = modCust.C_NO;
modOrder.C_CUST_NAME = modCust.C_NAME;
modOrder.C_SALE_CHANNEL = "";
modOrder.C_LEV = GetLev("STL_GRD_Lev"); //钢种等级
modOrder.C_ORDER_LEV = GetLev("Order_Lev"); //订单等级
modOrder.N_COST = 0; //成本
modOrder.C_TRANSMODE = modCon.C_TRANSMODEID; //发运方式
modOrder.C_TRANSMODEID = modCon.C_TRANSMODEID; //发运方式主键
modOrder.C_YWY = ts_user.GetSaleName(modCon.C_EMPLOYEEID); //业务员姓名
modOrder.N_STATUS = Convert.ToDecimal(modCon.N_STATUS);
List <Mod_TMO_ORDER> orderList = new List <Mod_TMO_ORDER>();
orderList.Add(modOrder);
result.Result = tmo_con.InsertFirstOrder(orderList) == true ? "提交成功" : "提交失败";
#endregion
return(result);
}
public AjaxResult ConAdd([FromBody] dynamic Json)
{
#region 参数
string ZCCode = Json.ZCCode == null ? "01" : Json.ZCCode; //政策编码
string ConName = Json.ConName; //合同名称
string ConType = Json.ConType; //合同类型ID
string Currency = Json.Currency; //货币类型ID
string ConsingDT = Json.ConsingDT; //签署日期
string ConeffeDT = Json.ConeffeDT; //计划有效日期
string ConinvalidDT = Json.ConinvalidDT; //计划失效日期
string ShipVia = Json.ShipVia; //发运方式ID
string Remark = Json.Remark; //备注
string CGID = Json.CGID; //收货单位
string STATION = Json.STATION; //站点
string SalesEmpID = Json.SalesEmpID; //业务员ID
string Addr = Json.Addr; //收货地址
string OTCID = Json.OTCID; //开票单位
string CustID = Json.CustID; //客户
#endregion
#region //数据操作
AjaxResult result = new AjaxResult();
List <Mod_TMO_ORDER> orderList = new List <Mod_TMO_ORDER>();
DataTable dt = ts_user.GetSaleDept(SalesEmpID).Tables[0];
Mod_TS_USER modUser = GetUserID();
Mod_TMO_CON mod = new Mod_TMO_CON();
string conNo = randomnumber.CreateConNo(ZCCode); //合同号
mod.C_CON_XH = conNo; //合同序号
mod.C_CON_NO = conNo; //合同号
mod.C_CON_NAME = ConName; //合同名称
mod.C_CONTYPEID = ConType; //合同类型ID
mod.C_CURRENCYTYPEID = Currency; //货币类型ID
mod.D_CONSING_DT = Convert.ToDateTime(ConsingDT); //签署日期
mod.D_CONEFFE_DT = Convert.ToDateTime(ConeffeDT); //计划有效日期
mod.D_CONINVALID_DT = Convert.ToDateTime(ConinvalidDT); //计划失效日期
//mod.D_NEED_DT = Convert.ToDateTime(ConinvalidDT).AddDays(-30);//需求日期
mod.C_TRANSMODEID = ShipVia; //发运方式ID
mod.C_AREA = dt.Rows[0]["AREA"].ToString(); //合同区域
mod.C_REAMRK = Remark; //备注
mod.C_CRECEIPTCUSTOMERID = CGID; //收货单位ID
mod.C_CRECEIPTCORPID = OTCID; //开票单位ID
mod.C_STATION = STATION; //站点
mod.C_EMPLOYEEID = SalesEmpID; //业务员ID
mod.C_DEPTID = dt.Rows[0]["C_DEPTID"].ToString(); //业务部门
if (!string.IsNullOrEmpty(CGID))
{
Mod_TS_CUSTFILE modCust = ts_custfile.GetCustModel(CGID);
mod.C_ADDRESS = Addr; //收货地址
mod.C_CRECEIPTAREAID = modCust.C_AREATYPE; //收货地区
}
Mod_TS_CUSTFILE modCustfile = CustID == "" ? ts_custfile.GetModel(modUser.C_CUST_ID) : ts_custfile.GetCustModel(CustID);
mod.C_CUSTOMERID = modCustfile.C_NC_M_ID; //NCID
mod.C_CUSTNAME = modCustfile.C_NAME;
mod.C_CUST_NO = modCustfile.C_NO; //客户编码
mod.C_COPERATORID = SalesEmpID; //制单人
mod.C_EMP_ID = modUser.C_ID;
mod.C_EMP_NAME = modUser.C_NAME;
mod.N_CUST_LEV = modCustfile.N_LEVEL;
mod.N_CHANGENUM = 0;//变更次数默认0
if (tmo_con.InsertConOrder(mod, orderList))
{
result.Code = DoResult.Success;
result.Result = conNo;
}
else
{
result.Code = DoResult.Failed;
result.Result = "提交失败";
}
#endregion
return(result);
}
public AjaxResult ConEdit([FromBody] dynamic Json)
{
#region //参数
string ConNo = Json.ConNo; //合同号
string ConName = Json.ConName; //合同名称
string ConType = Json.ConType; //合同类型ID
string Currency = Json.Currency; //货币类型ID
string ConsingDT = Json.ConsingDT; //签署日期
string ConeffeDT = Json.ConeffeDT; //计划有效日期
string ConinvalidDT = Json.ConinvalidDT; //计划失效日期
string ShipVia = Json.ShipVia; //发运方式ID
string Remark = Json.Remark; //备注
string CGCID = Json.CGCID; //收货单位ID
string STATION = Json.STATION; //站点
string SalesEmpID = Json.SalesEmpID; //业务员ID
string Addr = Json.Addr; //收货地址
string OTCID = Json.OTCID; //开票单位
#endregion
#region //数据操作
AjaxResult result = new AjaxResult();
if (!string.IsNullOrEmpty(ConNo))
{
List <Mod_TMO_ORDER> orderList = new List <Mod_TMO_ORDER>();
DataTable dt = ts_user.GetSaleDept(SalesEmpID).Tables[0];
Mod_TMO_CON mod = tmo_con.GetModel(ConNo);
mod.C_CON_NAME = ConName; //合同名称
mod.C_CONTYPEID = ConType; //合同类型
mod.C_CURRENCYTYPEID = Currency; //货币类型ID
mod.D_CONSING_DT = Convert.ToDateTime(ConsingDT); //签署日期
mod.D_CONEFFE_DT = Convert.ToDateTime(ConeffeDT); //计划有效日期
mod.D_CONINVALID_DT = Convert.ToDateTime(ConinvalidDT); //计划失效日期
mod.C_TRANSMODEID = ShipVia; //发运方式ID
mod.C_AREA = dt.Rows[0]["AREA"].ToString(); //合同区域
mod.C_CRECEIPTCUSTOMERID = CGCID; //收货单位
mod.C_CRECEIPTCORPID = OTCID; //开票单位
mod.C_STATION = STATION; //站点
mod.C_EMPLOYEEID = SalesEmpID; //业务员
mod.C_DEPTID = dt.Rows[0]["C_DEPTID"].ToString(); //业务部门
mod.C_REAMRK = Remark; //备注
mod.N_CHANGENUM = 0; //合同变更次数
if (!string.IsNullOrEmpty(CGCID))
{
Mod_TS_CUSTFILE modCust = ts_custfile.GetCustModel(CGCID);
mod.C_CRECEIPTCUSTOMERID = CGCID; //收货单位
mod.C_ADDRESS = Addr; //收货地址
mod.C_CRECEIPTAREAID = modCust.C_AREATYPE; //收货地区
}
if (tmo_con.UpdateConOrder(mod, orderList))
{
result.Code = DoResult.Success;
result.Result = "编辑成功";
}
else
{
result.Code = DoResult.Failed;
result.Result = "编辑失败";
}
}
else
{
result.Code = DoResult.Failed;
result.Result = "编辑失败";
}
#endregion
return(result);
}
/// <summary>
/// NC销售合同接口
/// </summary>
/// <param name="con">合同号</param>
/// <param name="xmlFileName">文件名/路径</param>
/// <param name="empID">操作人ID</param>
/// <returns></returns>
public List <string> SendXmlOrder(string con, string xmlFileName, string empID)
{
try
{
Mod_TMO_CON modCon = tmo_con.GetModel(con);
Mod_TMB_FLOWINFO modFlow = tmb_flowinfo.GetModel(modCon.C_FLOWID);
XmlDocument xmlDoc = new XmlDocument();
//创建类型声明节点
XmlNode node = xmlDoc.CreateXmlDeclaration("1.0", "UTF-8", "no");
xmlDoc.AppendChild(node);
//创建根节点
XmlElement root = xmlDoc.CreateElement("ufinterface");
#region//给节点属性赋值
root.SetAttribute("account", "1");
root.SetAttribute("billtype", "CTEXT");
root.SetAttribute("filename", "");
root.SetAttribute("isexchange", "Y");
root.SetAttribute("proc", "add");
root.SetAttribute("receiver", "101");
root.SetAttribute("replace", "Y");
root.SetAttribute("roottag", "bill");
root.SetAttribute("sender", "1107");
root.SetAttribute("subbilltype", "");
#endregion
xmlDoc.AppendChild(root);
//创建子根节点
XmlElement so_order = xmlDoc.CreateElement("bill");
#region //节点属性
so_order.SetAttribute("id", con); //主键
#endregion
root.AppendChild(so_order);
XmlNode head = xmlDoc.CreateNode(XmlNodeType.Element, "bill_head", null);
#region //表头_bill_head
CreateNode(xmlDoc, head, "actualinvalidate", Convert.ToDateTime(modCon.D_CONINVALID_DT).ToString("yyy-MM-dd")); //实际终止日期
CreateNode(xmlDoc, head, "actualvalidate", Convert.ToDateTime(modCon.D_CONEFFE_DT).ToString("yyy-MM-dd")); //实际生效日期
CreateNode(xmlDoc, head, "audiid", modCon.C_APPROVEID); //审核人
CreateNode(xmlDoc, head, "auditdate", Convert.ToDateTime(modCon.D_APPROVEDATE).ToString("yyy-MM-dd")); //审核日期
CreateNode(xmlDoc, head, "bsc", "N"); //是否委外---****
CreateNode(xmlDoc, head, "ct_code", modCon.C_CON_NO); //合同编码
CreateNode(xmlDoc, head, "ct_name", modCon.C_CON_NAME); //合同名称
CreateNode(xmlDoc, head, "ctflag", modCon.N_STATUS.ToString()); //合同状态
CreateNode(xmlDoc, head, "currid", modCon.C_CURRENCYTYPEID); //币种
CreateNode(xmlDoc, head, "currrate", "1"); //折本汇率
CreateNode(xmlDoc, head, "custid", modCon.C_CUSTOMERID); //客商
CreateNode(xmlDoc, head, "custunit", ""); //对方单位说明
CreateNode(xmlDoc, head, "depid", modCon.C_DEPTID); //部门1001NC100000008KOR85
CreateNode(xmlDoc, head, "ifearly", "N"); //是否期初
CreateNode(xmlDoc, head, "invallidate", Convert.ToDateTime(modCon.D_CONINVALID_DT).ToString("yyy-MM-dd")); //计划失效日期
CreateNode(xmlDoc, head, "iprintcount", "0"); //计划失效日期
CreateNode(xmlDoc, head, "operdate", Convert.ToDateTime(modCon.D_DMAKEDATE).ToString("yyy-MM-dd")); //制单日期
CreateNode(xmlDoc, head, "operid", modCon.C_COPERATORID); //制单人1006AA1000000000NI7B
CreateNode(xmlDoc, head, "payterm", ""); //收付款协议
CreateNode(xmlDoc, head, "personnelid", modCon.C_EMPLOYEEID); //人员(业务员ID)1001NC10000000000TD8
CreateNode(xmlDoc, head, "pk_corp", modCon.C_XGID); //公司
CreateNode(xmlDoc, head, "pk_ct_manage", modCon.C_CON_NO); //合同主键
CreateNode(xmlDoc, head, "pk_ct_type", modCon.C_CONTYPEID); //类型定义主键
CreateNode(xmlDoc, head, "projectid", ""); //项目号
CreateNode(xmlDoc, head, "subscribedate", Convert.ToDateTime(modCon.D_CONSING_DT).ToString("yyy-MM-dd")); //合同签订日期
CreateNode(xmlDoc, head, "valdate", Convert.ToDateTime(modCon.D_CONEFFE_DT).ToString("yyy-MM-dd")); //计划生效日期
CreateNode(xmlDoc, head, "activeflag", "0"); //激活状态
CreateNode(xmlDoc, head, "clastoperatorid", modCon.C_EDITEMPLOYEEID); //最后修改人
CreateNode(xmlDoc, head, "astcurrate", ""); //折辅汇率
CreateNode(xmlDoc, head, "nprepaylimitmny", ""); //预付款限额
CreateNode(xmlDoc, head, "nprepaymny", ""); //预付款
CreateNode(xmlDoc, head, "taudittime", Convert.ToDateTime(modCon.D_APPROVEDATE).ToString("yyy-MM-dd HH:mm:ss")); //审批时间
CreateNode(xmlDoc, head, "tlastmaketime", Convert.ToDateTime(modCon.D_EDITDATE).ToString("yyy-MM-dd HH:mm:ss")); //最后修改时间
CreateNode(xmlDoc, head, "tmaketime", Convert.ToDateTime(modCon.D_DMAKEDATE).ToString("yyy-MM-dd HH:mm:ss")); //制单时间
CreateNode(xmlDoc, head, "def1", ""); //自定义项1
CreateNode(xmlDoc, head, "def2", modFlow.C_NAME); //审批流程名称（日常合同）
CreateNode(xmlDoc, head, "def3", ""); //自定义项3
CreateNode(xmlDoc, head, "def4", ""); //自定义项4
CreateNode(xmlDoc, head, "def5", modCon.C_CON_NO); //自定义项5-合同表头主键
CreateNode(xmlDoc, head, "pk_defdoc1", modCon.C_REAMRK); // 合同说明信息
CreateNode(xmlDoc, head, "pk_defdoc2", ""); // 审批流主键
CreateNode(xmlDoc, head, "pk_defdoc3", ""); // 自定义项主键3
CreateNode(xmlDoc, head, "pk_defdoc4", ""); // 自定义项主键4
CreateNode(xmlDoc, head, "pk_defdoc5", GetUserName(modCon.C_EMPLOYEEID)); // 自定义项主键5-业务员姓名
CreateNode(xmlDoc, head, "transpmode", modCon.C_TRANSMODEID); // 发运方式
#endregion
so_order.AppendChild(head);
XmlElement body = xmlDoc.CreateElement("bill_body");
so_order.AppendChild(body);
DataTable dt = tmo_order.GetList(" C_CON_NO='" + con + "'").Tables[0];
for (int j = 0; j < dt.Rows.Count; j++)
{
int rowno = j + 1;
Mod_TMO_ORDER modOrder = tmo_order.GetModel(dt.Rows[j]["C_ID"].ToString());
if (modOrder != null)
{
XmlNode entry = xmlDoc.CreateNode(XmlNodeType.Element, "item", null);
#region //表体_item
CreateNode(xmlDoc, entry, "amount", modOrder.N_WGT.ToString()); //数量
CreateNode(xmlDoc, entry, "invclid", ""); //存货分类
CreateNode(xmlDoc, entry, "invid", modOrder.C_INVENTORYID); //存货管理档案主键
CreateNode(xmlDoc, entry, "measid", modOrder.C_UNITID); //主计量单位
CreateNode(xmlDoc, entry, "natiprice", modOrder.N_ORIGINALCURPRICE.ToString()); //本币无税单价
CreateNode(xmlDoc, entry, "natisum", modOrder.N_ORIGINALCURMNY.ToString()); //本币无税金额
CreateNode(xmlDoc, entry, "natitaxmny", modOrder.N_ORIGINALCURTAXMNY.ToString()); //本币税额
CreateNode(xmlDoc, entry, "natitaxprice", modOrder.N_ORIGINALCURTAXPRICE.ToString()); //本币含税单价
CreateNode(xmlDoc, entry, "natitaxsummny", modOrder.N_ORIGINALCURSUMMNY.ToString()); //本币价税合计
CreateNode(xmlDoc, entry, "ordnum", ""); //订单执行累计数量
CreateNode(xmlDoc, entry, "ordprice", ""); //订单执行累计含税单价
CreateNode(xmlDoc, entry, "ordsum", ""); //订单执行累计本币价税合计
CreateNode(xmlDoc, entry, "oriprice", modOrder.N_ORIGINALCURPRICE.ToString()); //原币无税单价
CreateNode(xmlDoc, entry, "orisum", modOrder.N_ORIGINALCURMNY.ToString()); //原币无税金额
CreateNode(xmlDoc, entry, "oritaxmny", modOrder.N_ORIGINALCURTAXMNY.ToString()); //原币税额
CreateNode(xmlDoc, entry, "oritaxprice", modOrder.N_ORIGINALCURTAXPRICE.ToString()); //原币含税单价
CreateNode(xmlDoc, entry, "oritaxsummny", modOrder.N_ORIGINALCURSUMMNY.ToString()); //原币价税合计
CreateNode(xmlDoc, entry, "pk_corp", modOrder.C_XGID); //公司
CreateNode(xmlDoc, entry, "pk_ct_manage", ""); //合同主键
CreateNode(xmlDoc, entry, "pk_ct_manage_b", ""); //表体主键
CreateNode(xmlDoc, entry, "taxration", modOrder.N_TAXRATE.ToString()); //税率
CreateNode(xmlDoc, entry, "astmeasid", modOrder.C_FUNITID); //辅计量单位
CreateNode(xmlDoc, entry, "astnum", modOrder.N_FNUM.ToString()); //辅数量
CreateNode(xmlDoc, entry, "astprice", ""); //辅币无税单价
CreateNode(xmlDoc, entry, "astsum", ""); //辅币无税金额
CreateNode(xmlDoc, entry, "asttaxmny", ""); //辅币税额
CreateNode(xmlDoc, entry, "asttaxprice", ""); //辅币含税单价
CreateNode(xmlDoc, entry, "asttaxsummny", ""); //辅币价税合计
CreateNode(xmlDoc, entry, "cqpbaseschemeid", ""); //优质优价方案
CreateNode(xmlDoc, entry, "crowno", rowno.ToString()); //行号
CreateNode(xmlDoc, entry, "transrate", modOrder.N_HSL.ToString()); //主辅计量换算率
CreateNode(xmlDoc, entry, "vbatchcode", ""); //批次号
CreateNode(xmlDoc, entry, "def1", ""); //自定义项1
CreateNode(xmlDoc, entry, "def2", ""); //自定义项2
CreateNode(xmlDoc, entry, "def3", ""); //自定义项3
CreateNode(xmlDoc, entry, "def4", modOrder.C_PRO_USE); //自定义项4产品用途
CreateNode(xmlDoc, entry, "def5", ""); //自定义项5
CreateNode(xmlDoc, entry, "def6", ""); //自定义项6
CreateNode(xmlDoc, entry, "def7", ""); //自定义项7
CreateNode(xmlDoc, entry, "def8", ""); //自定义项8
CreateNode(xmlDoc, entry, "def9", ""); //自定义项9
CreateNode(xmlDoc, entry, "def10", modOrder.C_ID); //合同表体主键
CreateNode(xmlDoc, entry, "pk_defdoc1", ""); //自定义项主键1
CreateNode(xmlDoc, entry, "pk_defdoc2", ""); //自定义项主键2
CreateNode(xmlDoc, entry, "pk_defdoc3", ""); //自定义项主键3
CreateNode(xmlDoc, entry, "pk_defdoc4", ""); //自定义项主键4
CreateNode(xmlDoc, entry, "pk_defdoc5", ""); //自定义项主键5
CreateNode(xmlDoc, entry, "pk_defdoc6", ""); //自定义项主键6
CreateNode(xmlDoc, entry, "pk_defdoc7", ""); //自定义项主键7
CreateNode(xmlDoc, entry, "pk_defdoc8", ""); //自定义项主键8
CreateNode(xmlDoc, entry, "pk_defdoc9", ""); //自定义项主键9
CreateNode(xmlDoc, entry, "pk_defdoc10", ""); //自定义项主键10
CreateNode(xmlDoc, entry, "pk_defdoc11", ""); //自定义项主键11
CreateNode(xmlDoc, entry, "pk_defdoc12", ""); //自定义项主键12
CreateNode(xmlDoc, entry, "pk_defdoc13", ""); //自定义项主键13
CreateNode(xmlDoc, entry, "pk_defdoc14", ""); //自定义项主键14
CreateNode(xmlDoc, entry, "pk_defdoc15", ""); //自定义项主键15
CreateNode(xmlDoc, entry, "pk_defdoc16", modOrder.C_SPEC); //规格
CreateNode(xmlDoc, entry, "pk_defdoc17", modOrder.C_STL_GRD); //钢种
CreateNode(xmlDoc, entry, "pk_defdoc18", ""); //自定义项主键18
CreateNode(xmlDoc, entry, "pk_defdoc19", ""); //自定义项主键19
CreateNode(xmlDoc, entry, "pk_defdoc20", ""); //自定义项主键20
CreateNode(xmlDoc, entry, "vfree1", modOrder.C_FREE1); //自由项1
CreateNode(xmlDoc, entry, "vfree2", modOrder.C_FREE2); //自由项2
CreateNode(xmlDoc, entry, "vfree3", modOrder.C_PACK); //自由项3
CreateNode(xmlDoc, entry, "vfree4", ""); //自由项4
CreateNode(xmlDoc, entry, "vfree5", ""); //自由项5
CreateNode(xmlDoc, entry, "creceiptcorpid", modOrder.C_RECEIPTCORPID); //收货单位
CreateNode(xmlDoc, entry, "vreceiveaddress", modOrder.C_RECEIVEADDRESS); //收货地址
CreateNode(xmlDoc, entry, "delivdate", Convert.ToDateTime(modOrder.D_DELIVERY_DT).ToString("yyy-MM-dd")); //计划收发货日期
CreateNode(xmlDoc, entry, "creceiptareaid", modOrder.C_RECEIPTAREAID); //收货地区ID
#endregion
body.AppendChild(entry);
}
}
xmlDoc.Save(xmlFileName);
List <string> parem = NCSendXml.SendXML(xmlDoc); //发送NC
parem.Add(con); //合同号
parem.Add(empID);
parem.Add("销售合同-NC");
parem.Add(parem[0] == "1" ? "导入NC成功" : "导入NC失败");
//日志录入
AddLog(parem);
return(parem);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 加载合同信息
/// </summary>
private void GetConInfo()
{
if (!string.IsNullOrEmpty(hidconno.Value))
{
Mod_TMO_CON modcon = tmo_con.GetModel(hidconno.Value);
if (modcon != null)
{
#region //是否合同变更
if (!string.IsNullOrEmpty(modcon.C_CON_NO_OLD))
{
hidycon.Value = modcon.C_CON_NO_OLD; //原合同号
hidycondlxwgt.Value = tmo_order.GetConSumWgt(modcon.C_CON_NO_OLD); //原合同待履行量
#region //变更合同量控制
DataTable dtfywgt = GetData("DM002");
if (dtfywgt.Rows.Count > 0)
{
decimal num = 0;
if (!string.IsNullOrEmpty(dtfywgt.Rows[0]["C_DETAILCODE"].ToString()))
{
num = Convert.ToDecimal(dtfywgt.Rows[0]["C_DETAILCODE"].ToString());
decimal fywgt = Convert.ToDecimal(hidycondlxwgt.Value);
decimal fd = fywgt * num;
hidsf.Value = Convert.ToString(fywgt + fd); //上幅数
hidxf.Value = Convert.ToString(fywgt - fd); //下幅数
hidmsg.Value = dtfywgt.Rows[0]["C_DETAILNAME"].ToString();
}
}
#endregion
}
#endregion
txtConNO.Value = modcon.C_CON_NO;
ltlcon_bgNo.Text = modcon.N_CHANGENUM.ToString();
Mod_TS_CUSTFILE modCust = ts_custfile.GetCustModel(modcon.C_CUSTOMERID);
ltlCustNo.Text = modCust?.C_NO ?? "";
ltlN_CON_STATUS.Text = modcon.N_STATUS.ToString();
hidstatus.Value = modcon.N_STATUS.ToString();
#region //根据合同状态显示按钮
switch (modcon.N_STATUS.ToString())
{
case "0": //待审
btnSave.Enabled = true; //保存
btnAdd.Disabled = false; //产品
btnCheck.Enabled = true; //送审
btnSX.Enabled = false; //生效
btndj.Enabled = true; //冻结
btnjd.Enabled = !btndj.Enabled; //解冻
btnzz.Enabled = true; //终止
btnqs.Enabled = false; //弃审
btncondel.Enabled = true; //合同删除
btncancel.Enabled = true; //撤回客户
btnAdd_TWC.Disabled = false; //头尾材
btnPrice.Enabled = true;
break;
case "1": //审核中
btnSave.Enabled = false; //保存
btnAdd.Disabled = true; //产品
btnCheck.Enabled = false; //送审
btnSX.Enabled = false; //生效
btndj.Enabled = false; //冻结
btnjd.Enabled = false; //解冻
btnzz.Enabled = false; //终止
btnqs.Enabled = false; //弃审
btncondel.Enabled = false; //合同删除
btncancel.Enabled = false; //撤回客户
btnAdd_TWC.Disabled = true; //头尾材
btnPrice.Enabled = false;
break;
case "4": // 审核通过
btnSave.Enabled = false; //保存
btnAdd.Disabled = true; //产品
btnCheck.Enabled = false; //送审
btnSX.Enabled = true; //生效
btndj.Enabled = true; //冻结
btnjd.Enabled = !btndj.Enabled; //解冻
btnzz.Enabled = true; //终止
btnqs.Enabled = true; //弃审
btncondel.Enabled = false; //合同删除
btncancel.Enabled = false; //撤回客户
btnAdd_TWC.Disabled = true; //头尾材
btnPrice.Enabled = false;
break;
case "2": //生效
btnSave.Enabled = false; //保存
btnAdd.Disabled = true; //产品
btnCheck.Enabled = false; //送审
btnSX.Enabled = false; //生效
btndj.Enabled = true; //冻结
btnjd.Enabled = !btndj.Enabled; //解冻
btnzz.Enabled = true; //终止
btnqs.Enabled = false; //弃审
btncondel.Enabled = false; //合同删除
btncancel.Enabled = false; //撤回客户
btnAdd_TWC.Disabled = true; //头尾材
btnPrice.Enabled = false;
break;
case "5": // 冻结
btnSave.Enabled = false; //保存
btnAdd.Disabled = true; //产品
btnCheck.Enabled = false; //送审
btnSX.Enabled = false; //生效
btndj.Enabled = false; //冻结
btnjd.Enabled = !btndj.Enabled; //解冻
btnzz.Enabled = false; //终止
btnqs.Enabled = false; //弃审
btncondel.Enabled = false; //合同删除
btncancel.Enabled = false; //撤回客户
btnAdd_TWC.Disabled = true; //头尾材
btnPrice.Enabled = false;
break;
case "6": // 终止
btnSave.Enabled = false; //保存
btnAdd.Disabled = true; //产品
btnCheck.Enabled = false; //送审
btnSX.Enabled = false; //生效
btndj.Enabled = false; //冻结
btnjd.Enabled = false; //解冻
btnzz.Enabled = false; //终止
btnqs.Enabled = false; //弃审
btncondel.Enabled = false; //合同删除
btncancel.Enabled = false; //撤回客户
btnAdd_TWC.Disabled = true; //头尾材
btnPrice.Enabled = false;
break;
}
#endregion
txtConName.Value = modcon.C_CON_NAME;
txtCustName.Value = modcon.C_CUSTNAME;
txtQianDanDT.Value = Convert.ToDateTime(modcon.D_CONSING_DT).ToString("yyy-MM-dd");
txtPlanStartDT.Value = Convert.ToDateTime(modcon.D_CONEFFE_DT).ToString("yyy-MM-dd");
txtPlanEndDT.Value = Convert.ToDateTime(modcon.D_CONINVALID_DT).ToString("yyy-MM-dd");
dropFaYun.SelectedIndex = dropFaYun.Items.IndexOf(dropFaYun.Items.FindByValue(modcon.C_TRANSMODEID)); //发运方式
dropBiZhong.SelectedIndex = dropBiZhong.Items.IndexOf(dropBiZhong.Items.FindByValue(modcon.C_CURRENCYTYPEID)); //货币类型
dropYeWuType.SelectedIndex = dropYeWuType.Items.IndexOf(dropYeWuType.Items.FindByValue(modcon.C_BIZTYPE)); //业务类型
dropConType.SelectedIndex = dropConType.Items.IndexOf(dropConType.Items.FindByValue(modcon.C_CONTYPEID)); //合同类型
dropSale.SelectedIndex = dropSale.Items.IndexOf(dropSale.Items.FindByValue(modcon.C_SALECORPID)); //销售组织
dropClass.SelectedIndex = dropClass.Items.IndexOf(dropClass.Items.FindByValue(modcon.N_FLAG));
#region//收货地址
DataTable dtaddr = ts_custaddr.GetAddr("", "", modcon.C_CUSTOMERID, "", "").Tables[0];
if (dtaddr.Rows.Count > 0)
{
dropAddr.DataSource = dtaddr;
dropAddr.DataTextField = "C_CGAREA";
dropAddr.DataValueField = "C_CGAREA";
dropAddr.DataBind();
dropAddr.SelectedIndex = dropAddr.Items.IndexOf(dropAddr.Items.FindByText(modcon.C_ADDRESS));
}
#endregion
#region //部门
Mod_TS_DEPT modDept = ts_dept.GetModel(modcon.C_DEPTID);
if (modDept != null)
{
txtDept.Value = modDept.C_NAME;
hidC_DEPT_ID.Value = modcon.C_DEPTID;
}
#endregion
#region //业务员
txtSaleUser.Value = ts_user.GetSaleName(modcon.C_EMPLOYEEID);
hidC_SALESMAN.Value = modcon.C_EMPLOYEEID;
#endregion
txtShuoHuoCompany.Value = GetCust(modcon.C_CRECEIPTCUSTOMERID);
hidC_CGID.Value = modcon.C_CRECEIPTCUSTOMERID ?? "";
txtKaiPiaoCompany.Value = GetCust(modcon.C_CRECEIPTCORPID);
hidC_OTCID.Value = modcon.C_CRECEIPTCORPID ?? "";
txtC_STATION.Value = modcon.C_STATION;
txtState.Value = StringFormat.GetOrderState(modcon.N_STATUS);
txtDESC.Value = modcon.C_REAMRK;
txtZhiDanRen.Value = GetUserName(modcon.C_COPERATORID);
txtZhiDanTime.Value = modcon.D_DMAKEDATE.ToString();
#region //最后修改人/最后修改时间
txtLastEditUser.Value = GetUserName(modcon.C_EDITEMPLOYEEID);
txtLastEditTime.Value = modcon.D_EDITDATE.ToString();
#endregion
#region//审批流程
txtC_APPROVEID.Value = GetUserName(modcon.C_APPROVEID);
txtD_APPROVEDATE.Value = modcon.D_APPROVEDATE.ToString();
if (!string.IsNullOrEmpty(modcon.C_FLOWID))
{
string url = "FlowStep_View.aspx?taskID=" + hidconno.Value + "&flowID=" + modcon.C_FLOWID;
Mod_TMB_FLOWINFO modFlow = tmb_flowinfo.GetModel(modcon.C_FLOWID);
ltlC_APPROVER_FLOW.Text = "<a href=\"javascript: void(0); \" class='flow' onclick=\"_iframe('" + url + "','500','400','审批记录');\">" + modFlow?.C_NAME + " <span class=\"glyphicon glyphicon-search\"></span></a>";
}
#endregion
GetOrderList();
}
}
}
private bool InsertOrder()
{
List <Mod_TMO_ORDER> orderList = new List <Mod_TMO_ORDER>();
if (Session["kh"] != null)
{
DataTable dt = (DataTable)Session["kh"];
for (int i = 0; i < dt.Rows.Count; i++)
{
#region 数据操作
Mod_TS_USER modUser = ts_user.GetModel(ltlC_EMP_ID.Text);
Mod_TMO_CON modCon = tmo_con.GetModel(txtConNO.Text);
Mod_TB_MATRL_MAIN modMat = tb_matrl_main.GetModel(dt.Rows[i]["C_ID"].ToString());
Mod_TS_CUSTFILE modCust = ts_custfile.GetModel(modUser.C_CUST_ID);
Mod_TMO_ORDER modOrder = new Mod_TMO_ORDER();
string order_no = randomnumber.CreateOrderNo(txtConNO.Text); //订单号
modOrder.C_ORDER_NO = order_no;
modOrder.C_CON_NO = txtConNO.Text; //合同号
modOrder.C_CON_NAME = modCon.C_CON_NAME; //合同名称
modOrder.C_AREA = modCon.C_AREA; //区域
modOrder.C_INVBASDOCID = modMat.C_PK_INVBASDOC; //存货档案主键
modOrder.C_INVENTORYID = modMat.C_PK_INVMANDOC; //存货管理档案主键
modOrder.C_PROD_NAME = modMat.C_PROD_NAME; //品名
modOrder.C_PROD_KIND = modMat.C_PROD_KIND; //品种
modOrder.C_MAT_CODE = modMat.C_MAT_CODE; //物料编码
modOrder.C_MAT_NAME = modMat.C_MAT_NAME; //物料名称
modOrder.C_SPEC = modMat.C_SPEC; //规格
modOrder.C_STL_GRD = modMat.C_MAT_TYPE == "841" ? modMat.C_MAT_NAME : modMat.C_MAT_TYPE == "851" ? modMat.C_MAT_NAME : modMat.C_STL_GRD; //钢种
modOrder.C_FUNITID = modMat.C_FJLDW; //辅单位
modOrder.C_UNITID = modMat.C_PK_MEASDOC; //主计量单位
modOrder.D_DELIVERY_DT = modCon.D_CONINVALID_DT; //计划收货日期
modOrder.D_DT = modCon.D_CONSING_DT; //订单日期//签单日期
modOrder.C_VDEF1 = ""; //质量ID
modOrder.C_SFPJ = "N";
modOrder.C_TECH_PROT = dt.Rows[i]["C_CUST_TECH_PROT"].ToString(); //客户协议号
modOrder.C_STD_CODE = dt.Rows[i]["C_STD_CODE"].ToString(); //执行标准
modOrder.C_FREE1 = dt.Rows[i]["ZYX1"].ToString(); //自由项1
modOrder.C_FREE2 = dt.Rows[i]["ZYX2"].ToString(); //自由项2
modOrder.C_BY4 = dt.Rows[i]["C_BY4"].ToString(); //是否不锈钢
modOrder.N_TYPE = Convert.ToDecimal(modMat.C_MAT_TYPE);
modOrder.C_PACK = dt.Rows[i]["C_PACK"].ToString(); //包装要求
modOrder.C_RECEIPTAREAID = modCon.C_CRECEIPTAREAID; //收货地区
modOrder.C_RECEIVEADDRESS = modCon.C_ADDRESS; //收货地址
modOrder.C_RECEIPTCORPID = modCon.C_CRECEIPTCUSTOMERID; //收货单位
modOrder.C_CURRENCYTYPEID = modCon.C_CURRENCYTYPEID; //货币
modOrder.N_TYPE = Convert.ToDecimal(modMat.C_MAT_TYPE);
modOrder.N_USER_LEV = modCon.N_CUST_LEV; //客户等级
modOrder.C_REMARK = modCon.C_REAMRK;
modOrder.C_EMP_ID = modUser.C_ID;
modOrder.C_EMP_NAME = modUser.C_EMP_NAME;
modOrder.C_CUST_NO = modCust.C_NO;
modOrder.C_CUST_NAME = modCust.C_NAME;
modOrder.C_SALE_CHANNEL = modCust.N_TYPE == 1 ? "经销" : "直销";
modOrder.C_LEV = GetLev("STL_GRD_Lev"); //钢种等级
modOrder.C_ORDER_LEV = GetLev("Order_Lev"); //订单等级
modOrder.N_COST = 0; //成本
modOrder.N_STATUS = -1; //订单状态
decimal N_WGT = 0;
if (!string.IsNullOrEmpty(dt.Rows[i]["N_WGT"].ToString()))
{
N_WGT = Convert.ToDecimal(dt.Rows[i]["N_WGT"].ToString());
}
modOrder.N_WGT = N_WGT; //数量
modOrder.N_HSL = modMat.N_HSL == null ? 0 : modMat.N_HSL; //换算率
modOrder.N_FNUM = modMat.N_HSL == null ? 1 : N_WGT / modMat.N_HSL; //辅数量
if (!string.IsNullOrEmpty(modMat.C_PK_TAXITEMS))
{
Mod_TMB_TAXITEMS modTaxi = tmb_taxitems.GetModel(modMat.C_PK_TAXITEMS);
modOrder.N_TAXRATE = modTaxi.N_TAXRATIO; //税率
#region //获取钢种单价-税率
string Price = dt.Rows[i]["PRICE"].ToString().ToString() == "" ? "0" : dt.Rows[i]["PRICE"].ToString().ToString(); //单价
if (!string.IsNullOrEmpty(Price))
{
decimal N_TAXRATE = Convert.ToDecimal(modOrder.N_TAXRATE) + 1; //税率
decimal N_ORIGINALCURPRICE = decimal.Round(Convert.ToDecimal(Price) / N_TAXRATE, 2); //原币无税单价
decimal N_ORIGINALCURTAXPRICE = Convert.ToDecimal(Price); //原币含税单价
decimal N_ORIGINALCURMNY = N_WGT * N_ORIGINALCURPRICE; //原币无税金额
decimal N_ORIGINALCURSUMMNY = N_WGT * N_ORIGINALCURTAXPRICE; //原币价税合计
decimal N_ORIGINALCURTAXMNY = N_ORIGINALCURSUMMNY - N_ORIGINALCURMNY; //原币税额
modOrder.N_ORIGINALCURPRICE = N_ORIGINALCURPRICE; //原币无税单价
modOrder.N_ORIGINALCURTAXPRICE = N_ORIGINALCURTAXPRICE; //原币含税单价
modOrder.N_ORIGINALCURTAXMNY = N_ORIGINALCURTAXMNY; //原币税额
modOrder.N_ORIGINALCURMNY = N_ORIGINALCURMNY; //原币无税金额
modOrder.N_ORIGINALCURSUMMNY = N_ORIGINALCURSUMMNY; //原币价税合计
}
#endregion
}
orderList.Add(modOrder);
#endregion
}
}
return(tmo_con.InsertFirstOrder(orderList));
}
public AjaxResult OrderEdit([FromBody] dynamic Json)
{
#region //参数
string OrderNO = Json.OrderNO; //订单号
string Pack = Json.Pack; //包装要求
string Wgt = Json.Wgt; //重量
string Price = Json.Price; //含税单价
string VdefID = Json.VdefID; //质量ID
#endregion
#region 数据操作
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
DataRow drOrder = tmo_order.GetRowOrder(OrderNO, "");
if (drOrder != null)
{
Mod_TS_USER modUser = GetUserID();
Mod_TS_CUSTFILE modCust = ts_custfile.GetModel(modUser.C_CUST_ID);
Mod_TMO_ORDER modOrder = tmo_order.GetModel(drOrder["C_ID"].ToString());
Mod_TMO_CON modCon = tmo_con.GetModel(modOrder.C_CON_NO);
modOrder.C_VDEF1 = VdefID; //质量;
modOrder.C_PACK = Pack; //包装要求
decimal N_WGT = 0;
if (!string.IsNullOrEmpty(Wgt))
{
N_WGT = Convert.ToDecimal(Wgt);
}
modOrder.N_WGT = N_WGT; //数量
modOrder.N_FNUM = N_WGT / modOrder.N_HSL; //数量
#region //获取钢种单价-税率
if (!string.IsNullOrEmpty(Price))
{
decimal N_TAXRATE = Convert.ToDecimal(modOrder.N_TAXRATE) + 1; //税率
decimal N_ORIGINALCURPRICE = decimal.Round(Convert.ToDecimal(Price) / N_TAXRATE, 2); //原币无税单价
decimal N_ORIGINALCURTAXPRICE = Convert.ToDecimal(Price); //原币含税单价
decimal N_ORIGINALCURMNY = N_WGT * N_ORIGINALCURPRICE; //原币无税金额
decimal N_ORIGINALCURSUMMNY = N_WGT * N_ORIGINALCURTAXPRICE; //原币价税合计
decimal N_ORIGINALCURTAXMNY = N_ORIGINALCURSUMMNY - N_ORIGINALCURMNY; //原币税额
modOrder.N_ORIGINALCURPRICE = N_ORIGINALCURPRICE; //原币无税单价
modOrder.N_ORIGINALCURTAXPRICE = N_ORIGINALCURTAXPRICE; //原币含税单价
modOrder.N_ORIGINALCURTAXMNY = N_ORIGINALCURTAXMNY; //原币税额
modOrder.N_ORIGINALCURMNY = N_ORIGINALCURMNY; //原币无税金额
modOrder.N_ORIGINALCURSUMMNY = N_ORIGINALCURSUMMNY; //原币价税合计
}
#endregion
List <Mod_TMO_ORDER> orderList = new List <Mod_TMO_ORDER>();
orderList.Add(modOrder);
result.Result = tmo_con.UpdateConOrder(modCon, orderList) == true ? "修改成功" : "修改失败";
}
else
{
result.Result = "当前暂无修改订单";
}
#endregion
return(result);
}
/// <summary>
/// 加载合同信息
/// </summary>
private void GetConInfo()
{
if (!string.IsNullOrEmpty(txtConNO.Text))
{
Mod_TMO_CON modcon = tmo_con.GetModel(txtConNO.Text);
if (modcon != null)
{
ltlcon_bgNo.Text = modcon.N_CHANGENUM.ToString();//合同版本
Mod_TS_CUSTFILE modCust = ts_custfile.GetCustModel(modcon.C_CUSTOMERID);
hidCustNO.Value = modCust.C_NO;
hidCustID.Value = modcon.C_CUSTOMERID;//客户ID
ltlCustType.Text = modCust.N_TYPE == 1 ? "经销" : "直销";
ltlN_CON_STATUS.Text = modcon.N_STATUS.ToString();
hidstatus.Value = modcon.N_STATUS.ToString(); //当前状态
#region //状态按钮设置
bool boolbtn = ltlN_CON_STATUS.Text == "-1" ? true : false;
btnSave.Enabled = boolbtn;
btnSubmit.Enabled = boolbtn;
btnProc.Disabled = ltlN_CON_STATUS.Text == "-1" ? false : true;
//btnProc_F.Disabled = ltlN_CON_STATUS.Text == "-1" ? false : true;
btnAdd.Disabled = ltlN_CON_STATUS.Text == "-1" ? false : true;
btnConBg.Enabled = ltlN_CON_STATUS.Text == "2" ? true : false;
#endregion
txtConName.Text = modcon.C_CON_NAME;
dropConType.SelectedIndex = dropConType.Items.IndexOf(dropConType.Items.FindByText(modcon.C_CONTYPEID));
txtCustName.Text = modcon.C_CUSTNAME;
if (!string.IsNullOrEmpty(modcon.D_CONSING_DT.ToString()))
{
txtDate.Value = Convert.ToDateTime(modcon.D_CONSING_DT).ToString("yyy-MM-dd");
}
if (!string.IsNullOrEmpty(modcon.D_CONEFFE_DT.ToString()))
{
txtStart.Value = Convert.ToDateTime(modcon.D_CONEFFE_DT).ToString("yyy-MM-dd");
}
if (!string.IsNullOrEmpty(modcon.D_CONINVALID_DT.ToString()))
{
txtEnd.Value = Convert.ToDateTime(modcon.D_CONINVALID_DT).ToString("yyy-MM-dd");
}
dropShipVia.SelectedIndex = dropShipVia.Items.IndexOf(dropShipVia.Items.FindByValue(modcon.C_TRANSMODEID));
dropCurrType.SelectedIndex = dropCurrType.Items.IndexOf(dropCurrType.Items.FindByValue(modcon.C_CURRENCYTYPEID));
txtC_CGC.Value = GetCust(modcon.C_CRECEIPTCUSTOMERID); //收货单位
hidC_CGID.Value = modcon.C_CRECEIPTCUSTOMERID; //收货单位NC主键
txtC_OTC.Value = GetCust(modcon.C_CRECEIPTCORPID); //开票单位
hidC_OTCID.Value = modcon.C_CRECEIPTCORPID; //开票单位NC主键
txtC_STATION.Value = modcon.C_STATION;
#region //业务员
txtSaleUser.Value = ts_user.GetSaleName(modcon.C_EMPLOYEEID);
hidsaleempid.Value = modcon.C_EMPLOYEEID;
hiddeptid.Value = modcon.C_DEPTID;
#endregion
txtReamrk.Value = modcon.C_REAMRK;
txtAddr.Value = modcon.C_ADDRESS;
GetOrderList();
}
}
}
