/// <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>
/// <param name="id">ID</param>
/// <returns></returns>
public string GetDeptName(object id)
{
string name = string.Empty;
Mod_TS_DEPT mod = ts_dept.GetModel(id.ToString());
if (mod != null)
{
name = mod.C_NAME;
}
return(name);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TS_DEPT DataRowToModel(DataRow row)
{
Mod_TS_DEPT model = new Mod_TS_DEPT();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_PARENT_ID"] != null)
{
model.C_PARENT_ID = row["C_PARENT_ID"].ToString();
}
if (row["C_CODE"] != null)
{
model.C_CODE = row["C_CODE"].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_STATUS"] != null && row["N_STATUS"].ToString() != "")
{
model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString());
}
if (row["C_DEPTH"] != null && row["C_DEPTH"].ToString() != "")
{
model.C_DEPTH = decimal.Parse(row["C_DEPTH"].ToString());
}
if (row["N_DEPTATTR"] != null)
{
model.N_DEPTATTR = row["N_DEPTATTR"].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 Update(Mod_TS_DEPT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TS_DEPT set ");
strSql.Append("C_PARENT_ID=:C_PARENT_ID,");
strSql.Append("C_CODE=:C_CODE,");
strSql.Append("C_NAME=:C_NAME,");
strSql.Append("C_DESC=:C_DESC,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("C_DEPTH=:C_DEPTH,");
strSql.Append("N_DEPTATTR=:N_DEPTATTR,");
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_PARENT_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DESC", OracleDbType.Varchar2, 200),
new OracleParameter(":N_STATUS", OracleDbType.Int16, 1),
new OracleParameter(":C_DEPTH", OracleDbType.Int16, 3),
new OracleParameter(":N_DEPTATTR", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_PARENT_ID;
parameters[1].Value = model.C_CODE;
parameters[2].Value = model.C_NAME;
parameters[3].Value = model.C_DESC;
parameters[4].Value = model.N_STATUS;
parameters[5].Value = model.C_DEPTH;
parameters[6].Value = model.N_DEPTATTR;
parameters[7].Value = model.C_EMP_ID;
parameters[8].Value = model.C_EMP_NAME;
parameters[9].Value = model.D_MOD_DT;
parameters[10].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TS_DEPT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TS_DEPT(");
strSql.Append("C_ID,C_PARENT_ID,C_CODE,C_NAME,C_DESC,N_STATUS,C_DEPTH,N_DEPTATTR,C_EMP_ID,C_EMP_NAME,D_MOD_DT)");
strSql.Append(" values (");
strSql.Append(":C_ID,:C_PARENT_ID,:C_CODE,:C_NAME,:C_DESC,:N_STATUS,:C_DEPTH,:N_DEPTATTR,:C_EMP_ID,:C_EMP_NAME,:D_MOD_DT)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PARENT_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DESC", OracleDbType.Varchar2, 200),
new OracleParameter(":N_STATUS", OracleDbType.Int32, 1),
new OracleParameter(":C_DEPTH", OracleDbType.Int32, 3),
new OracleParameter(":N_DEPTATTR", OracleDbType.Varchar2, 9),
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_PARENT_ID;
parameters[2].Value = model.C_CODE;
parameters[3].Value = model.C_NAME;
parameters[4].Value = model.C_DESC;
parameters[5].Value = model.N_STATUS;
parameters[6].Value = model.C_DEPTH;
parameters[7].Value = model.N_DEPTATTR;
parameters[8].Value = model.C_EMP_ID;
parameters[9].Value = model.C_EMP_NAME;
parameters[10].Value = model.D_MOD_DT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//初始化根目录
protected void btnInit_Click(object sender, EventArgs e)
{
//var BaseUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
//if (BaseUser != null)
{
Mod_TS_DEPT mod = new Mod_TS_DEPT();
mod.C_CODE = "-1";
mod.C_NAME = "总根目录";
mod.C_PARENT_ID = "-1";
mod.C_DEPTH = -1;
//mod.C_EMP_ID = BaseUser.Id;
// mod.C_EMP_NAME = BaseUser.Name;
if (dept.Add(mod))
{
this.ListAll(lfid.Text);
init_tree();
}
}
}
/// <summary>
/// 添加事件
protected void btn_Add_Click(object sender, EventArgs e)
{
int num2 = Convert.ToInt32(ldeph.Text) + 1;
Mod_TS_DEPT mod = new Mod_TS_DEPT();
mod.C_NAME = txt_menu.Text;
mod.C_CODE = txtCode.Text;
mod.C_PARENT_ID = lfid.Text;
mod.C_DEPTH = num2;
if (dept.Add(mod))
{
this.txt_menu.Text = "";
txtCode.Text = "";
this.ListAll(lfid.Text);
init_tree();
}
}
/// <summary>
/// 编辑事件
/// </summary>
protected void grd_menu_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string lmcode = ((TextBox)(grd_menu.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim();
string lmmc = ((TextBox)(grd_menu.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();
Mod_TS_DEPT mod = dept.GetModel(grd_menu.DataKeys[e.RowIndex].Value.ToString());
mod.C_NAME = lmmc;
mod.C_CODE = lmcode;
dept.Update(mod);
this.grd_menu.EditIndex = -1;
this.ListAll(lfid.Text);
init_tree();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TS_DEPT GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_PARENT_ID,C_CODE,C_NAME,C_DESC,N_STATUS,C_DEPTH,N_DEPTATTR,C_EMP_ID,C_EMP_NAME,D_MOD_DT from TS_DEPT ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TS_DEPT model = new Mod_TS_DEPT();
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>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TS_DEPT model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TS_DEPT model)
{
return(dal.Add(model));
}
/// <summary>
/// 发送转库单信息给NC
/// </summary>
/// <param name="xmlFileName">xml完整路径</param>
/// <param name="dh">转库单号</param>
/// <param name="dhid">转库单ID</param>
/// <returns></returns>
public string SendXml_GP4I(string xmlFileName, string dh, string dhid, string C_SLABWH_LOC_CODE, string C_SLABWH_AREA_CODE)
{
try
{
string urlname = "GP4I" + dh + ".XML";//XML名称
string url = xmlFileName + "\\NCXML";
if (!Directory.Exists(url))
{
Directory.CreateDirectory(url);
}
DataTable dt = dal_TSC_SLAB_MAIN.Get_ZK_List_Trans(dh, dhid).Tables[0];
DataRow dr = null;
if (dt.Rows.Count > 0)
{
dr = dt.Rows[0];
}
if (dr == null)
{
return("调拨失败");
}
Mod_TB_MATRL_MAIN mod_TB_MATRL_MAIN = dal_TB_MATRL_MAIN.GetModel(dr["C_MAT_CODE"].ToString());
Mod_TPB_SLABWH yck = dal_TPB_SLABWH.GetModel_Interface_Trans(dr["C_STOCK_CODE"].ToString()); //源仓库
Mod_TPB_SLABWH mbck = dal_TPB_SLABWH.GetModel_Interface_Trans(dr["C_STOCK_CODE_TO"].ToString()); //目标仓库
string djrq = DateTime.Now.ToString("yyyy-MM-dd");
Mod_TS_USER mod_TS_USER = dal_TS_USER.GetModel(RV.UI.UserInfo.userID); //获取操作人
string bmid = dal_TS_DEPT.GetDept(mod_TS_USER.C_ACCOUNT);
if (bmid == "")
{
return("操作人部门未维护！");
}
Mod_TS_DEPT mod_TS_DEPT = dal_TS_DEPT.GetModel(bmid);//获取部门
Mod_TQB_CHECKSTATE mod_TQB_CHECKSTATE = dal_TQB_CHECKSTATE.GetModelByName(dr["ZLDJ"].ToString(), "1001");
//Mod_TB_STD_CONFIG mod_TB_STD_CONFIG = dal_TB_STD_CONFIG.GetModel_Interface_Trans(dr["C_STD_CODE"].ToString(), dr["C_STL_GRD"].ToString());
Mod_TSC_SLAB_MAIN modSms = new Mod_TSC_SLAB_MAIN();
if (dr["C_BATCH_NO"].ToString() != "")
{
modSms = dal_TSC_SLAB_MAIN.GetModel_Batch(dr["C_STD_CODE"].ToString(), dr["C_STL_GRD"].ToString(), dr["C_BATCH_NO"].ToString());
}
else
{
modSms = dal_TSC_SLAB_MAIN.GetModel(dr["C_STD_CODE"].ToString(), dr["C_STL_GRD"].ToString(), dr["C_STOVE"].ToString());
}
//Mod_TSC_SLAB_MAIN modSms = dal_TSC_SLAB_MAIN.GetModel(dr["C_STD_CODE"].ToString(), dr["C_STL_GRD"].ToString(), dr["C_STOVE"].ToString());
if (mod_TB_MATRL_MAIN == null)
{
return("调拨失败");
}
if (yck == null)
{
return("调拨失败");
}
if (mbck == null)
{
return("调拨失败");
}
if (mod_TS_USER == null)
{
return("调拨失败");
}
if (mod_TQB_CHECKSTATE == null)
{
return("调拨失败，没有找到对应的质量等级");
}
if (modSms == null)
{
return("调拨失败，没有找到对应的自由项");
}
string C_SLABWH_LOC_NC_ID = "";
string C_SLABWH_LOC_NC_CODE = "";
string C_SLABWH_LOC_NC_NAME = "";
//if (yck.C_SLABWH_CODE == "132" || yck.C_SLABWH_CODE == "593")
if (yck.C_SLABWH_CODE == "132")
{
DataTable dtLOC = dal_TPB_SLABWH.GetList_NC_Loc(C_SLABWH_LOC_CODE, yck.C_SLABWH_CODE, C_SLABWH_AREA_CODE).Tables[0];
if (dtLOC.Rows.Count > 0)
{
C_SLABWH_LOC_NC_ID = dtLOC.Rows[0]["LOC_ID"].ToString();
C_SLABWH_LOC_NC_CODE = dtLOC.Rows[0]["C_SLABWH_LOC_CODE"].ToString();
C_SLABWH_LOC_NC_NAME = dtLOC.Rows[0]["C_SLABWH_LOC_NAME"].ToString();
}
}
XmlDocument xmlDoc = new XmlDocument();
//创建类型声明节点
XmlNode node = xmlDoc.CreateXmlDeclaration("1.0", "UTF-8", "no");
xmlDoc.AppendChild(node);
//创建根节点
XmlElement root = xmlDoc.CreateElement("ufinterface");
#region//给节点属性赋值
root.SetAttribute("billtype", "4K");
root.SetAttribute("filename", urlname);
root.SetAttribute("isexchange", "Y");
root.SetAttribute("operation", "req");
root.SetAttribute("proc", "add");
root.SetAttribute("receiver", "101");
root.SetAttribute("replace", "y");
root.SetAttribute("roottag", "bill");
root.SetAttribute("sender", "1107");
#endregion
xmlDoc.AppendChild(root);
//创建子根节点
XmlElement bill = xmlDoc.CreateElement("bill");
#region//节点属性
bill.SetAttribute("id", "GP" + dhid);
#endregion
root.AppendChild(bill);
XmlNode head = xmlDoc.CreateNode(XmlNodeType.Element, "bill_head", null);
#region //表头_order_head
CreateNode(xmlDoc, head, "ctjname", "");
CreateNode(xmlDoc, head, "bz", "");
CreateNode(xmlDoc, head, "cbilltypecode", "4K"); //库存单据类型编码
CreateNode(xmlDoc, head, "cinbsrid", "");
CreateNode(xmlDoc, head, "cinbsrname", "");
CreateNode(xmlDoc, head, "cindeptid", mod_TS_DEPT.C_ID); //入库部门ID
CreateNode(xmlDoc, head, "cindeptname", mod_TS_DEPT.C_NAME);
CreateNode(xmlDoc, head, "cinwarehouseid", mbck.C_ID); //入库仓库ID
CreateNode(xmlDoc, head, "cinwarehousename", mbck.C_SLABWH_NAME); //仓库名称
CreateNode(xmlDoc, head, "isLocatorMgtIn", "0");
CreateNode(xmlDoc, head, "isWasteWhIn", "0");
CreateNode(xmlDoc, head, "whreservedptyin", "");
CreateNode(xmlDoc, head, "islocatormgtin", "0");
CreateNode(xmlDoc, head, "iswastewhin", "0");
CreateNode(xmlDoc, head, "whreservedptyin", "");
CreateNode(xmlDoc, head, "coutbsor", "");
CreateNode(xmlDoc, head, "coutbsorname", "");
CreateNode(xmlDoc, head, "coutdeptid", mod_TS_DEPT.C_ID); //出库部门ID
CreateNode(xmlDoc, head, "coutdeptname", mod_TS_DEPT.C_NAME); //出库部门名称
CreateNode(xmlDoc, head, "coutwarehouseid", yck.C_ID); //出库仓库ID
CreateNode(xmlDoc, head, "coutwarehousename", yck.C_SLABWH_NAME); //仓库名称
CreateNode(xmlDoc, head, "isLocatorMgtOut", "0");
CreateNode(xmlDoc, head, "isWasteWhOut", "0");
CreateNode(xmlDoc, head, "whReservedPtyOut", "");
CreateNode(xmlDoc, head, "islocatormgtout", "0");
CreateNode(xmlDoc, head, "iswastewhout", "0");
CreateNode(xmlDoc, head, "whreservedptyout", "");
CreateNode(xmlDoc, head, "cshlddiliverdate", djrq); //单据日期
CreateNode(xmlDoc, head, "ctj", "");
CreateNode(xmlDoc, head, "dbilldate", djrq); //单据日期
CreateNode(xmlDoc, head, "nfixdisassemblymny", ""); //组装拆卸费用
CreateNode(xmlDoc, head, "pdfs", "");
CreateNode(xmlDoc, head, "pk_corp", "1001"); //公司ID
CreateNode(xmlDoc, head, "vbillcode", dh); //单据号
CreateNode(xmlDoc, head, "vnote", ""); //备注
CreateNode(xmlDoc, head, "vshldarrivedate", djrq); //应到货日期
CreateNode(xmlDoc, head, "vuserdef1", "");
CreateNode(xmlDoc, head, "vuserdef2", "");
CreateNode(xmlDoc, head, "vuserdef3", "");
CreateNode(xmlDoc, head, "vuserdef4", "");
CreateNode(xmlDoc, head, "vuserdef5", "");
CreateNode(xmlDoc, head, "vuserdef6", "");
CreateNode(xmlDoc, head, "vuserdef7", "");
CreateNode(xmlDoc, head, "vuserdef8", "");
CreateNode(xmlDoc, head, "vuserdef9", "");
CreateNode(xmlDoc, head, "vuserdef10", "");
CreateNode(xmlDoc, head, "vuserdef11", "");
CreateNode(xmlDoc, head, "vuserdef12", "");
CreateNode(xmlDoc, head, "vuserdef13", "");
CreateNode(xmlDoc, head, "vuserdef14", "");
CreateNode(xmlDoc, head, "vuserdef15", "");
CreateNode(xmlDoc, head, "vuserdef16", "");
CreateNode(xmlDoc, head, "vuserdef17", "");
CreateNode(xmlDoc, head, "vuserdef18", "");
CreateNode(xmlDoc, head, "vuserdef19", "");
CreateNode(xmlDoc, head, "vuserdef20", "");
CreateNode(xmlDoc, head, "vuserdef11h", "");
CreateNode(xmlDoc, head, "vuserdef12h", "");
CreateNode(xmlDoc, head, "vuserdef13h", "");
CreateNode(xmlDoc, head, "vuserdef14h", "");
CreateNode(xmlDoc, head, "vuserdef15h", "");
CreateNode(xmlDoc, head, "vuserdef16h", "");
CreateNode(xmlDoc, head, "vuserdef17h", "");
CreateNode(xmlDoc, head, "vuserdef18h", "");
CreateNode(xmlDoc, head, "vuserdef19h", "");
CreateNode(xmlDoc, head, "vuserdef20h", "");
CreateNode(xmlDoc, head, "pk_defdoc1", "");
CreateNode(xmlDoc, head, "pk_defdoc2", "");
CreateNode(xmlDoc, head, "pk_defdoc3", "");
CreateNode(xmlDoc, head, "pk_defdoc4", "");
CreateNode(xmlDoc, head, "pk_defdoc5", "");
CreateNode(xmlDoc, head, "pk_defdoc6", "");
CreateNode(xmlDoc, head, "pk_defdoc7", "");
CreateNode(xmlDoc, head, "pk_defdoc8", "");
CreateNode(xmlDoc, head, "pk_defdoc9", "");
CreateNode(xmlDoc, head, "pk_defdoc10", "");
CreateNode(xmlDoc, head, "pk_defdoc1h", "");
CreateNode(xmlDoc, head, "pk_defdoc2h", "");
CreateNode(xmlDoc, head, "pk_defdoc3h", "");
CreateNode(xmlDoc, head, "pk_defdoc4h", "");
CreateNode(xmlDoc, head, "pk_defdoc5h", "");
CreateNode(xmlDoc, head, "pk_defdoc6h", "");
CreateNode(xmlDoc, head, "pk_defdoc7h", "");
CreateNode(xmlDoc, head, "pk_defdoc8h", "");
CreateNode(xmlDoc, head, "pk_defdoc9h", "");
CreateNode(xmlDoc, head, "pk_defdoc10h", "");
CreateNode(xmlDoc, head, "pk_defdoc11", "");
CreateNode(xmlDoc, head, "pk_defdoc12", "");
CreateNode(xmlDoc, head, "pk_defdoc13", "");
CreateNode(xmlDoc, head, "pk_defdoc14", "");
CreateNode(xmlDoc, head, "pk_defdoc15", "");
CreateNode(xmlDoc, head, "pk_defdoc16", "");
CreateNode(xmlDoc, head, "pk_defdoc17", "");
CreateNode(xmlDoc, head, "pk_defdoc18", "");
CreateNode(xmlDoc, head, "pk_defdoc19", "");
CreateNode(xmlDoc, head, "pk_defdoc20", "");
CreateNode(xmlDoc, head, "pk_defdoc11h", "");
CreateNode(xmlDoc, head, "pk_defdoc12h", "");
CreateNode(xmlDoc, head, "pk_defdoc13h", "");
CreateNode(xmlDoc, head, "pk_defdoc14h", "");
CreateNode(xmlDoc, head, "pk_defdoc15h", "");
CreateNode(xmlDoc, head, "pk_defdoc16h", "");
CreateNode(xmlDoc, head, "pk_defdoc17h", "");
CreateNode(xmlDoc, head, "pk_defdoc18h", "");
CreateNode(xmlDoc, head, "pk_defdoc19h", "");
CreateNode(xmlDoc, head, "pk_defdoc20h", "");
CreateNode(xmlDoc, head, "vuserdef1h", "");
CreateNode(xmlDoc, head, "vuserdef2h", "");
CreateNode(xmlDoc, head, "vuserdef3h", "");
CreateNode(xmlDoc, head, "vuserdef4h", "");
CreateNode(xmlDoc, head, "vuserdef5h", "");
CreateNode(xmlDoc, head, "vuserdef6h", "");
CreateNode(xmlDoc, head, "vuserdef7h", "");
CreateNode(xmlDoc, head, "vuserdef8h", "");
CreateNode(xmlDoc, head, "vuserdef9h", "");
CreateNode(xmlDoc, head, "vuserdef10h", "");
CreateNode(xmlDoc, head, "cauditorid", "");
CreateNode(xmlDoc, head, "cauditorname", "");
CreateNode(xmlDoc, head, "coperatorid", mod_TS_USER.C_ID); //制单人
CreateNode(xmlDoc, head, "coperatorname", mod_TS_USER.C_NAME); //制单人名称
CreateNode(xmlDoc, head, "vadjuster", "");
CreateNode(xmlDoc, head, "vadjustername", "");
CreateNode(xmlDoc, head, "coperatoridnow", "");
CreateNode(xmlDoc, head, "ctjname", "");
CreateNode(xmlDoc, head, "pk_calbody_in", "1001NC10000000000669");
CreateNode(xmlDoc, head, "pk_calbody_out", "1001NC10000000000669");
CreateNode(xmlDoc, head, "vcalbody_inname", "邢钢库存组织");
CreateNode(xmlDoc, head, "vcalbody_outname", "邢钢库存组织");
CreateNode(xmlDoc, head, "ts", DateTime.Now.ToString());
CreateNode(xmlDoc, head, "timestamp", ""); //?
CreateNode(xmlDoc, head, "headts", DateTime.Now.ToString());
CreateNode(xmlDoc, head, "isforeignstor_in", "N");
CreateNode(xmlDoc, head, "isgathersettle_in", "N");
CreateNode(xmlDoc, head, "isforeignstor_out", "N");
CreateNode(xmlDoc, head, "isgathersettle_out", "N");
CreateNode(xmlDoc, head, "icheckmode", "");
CreateNode(xmlDoc, head, "fassistantflag", "N"); //是否计算期间业务量
CreateNode(xmlDoc, head, "fbillflag", "");
CreateNode(xmlDoc, head, "vostatus", "");
CreateNode(xmlDoc, head, "iprintcount", "");
CreateNode(xmlDoc, head, "clastmodiid", mod_TS_USER.C_ID); //最后修改人
CreateNode(xmlDoc, head, "clastmodiname", mod_TS_USER.C_NAME); //最后修改人名称
CreateNode(xmlDoc, head, "tlastmoditime", DateTime.Now.ToString()); //最后修改时间
CreateNode(xmlDoc, head, "cnxtbilltypecode", "4I");
CreateNode(xmlDoc, head, "cspecialhid", "");
#endregion
bill.AppendChild(head);
XmlElement body = xmlDoc.CreateElement("bill_body");
bill.AppendChild(body);
XmlNode item = xmlDoc.CreateNode(XmlNodeType.Element, "item", null);
#region //表体_item
CreateNode(xmlDoc, item, "csourcetypename", "");
CreateNode(xmlDoc, item, "cinvbasid", mod_TB_MATRL_MAIN.C_PK_INVBASDOC); //来源单据号
CreateNode(xmlDoc, item, "pk_invbasdoc", mod_TB_MATRL_MAIN.C_PK_INVBASDOC);
CreateNode(xmlDoc, item, "fixedflag", "N");
CreateNode(xmlDoc, item, "bgssl", "");
CreateNode(xmlDoc, item, "castunitid", mod_TB_MATRL_MAIN.C_FJLDW); //辅计量单位ID
CreateNode(xmlDoc, item, "castunitname", mod_TB_MATRL_MAIN.C_FJLDWMC);
CreateNode(xmlDoc, item, "cinventorycode", mod_TB_MATRL_MAIN.C_MAT_CODE);
CreateNode(xmlDoc, item, "cinventoryid", mod_TB_MATRL_MAIN.C_PK_INVMANDOC); //存货ID
CreateNode(xmlDoc, item, "cinvmanid", mod_TB_MATRL_MAIN.C_PK_INVBASDOC);
CreateNode(xmlDoc, item, "isLotMgt", "1");
CreateNode(xmlDoc, item, "isSerialMgt", "0");
CreateNode(xmlDoc, item, "isValidateMgt", "0");
CreateNode(xmlDoc, item, "isAstUOMmgt", "1");
CreateNode(xmlDoc, item, "isFreeItemMgt", "1");
CreateNode(xmlDoc, item, "isSet", "0");
CreateNode(xmlDoc, item, "standStoreUOM", "");
CreateNode(xmlDoc, item, "defaultAstUOM", mod_TB_MATRL_MAIN.C_FJLDW);
CreateNode(xmlDoc, item, "isSellProxy", "0");
CreateNode(xmlDoc, item, "qualityDay", "");
CreateNode(xmlDoc, item, "invReservedPty", "");
CreateNode(xmlDoc, item, "isSolidConvRate", "0");
CreateNode(xmlDoc, item, "islotmgt", "1");
CreateNode(xmlDoc, item, "isserialmgt", "0");
CreateNode(xmlDoc, item, "isvalidatemgt", "0");
CreateNode(xmlDoc, item, "isastuommgt", "1");
CreateNode(xmlDoc, item, "isfreeitemmgt", "1");
CreateNode(xmlDoc, item, "isset", "0");
CreateNode(xmlDoc, item, "standstoreuom", "");
CreateNode(xmlDoc, item, "defaultastuom", mod_TB_MATRL_MAIN.C_FJLDW);
CreateNode(xmlDoc, item, "issellproxy", "0");
CreateNode(xmlDoc, item, "qualityday", "");
CreateNode(xmlDoc, item, "invreservedpty", "");
CreateNode(xmlDoc, item, "issolidconvrate", "0");
CreateNode(xmlDoc, item, "csourcebillbid", "");
CreateNode(xmlDoc, item, "csourcebillhid", "");
CreateNode(xmlDoc, item, "csourcetype", "");
CreateNode(xmlDoc, item, "cspaceid", C_SLABWH_LOC_NC_ID);
CreateNode(xmlDoc, item, "cspacecode", C_SLABWH_LOC_NC_CODE);
CreateNode(xmlDoc, item, "cspacename", C_SLABWH_LOC_NC_NAME);
CreateNode(xmlDoc, item, "cspecialhid", ""); //？？？
CreateNode(xmlDoc, item, "cwarehouseid", "");
CreateNode(xmlDoc, item, "cwarehousename", "");
CreateNode(xmlDoc, item, "isLocatorMgt", "");
CreateNode(xmlDoc, item, "isWasteWh", "");
CreateNode(xmlDoc, item, "whreservedpty", "");
CreateNode(xmlDoc, item, "islocatormgt", "");
CreateNode(xmlDoc, item, "iswastewh", "");
CreateNode(xmlDoc, item, "whreservedpty", "");
CreateNode(xmlDoc, item, "cyfsl", "");
CreateNode(xmlDoc, item, "cysl", "");
CreateNode(xmlDoc, item, "desl", "");
CreateNode(xmlDoc, item, "dshldtransnum", dr["wgt"].ToString()); //应转数量
CreateNode(xmlDoc, item, "dvalidate", "");
CreateNode(xmlDoc, item, "fbillrowflag", "");
CreateNode(xmlDoc, item, "hlzl", "");
CreateNode(xmlDoc, item, "hsl", Math.Round(Convert.ToDouble(dr["wgt"]) / Convert.ToDouble(dr["qua"]), 6).ToString()); //换算率
CreateNode(xmlDoc, item, "invname", mod_TB_MATRL_MAIN.C_MAT_NAME); //物料名称
CreateNode(xmlDoc, item, "invspec", dr["C_SPEC"].ToString()); //规格
CreateNode(xmlDoc, item, "invtype", dr["C_STL_GRD"].ToString()); //钢种
CreateNode(xmlDoc, item, "je", "");
CreateNode(xmlDoc, item, "jhdj", "");
CreateNode(xmlDoc, item, "jhje", "");
CreateNode(xmlDoc, item, "jhpdzq", "");
CreateNode(xmlDoc, item, "measdocname", mod_TB_MATRL_MAIN.C_ZJLDWMC); //计量单位名称
CreateNode(xmlDoc, item, "naccountastnum", "");
CreateNode(xmlDoc, item, "naccountnum", "");
CreateNode(xmlDoc, item, "nadjustastnum", "");
CreateNode(xmlDoc, item, "nadjustnum", "");
CreateNode(xmlDoc, item, "ncheckastnum", "");
CreateNode(xmlDoc, item, "nchecknum", "");
CreateNode(xmlDoc, item, "nprice", "");
CreateNode(xmlDoc, item, "nmny", "");
CreateNode(xmlDoc, item, "nplannedmny", ""); //计划金额
CreateNode(xmlDoc, item, "nplannedprice", ""); //计划单价
CreateNode(xmlDoc, item, "nshldtransastnum", dr["qua"].ToString()); //应转数量
CreateNode(xmlDoc, item, "pk_measdoc", mod_TB_MATRL_MAIN.C_PK_MEASDOC); //主计量单位
CreateNode(xmlDoc, item, "scrq", djrq); //生产日期
CreateNode(xmlDoc, item, "sjpdzq", "");
string vbatchcode = "";
if (dr["C_BATCH_NO"].ToString() != "")
{
vbatchcode = dr["C_BATCH_NO"].ToString();
}
else
{
vbatchcode = dr["C_STOVE"].ToString();
}
CreateNode(xmlDoc, item, "vbatchcode", vbatchcode); //炉号
CreateNode(xmlDoc, item, "vfree0", ""); //？
CreateNode(xmlDoc, item, "vfree1", modSms.C_ZYX1); //自由项1
CreateNode(xmlDoc, item, "vfree2", modSms.C_ZYX2); //自由项2
CreateNode(xmlDoc, item, "vfree3", ""); //包装要求
CreateNode(xmlDoc, item, "vfree4", "");
CreateNode(xmlDoc, item, "vfree5", "");
CreateNode(xmlDoc, item, "vfree6", "");
CreateNode(xmlDoc, item, "vfree7", "");
CreateNode(xmlDoc, item, "vfree8", "");
CreateNode(xmlDoc, item, "vfree9", "");
CreateNode(xmlDoc, item, "vfree10", "");
CreateNode(xmlDoc, item, "vfreename1", ""); //？
CreateNode(xmlDoc, item, "vfreename2", ""); //？
CreateNode(xmlDoc, item, "vfreename3", ""); //？
CreateNode(xmlDoc, item, "vfreename4", "");
CreateNode(xmlDoc, item, "vfreename5", "");
CreateNode(xmlDoc, item, "vfreename6", "");
CreateNode(xmlDoc, item, "vfreename7", "");
CreateNode(xmlDoc, item, "vfreename8", "");
CreateNode(xmlDoc, item, "vfreename9", "");
CreateNode(xmlDoc, item, "vfreename10", "");
CreateNode(xmlDoc, item, "vsourcebillcode", "");
CreateNode(xmlDoc, item, "vuserdef1", "");
CreateNode(xmlDoc, item, "vuserdef2", "");
CreateNode(xmlDoc, item, "vuserdef3", "");
CreateNode(xmlDoc, item, "vuserdef4", "");
CreateNode(xmlDoc, item, "vuserdef5", "");
CreateNode(xmlDoc, item, "vuserdef6", "");
CreateNode(xmlDoc, item, "vuserdef7", "");
CreateNode(xmlDoc, item, "vuserdef8", "");
CreateNode(xmlDoc, item, "vuserdef9", "");
CreateNode(xmlDoc, item, "vuserdef10", dhid); //自定义项
CreateNode(xmlDoc, item, "vuserdef11", "");
CreateNode(xmlDoc, item, "vuserdef12", "");
CreateNode(xmlDoc, item, "vuserdef13", "");
CreateNode(xmlDoc, item, "vuserdef14", "");
CreateNode(xmlDoc, item, "vuserdef15", "");
CreateNode(xmlDoc, item, "vuserdef16", "");
CreateNode(xmlDoc, item, "vuserdef17", "");
CreateNode(xmlDoc, item, "vuserdef18", "");
CreateNode(xmlDoc, item, "vuserdef19", "");
CreateNode(xmlDoc, item, "vuserdef20", "");
CreateNode(xmlDoc, item, "pk_defdoc1", "");
CreateNode(xmlDoc, item, "pk_defdoc2", "");
CreateNode(xmlDoc, item, "pk_defdoc3", "");
CreateNode(xmlDoc, item, "pk_defdoc4", "");
CreateNode(xmlDoc, item, "pk_defdoc5", "");
CreateNode(xmlDoc, item, "pk_defdoc6", "");
CreateNode(xmlDoc, item, "pk_defdoc7", "");
CreateNode(xmlDoc, item, "pk_defdoc8", "");
CreateNode(xmlDoc, item, "pk_defdoc9", "");
CreateNode(xmlDoc, item, "pk_defdoc10", "");
CreateNode(xmlDoc, item, "pk_defdoc11", "");
CreateNode(xmlDoc, item, "pk_defdoc12", "");
CreateNode(xmlDoc, item, "pk_defdoc13", "");
CreateNode(xmlDoc, item, "pk_defdoc14", "");
CreateNode(xmlDoc, item, "pk_defdoc15", "");
CreateNode(xmlDoc, item, "pk_defdoc16", "");
CreateNode(xmlDoc, item, "pk_defdoc17", "");
CreateNode(xmlDoc, item, "pk_defdoc18", "");
CreateNode(xmlDoc, item, "pk_defdoc19", "");
CreateNode(xmlDoc, item, "pk_defdoc20", "");
CreateNode(xmlDoc, item, "yy", "");
CreateNode(xmlDoc, item, "ztsl", "");
CreateNode(xmlDoc, item, "bkxcl", "");
CreateNode(xmlDoc, item, "chzl", "");
CreateNode(xmlDoc, item, "neconomicnum", "");
CreateNode(xmlDoc, item, "nmaxstocknum", "");
CreateNode(xmlDoc, item, "nminstocknum", dr["qua"].ToString()); //？
CreateNode(xmlDoc, item, "norderpointnum", dr["wgt"].ToString()); //？
CreateNode(xmlDoc, item, "xczl", "");
CreateNode(xmlDoc, item, "nsafestocknum", "");
CreateNode(xmlDoc, item, "fbillflag", "");
CreateNode(xmlDoc, item, "vfreeid1", ""); //？
CreateNode(xmlDoc, item, "vfreeid2", ""); //？
CreateNode(xmlDoc, item, "vfreeid3", ""); //？
CreateNode(xmlDoc, item, "vfreeid4", "");
CreateNode(xmlDoc, item, "vfreeid5", "");
CreateNode(xmlDoc, item, "vfreeid6", "");
CreateNode(xmlDoc, item, "vfreeid7", "");
CreateNode(xmlDoc, item, "vfreeid8", "");
CreateNode(xmlDoc, item, "vfreeid9", "");
CreateNode(xmlDoc, item, "vfreeid10", "");
CreateNode(xmlDoc, item, "discountflag", "N");
CreateNode(xmlDoc, item, "laborflag", "N");
CreateNode(xmlDoc, item, "childsnum", "");
CreateNode(xmlDoc, item, "invsetparttype", "");
CreateNode(xmlDoc, item, "partpercent", "");
CreateNode(xmlDoc, item, "vnote", "");
CreateNode(xmlDoc, item, "vbodynote", "");
CreateNode(xmlDoc, item, "ccorrespondtypename", "");
CreateNode(xmlDoc, item, "cfirstbillbid", "");
CreateNode(xmlDoc, item, "cfirstbillhid", "");
CreateNode(xmlDoc, item, "cfirsttypename", "");
CreateNode(xmlDoc, item, "cfirsttype", "");
CreateNode(xmlDoc, item, "csourcetypename", "");
CreateNode(xmlDoc, item, "pk_calbody", "");
CreateNode(xmlDoc, item, "vcalbodyname", "");
CreateNode(xmlDoc, item, "ts", DateTime.Now.ToString()); //？
CreateNode(xmlDoc, item, "timestamp", ""); //？
CreateNode(xmlDoc, item, "bodyts", DateTime.Now.ToString()); //？
CreateNode(xmlDoc, item, "crowno", "1"); //行号???
CreateNode(xmlDoc, item, "nperiodastnum", ""); //期间业务辅数量
CreateNode(xmlDoc, item, "nperiodnum", ""); //期间业务数量
CreateNode(xmlDoc, item, "isforeignstor", "N");
CreateNode(xmlDoc, item, "isgathersettle", "N");
CreateNode(xmlDoc, item, "csortrowno", "");
CreateNode(xmlDoc, item, "cvendorid", "");
CreateNode(xmlDoc, item, "cvendorname", "");
CreateNode(xmlDoc, item, "pk_cubasdoc", "");
CreateNode(xmlDoc, item, "pk_corp", "1001"); //公司ID
CreateNode(xmlDoc, item, "tbatchtime", ""); //组坯时间
CreateNode(xmlDoc, item, "dproducedate", "");
CreateNode(xmlDoc, item, "dvalidate", "");
CreateNode(xmlDoc, item, "vvendbatchcode", "");
CreateNode(xmlDoc, item, "qualitymanflag", "");
CreateNode(xmlDoc, item, "qualitydaynum", "");
CreateNode(xmlDoc, item, "cqualitylevelid", mod_TQB_CHECKSTATE.C_ID); //质量等级主键
CreateNode(xmlDoc, item, "vnote", "");
CreateNode(xmlDoc, item, "tchecktime", ""); //打牌时间
CreateNode(xmlDoc, item, "vdef1", "");
CreateNode(xmlDoc, item, "vdef2", "");
CreateNode(xmlDoc, item, "vdef3", "");
CreateNode(xmlDoc, item, "vdef4", "");
CreateNode(xmlDoc, item, "vdef5", "");
CreateNode(xmlDoc, item, "vdef6", "");
CreateNode(xmlDoc, item, "vdef7", "");
CreateNode(xmlDoc, item, "vdef8", "");
CreateNode(xmlDoc, item, "vdef9", "");
CreateNode(xmlDoc, item, "vdef10", "");
CreateNode(xmlDoc, item, "vdef11", "");
CreateNode(xmlDoc, item, "vdef12", "");
CreateNode(xmlDoc, item, "vdef13", "");
CreateNode(xmlDoc, item, "vdef14", "");
CreateNode(xmlDoc, item, "vdef15", "");
CreateNode(xmlDoc, item, "vdef16", "");
CreateNode(xmlDoc, item, "vdef17", "");
CreateNode(xmlDoc, item, "vdef18", "");
CreateNode(xmlDoc, item, "vdef19", "");
CreateNode(xmlDoc, item, "vdef20", "");
CreateNode(xmlDoc, item, "naccountgrsnum", "");
CreateNode(xmlDoc, item, "ncheckgrsnum", "");
CreateNode(xmlDoc, item, "nadjustgrsnum", "");
CreateNode(xmlDoc, item, "nshldtransgrsnum", "");
CreateNode(xmlDoc, item, "cspecialbid", ""); //？
CreateNode(xmlDoc, item, "vbatchcode_temp", ""); //？
CreateNode(xmlDoc, item, "cqualitylevelname", mod_TQB_CHECKSTATE.C_CHECKSTATE_NAME); //？
CreateNode(xmlDoc, item, "vdef1", ""); //？
CreateNode(xmlDoc, item, "vdef2", ""); //？
CreateNode(xmlDoc, item, "vdef3", ""); //？
#endregion
body.AppendChild(item);
xmlDoc.Save(url + "\\" + urlname);
List <string> parem = SendNC.SendXML(url + "\\" + urlname);
//parem.Add(dayplcode);
//parem.Add(empID);
//parem.Add("发运单");
//日志
//AddLog(parem);
if (parem[0] == "1")
{
return("1");
}
else
{
return(parem[1].ToString());
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// 加载合同信息
/// </summary>
private void GetConInfo()
{
if (!string.IsNullOrEmpty(txtConNO.Value))
{
Mod_TMO_CON modcon = con.GetModel(txtConNO.Value);
if (modcon != null)
{
txtConName.Value = modcon.C_CON_NAME;
dropConType.SelectedIndex = dropConType.Items.IndexOf(dropConType.Items.FindByText(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.SelectedIndex = dropFaYun.Items.IndexOf(dropFaYun.Items.FindByText(modcon.C_SHIPVIA));
dropBiZhong.SelectedIndex = dropBiZhong.Items.IndexOf(dropBiZhong.Items.FindByText(modcon.C_CURRENCY_TYPE));
dropYeWuType.SelectedIndex = dropYeWuType.Items.IndexOf(dropYeWuType.Items.FindByText(modcon.C_BUSINESS_TYPE));
#region //部门
Mod_TS_DEPT modDept = dept.GetModel(modcon.C_DEPT_ID);
if (modDept != null)
{
txtDept.Value = modDept.C_NAME;
hidDeptID.Value = modcon.C_DEPT_ID;
}
#endregion
#region //业务员
txtSaleUser.Value = GetUserName(modcon.C_SALESMAN);
hidEmpID.Value = modcon.C_SALESMAN;
#endregion
dropSale.SelectedIndex = dropSale.Items.IndexOf(dropSale.Items.FindByText(modcon.C_SALE_DEPT));
dropClass.SelectedIndex = dropClass.Items.IndexOf(dropClass.Items.FindByText(GetConFlag(Convert.ToInt32(modcon.N_FLAG))));
txtKC.Value = modcon.C_STOCK_DEPT;
#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.SelectedIndex = dropArea.Items.IndexOf(dropArea.Items.FindByText(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;
txtZhiDanRen.Value = modcon.C_CUST_MAKING;
txtZhiDanTime.Value = modcon.C_CUST_MAKING_DT.ToString();
#region //最后修改人/最后修改时间 /审批人/审批时间
txtLastEditUser.Value = GetUserName(modcon.C_XG_MODIFY);
txtLastEditTime.Value = modcon.C_XG_MODEIFY_DT.ToString();
txtCheckUser.Value = GetUserName(modcon.C_APPROVER);
txtCheckTime.Value = modcon.D_APPROVER_DT.ToString();
#endregion
iframe1.Src = "Con_OrderList.aspx?ID=" + txtConNO.Value;
}
}
}
/// <summary>
/// 新增合同
/// </summary>
/// <param name="N_STATUS">合同状态</param>
/// <returns></returns>
private bool Add(int N_STATUS)
{
bool result = true;
List <Mod_TMO_ORDER> orderList = new List <Mod_TMO_ORDER>();
#region //添加合同基本信息
Mod_TMO_CON modCon = new Mod_TMO_CON();
Mod_TS_DEPT modDept = ts_dept.GetModel(hiddeptid.Value);
string areaCode = dropConPolicyArea.SelectedItem.Value == "" ? "01" : dropConPolicyArea.SelectedItem.Value;
conNo = randomnumber.CreateConNo(areaCode); //合同号
modCon.C_CON_XH = conNo;
modCon.C_CON_NO = conNo; //合同号
modCon.C_CON_NAME = txtConName.Text; //合同名称
modCon.C_CONTYPEID = dropConType.SelectedItem.Value; //合同类型
modCon.C_CUSTOMERID = hidCustID.Value; //客户ID
modCon.C_CUSTNAME = txtCustName.Text; //客户名称
modCon.C_CUST_NO = hidCustNO.Value; //客户客户编码
modCon.C_EMPLOYEEID = hidsaleempid.Value; //业务员ID
modCon.C_DEPTID = hiddeptid.Value; //业务部门
if (!string.IsNullOrEmpty(hiddeptid.Value))
{
Mod_TS_DEPT moddept = ts_dept.GetModel(hiddeptid.Value);
modCon.C_AREA = moddept.C_NAME; //部门
}
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.C_TRANSMODEID = dropShipVia.SelectedValue; //发运方式
modCon.N_STATUS = N_STATUS;
modCon.C_EMP_ID = ltlC_EMP_ID.Text;
modCon.C_EMP_NAME = ltlC_EMP_NAME.Text;
modCon.N_CUST_LEV = Convert.ToDecimal(ltlCustLEV.Text);//客户等级
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_CRECEIPTCORPID = hidC_OTCID.Value; //开票单位
modCon.C_STATION = txtC_STATION.Value; //站点
modCon.C_REAMRK = txtReamrk.Value;
modCon.N_CHANGENUM = 0; //合同变更次数
#endregion
#region//添加合同明细
for (int i = 0; i < rptList.Items.Count; i++)
{
Literal ltlC_ID = (Literal)rptList.Items[i].FindControl("ltlC_ID"); //物料ID
Literal ltlC_TECH_PROT = (Literal)rptList.Items[i].FindControl("ltlC_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"); //执行标准
TextBox txtPack_Code = (TextBox)rptList.Items[i].FindControl("txtPack_Code"); //包装要求
TextBox txtC_PRO_USE = (TextBox)rptList.Items[i].FindControl("txtC_PRO_USE"); //产品用途
TextBox txtC_CUST_SQ = (TextBox)rptList.Items[i].FindControl("txtC_CUST_SQ"); //特殊要求
DropDownList dropZL = (DropDownList)rptList.Items[i].FindControl("dropZL"); //质量
HtmlInputText txtWgt = (HtmlInputText)rptList.Items[i].FindControl("txtWgt"); //数量
HtmlInputText txtPrice = (HtmlInputText)rptList.Items[i].FindControl("txtPrice"); //含税单价
if (dropConPolicyArea.SelectedItem.Text != "钢坯")
{
if (string.IsNullOrEmpty(txtPack_Code.Text) && tqb_pack.Exists(txtPack_Code.Text))
{
result = false;
break;
}
}
#region //合同明细
Mod_TB_MATRL_MAIN modMat = tb_matrl_main.GetModel(ltlC_ID.Text);
Mod_TMO_ORDER modOrder = new Mod_TMO_ORDER(); //订单表
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_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 = dropZL.SelectedItem.Value; //质量主键ID
modOrder.C_SFPJ = "N";
modOrder.C_TECH_PROT = ltlC_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.N_TYPE = Convert.ToDecimal(modMat.C_MAT_TYPE); //订单类型
modOrder.C_PACK = txtPack_Code.Text.Trim(); //包装要求
Mod_TMB_TAXITEMS modTaxi = tmb_taxitems.GetModel(modMat.C_PK_TAXITEMS);
decimal shuolv = Convert.ToDecimal(modTaxi.N_TAXRATIO) >= 1 ? Convert.ToDecimal(modTaxi.N_TAXRATIO) / 100 : Convert.ToDecimal(modTaxi.N_TAXRATIO); //税率
modOrder.N_TAXRATE = shuolv; //税率
decimal N_WGT = 0;
if (!string.IsNullOrEmpty(txtWgt.Value))
{
N_WGT = Convert.ToDecimal(txtWgt.Value);
}
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(txtPrice.Value))
{
decimal N_TAXRATE = Convert.ToDecimal(modOrder.N_TAXRATE) + 1; //税率
decimal N_ORIGINALCURPRICE = Convert.ToDecimal(txtPrice.Value) / N_TAXRATE; //原币无税单价
decimal N_ORIGINALCURTAXPRICE = Convert.ToDecimal(txtPrice.Value); //原币含税单价
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 = txtC_CUST_SQ.Text; //客户要求
modOrder.C_PRO_USE = txtC_PRO_USE.Text; //产品用途
modOrder.C_EMP_ID = modCon.C_EMP_ID;
modOrder.C_EMP_NAME = modCon.C_EMP_NAME;
modOrder.C_CUST_NO = hidCustNO.Value;
modOrder.C_CUST_NAME = txtCustName.Text;
modOrder.C_SALE_CHANNEL = ltlCustType.Text;
modOrder.C_LEV = GetLev("STL_GRD_Lev"); //钢种等级
modOrder.C_ORDER_LEV = GetLev("Order_Lev"); //订单等级
modOrder.N_COST = 0; //成本
modOrder.C_TRANSMODE = dropShipVia.SelectedItem.Text; //发运方式
modOrder.C_TRANSMODEID = dropShipVia.SelectedItem.Value; //发运方式主键
modOrder.C_YWY = txtSaleUser.Value; //业务员姓名
modOrder.N_STATUS = N_STATUS;
orderList.Add(modOrder);
#endregion
}
#endregion
return(result == true?tmo_con.InsertConOrder(modCon, orderList) : result);
}
/// <summary>
/// 发送转库实绩信息给NC
/// </summary>
/// <param name="xmlFileName">xml完整路径</param>
/// <returns></returns>
public string SendXml_GP(string xmlFileName, string C_ZKD_NO)
{
try
{
string name = "\\4A" + C_ZKD_NO + ".xml";
xmlFileName += name;
DataTable zkddt = dal_TRC_ROLL_ZKD.GetListBydh(C_ZKD_NO).Tables[0];
if (zkddt.Rows.Count == 0)
{
return("PCI转库单表未查询到转库单：" + C_ZKD_NO + "信息！");
}
DataRow dtrow = zkddt.Rows[0];
Mod_TPB_LINEWH yck = dal_TPB_LINEWH.GetModel(dtrow["C_LINEWH_ID"].ToString()); //源仓库
Mod_TPB_LINEWH mbck = dal_TPB_LINEWH.GetModel(dtrow["C_MBLINEWH_ID"].ToString()); //目标仓库
//Mod_TRC_ROLL_PRODCUT mod_TRC_ROLL_PRODCUT = dal_TRC_ROLL_PRODCUT.GetModel();
string djrq = Convert.ToDateTime(dtrow["D_MOD_DT"].ToString()).ToString("yyyy-MM-dd");
Mod_TS_USER mod_TS_USER = dal_TS_USER.GetModel(dtrow["C_EMP_ID"].ToString());
string bmid = dal_TS_DEPT.GetDept(mod_TS_USER.C_ACCOUNT);
if (bmid == "")
{
return("操作人部门未维护！");
}
Mod_TS_DEPT mod_TS_DEPT = dal_TS_DEPT.GetModel(bmid);//获取部门
XmlDocument xmlDoc = new XmlDocument();
//创建类型声明节点
XmlNode node = xmlDoc.CreateXmlDeclaration("1.0", "UTF-8", "no");
xmlDoc.AppendChild(node);
//创建根节点
XmlElement root = xmlDoc.CreateElement("ufinterface");
#region//给节点属性赋值
root.SetAttribute("billtype", "4K");
root.SetAttribute("filename", "ZK4A" + C_ZKD_NO + ".xml");
root.SetAttribute("isexchange", "Y");
root.SetAttribute("operation", "req");
root.SetAttribute("proc", "update");
root.SetAttribute("receiver", "101");
root.SetAttribute("replace", "y");
root.SetAttribute("roottag", "bill");
root.SetAttribute("sender", "1107");
#endregion
xmlDoc.AppendChild(root);
//创建子根节点
XmlElement bill = xmlDoc.CreateElement("bill");
#region//节点属性
bill.SetAttribute("id", "ZK" + C_ZKD_NO);
#endregion
root.AppendChild(bill);
XmlNode head = xmlDoc.CreateNode(XmlNodeType.Element, "bill_head", null);
#region //表头_order_head
CreateNode(xmlDoc, head, "ctjname", "");
CreateNode(xmlDoc, head, "bz", "");
CreateNode(xmlDoc, head, "cbilltypecode", "4K"); //库存单据类型编码
CreateNode(xmlDoc, head, "cinbsrid", "");
CreateNode(xmlDoc, head, "cinbsrname", "");
CreateNode(xmlDoc, head, "cindeptid", mod_TS_DEPT.C_ID); //入库部门ID
CreateNode(xmlDoc, head, "cindeptname", mod_TS_DEPT.C_NAME);
CreateNode(xmlDoc, head, "cinwarehouseid", mbck.C_ID); //入库仓库ID
CreateNode(xmlDoc, head, "cinwarehousename", mbck.C_LINEWH_NAME); //仓库名称
CreateNode(xmlDoc, head, "isLocatorMgtIn", "0");
CreateNode(xmlDoc, head, "isWasteWhIn", "0");
CreateNode(xmlDoc, head, "whreservedptyin", "");
CreateNode(xmlDoc, head, "islocatormgtin", "0");
CreateNode(xmlDoc, head, "iswastewhin", "0");
CreateNode(xmlDoc, head, "whreservedptyin", "");
CreateNode(xmlDoc, head, "coutbsor", "");
CreateNode(xmlDoc, head, "coutbsorname", "");
CreateNode(xmlDoc, head, "coutdeptid", mod_TS_DEPT.C_ID); //出库部门ID
CreateNode(xmlDoc, head, "coutdeptname", mod_TS_DEPT.C_NAME); //出库部门名称
CreateNode(xmlDoc, head, "coutwarehouseid", yck.C_ID); //出库仓库ID
CreateNode(xmlDoc, head, "coutwarehousename", yck.C_LINEWH_NAME); //仓库名称
CreateNode(xmlDoc, head, "isLocatorMgtOut", "0");
CreateNode(xmlDoc, head, "isWasteWhOut", "0");
CreateNode(xmlDoc, head, "whReservedPtyOut", "");
CreateNode(xmlDoc, head, "islocatormgtout", "0");
CreateNode(xmlDoc, head, "iswastewhout", "0");
CreateNode(xmlDoc, head, "whreservedptyout", "");
CreateNode(xmlDoc, head, "cshlddiliverdate", djrq); //单据日期
CreateNode(xmlDoc, head, "ctj", "");
CreateNode(xmlDoc, head, "dbilldate", djrq); //单据日期
CreateNode(xmlDoc, head, "nfixdisassemblymny", ""); //组装拆卸费用
CreateNode(xmlDoc, head, "pdfs", "");
CreateNode(xmlDoc, head, "pk_corp", "1001"); //公司ID
CreateNode(xmlDoc, head, "vbillcode", C_ZKD_NO); //单据号
CreateNode(xmlDoc, head, "vnote", ""); //备注
CreateNode(xmlDoc, head, "vshldarrivedate", djrq); //应到货日期
CreateNode(xmlDoc, head, "vuserdef1", "");
CreateNode(xmlDoc, head, "vuserdef2", "");
CreateNode(xmlDoc, head, "vuserdef3", "");
CreateNode(xmlDoc, head, "vuserdef4", "");
CreateNode(xmlDoc, head, "vuserdef5", "");
CreateNode(xmlDoc, head, "vuserdef6", "");
CreateNode(xmlDoc, head, "vuserdef7", "");
CreateNode(xmlDoc, head, "vuserdef8", "");
CreateNode(xmlDoc, head, "vuserdef9", "");
CreateNode(xmlDoc, head, "vuserdef10", "");
CreateNode(xmlDoc, head, "vuserdef11", "");
CreateNode(xmlDoc, head, "vuserdef12", "");
CreateNode(xmlDoc, head, "vuserdef13", "");
CreateNode(xmlDoc, head, "vuserdef14", "");
CreateNode(xmlDoc, head, "vuserdef15", "");
CreateNode(xmlDoc, head, "vuserdef16", "");
CreateNode(xmlDoc, head, "vuserdef17", "");
CreateNode(xmlDoc, head, "vuserdef18", "");
CreateNode(xmlDoc, head, "vuserdef19", "");
CreateNode(xmlDoc, head, "vuserdef20", "");
CreateNode(xmlDoc, head, "vuserdef11h", "");
CreateNode(xmlDoc, head, "vuserdef12h", "");
CreateNode(xmlDoc, head, "vuserdef13h", "");
CreateNode(xmlDoc, head, "vuserdef14h", "");
CreateNode(xmlDoc, head, "vuserdef15h", "");
CreateNode(xmlDoc, head, "vuserdef16h", "");
CreateNode(xmlDoc, head, "vuserdef17h", "");
CreateNode(xmlDoc, head, "vuserdef18h", "");
CreateNode(xmlDoc, head, "vuserdef19h", "");
CreateNode(xmlDoc, head, "vuserdef20h", "");
CreateNode(xmlDoc, head, "pk_defdoc1", "");
CreateNode(xmlDoc, head, "pk_defdoc2", "");
CreateNode(xmlDoc, head, "pk_defdoc3", "");
CreateNode(xmlDoc, head, "pk_defdoc4", "");
CreateNode(xmlDoc, head, "pk_defdoc5", "");
CreateNode(xmlDoc, head, "pk_defdoc6", "");
CreateNode(xmlDoc, head, "pk_defdoc7", "");
CreateNode(xmlDoc, head, "pk_defdoc8", "");
CreateNode(xmlDoc, head, "pk_defdoc9", "");
CreateNode(xmlDoc, head, "pk_defdoc10", "");
CreateNode(xmlDoc, head, "pk_defdoc1h", "");
CreateNode(xmlDoc, head, "pk_defdoc2h", "");
CreateNode(xmlDoc, head, "pk_defdoc3h", "");
CreateNode(xmlDoc, head, "pk_defdoc4h", "");
CreateNode(xmlDoc, head, "pk_defdoc5h", "");
CreateNode(xmlDoc, head, "pk_defdoc6h", "");
CreateNode(xmlDoc, head, "pk_defdoc7h", "");
CreateNode(xmlDoc, head, "pk_defdoc8h", "");
CreateNode(xmlDoc, head, "pk_defdoc9h", "");
CreateNode(xmlDoc, head, "pk_defdoc10h", "");
CreateNode(xmlDoc, head, "pk_defdoc11", "");
CreateNode(xmlDoc, head, "pk_defdoc12", "");
CreateNode(xmlDoc, head, "pk_defdoc13", "");
CreateNode(xmlDoc, head, "pk_defdoc14", "");
CreateNode(xmlDoc, head, "pk_defdoc15", "");
CreateNode(xmlDoc, head, "pk_defdoc16", "");
CreateNode(xmlDoc, head, "pk_defdoc17", "");
CreateNode(xmlDoc, head, "pk_defdoc18", "");
CreateNode(xmlDoc, head, "pk_defdoc19", "");
CreateNode(xmlDoc, head, "pk_defdoc20", "");
CreateNode(xmlDoc, head, "pk_defdoc11h", "");
CreateNode(xmlDoc, head, "pk_defdoc12h", "");
CreateNode(xmlDoc, head, "pk_defdoc13h", "");
CreateNode(xmlDoc, head, "pk_defdoc14h", "");
CreateNode(xmlDoc, head, "pk_defdoc15h", "");
CreateNode(xmlDoc, head, "pk_defdoc16h", "");
CreateNode(xmlDoc, head, "pk_defdoc17h", "");
CreateNode(xmlDoc, head, "pk_defdoc18h", "");
CreateNode(xmlDoc, head, "pk_defdoc19h", "");
CreateNode(xmlDoc, head, "pk_defdoc20h", "");
CreateNode(xmlDoc, head, "vuserdef1h", "");
CreateNode(xmlDoc, head, "vuserdef2h", "");
CreateNode(xmlDoc, head, "vuserdef3h", "");
CreateNode(xmlDoc, head, "vuserdef4h", "");
CreateNode(xmlDoc, head, "vuserdef5h", "");
CreateNode(xmlDoc, head, "vuserdef6h", "");
CreateNode(xmlDoc, head, "vuserdef7h", "");
CreateNode(xmlDoc, head, "vuserdef8h", "");
CreateNode(xmlDoc, head, "vuserdef9h", "");
CreateNode(xmlDoc, head, "vuserdef10h", "");
CreateNode(xmlDoc, head, "cauditorid", "");
CreateNode(xmlDoc, head, "cauditorname", "");
CreateNode(xmlDoc, head, "coperatorid", mod_TS_USER.C_ID); //制单人
CreateNode(xmlDoc, head, "coperatorname", mod_TS_USER.C_NAME); //制单人名称
CreateNode(xmlDoc, head, "vadjuster", "");
CreateNode(xmlDoc, head, "vadjustername", "");
CreateNode(xmlDoc, head, "coperatoridnow", "");
CreateNode(xmlDoc, head, "ctjname", "");
CreateNode(xmlDoc, head, "pk_calbody_in", "1001NC10000000000669");
CreateNode(xmlDoc, head, "pk_calbody_out", "1001NC10000000000669");
CreateNode(xmlDoc, head, "vcalbody_inname", "邢钢库存组织");
CreateNode(xmlDoc, head, "vcalbody_outname", "邢钢库存组织");
CreateNode(xmlDoc, head, "ts", DateTime.Now.ToString());
CreateNode(xmlDoc, head, "timestamp", ""); //?
CreateNode(xmlDoc, head, "headts", DateTime.Now.ToString());
CreateNode(xmlDoc, head, "isforeignstor_in", "N");
CreateNode(xmlDoc, head, "isgathersettle_in", "N");
CreateNode(xmlDoc, head, "isforeignstor_out", "N");
CreateNode(xmlDoc, head, "isgathersettle_out", "N");
CreateNode(xmlDoc, head, "icheckmode", "");
CreateNode(xmlDoc, head, "fassistantflag", "N"); //是否计算期间业务量
CreateNode(xmlDoc, head, "fbillflag", "");
CreateNode(xmlDoc, head, "vostatus", "");
CreateNode(xmlDoc, head, "iprintcount", "");
CreateNode(xmlDoc, head, "clastmodiid", mod_TS_USER.C_ID); //最后修改人
CreateNode(xmlDoc, head, "clastmodiname", mod_TS_USER.C_NAME); //最后修改人名称
CreateNode(xmlDoc, head, "tlastmoditime", mod_TS_USER.D_MOD_DT.ToString()); //最后修改时间
CreateNode(xmlDoc, head, "cnxtbilltypecode", "4A");
CreateNode(xmlDoc, head, "cspecialhid", "");
#endregion
bill.AppendChild(head);
XmlElement body = xmlDoc.CreateElement("bill_body");
bill.AppendChild(body);
int hno = 0;
foreach (DataRow row in zkddt.Rows)
{
hno++;
string zldj = row["C_JUDGE_LEV_ZH"].ToString();
if (zldj == "")
{
zldj = "DP";
}
Mod_TB_MATRL_MAIN mod_TB_MATRL_MAIN = dal_TB_MATRL_MAIN.GetModel(row["C_MAT_CODE"].ToString());
Mod_TQB_CHECKSTATE mod_TQB_CHECKSTATE = dal_TQB_CHECKSTATE.GetModelByName(zldj, "1001");
Mod_TRC_ROLL_ZKD mod_TRC_ROLL_ZKD = dal_TRC_ROLL_ZKD.GetModeltran(row["C_ID"].ToString());
decimal num = Convert.ToDecimal(mod_TRC_ROLL_ZKD.N_SJNUM == null ? 0 : mod_TRC_ROLL_ZKD.N_SJNUM);
decimal wgt = Convert.ToDecimal(mod_TRC_ROLL_ZKD.N_SJWGT == null ? 0 : mod_TRC_ROLL_ZKD.N_SJWGT);
XmlNode item = xmlDoc.CreateNode(XmlNodeType.Element, "item", null);
#region //表体_item
CreateNode(xmlDoc, item, "csourcetypename", "");
CreateNode(xmlDoc, item, "cinvbasid", mod_TB_MATRL_MAIN.C_PK_INVBASDOC); //来源单据号
CreateNode(xmlDoc, item, "pk_invbasdoc", mod_TB_MATRL_MAIN.C_PK_INVBASDOC);
CreateNode(xmlDoc, item, "fixedflag", "N");
CreateNode(xmlDoc, item, "bgssl", "");
CreateNode(xmlDoc, item, "castunitid", mod_TB_MATRL_MAIN.C_FJLDW); //辅计量单位ID
CreateNode(xmlDoc, item, "castunitname", mod_TB_MATRL_MAIN.C_FJLDWMC);
CreateNode(xmlDoc, item, "cinventorycode", mod_TB_MATRL_MAIN.C_MAT_CODE);
CreateNode(xmlDoc, item, "cinventoryid", mod_TB_MATRL_MAIN.C_PK_INVMANDOC); //存货ID
CreateNode(xmlDoc, item, "cinvmanid", mod_TB_MATRL_MAIN.C_PK_INVBASDOC);
CreateNode(xmlDoc, item, "isLotMgt", "1");
CreateNode(xmlDoc, item, "isSerialMgt", "0");
CreateNode(xmlDoc, item, "isValidateMgt", "0");
CreateNode(xmlDoc, item, "isAstUOMmgt", "1");
CreateNode(xmlDoc, item, "isFreeItemMgt", "1");
CreateNode(xmlDoc, item, "isSet", "0");
CreateNode(xmlDoc, item, "standStoreUOM", "");
CreateNode(xmlDoc, item, "defaultAstUOM", mod_TB_MATRL_MAIN.C_FJLDW);
CreateNode(xmlDoc, item, "isSellProxy", "0");
CreateNode(xmlDoc, item, "qualityDay", "");
CreateNode(xmlDoc, item, "invReservedPty", "");
CreateNode(xmlDoc, item, "isSolidConvRate", "0");
CreateNode(xmlDoc, item, "islotmgt", "1");
CreateNode(xmlDoc, item, "isserialmgt", "0");
CreateNode(xmlDoc, item, "isvalidatemgt", "0");
CreateNode(xmlDoc, item, "isastuommgt", "1");
CreateNode(xmlDoc, item, "isfreeitemmgt", "1");
CreateNode(xmlDoc, item, "isset", "0");
CreateNode(xmlDoc, item, "standstoreuom", "");
CreateNode(xmlDoc, item, "defaultastuom", mod_TB_MATRL_MAIN.C_FJLDW);
CreateNode(xmlDoc, item, "issellproxy", "0");
CreateNode(xmlDoc, item, "qualityday", "");
CreateNode(xmlDoc, item, "invreservedpty", "");
CreateNode(xmlDoc, item, "issolidconvrate", "0");
CreateNode(xmlDoc, item, "csourcebillbid", "");
CreateNode(xmlDoc, item, "csourcebillhid", "");
CreateNode(xmlDoc, item, "csourcetype", "");
CreateNode(xmlDoc, item, "cspaceid", "");
CreateNode(xmlDoc, item, "cspacecode", "");
CreateNode(xmlDoc, item, "cspacename", "");
CreateNode(xmlDoc, item, "cspecialhid", ""); //？？？
CreateNode(xmlDoc, item, "cwarehouseid", "");
CreateNode(xmlDoc, item, "cwarehousename", "");
CreateNode(xmlDoc, item, "isLocatorMgt", "");
CreateNode(xmlDoc, item, "isWasteWh", "");
CreateNode(xmlDoc, item, "whreservedpty", "");
CreateNode(xmlDoc, item, "islocatormgt", "");
CreateNode(xmlDoc, item, "iswastewh", "");
CreateNode(xmlDoc, item, "whreservedpty", "");
CreateNode(xmlDoc, item, "cyfsl", "");
CreateNode(xmlDoc, item, "cysl", "");
CreateNode(xmlDoc, item, "desl", "");
CreateNode(xmlDoc, item, "dshldtransnum", wgt.ToString()); //应转数量
CreateNode(xmlDoc, item, "dvalidate", "");
CreateNode(xmlDoc, item, "fbillrowflag", "");
CreateNode(xmlDoc, item, "hlzl", "");
if (num == 0)
{
CreateNode(xmlDoc, item, "hsl", "0"); //换算率
}
else
{
CreateNode(xmlDoc, item, "hsl", Math.Round(Convert.ToDouble(wgt / num), 6).ToString()); //换算率
}
CreateNode(xmlDoc, item, "invname", mod_TB_MATRL_MAIN.C_MAT_NAME); //物料名称
CreateNode(xmlDoc, item, "invspec", mod_TRC_ROLL_ZKD.C_SPEC); //规格
CreateNode(xmlDoc, item, "invtype", mod_TRC_ROLL_ZKD.C_STL_GRD); //钢种
CreateNode(xmlDoc, item, "je", "");
CreateNode(xmlDoc, item, "jhdj", "");
CreateNode(xmlDoc, item, "jhje", "");
CreateNode(xmlDoc, item, "jhpdzq", "");
CreateNode(xmlDoc, item, "measdocname", mod_TB_MATRL_MAIN.C_ZJLDWMC); //主计量单位名称
CreateNode(xmlDoc, item, "naccountastnum", "");
CreateNode(xmlDoc, item, "naccountnum", "");
CreateNode(xmlDoc, item, "nadjustastnum", "");
CreateNode(xmlDoc, item, "nadjustnum", "");
CreateNode(xmlDoc, item, "ncheckastnum", "");
CreateNode(xmlDoc, item, "nchecknum", "");
CreateNode(xmlDoc, item, "nprice", "");
CreateNode(xmlDoc, item, "nmny", "");
CreateNode(xmlDoc, item, "nplannedmny", ""); //计划金额
CreateNode(xmlDoc, item, "nplannedprice", ""); //计划单价
CreateNode(xmlDoc, item, "nshldtransastnum", num.ToString()); //应转辅数量
CreateNode(xmlDoc, item, "pk_measdoc", mod_TB_MATRL_MAIN.C_PK_MEASDOC); //主计量单位
CreateNode(xmlDoc, item, "scrq", djrq); //生产日期
CreateNode(xmlDoc, item, "sjpdzq", "");
CreateNode(xmlDoc, item, "vbatchcode", mod_TRC_ROLL_ZKD.C_BATCH_NO); //批号
CreateNode(xmlDoc, item, "vfree0", ""); //？
CreateNode(xmlDoc, item, "vfree1", mod_TRC_ROLL_ZKD.C_ZYX1); //自由项1
CreateNode(xmlDoc, item, "vfree2", mod_TRC_ROLL_ZKD.C_ZYX2); //自由项2
CreateNode(xmlDoc, item, "vfree3", mod_TRC_ROLL_ZKD.C_BZYQ); //包装要求
CreateNode(xmlDoc, item, "vfree4", "");
CreateNode(xmlDoc, item, "vfree5", "");
CreateNode(xmlDoc, item, "vfree6", "");
CreateNode(xmlDoc, item, "vfree7", "");
CreateNode(xmlDoc, item, "vfree8", "");
CreateNode(xmlDoc, item, "vfree9", "");
CreateNode(xmlDoc, item, "vfree10", "");
CreateNode(xmlDoc, item, "vfreename1", ""); //？
CreateNode(xmlDoc, item, "vfreename2", ""); //？
CreateNode(xmlDoc, item, "vfreename3", ""); //？
CreateNode(xmlDoc, item, "vfreename4", "");
CreateNode(xmlDoc, item, "vfreename5", "");
CreateNode(xmlDoc, item, "vfreename6", "");
CreateNode(xmlDoc, item, "vfreename7", "");
CreateNode(xmlDoc, item, "vfreename8", "");
CreateNode(xmlDoc, item, "vfreename9", "");
CreateNode(xmlDoc, item, "vfreename10", "");
CreateNode(xmlDoc, item, "vsourcebillcode", "");
CreateNode(xmlDoc, item, "vuserdef1", "");
CreateNode(xmlDoc, item, "vuserdef2", "");
CreateNode(xmlDoc, item, "vuserdef3", "");
CreateNode(xmlDoc, item, "vuserdef4", "");
CreateNode(xmlDoc, item, "vuserdef5", "");
CreateNode(xmlDoc, item, "vuserdef6", "");
CreateNode(xmlDoc, item, "vuserdef7", "");
CreateNode(xmlDoc, item, "vuserdef8", "");
CreateNode(xmlDoc, item, "vuserdef9", "");
CreateNode(xmlDoc, item, "vuserdef10", mod_TRC_ROLL_ZKD.C_ID); //自定义项
CreateNode(xmlDoc, item, "vuserdef11", "");
CreateNode(xmlDoc, item, "vuserdef12", "");
CreateNode(xmlDoc, item, "vuserdef13", "");
CreateNode(xmlDoc, item, "vuserdef14", "");
CreateNode(xmlDoc, item, "vuserdef15", "");
CreateNode(xmlDoc, item, "vuserdef16", "");
CreateNode(xmlDoc, item, "vuserdef17", "");
CreateNode(xmlDoc, item, "vuserdef18", "");
CreateNode(xmlDoc, item, "vuserdef19", "");
CreateNode(xmlDoc, item, "vuserdef20", "");
CreateNode(xmlDoc, item, "pk_defdoc1", "");
CreateNode(xmlDoc, item, "pk_defdoc2", "");
CreateNode(xmlDoc, item, "pk_defdoc3", "");
CreateNode(xmlDoc, item, "pk_defdoc4", "");
CreateNode(xmlDoc, item, "pk_defdoc5", "");
CreateNode(xmlDoc, item, "pk_defdoc6", "");
CreateNode(xmlDoc, item, "pk_defdoc7", "");
CreateNode(xmlDoc, item, "pk_defdoc8", "");
CreateNode(xmlDoc, item, "pk_defdoc9", "");
CreateNode(xmlDoc, item, "pk_defdoc10", "");
CreateNode(xmlDoc, item, "pk_defdoc11", "");
CreateNode(xmlDoc, item, "pk_defdoc12", "");
CreateNode(xmlDoc, item, "pk_defdoc13", "");
CreateNode(xmlDoc, item, "pk_defdoc14", "");
CreateNode(xmlDoc, item, "pk_defdoc15", "");
CreateNode(xmlDoc, item, "pk_defdoc16", "");
CreateNode(xmlDoc, item, "pk_defdoc17", "");
CreateNode(xmlDoc, item, "pk_defdoc18", "");
CreateNode(xmlDoc, item, "pk_defdoc19", "");
CreateNode(xmlDoc, item, "pk_defdoc20", "");
CreateNode(xmlDoc, item, "yy", "");
CreateNode(xmlDoc, item, "ztsl", "");
CreateNode(xmlDoc, item, "bkxcl", "");
CreateNode(xmlDoc, item, "chzl", "");
CreateNode(xmlDoc, item, "neconomicnum", "");
CreateNode(xmlDoc, item, "nmaxstocknum", "");
CreateNode(xmlDoc, item, "nminstocknum", num.ToString()); //？
CreateNode(xmlDoc, item, "norderpointnum", wgt.ToString()); //？
CreateNode(xmlDoc, item, "xczl", "");
CreateNode(xmlDoc, item, "nsafestocknum", "");
CreateNode(xmlDoc, item, "fbillflag", "");
CreateNode(xmlDoc, item, "vfreeid1", ""); //？
CreateNode(xmlDoc, item, "vfreeid2", ""); //？
CreateNode(xmlDoc, item, "vfreeid3", ""); //？
CreateNode(xmlDoc, item, "vfreeid4", "");
CreateNode(xmlDoc, item, "vfreeid5", "");
CreateNode(xmlDoc, item, "vfreeid6", "");
CreateNode(xmlDoc, item, "vfreeid7", "");
CreateNode(xmlDoc, item, "vfreeid8", "");
CreateNode(xmlDoc, item, "vfreeid9", "");
CreateNode(xmlDoc, item, "vfreeid10", "");
CreateNode(xmlDoc, item, "discountflag", "N");
CreateNode(xmlDoc, item, "laborflag", "N");
CreateNode(xmlDoc, item, "childsnum", "");
CreateNode(xmlDoc, item, "invsetparttype", "");
CreateNode(xmlDoc, item, "partpercent", "");
CreateNode(xmlDoc, item, "vnote", "");
CreateNode(xmlDoc, item, "vbodynote", "");
CreateNode(xmlDoc, item, "ccorrespondtypename", "");
CreateNode(xmlDoc, item, "cfirstbillbid", "");
CreateNode(xmlDoc, item, "cfirstbillhid", "");
CreateNode(xmlDoc, item, "cfirsttypename", "");
CreateNode(xmlDoc, item, "cfirsttype", "");
CreateNode(xmlDoc, item, "csourcetypename", "");
CreateNode(xmlDoc, item, "pk_calbody", "");
CreateNode(xmlDoc, item, "vcalbodyname", "");
CreateNode(xmlDoc, item, "ts", DateTime.Now.ToString()); //？
CreateNode(xmlDoc, item, "timestamp", ""); //？
CreateNode(xmlDoc, item, "bodyts", DateTime.Now.ToString()); //？
CreateNode(xmlDoc, item, "crowno", hno.ToString()); //行号???
CreateNode(xmlDoc, item, "nperiodastnum", ""); //期间业务辅数量
CreateNode(xmlDoc, item, "nperiodnum", ""); //期间业务数量
CreateNode(xmlDoc, item, "isforeignstor", "N");
CreateNode(xmlDoc, item, "isgathersettle", "N");
CreateNode(xmlDoc, item, "csortrowno", "");
CreateNode(xmlDoc, item, "cvendorid", "");
CreateNode(xmlDoc, item, "cvendorname", "");
CreateNode(xmlDoc, item, "pk_cubasdoc", "");
CreateNode(xmlDoc, item, "pk_corp", "1001"); //公司ID
CreateNode(xmlDoc, item, "tbatchtime", ""); //组坯时间
CreateNode(xmlDoc, item, "dproducedate", "");
CreateNode(xmlDoc, item, "dvalidate", "");
CreateNode(xmlDoc, item, "vvendbatchcode", "");
CreateNode(xmlDoc, item, "qualitymanflag", "");
CreateNode(xmlDoc, item, "qualitydaynum", "");
CreateNode(xmlDoc, item, "cqualitylevelid", mod_TQB_CHECKSTATE.C_ID); //质量等级主键
CreateNode(xmlDoc, item, "vnote", "");
CreateNode(xmlDoc, item, "tchecktime", ""); //打牌时间
CreateNode(xmlDoc, item, "vdef1", "");
CreateNode(xmlDoc, item, "vdef2", "");
CreateNode(xmlDoc, item, "vdef3", "");
CreateNode(xmlDoc, item, "vdef4", "");
CreateNode(xmlDoc, item, "vdef5", "");
CreateNode(xmlDoc, item, "vdef6", "");
CreateNode(xmlDoc, item, "vdef7", "");
CreateNode(xmlDoc, item, "vdef8", "");
CreateNode(xmlDoc, item, "vdef9", "");
CreateNode(xmlDoc, item, "vdef10", "");
CreateNode(xmlDoc, item, "vdef11", "");
CreateNode(xmlDoc, item, "vdef12", "");
CreateNode(xmlDoc, item, "vdef13", "");
CreateNode(xmlDoc, item, "vdef14", "");
CreateNode(xmlDoc, item, "vdef15", "");
CreateNode(xmlDoc, item, "vdef16", "");
CreateNode(xmlDoc, item, "vdef17", "");
CreateNode(xmlDoc, item, "vdef18", "");
CreateNode(xmlDoc, item, "vdef19", "");
CreateNode(xmlDoc, item, "vdef20", "");
CreateNode(xmlDoc, item, "naccountgrsnum", "");
CreateNode(xmlDoc, item, "ncheckgrsnum", "");
CreateNode(xmlDoc, item, "nadjustgrsnum", "");
CreateNode(xmlDoc, item, "nshldtransgrsnum", "");
CreateNode(xmlDoc, item, "cspecialbid", ""); //？
CreateNode(xmlDoc, item, "vbatchcode_temp", ""); //？
CreateNode(xmlDoc, item, "cqualitylevelname", zldj); //？
CreateNode(xmlDoc, item, "vdef1", ""); //？
CreateNode(xmlDoc, item, "vdef2", ""); //？
CreateNode(xmlDoc, item, "vdef3", ""); //？
#endregion
body.AppendChild(item);
}
xmlDoc.Save(xmlFileName);
//List<string> parem = SendNC.SendXML("D:/XML/ZK18091300456044K4A.XML");
List <string> parem = SendNC.SendXML(xmlFileName);
//parem.Add(dayplcode);
//parem.Add(empID);
//parem.Add("发运单");
////日志
////AddLog(parem);
if (parem[0] == "1")
{
return("1");
}
else
{
return(parem[1]);
}
}
catch (Exception ex)
{
return(ex.ToString());
}
}
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>
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>
/// <param name="dt">要发送的集合</param>
/// <returns>返回int类型 大于0为转入成功,等于0发送失败</returns>
public int ADDFYDToZJB(string sendcode)
{
//TransactionHelper_SQL.BeginTransaction();
List <Mod_TMD_DISPATCHDETAILS> item = new List <Mod_TMD_DISPATCHDETAILS>();
#region //实例化
Dal_TMD_DISPATCHDETAILS dalitem = new Dal_TMD_DISPATCHDETAILS();
Dal_TQB_CHECKSTATE daltqb = new Dal_TQB_CHECKSTATE();
Dal_TS_DEPT daldetp = new Dal_TS_DEPT();
Dal_TS_USER daluser = new Dal_TS_USER();
Dal_TMD_DISPATCH dalhead = new Dal_TMD_DISPATCH();
Dal_TS_DIC daldic = new Dal_TS_DIC();
#endregion
Mod_TMD_DISPATCH modTmd = dalhead.GetModel(sendcode); //发运单主表
item = DataTableToList(dalitem.GetList(sendcode).Tables[0]); //发运明细
StringBuilder strSql = new StringBuilder();
for (int i = 0; i < item.Count; i++)
{
#region //基础数据
Mod_TQB_CHECKSTATE modtqb = daltqb.GetModel(item[i].C_QUALIRY_LEV);
Mod_TS_DEPT moddept = daldetp.GetModel(modTmd.C_BUSINESS_DEPT); //业务部门
string saleemp = daluser.GetSaleName(modTmd.C_BUSINESS_ID); //业务人
Mod_TS_USER moduser = daluser.GetModel(modTmd.C_CREATE_ID); //制单人
//0主计量单位，1辅单位
DataTable dt = DbHelperOra.Query("SELECT T.C_ID,T.C_MEASNAME FROM TMB_MEAS T WHERE T.C_ID in('" + item[i].C_UNITIS + "','" + item[i].C_AU_UNITIS + "')").Tables[0];
DataRow drfyfs = DbHelperOra.GetDataRow("select T.C_INDEX from TS_DIC t where t.c_detailcode='" + modTmd.C_SHIPVIA + "'");
#endregion
#region //插入条码中间表
strSql.Append("insert into ReZJB_FYD(");
strSql.Append("fydh,"); //发运单号-
strSql.Append("ck,"); //仓库主键-
strSql.Append("khbm,"); //客户编码-
strSql.Append("yslb,"); //运输方式主键
strSql.Append("cph,"); //车牌号-
strSql.Append("wlh,"); //物料编码-
strSql.Append("wlmc,"); //物料名称-
strSql.Append("sx,"); //质量等级编码A,B-
strSql.Append("jhsl,"); //支数--
strSql.Append("jhzl,"); //重量--
strSql.Append("zjldw,"); //线材主计量单位名称（件【线材】）-
strSql.Append("fjldw,"); //吨--
strSql.Append("ywbm,"); //业务部门名称--
strSql.Append("ywry,"); //业务员名称--
strSql.Append("zdr,"); //制单人名称--
strSql.Append("zdrq,"); //制单时间--
strSql.Append("PH,"); //钢种--
strSql.Append("GG,"); //规格--
strSql.Append("ZJBstatus,"); //状态默认0--
strSql.Append("CAPPK,"); //发运单明细表主键--
strSql.Append("insertts,"); //插入时间--
strSql.Append("PCInfo,"); //其他要求名称--
strSql.Append("zyx1,"); //自由项1--
strSql.Append("zyx2,"); //自由项2--
strSql.Append("zyx3,"); //包装要求
strSql.Append("zyx4,"); //导入条码次数
strSql.Append("zldj"); //行备注
strSql.Append(")values(");
strSql.Append("'" + item[i].C_DISPATCH_ID + "',"); //发运单号
strSql.Append("'" + item[i].C_SEND_STOCK_PK + "',"); //发运仓库主键
strSql.Append("'" + item[i].C_CUSTNO + "',"); //客户编码
strSql.Append("'" + drfyfs["C_INDEX"].ToString() + "',"); //发运方式主键1汽运 2火运
strSql.Append("'" + modTmd.C_LIC_PLA_NO + "',"); //车牌号
strSql.Append("'" + item[i].C_MAT_CODE + "',"); //物料编码
strSql.Append("'" + item[i].C_MAT_NAME + "',"); //物料编码
strSql.Append("'" + modtqb.C_CHECKSTATE_NAME + "',"); //质量等级名称
strSql.Append("'" + item[i].N_FYZS + "',"); //发运支数
strSql.Append("'" + item[i].N_FYWGT + "',"); //发运重量
strSql.Append("'" + dt.Rows[1]["C_MEASNAME"] + "',"); //线材主计量单位名称（件【线材】）
strSql.Append("'" + dt.Rows[0]["C_MEASNAME"] + "',"); //线材主计量单位名称（吨）
strSql.Append("'" + moddept.C_NAME + "',"); //业务部门名称
strSql.Append("'" + saleemp + "',"); //业务员名称
strSql.Append("'" + moduser.C_NAME + "',"); //制单人名称
strSql.Append("'" + modTmd.D_CREATE_DT + "',"); //制单时间
strSql.Append("'" + item[i].C_STL_GRD + "',"); //钢种
strSql.Append("'" + item[i].C_SPEC + "',"); //规格
strSql.Append("0,"); //状态
strSql.Append("'" + item[i].C_ID + "',"); //发运单明细表主键
strSql.Append("'" + DateTime.Now.ToString() + "',"); //插入时间
strSql.Append("'" + item[i].C_ELSENEED + "',"); //其他要求
strSql.Append("'" + item[i].C_FREE_TERM + "',"); //自由项1
strSql.Append("'" + item[i].C_FREE_TERM2 + "',"); //自由项2
strSql.Append("'" + item[i].C_PACK + "',"); // 包装要求
strSql.Append("'" + modTmd.C_EXTEND1 + "',"); // 导入条码系统次数
strSql.Append("'" + item[i].C_REMARK + "'"); // 行备注
strSql.Append(");");
#endregion
}
if (DbHelper_SQL.ExecuteSql(strSql.ToString()) == 0)
{
return(-2);
}
return(1);
}
