public AjaxResult Material2([FromBody] dynamic Json)
{
Bll_TB_MATRL_MAIN tb_matrl_main = new Bll_TB_MATRL_MAIN();
Mod_TS_USER modUser = GetUserID();
Mod_TS_CUSTFILE modCustfile = ts_custfile.GetModel(modUser.C_CUST_ID);
AjaxResult result = new AjaxResult();
#region //参数
string MatCode = Json.MatCode; //物料编码
string MatName = Json.MatName; //物料名称
string Stl_Grd = Json.Stl_Grd; //钢种
string Spec = Json.Spec; //规格
string prodKind = Json.prodKind; //大类
string prodName = Json.prodName; //小类
#endregion
DataTable dt = new DataTable();
if (prodKind.Contains("商品坯"))
{
dt = tb_matrl_main.GetCustStlGrd_GP(prodKind, prodName, modCustfile.C_NO, MatCode, Stl_Grd, Spec).Tables[0];
}
else
{
dt = tb_matrl_main.GetCust_StlGrd(prodKind, prodName, modCustfile.C_NO, MatCode, Stl_Grd, Spec).Tables[0];
}
result.Code = DoResult.Success;
result.Result = JsonConvert.SerializeObject(dt);
return(result);
}
public AjaxResult Tech_Prot([FromBody] dynamic Json)
{
string MatID = Json.MatID; //物料ID
#region //数据操作
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
string[] matList = { "851", "841", "831" };
Mod_TS_USER mod = GetUserID();
Mod_TS_CUSTFILE modCust = ts_custfile.GetModel(mod.C_CUST_ID);
Mod_TB_MATRL_MAIN modMat = tb_matrl_main.GetModel(MatID);
decimal n_type = Convert.ToDecimal(modMat.C_MAT_TYPE);
if (!matList.Contains(modMat.C_MAT_GROUP_CODE))
{
DataTable dt = tb_std_config.GetCUST_TECH_PROT(modMat.C_STL_GRD, modCust.C_NO).Tables[0];
if (dt.Rows.Count > 0)
{
result.Result = JsonConvert.SerializeObject(dt);
}
}
#endregion
return(result);
}
/// <summary>
/// 公司档案
/// </summary>
protected void btnSave2_Click(object sender, EventArgs e)
{
try
{
Mod_TS_USER mod = ts_user.GetModel(ltlUserID.Text);
mod.C_CJNAME = txtC_CJNAME.Text;
mod.C_CJINTRO = txtC_CJINTRO.Text;
mod.C_STL_GRD = txtC_STL_GRD.Text;
mod.C_LEGALREPRES = txtC_LEGALREPRES.Text;
mod.C_CGJCR = txtC_CGJCR.Text;
mod.C_JOB = txtC_JOB.Text;
mod.C_JCTEL = txtC_JCTEL.Text;
mod.C_ADDRESS = txtC_ADDRESS.Text;
mod.C_AREA = dropArea.SelectedValue;
mod.C_MANAGER = txtC_MANAGER.Text;
if (ts_user.UpdateInfo(mod))
{
ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", "alert('保存成功');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", "alert('" + ex.ToString() + "');", true);
}
}
public AjaxResult GetQualBack([FromBody] dynamic Json)
{
#region //参数
string fileID = Json.fileID; //文件ID
string content = Json.content; //批语
#endregion
#region //数据操作
string jg = string.Empty;
Mod_TMF_FILEINFO modFile = tmf_fileinfo.GetModel(fileID);
Mod_TS_USER modUser = GetUserID();
//删除当前步骤与下一步骤
if (tmb_file_next_emp.BackSetp(fileID, "0", "0", "0"))
{
//更新当前审批人/时间/状态
if (tmq_quality_main.UpdateCheckEmp(modFile.C_TASK_ID, modUser.C_ID, "0", DateTime.Now))
{
jg = ProAdd("驳回", content, modUser.C_NAME, modUser.C_ID, modFile.C_STEP_ID, fileID);
}
}
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
result.Result = jg;
#endregion
return(result);
}
/// <summary>
/// 更新密码
/// </summary>
public bool UpdatePwd(Mod_TS_USER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TS_USER set ");
strSql.Append("C_PASSWORD=:C_PASSWORD");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_PASSWORD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_PASSWORD;
parameters[1].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public AjaxResult AddBook([FromBody] dynamic Json)
{
AjaxResult result = new AjaxResult();
#region //接收参数
string zf_dt = Json.zf_dt; //走访日期
string cust_name = Json.cust_name; //客户名称
string area = Json.area; //区域
string cust_manage = Json.cust_manage; //客户经理
string cust_emp = Json.cust_emp; //客户人员
string cust_emp_tel = Json.cust_emp_tel; //客户人员电话
string meeting_cust = Json.meeting_cust; //参会客户名单
string meeting_xg = Json.meeting_xg; //参会邢钢名单
string main_content = Json.main_content; //主要交流内容
string need_s_q = Json.need_s_q; //需解决问题
string leave_q = Json.leave_q; //遗留问题
string stl_grd = Json.stl_grd; //钢种
string pro_use = Json.pro_use; //用途
string site = Json.site; //交流地点
string remark = Json.remark; //备注
string type = Json.type; //0：走访用户，1来访客户
#endregion
#region //数据操作
result.Code = DoResult.Success;
Mod_TS_USER modUser = GetUserID();
Mod_TMC_CUST_BOOK mod = new Mod_TMC_CUST_BOOK();
mod.D_ZF_DT = Convert.ToDateTime(zf_dt);
mod.C_CUST_NAME = cust_name;
mod.C_AREA = area;
mod.C_CUST_MANAGE = cust_manage;
mod.C_CUST_EMP = cust_emp;
mod.C_CUST_EMP_TEL = cust_emp_tel;
mod.C_MEETING_CUST = meeting_cust;
mod.C_MEETING_XG = meeting_xg;
mod.C_MAIN_CONTENT = main_content;
mod.C_NEED_S_Q = need_s_q;
mod.C_LEAVE_Q = leave_q;
mod.C_STL_GRD = stl_grd;
mod.C_PRO_USE = pro_use;
mod.C_SITE = site;
mod.C_REMARK = remark;
mod.N_TYPE = Convert.ToDecimal(type);
mod.C_EMPID = modUser.C_ID;
if (tmc_cust_book.Add(mod))
{
result.Result = "录入成功！";
}
else
{
result.Result = "录入失败！";
}
#endregion
return(result);
}
/// <summary>
/// 获取用户姓名
/// </summary>
/// <param name="id">用户ID</param>
/// <returns></returns>
private string GetUserName(string id)
{
string name = string.Empty;
Mod_TS_USER mod = ts_user.GetModel(id);
if (mod != null)
{
name = mod.C_NAME;
}
return(name);
}
public AjaxResult GetConOK([FromBody] dynamic Json)
{
#region //参数
string fileID = Json.fileID; //文件ID
string content = Json.content; //批语
string nextApprEmpID = Json.nextApprEmpID; //下一步骤审批人ID,注意:多人审批"#"隔开,如(张三ID#李四)
#endregion
#region //数据操作
string jg = string.Empty;
Mod_TMF_FILEINFO modFile = tmf_fileinfo.GetModel(fileID);
Mod_TS_USER modUser = GetUserID();
string nextStep = tmb_flowstep.GetNextStep(modFile.C_FLOW_ID, modFile.C_STEP_ID);
if (nextStep == "0")
{
#region //最后步骤操作
Mod_ApproveCon mod = new Mod_ApproveCon();
mod.C_EMP_ID = modUser.C_ID;
mod.NEXTSTEPID = nextStep;
mod.FILE_STATUS = "1";
mod.FILEID = fileID;
mod.CON_STATUS = "2";
mod.CON_NO = modFile.C_TASK_ID;
if (tmf_fileinfo.UpdateLastStep(mod))
{
jg = ProAdd("批准", content, modUser.C_NAME, modUser.C_ID, modFile.C_STEP_ID, fileID);
}
#endregion
}
else
{
#region //下一步骤操作
if (tmb_file_next_emp.UpdateNextSetp(fileID, modFile.C_STEP_ID, nextStep, nextApprEmpID, modUser.C_ID))
{
jg = ProAdd("批准", content, modUser.C_NAME, modUser.C_ID, modFile.C_STEP_ID, fileID);
}
#endregion
}
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
result.Result = jg;
#endregion
return(result);
}
public AjaxResult GetAddr([FromBody] dynamic Json)
{
string CGID = Json.CGID; //参数：收货单位
#region //数据操作
Mod_TS_USER modUser = GetUserID();
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
result.Result = SerializationHelper.Dtb2Json(ts_custaddr.GetAddr("", "", CGID, "", "").Tables[0]);
#endregion
return(result);
}
public AjaxResult GetMenu([FromBody] dynamic Json)
{
#region //数据操作
Mod_TS_USER modUser = GetUserID();
Mod_TS_CUSTFILE modCustfile = ts_custfile.GetModel(modUser.C_CUST_ID);
DataTable dt = tb_matrl_main.Get_PROD_KIND(modCustfile.C_NO).Tables[0];
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
result.Result = SerializationHelper.Dtb2Json(dt);
#endregion
return(result);
}
public AjaxResult GetQualOK([FromBody] dynamic Json)
{
#region //参数
string fileID = Json.fileID; //文件ID
string content = Json.content; //批语
string nextApprEmpID = Json.nextApprEmpID; //下一步骤审批人ID,注意:多人审批"#"隔开,如(张三ID#李四)
#endregion
#region //数据操作
string jg = string.Empty;
Mod_TMF_FILEINFO modFile = tmf_fileinfo.GetModel(fileID);
Mod_TS_USER modUser = GetUserID();
string nextStep = tmb_flowstep.GetNextStep(modFile.C_FLOW_ID, modFile.C_STEP_ID);
if (nextStep == "0")
{
#region //最后步骤操作
if (tmf_fileinfo.UpdateStepStatus(nextStep, 1, fileID)) //更新文件事务状态为办结
{
////更新当前审批人/时间/状态
tmq_quality_main.UpdateCheckEmp(modFile.C_TASK_ID, modUser.C_ID, "2", DateTime.Now);
jg = ProAdd("批准", content, modUser.C_NAME, modUser.C_ID, modFile.C_STEP_ID, fileID);
}
#endregion
}
else
{
#region //下一步骤操作
if (tmb_file_next_emp.UpdateNextSetp(fileID, modFile.C_STEP_ID, nextStep, nextApprEmpID, modUser.C_ID))
{
jg = ProAdd("批准", content, modUser.C_NAME, modUser.C_ID, modFile.C_STEP_ID, fileID);
}
#endregion
}
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
result.Result = jg;
#endregion
return(result);
}
//修改密码
protected void btnSavePwd_Click(object sender, EventArgs e)
{
try
{
Mod_TS_USER mod = new Mod_TS_USER();
mod.C_ID = ltlUserID.Text;
mod.C_PASSWORD = Encrypt.MD5(txtPwd.Value);
if (ts_user.UpdatePwd(mod))
{
ScriptManager.RegisterStartupScript(UpdatePanel5, this.Page.GetType(), "", "alert('修改成功');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(UpdatePanel5, this.Page.GetType(), "", "alert('" + ex.ToString() + "');", true);
}
}
public AjaxResult GetMenu3([FromBody] dynamic Json)
{
#region //参数
string key = Json.key;
string key2 = Json.key2;
#endregion
#region 数据操作
AjaxResult result = new AjaxResult();
Mod_TS_USER modUser = GetUserID();
Mod_TS_CUSTFILE modCustfile = ts_custfile.GetModel(modUser.C_CUST_ID);
DataTable dt = tb_matrl_main.Get_PROD_NAME_StlGrd(modCustfile.C_NO, key, key2).Tables[0];
result.Code = DoResult.Success;
result.Result = SerializationHelper.Dtb2Json(dt);
#endregion
return(result);
}
public AjaxResult ConsultEdit([FromBody] dynamic Json)
{
#region //接收参数
string ID = Json.ID; //主键
string QuestID = Json.QuestID; //技术问题ID
string Stl_Grd = Json.Stl_Grd; //钢种
string UseDesc = Json.UseDesc; //用途及工艺
string Remark = Json.Remark; //问题描述
#endregion
#region //数据操作
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
Mod_TS_USER modUser = GetUserID();
Mod_TMC_TECH_CONSULT mod = tmc_tech_consult.GetModel(ID);
if (mod.N_STATE == 0)
{
mod.C_QUEST_ID = QuestID;
mod.C_STL_GRD = Stl_Grd;
mod.C_USE_DESC = UseDesc;
mod.C_REMARK = Remark;
mod.C_EMP_ID = modUser.C_ID;
mod.C_EMP_NAME = modUser.C_NAME;
if (tmc_tech_consult.Update(mod))
{
result.Result = "保存成功";
}
else
{
result.Result = "保存失败";
}
}
else
{
result.Result = "当前状态咱不可修改";
}
#endregion
return(result);
}
public AjaxResult GetChat([FromBody] dynamic Json)
{
#region //接收参数
string Count = Json.Count; //条数
string LastDT = Json.LastDT; //最后一条时间
string FristDT = Json.FristDT; //第一条时间
#endregion
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
#region//数据操作
Mod_TS_USER modUser = GetUserID();
DataTable dt = tmc_chat.GetChatList2(modUser.C_ID, LastDT, FristDT, Count).Tables[0];
result.Result = SerializationHelper.Dtb2Json(dt);
#endregion
return(result);
}
//个人信息保存
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
Mod_TS_USER mod = ts_user.GetModel(ltlUserID.Text);
mod.C_NAME = txtName.Value;
mod.C_PHONE = txtTel.Value;
mod.C_MOBILE = txtPhone.Value;
mod.C_MOBILE2 = txtFax.Value;
mod.C_EMAIL = txtEMail.Value;
if (ts_user.UpdateInfo(mod))
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('保存成功');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('" + ex.ToString() + "');", true);
}
}
public AjaxResult ChatAdd([FromBody] dynamic Json)
{
#region //接收参数
string Content = Json.Content; //发送内容
#endregion
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
#region //数据操作
DataRow dr = tmc_chat_emp.GetChatEmp();
if (dr != null)
{
Mod_TS_USER modUser = GetUserID();
string fid = dr["c_user_id"].ToString();
Mod_TMC_CHAT mod = new Mod_TMC_CHAT();
mod.C_UID = modUser.C_ID;
mod.C_FID = fid;
mod.C_CONTENT = Content;
mod.D_DT = DateTime.Now;
if (tmc_chat.Add(mod))
{
result.Result = "提交成功";
}
else
{
result.Result = "提交失败";
}
}
else
{
result.Result = "提交失败";
}
#endregion
return(result);
}
public AjaxResult GetBook([FromBody] dynamic Json)
{
AjaxResult result = new AjaxResult();
#region //接收参数
string cust_name = Json.cust_name; //客户
string area = Json.area; //区域
string type = Json.type; //0：走访用户，1来访客户
string start_dt = Json.start_dt; //走访开始时间
string end_dt = Json.end_dt; //走访结束时间
#endregion
#region //数据操作
Mod_TS_USER modUser = GetUserID();
result.Code = DoResult.Success;
DataTable dt = tmc_cust_book.GetList(cust_name, area, type, start_dt, end_dt, modUser.C_ID).Tables[0];
result.Result = JsonConvert.SerializeObject(dt);
#endregion
return(result);
}
public AjaxResult GetAffair([FromBody] dynamic Json)
{
#region //参数
string title = Json.title; //文件名称
string status = Json.status; //状态0待办，1已办
string flowID = Json.flowID; //工作流ID
string startTime = Json.startTime; //开始时间
string endTime = Json.endTime; //结束时间
#endregion
#region //数据操作
Mod_TS_USER modUser = GetUserID();
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
result.Result = SerializationHelper.Dtb2Json(tmf_fileinfo.GetFileTran(title, status, flowID, startTime, endTime, modUser.C_ID).Tables[0]);
#endregion
return(result);
}
public AjaxResult GetOldOrder([FromBody] dynamic Json)
{
#region //参数
string ConNo = Json.ConNo; //合同号
string StlGrd = Json.StlGrd; //钢种
string StartTime = Json.StartTime; //签署开始时间
string EndTime = Json.EndTime; //签署结束时间
#endregion
#region //数据操作
Mod_TS_USER modUser = GetUserID();
Mod_TS_CUSTFILE mod = ts_custfile.GetModel(modUser.C_CUST_ID);
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
result.Result = SerializationHelper.Dtb2Json(tmo_condetails.GetConOrderList(ConNo, "", StlGrd, StartTime, EndTime, mod.C_NO).Tables[0]);
#endregion
return(result);
}
public AjaxResult ConsultList([FromBody] dynamic Json)
{
#region //接收参数
string QuestID = Json.QuestID; //技术问题ID
int PageSize = Json.PageSize; //显示页数
int StartIndex = Json.StartIndex; //起始页数
string StartDT = Json.StartDT; //开始时间
string EndDT = Json.EndDT; //结束时间
string State = Json.State; //状态
#endregion
#region //数据操作
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
Mod_TS_USER mod = GetUserID();
DataTable dt = tmc_tech_consult.GetListByPage(PageSize, StartIndex, QuestID, mod.C_ID, StartDT, EndDT, "", State).Tables[0];
result.Result = SerializationHelper.Dtb2Json(dt);
#endregion
return(result);
}
public AjaxResult GetOrderTail([FromBody] dynamic Json)
{
#region //参数
string ConNO = Json.ConNO; //合同号
string StartDate = Json.StartDate; //开始时间
string EndDate = Json.EndDate; //结束时间
#endregion
#region //数据操作
AjaxResult result = new AjaxResult();
Mod_TS_USER modUser = GetUserID();
if (modUser != null)
{
Mod_TS_CUSTFILE mod = ts_custfile.GetModel(modUser.C_CUST_ID);
result.Code = DoResult.Success;
result.Result = SerializationHelper.Dtb2Json(tmo_order.GetOrderJL(ConNO, StartDate, EndDate, mod.C_NO).Tables[0]);
}
#endregion
return(result);
}
public AjaxResult ConList([FromBody] dynamic Json)
{
#region //参数
int PageSize = Json.PageSize; //显示页数
int StartIndex = Json.StartIndex; //起始页数
string ConNo = Json.ConNo; //合同号
string ConName = Json.ConName; //合同名称
string StartDT = Json.StartDT; //签署开始时间
string EndDT = Json.EndDT; //签署结束时间
string ConType = Json.ConType; //合同类型ID
#endregion
#region //数据操作
AjaxResult result = new AjaxResult();
Mod_TS_USER modUser = GetUserID();
DataTable dt = DataSetHelper.SplitDataSet(tmo_con.GetConList(ConNo, ConName, StartDT, EndDT, modUser.C_ID, ConType, ""), PageSize, StartIndex).Tables[0];
result.Code = DoResult.Success;
result.Result = JsonConvert.SerializeObject(dt);
#endregion
return(result);
}
public AjaxResult ConsultAdd([FromBody] dynamic Json)
{
#region //接收参数
string QuestID = Json.QuestID; //技术问题ID
string Stl_Grd = Json.Stl_Grd; //钢种
string UseDesc = Json.UseDesc; //用途及工艺
string Remark = Json.Remark; //问题描述
#endregion
#region //数据操作
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
Mod_TS_USER modUser = GetUserID();
Mod_TS_CUSTFILE modcustfile = ts_custfile.GetModel(modUser.C_CUST_ID);
Mod_TMC_TECH_CONSULT mod = new Mod_TMC_TECH_CONSULT();
mod.C_QUEST_ID = QuestID;
mod.C_CUST_NAME = modcustfile.C_NAME;
mod.C_CUST_CODE = modcustfile.C_NO;
mod.C_STL_GRD = Stl_Grd;
mod.C_USE_DESC = UseDesc;
mod.C_REMARK = Remark;
mod.C_EMP_ID = modUser.C_ID;
mod.C_EMP_NAME = modUser.C_NAME;
if (tmc_tech_consult.Add(mod))
{
result.Result = "提交成功";
}
else
{
result.Result = "提交失败";
}
#endregion
return(result);
}
public AjaxResult GetConBack([FromBody] dynamic Json)
{
#region //参数
string fileID = Json.fileID; //文件ID
string content = Json.content; //批语
#endregion
#region //数据操作
string jg = string.Empty;
Mod_TMF_FILEINFO modFile = tmf_fileinfo.GetModel(fileID);
Mod_TS_USER modUser = GetUserID();
#region //驳回最后步骤操作
Mod_ApproveCon mod = new Mod_ApproveCon();
mod.UPSTEPID = "0";
mod.FILE_STATUS = "1";
mod.FILEID = fileID;
mod.STEPID = modFile.C_STEP_ID;
mod.CON_STATUS = "0";
mod.CON_NO = modFile.C_TASK_ID;
mod.C_EMP_ID = modUser.C_ID;
if (tmf_fileinfo.UpdateBackLastSetp(mod))
{
jg = ProAdd("驳回", content, modUser.C_NAME, modUser.C_ID, modFile.C_STEP_ID, fileID);
}
#endregion
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
result.Result = jg;
#endregion
return(result);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TS_USER GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_NAME,C_ACCOUNT,C_PASSWORD,C_EMAIL,C_MOBILE,N_TYPE,N_STATUS,C_DESC,D_LASTLOGINTIME,C_EMP_ID,C_EMP_NAME,D_MOD_DT,C_MOBILE2,C_PHONE,C_SHORTNAME,C_CUST_ID,C_TOKEN_ID,C_CJNAME,C_CJINTRO,C_STL_GRD,C_LEGALREPRES,C_CGJCR,C_JOB,C_JCTEL,C_ADDRESS,C_AREA,C_MANAGER,N_TYPE from TS_USER ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TS_USER model = new Mod_TS_USER();
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>
/// 发送转库单信息给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);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
if (vUser != null)
{
try
{
ltlUserID.Text = vUser.Id;
ltlCustID.Text = vUser.CustId;
hCustID.Value = vUser.CustId;
BindArea();
Mod_TS_USER mod = ts_user.GetModel(vUser.Id);
if (mod != null)
{
#region //基本信息
txtUserName.Value = mod.C_ACCOUNT;
txtName.Value = mod.C_NAME;
txtPhone.Value = mod.C_MOBILE;
txtFax.Value = mod.C_MOBILE2;
txtTel.Value = mod.C_PHONE;
txtEMail.Value = mod.C_EMAIL;
#endregion
#region //余额
DataTable dt = ts_custfile.GetCusetMoney(vUser.CustId).Tables[0];
if (dt.Rows.Count > 0)
{
ltltime.Text = Convert.ToDateTime(dt.Rows[0]["TS"].ToString()).ToString();
txtMoney.Value = decimal.Parse(dt.Rows[0]["KHYE"].ToString()).ToString("###,##0.00");
}
#endregion
#region //公司档案
if (!string.IsNullOrEmpty(mod.C_CJNAME))
{
txtC_CJNAME.Text = mod.C_CJNAME;
}
else
{
if (!string.IsNullOrEmpty(ltlCustID.Text))
{
Mod_TS_CUSTFILE modCustFile = ts_custfile.GetModel(ltlCustID.Text);
txtC_CJNAME.Text = modCustFile.C_NAME;
}
}
txtC_CJINTRO.Text = mod.C_CJINTRO;
txtC_STL_GRD.Text = mod.C_STL_GRD;
txtC_LEGALREPRES.Text = mod.C_LEGALREPRES;
txtC_CGJCR.Text = mod.C_CGJCR;
txtC_JOB.Text = mod.C_JOB;
txtC_JCTEL.Text = mod.C_JCTEL;
txtC_ADDRESS.Text = mod.C_ADDRESS;
dropArea.SelectedIndex = dropArea.Items.IndexOf(dropArea.Items.FindByText(mod.C_AREA));
txtC_MANAGER.Text = mod.C_MANAGER;
#endregion
}
}
catch (Exception ex)
{
WebMsg.MessageBox(ex.Message);
}
}
}
}
/// <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());
}
}
/// <summary>
/// 发送完工报告给NC
/// </summary>
/// <param name="xmlFileName">xml完整路径</param>
/// <param name="c_stove">炉号</param>
/// <returns></returns>
public bool SendXml_SLAB_A4(string xmlFileName, string c_stove, string strUserID)
{
try
{
string urlname = "GPWG" + c_stove + ".XML";//XML名称
string url = xmlFileName + "\\NCXML";
if (!Directory.Exists(url))
{
Directory.CreateDirectory(url);
}
DataTable dt = dal_slab_mes.GetList("", "", c_stove, "", "全部").Tables[0];
Mod_TSC_SLAB_MAIN mod_slab_main = dal_slab_main.GetModel_Stove_Trans(c_stove); //钢坯实绩
Mod_TB_MATRL_MAIN mod_mater_main = dal_mater_main.GetModel(mod_slab_main.C_MAT_CODE); //物料主表
Mod_TS_USER mod_ts_user = dal_user.GetModel(strUserID); //用户主表
Mod_TPB_SLABWH mod_SLABWH = dal_slabwh.GetModel_Interface(mod_slab_main.C_SLABWH_CODE); //库存表
Mod_TB_STD_CONFIG mod_std_config = dal_std_config.GetModel_Interface(mod_slab_main.C_STD_CODE, mod_slab_main.C_STL_GRD); // 自由项
if (dt == null)
{
return(false);
}
if (mod_slab_main == null)
{
return(false);
}
if (mod_mater_main == null)
{
return(false);
}
if (mod_ts_user == null)
{
return(false);
}
if (mod_SLABWH == null)
{
return(false);
}
if (mod_std_config == null)
{
return(false);
}
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", "AM");
root.SetAttribute("filename", "");
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", mod_slab_main.C_STOVE);
#endregion
root.AppendChild(bill);
XmlNode head = xmlDoc.CreateNode(XmlNodeType.Element, "bill_head", null);
#region //表头_order_head
CreateNode(xmlDoc, head, "zdrid", "08908"); //制单人 （mod_ts_user.C_ACCOUNT）
CreateNode(xmlDoc, head, "rq", Convert.ToDateTime(dt.Rows[0]["生产时间"].ToString()).ToString("yyyy-MM-dd")); //日期
CreateNode(xmlDoc, head, "sj", Convert.ToDateTime(dt.Rows[0]["生产时间"].ToString()).ToString("HH:mm:ss")); //时间
CreateNode(xmlDoc, head, "gzzxbmid", dt.Rows[0]["连铸代码"].ToString()); //工作中心编码ID
CreateNode(xmlDoc, head, "scbmid", ""); //生产部门ID
#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, "pch", mod_slab_main.C_STOVE); //批次号
CreateNode(xmlDoc, item, "scddh", ""); //生产订单号
CreateNode(xmlDoc, item, "wlbmid", mod_mater_main.C_PK_INVMANDOC); //物料编码ID（C_PK_INVMANDOC）
CreateNode(xmlDoc, item, "jldwid", mod_mater_main.C_PK_MEASDOC); //计量单位ID
CreateNode(xmlDoc, item, "gzzxid", dt.Rows[0]["连铸主键"].ToString()); //工作中心ID
CreateNode(xmlDoc, item, "ccxh", mod_slab_main.C_STOVE); //产出序号-炉号
CreateNode(xmlDoc, item, "gxh", ""); //工序号
CreateNode(xmlDoc, item, "pk_produce", ""); //物料PK
CreateNode(xmlDoc, item, "ksrq", Convert.ToDateTime(dt.Rows[0]["计划开始时间"].ToString()).ToString("yyyy-MM-dd")); //开始日期
CreateNode(xmlDoc, item, "kssj", Convert.ToDateTime(dt.Rows[0]["计划开始时间"].ToString()).ToString("HH:mm:ss")); //开始时间
CreateNode(xmlDoc, item, "jsrq", Convert.ToDateTime(dt.Rows[0]["计划结束时间"].ToString()).ToString("yyyy-MM-dd")); //结束日期
CreateNode(xmlDoc, item, "jssj", Convert.ToDateTime(dt.Rows[0]["计划结束时间"].ToString()).ToString("HH:mm:ss")); //结束时间
CreateNode(xmlDoc, item, "hgsl", dt.Rows[0]["重量"].ToString()); //合格数量
CreateNode(xmlDoc, item, "fhgsl", dt.Rows[0]["支数"].ToString()); //辅合格数量
CreateNode(xmlDoc, item, "sflfcp", "N"); //是否联副产品
CreateNode(xmlDoc, item, "sffsgp", "N"); //是否发生改判
CreateNode(xmlDoc, item, "zdy1", ""); //自定义项1
CreateNode(xmlDoc, item, "zdy2", ""); //自定义项2
CreateNode(xmlDoc, item, "zdy3", ""); //自定义项3
CreateNode(xmlDoc, item, "zdy4", ""); //自定义项4
CreateNode(xmlDoc, item, "zdy5", ""); //自定义项5
CreateNode(xmlDoc, item, "freeitemvalue1", mod_std_config.C_ZYX1);
CreateNode(xmlDoc, item, "freeitemvalue2", mod_std_config.C_ZYX2);
CreateNode(xmlDoc, item, "freeitemvalue3", "");
CreateNode(xmlDoc, item, "freeitemvalue4", "");
CreateNode(xmlDoc, item, "freeitemvalue5", dt.Rows[0]["C_PLAN_ID"].ToString()); //PCI计划订单主键
CreateNode(xmlDoc, item, "pk_corp", ""); //公司编码
CreateNode(xmlDoc, item, "gcbm", ""); //工厂
#endregion
body.AppendChild(item);
xmlDoc.Save(url + "\\" + urlname);
List <string> parem = dalSendNC.SendXML(url + "\\" + urlname);
if (parem[0] == "1")
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
