protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserID = theUserManager.getUserId();
if (string.IsNullOrEmpty(Request.QueryString["rmesid"]))
{
return;
}
rmesID = Request.QueryString["rmesid"].ToString();
BomExchangeEntity bomRule = db.First <BomExchangeEntity>("where rmes_id=@0", rmesID);
oldBom = bomRule.ITEM_CODE_FROM;
oldName = bomRule.ITEM_NAME_FROM;
newBom = bomRule.ITEM_CODE_TO;
newName = bomRule.ITEM_NAME_TO;
TextOldBOM.Text = oldBom;
TextOldName.Text = oldName;
TextNewBOM.Text = newBom;
TextNewName.Text = newName;
string sql = "select t.project_code,t.project_code||'-'||t.project_name SHOWNAME from data_project t "
+ " where t.status='Y' and exists(select distinct a.project_code from data_xk_oldbom a where a.item_code in"
+ " ( '" + oldBom + "','" + newBom + "') and t.project_code = a.project_code) order by t.project_code";
comboProject.DataSource = dc.GetTable(sql);
comboProject.DataBind();
}
protected void butConfirm_Click(object sender, EventArgs e)
{
string project, oldBom, oldName, newBom, newName;
project = comboProject.SelectedItem.Value.ToString();
oldBom = TextOldBOM.Text.Trim();
oldName = TextOldName.Text.Trim();
newBom = TextNewBOM.Text.Trim();
newName = TextNewName.Text.Trim();
string sql = "select * from data_xk_bom_exchange where item_code_from='" + oldBom + "' and item_code_to='" + newBom + "' and project_code='" + project + "' and enable_flag='Y'";
if (dc.GetTable(sql).Rows.Count != 0)
{
lblMessage.Text = "已存在相同物料替换规则！原物料代码：" + oldBom + "；新代码：" + newBom + "";
TextOldBOM.Text = "";
TextOldName.Text = "";
TextNewBOM.Text = "";
TextNewName.Text = "";
return;
}
BomExchangeEntity bomRule = new BomExchangeEntity
{
PROJECT_CODE = project,
ITEM_CODE_FROM = oldBom,
ITEM_NAME_FROM = oldName,
ITEM_CODE_TO = newBom,
ITEM_NAME_TO = newName,
CREAT_TIME = DateTime.Now,
ENABLE_FLAG = "Y",
USER_ID = theUserID,
USE_COUNT = 0,
WORK_CODE = ""
};
string id = db.Insert(bomRule).ToString();
TextOldBOM.Text = "";
TextOldName.Text = "";
TextNewBOM.Text = "";
TextNewName.Text = "";
lblMessage.Text = "新增物料替换规则成功！原物料代码：" + oldBom + "；新代码：" + newBom + "";
}
protected void butRestore_Click(object sender, EventArgs e)
{
string project, oldBom, oldName, newBom, newName;
project = comboProject.SelectedItem.Value.ToString();
oldBom = ComboItemFrom.SelectedItem.Value.ToString();
oldName = TextOldName.Text.Trim();
newBom = TextNewBOM.Text.Trim();
newName = TextNewName.Text.Trim();
BomExchangeEntity bomRule = db.First <BomExchangeEntity>("where item_code_from=@0 and ENABLE_FLAG='Y'", oldBom);
rmesID = bomRule.RMES_ID;
//还原物料
int rows = dc.ExeSql("update DATA_XK_OLDBOM set ITEM_CODE='" + oldBom + "', ITEM_NAME='" + oldName + "' where ITEM_CODE = '" + newBom + "' and ITEM_NAME='" + newName + "' and PROJECT_CODE = '" + project + "'");
//写入事件日志
string IPaddress = GetIP();
KeyWorklogEntity log = new KeyWorklogEntity
{
CREATE_TIME = DateTime.Now,
USER_ID = theUserID,
USER_IP = IPaddress,
WORK_TYPE = "物料替换",
DELETE_FLAG = "N",
CONTENT_LOG1 = "从物料代码：" + newBom,
CONTENT_LOG2 = "还原成：" + oldBom,
CONTENT_LOG3 = "合同号：" + project + "；替换规则ID：" + rmesID,
AFFECT_ROWS = rows
};
string rmesId = db.Insert(log).ToString();
ComboItemFrom.SelectedIndex = -1;
TextOldName.Text = "";
TextNewBOM.Text = "";
TextNewName.Text = "";
lblMessage.Text = "物料还原成功！原物料代码：" + oldBom + "；新代码：" + newBom + "；请继续...";
}
protected void ASPxCbSubmit_Callback(object source, DevExpress.Web.ASPxCallback.CallbackEventArgs e)
{
char[] charSeparators = new char[] { ',' };
string[] collection = e.Parameter.Split(charSeparators);
string p = collection[0].ToString();
string code = collection[1].ToString();
string strName;
switch (p)
{
case "checkValue":
BomExchangeEntity bomRule = db.First <BomExchangeEntity>("where item_code_from=@0 and ENABLE_FLAG='Y'", code);
strName = bomRule.ITEM_NAME_FROM + "," + bomRule.ITEM_CODE_TO + "," + bomRule.ITEM_NAME_TO;
rmesID = bomRule.RMES_ID;
e.Result = "checkOK," + strName;
break;
}
}
