/// <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);
}
}
}
/// <summary>
/// 获取流程
/// </summary>
/// <returns></returns>
public static string GetFlow(object id)
{
string result = "";
if (!string.IsNullOrEmpty(id.ToString()))
{
Mod_TMB_FLOWINFO mod = tmb_flowinfo.GetModel(id.ToString());
result = mod.C_NAME;
}
return(result);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMB_FLOWINFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TMB_FLOWINFO set ");
strSql.Append("C_NAME=:C_NAME,");
strSql.Append("C_DESC=:C_DESC,");
strSql.Append("N_SORT=:N_SORT,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("C_EMP_NAME=:C_EMP_NAME,");
strSql.Append("D_MOD_DT=:D_MOD_DT");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":N_SORT", OracleDbType.Decimal, 9),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_NAME;
parameters[1].Value = model.C_DESC;
parameters[2].Value = model.N_SORT;
parameters[3].Value = model.C_REMARK;
parameters[4].Value = model.N_STATUS;
parameters[5].Value = model.C_EMP_ID;
parameters[6].Value = model.C_EMP_NAME;
parameters[7].Value = model.D_MOD_DT;
parameters[8].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMB_FLOWINFO DataRowToModel(DataRow row)
{
Mod_TMB_FLOWINFO model = new Mod_TMB_FLOWINFO();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_NAME"] != null)
{
model.C_NAME = row["C_NAME"].ToString();
}
if (row["C_DESC"] != null)
{
model.C_DESC = row["C_DESC"].ToString();
}
if (row["N_SORT"] != null && row["N_SORT"].ToString() != "")
{
model.N_SORT = decimal.Parse(row["N_SORT"].ToString());
}
if (row["C_REMARK"] != null)
{
model.C_REMARK = row["C_REMARK"].ToString();
}
if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "")
{
model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString());
}
if (row["C_EMP_ID"] != null)
{
model.C_EMP_ID = row["C_EMP_ID"].ToString();
}
if (row["C_EMP_NAME"] != null)
{
model.C_EMP_NAME = row["C_EMP_NAME"].ToString();
}
if (row["D_MOD_DT"] != null && row["D_MOD_DT"].ToString() != "")
{
model.D_MOD_DT = DateTime.Parse(row["D_MOD_DT"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMB_FLOWINFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMB_FLOWINFO(");
strSql.Append("C_ID,C_NAME,C_DESC,N_SORT,C_REMARK,N_STATUS,C_EMP_ID,C_EMP_NAME,D_MOD_DT)");
strSql.Append(" values (");
strSql.Append(":C_ID,:C_NAME,:C_DESC,:N_SORT,:C_REMARK,:N_STATUS,:C_EMP_ID,:C_EMP_NAME,:D_MOD_DT)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":N_SORT", OracleDbType.Decimal, 9),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_NAME;
parameters[2].Value = model.C_DESC;
parameters[3].Value = model.N_SORT;
parameters[4].Value = model.C_REMARK;
parameters[5].Value = model.N_STATUS;
parameters[6].Value = model.C_EMP_ID;
parameters[7].Value = model.C_EMP_NAME;
parameters[8].Value = model.D_MOD_DT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMB_FLOWINFO GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_NAME,C_DESC,N_SORT,C_REMARK,N_STATUS,C_EMP_ID,C_EMP_NAME,D_MOD_DT from TMB_FLOWINFO ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TMB_FLOWINFO model = new Mod_TMB_FLOWINFO();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <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();
}
}
}
/// <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>
public bool Update(Mod_TMB_FLOWINFO model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMB_FLOWINFO model)
{
return(dal.Add(model));
}
