/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TB_STD_CONFIG GetModel_Interface_Trans(string C_STD_CODE, string C_STL_GRD)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_STD_ID,C_CUST_TECH_PROT,C_ZYX1,C_ZYX2,C_STL_GRD,C_STD_CODE,C_STEEL_SIGN,C_EMP_ID,D_MOD_DT,C_REMARK,D_START_DATE,D_END_DATE,N_STATUS,C_CUST_NO,C_CUST_NAME from TB_STD_CONFIG ");
strSql.Append(" where C_STD_CODE=:C_STD_CODE and C_STL_GRD=:C_STL_GRD ");
OracleParameter[] parameters =
{
new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_STD_CODE;
parameters[1].Value = C_STL_GRD;
Mod_TB_STD_CONFIG model = new Mod_TB_STD_CONFIG();
DataSet ds = TransactionHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (tb_std_config.Exists(txtstlgrd.Value, txtcustno.Value, txtcust_tech_prot.Text))
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('当前客户钢种协议号重复');", true);
}
else
{
Mod_TB_STD_CONFIG mod = new Mod_TB_STD_CONFIG();
mod.C_STD_CODE = dropstd.SelectedItem.Text;
mod.C_STD_ID = dropstd.SelectedItem.Value;
mod.C_CUST_TECH_PROT = txtcust_tech_prot.Text;
mod.C_ZYX1 = dropzyx1.SelectedItem.Text;
mod.C_ZYX2 = dropzyx2.SelectedItem.Text;
mod.C_STL_GRD = txtstlgrd.Value;
mod.C_EMP_ID = ltlempid.Text;
mod.C_CUST_NO = txtcustno.Value;
mod.C_CUST_NAME = txtcustname.Value;
mod.C_ZZS = dropzzs.SelectedItem.Text;
if (tb_matrl_main.InsertFree(mod))
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('保存成功');", true);
}
}
}
catch (Exception ex)
{
WebMsg.MessageBox(ex.Message);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TB_STD_CONFIG GetModel(string C_ID)
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_STD_ID,C_CUST_TECH_PROT,C_ZYX1,C_ZYX2,C_STL_GRD,C_STD_CODE,C_STEEL_SIGN,C_EMP_ID,D_MOD_DT,C_REMARK,D_START_DATE,D_END_DATE,N_STATUS from TB_STD_CONFIG ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TB_STD_CONFIG model = new Mod_TB_STD_CONFIG();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
//客户协议标记
protected void btnflag_Click(object sender, EventArgs e)
{
try
{
List <Mod_TB_STD_CONFIG> list = new List <Mod_TB_STD_CONFIG>();
for (int i = 0; i < rptList.Items.Count; i++)
{
HtmlInputCheckBox cbxselect = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxselect");
Literal ltlflag = (Literal)rptList.Items[i].FindControl("ltlflag");
if (cbxselect.Checked)
{
Mod_TB_STD_CONFIG mod = new Mod_TB_STD_CONFIG();
mod.C_ID = cbxselect.Value;
mod.C_FLAG = ltlflag.Text == "N" ? "Y" : "N";
list.Add(mod);
}
}
if (tb_std_config.UpdateFlag(list))
{
WebMsg.MessageBox("设置成功");
GetListBind();
}
}
catch (Exception ex)
{
WebMsg.MessageBox(ex.Message);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TB_STD_CONFIG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TB_STD_CONFIG(");
strSql.Append("C_STD_ID,C_CUST_TECH_PROT,C_ZYX1,C_ZYX2,C_STL_GRD,C_STD_CODE,C_STEEL_SIGN,C_EMP_ID,D_MOD_DT,C_REMARK,D_START_DATE,D_END_DATE,N_STATUS,C_CUST_NO,C_CUST_NAME)");
strSql.Append(" values (");
strSql.Append(":C_STD_ID,:C_CUST_TECH_PROT,:C_ZYX1,:C_ZYX2,:C_STL_GRD,:C_STD_CODE,:C_STEEL_SIGN,:C_EMP_ID,:D_MOD_DT,:C_REMARK,:D_START_DATE,:D_END_DATE,:N_STATUS,:C_CUST_NO,:C_CUST_NAME)");
OracleParameter[] parameters =
{
new OracleParameter(":C_STD_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_TECH_PROT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX1", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STEEL_SIGN", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":D_START_DATE", OracleDbType.Date),
new OracleParameter(":D_END_DATE", OracleDbType.Date),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_CUST_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_NAME", OracleDbType.Varchar2, 200)
};
parameters[0].Value = model.C_STD_ID;
parameters[1].Value = model.C_CUST_TECH_PROT;
parameters[2].Value = model.C_ZYX1;
parameters[3].Value = model.C_ZYX2;
parameters[4].Value = model.C_STL_GRD;
parameters[5].Value = model.C_STD_CODE;
parameters[6].Value = model.C_STEEL_SIGN;
parameters[7].Value = model.C_EMP_ID;
parameters[8].Value = model.D_MOD_DT;
parameters[9].Value = model.C_REMARK;
parameters[10].Value = model.D_START_DATE;
parameters[11].Value = model.D_END_DATE;
parameters[12].Value = model.N_STATUS;
parameters[13].Value = model.C_CUST_NO;
parameters[14].Value = model.C_CUST_NAME;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除客户协议
/// </summary>
/// <param name="listID"></param>
/// <param name="status"></param>
/// <returns></returns>
public bool DelList(List <string> listID)
{
ArrayList arraySql = new ArrayList();
for (int i = 0; i < listID.Count; i++)
{
Mod_TB_STD_CONFIG mod = GetModel(listID[i].ToString());
if (mod != null)
{
}
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from tb_std_config where C_ID='" + listID[i].ToString() + "'");
arraySql.Add(strSql.ToString());
}
return(DbHelperOra.ExecuteSqlTran(arraySql));
}
private void btn_del_Click(object sender, EventArgs e)
{
try
{
if (DialogResult.No == MessageBox.Show("是否确认停用？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1))
{
return;
}
int selectedNum = this.gv_config.SelectedRowsCount;
int commitNum = 0; //停用记录数量
int failtNum = 0; //停用失败数量
int[] rownumber = this.gv_config.GetSelectedRows(); //获取选中行号数组；
for (int i = 0; i < rownumber.Length; i++)
{
int selectedHandle = rownumber[i];
string strID = this.gv_config.GetRowCellValue(selectedHandle, "C_ID").ToString();
Mod_TB_STD_CONFIG model = bll_TB_STD_CONFIG.GetModel(strID);
model.N_STATUS = 0;
model.C_EMP_ID = RV.UI.UserInfo.userID;
model.D_MOD_DT = RV.UI.ServerTime.timeNow();
model.D_END_DATE = RV.UI.ServerTime.timeNow();
bool update = bll_TB_STD_CONFIG.Update(model);
if (update)
{
commitNum = commitNum + 1;
}
else
{
failtNum = failtNum + 1;
}
}
MessageBox.Show("选择" + selectedNum.ToString() + "条记录，停用" + commitNum.ToString() + "条记录！");
Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "停用客户协议自由项匹配数据");//添加操作日志
Query();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TB_STD_CONFIG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TB_STD_CONFIG set ");
strSql.Append("C_ID=:C_ID,");
strSql.Append("C_STD_ID=:C_STD_ID,");
strSql.Append("C_CUST_TECH_PROT=:C_CUST_TECH_PROT,");
strSql.Append("C_ZYX1=:C_ZYX1,");
strSql.Append("C_ZYX2=:C_ZYX2,");
strSql.Append("C_STL_GRD=:C_STL_GRD,");
strSql.Append("C_STD_CODE=:C_STD_CODE,");
strSql.Append("C_STEEL_SIGN=:C_STEEL_SIGN,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("D_START_DATE=:D_START_DATE,");
strSql.Append("D_END_DATE=:D_END_DATE,");
strSql.Append("N_STATUS=:N_STATUS");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STD_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_TECH_PROT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX1", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STEEL_SIGN", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":D_START_DATE", OracleDbType.Date),
new OracleParameter(":D_END_DATE", OracleDbType.Date),
new OracleParameter(":N_STATUS", OracleDbType.Int32, 1)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_STD_ID;
parameters[2].Value = model.C_CUST_TECH_PROT;
parameters[3].Value = model.C_ZYX1;
parameters[4].Value = model.C_ZYX2;
parameters[5].Value = model.C_STL_GRD;
parameters[6].Value = model.C_STD_CODE;
parameters[7].Value = model.C_STEEL_SIGN;
parameters[8].Value = model.C_EMP_ID;
parameters[9].Value = model.D_MOD_DT;
parameters[10].Value = model.C_REMARK;
parameters[11].Value = model.D_START_DATE;
parameters[12].Value = model.D_END_DATE;
parameters[13].Value = model.N_STATUS;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TB_STD_CONFIG DataRowToModel(DataRow row)
{
Mod_TB_STD_CONFIG model = new Mod_TB_STD_CONFIG();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_STD_ID"] != null)
{
model.C_STD_ID = row["C_STD_ID"].ToString();
}
if (row["C_CUST_TECH_PROT"] != null)
{
model.C_CUST_TECH_PROT = row["C_CUST_TECH_PROT"].ToString();
}
if (row["C_ZYX1"] != null)
{
model.C_ZYX1 = row["C_ZYX1"].ToString();
}
if (row["C_ZYX2"] != null)
{
model.C_ZYX2 = row["C_ZYX2"].ToString();
}
if (row["C_STL_GRD"] != null)
{
model.C_STL_GRD = row["C_STL_GRD"].ToString();
}
if (row["C_STD_CODE"] != null)
{
model.C_STD_CODE = row["C_STD_CODE"].ToString();
}
if (row["C_STEEL_SIGN"] != null)
{
model.C_STEEL_SIGN = row["C_STEEL_SIGN"].ToString();
}
if (row["C_EMP_ID"] != null)
{
model.C_EMP_ID = row["C_EMP_ID"].ToString();
}
if (row["D_MOD_DT"] != null && row["D_MOD_DT"].ToString() != "")
{
model.D_MOD_DT = DateTime.Parse(row["D_MOD_DT"].ToString());
}
if (row["C_REMARK"] != null)
{
model.C_REMARK = row["C_REMARK"].ToString();
}
if (row["D_START_DATE"] != null && row["D_START_DATE"].ToString() != "")
{
model.D_START_DATE = DateTime.Parse(row["D_START_DATE"].ToString());
}
if (row["D_END_DATE"] != null && row["D_END_DATE"].ToString() != "")
{
model.D_END_DATE = DateTime.Parse(row["D_END_DATE"].ToString());
}
if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "")
{
model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString());
}
}
return(model);
}
/// <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);
}
}
/// <summary>
/// 添加客户自由匹配项
/// </summary>
/// <param name="mod"></param>
/// <returns></returns>
public bool InsertFree(Mod_TB_STD_CONFIG mod)
{
return(dal.InsertFree(mod));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TB_STD_CONFIG model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TB_STD_CONFIG model)
{
return(dal.Add(model));
}
private void btn_Save_Click(object sender, EventArgs e)
{
if (cbo_gz.EditValue.ToString() == "")
{
MessageBox.Show("请选择钢种！");
this.cbo_gz.Focus();
return;
}
if (cbo_zyx1.Text.Trim() == "")
{
MessageBox.Show("请选择自由项1");
this.cbo_zyx1.Focus();
return;
}
if (cbo_zyx2.Text.Trim() == "")
{
MessageBox.Show("请输自由项2");
this.cbo_zyx2.Focus();
return;
}
Mod_TB_STD_CONFIG model = new Mod_TB_STD_CONFIG();
model.C_STL_GRD = cbo_gz.EditValue.ToString();
model.C_CUST_TECH_PROT = txt_khxy.Text;
model.C_STEEL_SIGN = txt_lgjh.Text;
model.C_STD_CODE = cbo_zzbz.EditValue.ToString();
model.C_ZYX1 = cbo_zyx1.EditValue.ToString();
model.C_ZYX2 = cbo_zyx2.EditValue.ToString();
model.C_EMP_ID = RV.UI.UserInfo.userID;
model.C_CUST_NO = this.lbl_cust_no.Text;
model.C_CUST_NAME = this.cbo_cust_name.Text;
model.C_REMARK = txt_Remark.Text.Trim();
try
{
#region 检测是否重复添加
System.Collections.Hashtable ht = new System.Collections.Hashtable();
ht.Add("C_STL_GRD", model.C_STL_GRD);
ht.Add("N_STATUS", "1");
ht.Add("C_CUST_TECH_PROT", model.C_STEEL_SIGN);
ht.Add("C_STD_CODE", model.C_STD_CODE);
if (Common.CheckRepeat.CheckTable("TB_STD_CONFIG", ht) > 0)
{
MessageBox.Show("已存在,不能重复添加！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
#endregion
if (bll_TB_STD_CONFIG.Add(model))
{
Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "添加客户协议和自由项关系");//添加操作日志
MessageBox.Show("保存成功！");
Query();//重新加载仓库信息
return;
}
}
catch (Exception)
{
MessageBox.Show("保存失败！");
}
}
/// <summary>
/// 发送入库实绩给NC
/// </summary>
/// <param name="xmlFileName">xml完整路径</param>
/// <param name="c_stove">炉号</param>
/// <param name="user_id">操作人员</param>
/// <returns></returns>
public bool SendXml_SLAB_46(string xmlFileName, string c_stove, string user_id)
{
try
{
string urlname = "GPRK" + 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(user_id); //用户主表
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); // 自由项
Mod_TMO_ORDER mod_tmo_order = dal_tmo_order.GetModelByORDERNO(mod_slab_main.C_ORD_NO); //订单池
Mod_TQB_CHECKSTATE mod_checkstate = dal_checkstate.GetModelByName(mod_slab_main.C_JUDGE_LEV_ZH, mod_tmo_order.C_XGID); //判定等级
DateTime dt_time = Convert.ToDateTime(mod_slab_main.D_WE_DATE.ToString());
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);
}
if (mod_tmo_order == null)
{
return(false);
}
if (mod_checkstate == 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", "46");
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, "cwarehouseid", mod_SLABWH.C_ID); //仓库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, "cwarehouseid", mod_SLABWH.C_ID); //仓库ID
CreateNode(xmlDoc, item, "taccounttime", mod_slab_main.D_WE_DATE.ToString()); //库房签字时间
CreateNode(xmlDoc, item, "coperatorid", mod_ts_user.C_ID); //制单人
CreateNode(xmlDoc, item, "ccheckstate_bid", mod_checkstate.C_ID); //质量等级
CreateNode(xmlDoc, item, "cworkcenterid", dt.Rows[0]["连铸主键"].ToString()); //工作中心主键/连铸机号
CreateNode(xmlDoc, item, "dbizdate", dt_time.ToString("yyyy-MM-dd")); //业务日期
CreateNode(xmlDoc, item, "vbatchcode", mod_slab_main.C_STOVE); //批次号
CreateNode(xmlDoc, item, "cinvbasid", mod_mater_main.C_PK_INVBASDOC); //存货基本ID
CreateNode(xmlDoc, item, "pk_produce", ""); //介质物料PK
CreateNode(xmlDoc, item, "ninnum", dt.Rows[0]["重量"].ToString()); //实入数量-重量
CreateNode(xmlDoc, item, "ninassistnum", dt.Rows[0]["支数"].ToString()); //实入辅数量-件数
CreateNode(xmlDoc, item, "castunitid", mod_mater_main.C_FJLDW); //辅计量单位ID
CreateNode(xmlDoc, item, "vfree1", mod_std_config.C_ZYX1); //自由项1
CreateNode(xmlDoc, item, "vfree2", mod_std_config.C_ZYX2); //自由项2
CreateNode(xmlDoc, item, "vfree3", ""); //自由项3
CreateNode(xmlDoc, item, "vfree4", ""); //自由项4
CreateNode(xmlDoc, item, "vfree5", ""); //自由项5
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
{
return(false);
}
}
