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