protected void btnDone_Click(object sender, EventArgs e)//
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
//if (opt.GetSegValue("select flow_status from ht_eq_mt_plan where pz_code = '" + txtCode.Text + "'", "flow_status") != "2")
// return;
for (int i = 0; i <= GridView2.Rows.Count - 1; i++)
{
if (((CheckBox)GridView2.Rows[i].FindControl("chk")).Checked)
{
string ID = GridView2.DataKeys[i].Value.ToString();
string query = "update ht_eq_mt_plan_detail set STATUS = '5' where ID = '" + ID + "' and status = '4'";
string log_message = opt.UpDateOra(query) == "Success" ? "确认完成维保计划成功" : "确认完成维保计划失败";
log_message += "--标识:" + ID;
InsertTlog(log_message);
}
}
string alter = opt.GetSegValue("select case when total = done then 1 else 0 end as status from (select count(distinct t.id) as total,count( distinct t1.id) as done from ht_eq_mt_plan_detail t left join ht_eq_mt_plan_detail t1 on t1.id = t.id and t1.status = '5' and t1.is_del = '0' where t.main_id = '" + txtCode.Text + "' and t.is_del = '0')", "status");
if (alter == "1")
{
opt.UpDateOra("update ht_eq_mt_plan set TASK_STATUS = '5' where PZ_CODE = '" + txtCode.Text + "' and TASK_STATUS = '4'");
bindGrid1();
}
bindGrid2(txtCode.Text);
}
protected void btnTrack_Click(object sender, EventArgs e)//
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
//if (opt.GetSegValue("select flow_status from HT_EQ_RP_PLAN where pz_code = '" + txtCode.Text + "'", "flow_status") != "2")
//{
// ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", "$('#dspcthor').hide();", true);
// return;
//}
for (int i = 0; i <= GridView2.Rows.Count - 1; i++)
{
if (((CheckBox)GridView2.Rows[i].FindControl("chk")).Checked)
{
string ID = GridView2.DataKeys[i].Value.ToString();
string query = "update HT_EQ_RP_PLAN_detail set STATUS = '3' where ID = '" + ID + "' and status = '2'";
string log_message = opt.UpDateOra(query) == "Success" ? "下发跟踪维修计划明细成功" : "下发跟踪维修计划明细失败";
log_message += "--标识:" + ID;
InsertTlog(log_message);
}
}
string alter = opt.GetSegValue("select case when total = done then 1 else 0 end as status from (select count(distinct t.id) as total,count( distinct t1.id) as done from HT_EQ_RP_PLAN_detail t left join HT_EQ_RP_PLAN_detail t1 on t1.id = t.id and t1.status >= '3' and t1.is_del = '0' where t.main_id = '" + txtCode.Text + "' and t.is_del = '0')", "status");
if (alter == "1")
{
opt.UpDateOra("update HT_EQ_RP_PLAN set TASK_STATUS = '3' where PZ_CODE = '" + txtCode.Text + "' and TASK_STATUS = '2'");
bindGrid1();
}
bindGrid2(txtCode.Text);
}
//根据产品ID获取工艺标准信息并更新。
protected static void getTechstdd_SQL(string id, string prodcode)
{
MSYS.Web.MateriaService.WsBaseDataInterfaceService service = new MSYS.Web.MateriaService.WsBaseDataInterfaceService();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
// List<string> commandlist = new List<string>();
try
{
techStddInfoVO tech = service.getTechStdById(id);
if (tech != null)
{
tQaTechStdd info = tech.techStddInfo;
string[] seg = { "ID", "TECH_CODE", "TECH_NAME", "STANDARD_VOL", "REMARK", "PROD_CODE", "MODIFY_ID", "MODIFY_TIME", "IS_VALID", "IS_DEL", "E_DATE", "CREATE_ID", "CREATE_DEPT_ID", "CREATE_DATE", "CONTROL_STATUS", "B_DATE" };
string[] value = { id, info.standardCode, info.techStddName, info.standardVol, info.remark, prodcode, info.modifyId, info.modifyTime.ToString("yyyy-MM-dd HH:mm:ss"), info.isValid, info.isDel, info.EDate.ToString("yyyy-MM-dd HH:mm:ss"), info.createId, info.createDept, info.createDate.ToString("yyyy-MM-dd HH:mm:ss"), info.controlStatus, info.BDate.ToString("yyyy-MM-dd HH:mm:ss") };
string temp = opt.getMergeStr(seg, value, 2, "HT_TECH_STDD_CODE");
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
if (tech.techStdDetails != null && tech.techStdDetails.Length > 0)
{
string[] subseg = { "ID", "TECH_CODE", "PARA_CODE", "PARA_TYPE", "REMARK", "VALUE", "UPPER_LIMIT", "LOWER_LIMIT", "UNIT" };
foreach (techStddDetail detail in tech.techStdDetails)
{
if (detail.baseDown != "" && detail.baseUp != "")
{
string stdvalue = detail.centerVal == "" ? ((Convert.ToDouble(detail.baseDown) + Convert.ToDouble(detail.baseUp)) / 2).ToString() : detail.centerVal;
string[] subvalue = { detail.id, info.standardCode, detail.projCode, detail.techParmType, detail.remark, stdvalue, detail.baseUp, detail.baseDown, detail.bzUnit };
temp = opt.getMergeStr(subseg, subvalue, 1, "HT_TECH_STDD_CODE_DETAIL");
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
}
}
/* "TECH_STDD_ID" IS '工艺技术标准主表id';
* "TECH_PRAM_TYPE" IS '技术参数类型';
* "PROJ_CODE" IS '工序项目编码';
* "PARM_STDD" IS '工艺参数或质量标准';
* "CENTER_VAL" IS '中心值';
* "BIAS_UP" IS '上偏值';
* "BIAS_DOWN" IS '下偏值';
* "STDD_VALUE" IS '工艺标准值';
* "PASS_PERCENT" IS '合格率';
* "BZ_UNIT" IS '计量单位';
* "SORT" IS '排序';
* "REMARK" IS '备注';*/
}
}
catch (Exception ee)
{
}
}
protected void btnDel_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string query = "update ht_pub_inspect_process set IS_DEL = '1' where PROCESS_CODE = '" + txtCode.Text + "'";
opt.UpDateOra(query);
query = "update HT_PUB_TECH_PARA set IS_DEL = '1' where substr(PARA_CODE,1,7) = '" + txtCode.Text + "'";
opt.UpDateOra(query);
}
protected void btnModify_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
if (txtCode.Text.Length == 10 && txtCode.Text.Substring(0, 5) == listSection.SelectedValue)
{
string oldepath = opt.GetSegValue("select * from HT_PUB_TECH_PARA where PARA_CODE = '" + txtCode.Text + "'", "PATH_NODE");
string[] seg = { "PARA_CODE", "PARA_NAME", "PARA_UNIT", "PARA_TYPE", "REMARK", "IS_VALID", "CREATE_ID", "CREATE_TIME", "EQUIP_CODE", "SET_TAG", "VALUE_TAG", "BUSS_ID", "PATH_NODE" };
string[] value = { txtCode.Text, txtName.Text, txtUnit.Text, getType(), txtDscrp.Text, Convert.ToInt16(rdValid.Checked).ToString(), ((MSYS.Data.SysUser)Session["User"]).id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), listEquip.SelectedValue, txtSetTag.Text, txtValueTag.Text, listApt.SelectedValue, listPathnode.SelectedValue };
string log_message;
if (opt.MergeInto(seg, value, 1, "HT_PUB_TECH_PARA") == "Success")
{
log_message = "保存参数点成功";
tvHtml = InitTree();
string[] procseg = { };
object[] procvalues = { };
opt.ExecProcedures("Create_Online_month_Report", procseg, procvalues);
if (ckQuaAnalyze.Checked && oldepath != listPathnode.SelectedValue)
{
DataSet points = opt.CreateDataSetOra("select distinct path_code,path_name from ht_pub_para_weight t ");
if (points != null && points.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in points.Tables[0].Rows)
{
if (listPathnode.SelectedValue == "")
{
opt.UpDateOra("insert into ht_pub_para_weight(para_code,path_code,weight,path_name)values ('" + txtCode.Text + "','" + row["path_code"].ToString() + "','0.2','" + row["path_name"].ToString() + "')");
}
else
{
DataSet paras = opt.CreateDataSetOra("select r.para_code,t.pathcode from ht_pub_path_prod t left join ht_pub_path_node s on s.is_del = '0' and s.section_code = t.section_code and substr(t.section_path,s.orders,1) = '0' left join ht_pub_tech_para r on r.path_node = s.id and r.is_del = '0' and r.para_type like '______1%' where t.pathcode = '" + row["path_code"].ToString() + "' and t.is_del = '0' and r.para_code = '" + txtCode.Text + "'");
if (paras != null && paras.Tables[0].Rows.Count > 0)
{
opt.UpDateOra("delete from ht_pub_para_weight where para_code = '" + txtCode.Text + "' and path_code = '" + row["path_code"].ToString() + "'");
}
}
}
}
}
// opt.UpDateOra("delete from ht_pub_para_weight where PATH_CODE = '" + listPathAll.SelectedValue + "'");
// opt.UpDateOra("insert into ht_pub_para_weight ( select r.para_code,t.pathcode,'0',0.2,'test1' from ht_pub_path_prod t left join ht_pub_path_node s on s.is_del = '0' and s.section_code = t.section_code and substr(t.section_path,s.orders,1) = '1' left join ht_pub_tech_para r on r.path_node = s.id and r.is_del = '0' and r.para_type like '______1%' where t.pathcode = '" + listPathAll.SelectedValue + "' and t.is_del = '0' and r.para_code is not null union select r.para_code,'" + listPathAll.SelectedValue + "','0',0.2,'test1' from ht_pub_tech_para r where r.para_type like '______1%' and r.path_node is null and r.is_del = '0')");
}
else
{
log_message = "保存参数点失败";
}
log_message += "--数据详情:" + string.Join(",", value);
ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "sucess", "initTree();alert('" + log_message + "');", true);
InsertTlog(log_message);
}
else
{
ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "message", "alert('请确认工艺参数所属工艺段是否正确')", true);
}
}
protected void btnDelSel2_Click(object sender, EventArgs e)
{
try
{
foreach (GridViewRow row in GridView3.Rows)
{
if (((CheckBox)row.FindControl("chk")).Checked)
{
int index = row.RowIndex;
string planno = GridView3.DataKeys[index].Values[0].ToString();
string section = GridView3.DataKeys[index].Values[1].ToString();
string seg = GridView3.DataKeys[index].Values[2].ToString();
string query = "update HT_PROD_REPORT set " + seg + " = '' where PLANNO = '" + planno + "' and SECTION_CODE = '" + section + "'";
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string log_message = opt.UpDateOra(query) == "Success" ? "删除人工录入记录成功" : "删除人工录入记录失败";
log_message += "--标识--计划号:" + planno + "工艺段:" + section + "字段:" + seg;
InsertTlog(log_message);
}
}
bindGrid3();
}
catch (Exception ee)
{
Response.Write(ee.Message);
}
}
protected void btnDelSel_Click(object sender, EventArgs e)
{
try
{
for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
{
GridViewRow row = GridView1.Rows[i];
if (((CheckBox)row.FindControl("chk")).Checked)
{
string mtr_code = ((DropDownList)row.FindControl("listParaName")).SelectedValue;
string type = ((DropDownList)row.FindControl("listtype")).SelectedValue;
string query = "update HT_QLT_STDD_CODE_DETAIL set IS_DEL = '1' where QLT_CODE = '" + txtCode.Text + "' and PARA_CODE = '" + mtr_code + "' and QLT_TYPE = '" + type + "'";
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string log_message = opt.UpDateOra(query) == "Success" ? "删除质量标准明细成功" : "删除质量标准明细失败";
log_message += "--标识:" + txtCode.Text + ":" + mtr_code;
InsertTlog(log_message);
}
}
bindGrid(txtCode.Text, hideprc.Value);
}
catch (Exception ee)
{
Response.Write(ee.Message);
}
}
}//绑定GridView2数据源
protected void btnGrid2Save_Click(object sender, EventArgs e)//
{
try
{
Button btn = (Button)sender;
GridViewRow row = (GridViewRow)btn.NamingContainer;
int rowIndex = row.RowIndex;
string id = GridView2.DataKeys[rowIndex].Value.ToString();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string[] seg = { "ID", "OLDVALUE", "POINTVALUE", "SAMPLE_TIME", "remark", "STATUS" };
string[] value = { id, ((TextBox)row.FindControl("txtGridOldvalue")).Text, ((TextBox)row.FindControl("txtGridNewvalue")).Text, ((TextBox)row.FindControl("txtGridClbrtime")).Text, ((TextBox)row.FindControl("txtGridremark")).Text, "2" };
string log_message = opt.MergeInto(seg, value, 1, "HT_EQ_MCLBR_PLAN_detail") == "Success" ? "自动校准成功" : "自动校准失败";
log_message += "--详情:" + string.Join(",", value);
InsertTlog(log_message);
string alter = opt.GetSegValue("select case when total = done then 1 else 0 end as status from (select count(distinct t.id) as total,count( distinct t1.id) as done from HT_EQ_MCLBR_PLAN_detail t left join HT_EQ_MCLBR_PLAN_detail t1 on t1.id = t.id and t1.status >= '2' and t1.is_del = '0' where t.main_id = '" + txtCode.Value + "' and t.is_del = '0')", "status");
if (alter == "1")
{
opt.UpDateOra("update HT_EQ_MCLBR_PLAN set TASK_STATUS = '2' where PZ_CODE = '" + txtCode.Value + "' and TASK_STATUS = '1'");
bindGrid1();
}
}
catch (Exception ee)
{
Response.Write(ee.Message);
}
}
}//绑定GridView2数据源
protected void btnGrid2Save_Click(object sender, EventArgs e)//
{
List <string> commandlist = new List <string>();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
foreach (GridViewRow row in GridView2.Rows)
{
int rowIndex = row.RowIndex;
string id = GridView2.DataKeys[rowIndex].Value.ToString();
string status = ((DropDownList)row.FindControl("listGrid2Status")).SelectedValue;
if ((status == "1" || status == "2") && ((TextBox)row.FindControl("txtGridNewvalue")).Text != "")
{
string[] seg = { "ID", "OLDVALUE", "POINTVALUE", "SAMPLE_TIME", "remark", "STATUS" };
string[] value = { id, ((TextBox)row.FindControl("txtGridOldvalue")).Text, ((TextBox)row.FindControl("txtGridNewvalue")).Text, ((TextBox)row.FindControl("txtGridClbrtime")).Text, ((TextBox)row.FindControl("txtGridremark")).Text, "2" };
commandlist.Add(opt.getMergeStr(seg, value, 1, "HT_EQ_MCLBR_PLAN_detail"));
}
}
if (commandlist.Count > 0)
{
string log_message = opt.TransactionCommand(commandlist) == "Success" ? "人工校准录入成功" : "人工校准录入失败";
InsertTlog(log_message);
bindGrid2(txtCode.Value);
string alter = opt.GetSegValue("select case when total = done then 1 else 0 end as status from (select count(distinct t.id) as total,count( distinct t1.id) as done from HT_EQ_MCLBR_PLAN_detail t left join HT_EQ_MCLBR_PLAN_detail t1 on t1.id = t.id and t1.status >= '2' and t1.is_del = '0' where t.main_id = '" + txtCode.Value + "' and t.is_del = '0')", "status");
if (alter == "1")
{
opt.UpDateOra("update HT_EQ_MCLBR_PLAN set TASK_STATUS = '2' where PZ_CODE = '" + txtCode.Value + "' and TASK_STATUS = '1'");
bindGrid1();
}
}
}
protected void btnGrid2Save_Click(object sender, EventArgs e)//
{
List <string> commandlist = new List <string>();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
foreach (GridViewRow row in GridView2.Rows)
{
int rowIndex = row.RowIndex;
string id = GridView2.DataKeys[rowIndex].Value.ToString();
string status = ((DropDownList)row.FindControl("listGrid2Status")).SelectedValue;
if ((status == "1" || status == "2") && ((TextBox)row.FindControl("txtGridpos")).Text != "")
{
string[] seg = { "section", "equipment_id", "position", "pointnum", "luboil", "periodic", "style", "amount", "CREATE_TIME", "MAIN_ID", "STATUS" };
string[] value = { ((DropDownList)row.FindControl("listGridsct")).SelectedValue, ((DropDownList)row.FindControl("listGridEq")).SelectedValue, ((TextBox)row.FindControl("txtGridpos")).Text, ((TextBox)row.FindControl("txtGridnum")).Text, ((TextBox)row.FindControl("txtGridoil")).Text, ((TextBox)row.FindControl("txtGriPric")).Text, ((TextBox)row.FindControl("txtGridStyle")).Text, ((TextBox)row.FindControl("txtGridamount")).Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), hdcode.Value, "2" };
commandlist.Add(opt.UpdateStr(seg, value, "ht_eq_lb_plan_detail", " where ID = '" + id + "'"));
}
}
if (commandlist.Count > 0)
{
string log_message = opt.TransactionCommand(commandlist) == "Success" ? "润滑记录录入成功" : "润滑记录录入失败";
InsertTlog(log_message);
bindGrid2(txtCode.Value);
string alter = opt.GetSegValue("select case when total = done then 1 else 0 end as status from (select count(distinct t.id) as total,count( distinct t1.id) as done from ht_eq_lb_plan_detail t left join ht_eq_lb_plan_detail t1 on t1.id = t.id and t1.status >= '2' and t1.is_del = '0' where t.main_id = '" + hdcode.Value + "' and t.is_del = '0')", "status");
if (alter == "1")
{
opt.UpDateOra("update ht_eq_lb_plan set TASK_STATUS = '2' where PZ_CODE = '" + hdcode.Value + "' and TASK_STATUS = '1'");
bindGrid1();
}
}
}
protected void btnDelSel_Click(object sender, EventArgs e)//删除选中记录
{
try
{
for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
{
if (((CheckBox)GridView1.Rows[i].FindControl("ck")).Checked)
{
string ALM_MSGID = GridView1.DataKeys[i].Value.ToString();
//string query = "update HT_EQ_RP_PLAN_detail set IS_DEL = '1' where ID = '" + ID + "'";
string query = "delete from fixalarms where ALM_MSGID='" + ALM_MSGID + "'";
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
System.Diagnostics.Debug.WriteLine("delete sql" + query);
//opt.CreateDataSetOra(query);
string log_message = opt.UpDateOra(query) == "Success" ? "删除报警成功" : "删除报警信息失败";
log_message += "--标识:" + ID;
InsertTlog(log_message);
}
}
bindGrid1();
}
catch (Exception ee)
{
Response.Write(ee.Message);
}
}
protected void btnGrid1DelSel_Click(object sender, EventArgs e)//删除选中记录
{
try
{
// createGridView();
for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
{
if (((CheckBox)GridView1.Rows[i].FindControl("ck")).Checked)
{
string section_code = GridView1.DataKeys[i].Values[0].ToString();
string para_code = GridView1.DataKeys[i].Values[1].ToString();
GridViewRow row = GridView1.Rows[i];
string query = "delete from ht_inner_report_contrast where section_code = '" + section_code + "' and seg_name = '" + ((DropDownList)row.FindControl("listSeg")).SelectedValue + "' and para_code = '" + para_code + "'";
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string log_message = opt.UpDateOra(query) == "Success" ? "删除报表字段成功" : "删除报表字段失败";
log_message += "--标识:" + section_code + para_code;
InsertTlog(log_message);
}
}
bindGrid();
}
catch (Exception ee)
{
Response.Write(ee.Message);
}
}
protected void btnGrid1DelSel_Click(object sender, EventArgs e)//删除选中记录
{
try
{
// createGridView();
for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
{
if (((CheckBox)GridView1.Rows[i].FindControl("ck_sel")).Checked)
{
string sectioncode = GridView1.DataKeys[i].Values[0].ToString();
string pathcode = GridView1.DataKeys[i].Values[1].ToString();
string query = "delete from ht_pub_path_section where SECTION_CODE = '" + sectioncode + "' and pathcode = '" + pathcode + "'";
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string log_message = opt.UpDateOra(query) == "Success" ? "删除工艺路径成功" : "删除工艺路径失败";
log_message += ",工艺段:" + sectioncode + "路径" + pathcode;
InsertTlog(log_message);
}
}
createGridView();
bindGrid1();
}
catch (Exception ee)
{
Response.Write(ee.Message);
}
}
protected void createView()
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
DataSet data = opt.CreateDataSetOra("select * from ht_qlt_weight t where is_del = '0' order by ID ");
if (data != null && data.Tables[0].Rows.Count == 4)
{
DataRowCollection Rows = data.Tables[0].Rows;
StringBuilder str = new StringBuilder();
str.Append(" select nvl(r.产品,nvl(s.产品,nvl(t.产品,p.产品))) as 产品,nvl(r.班组,nvl(s.班组,nvl(t.班组,p.班组))) as 班组,nvl(r.时间,nvl(s.检测时间,nvl(t.检测时间,p.检测时间))) as 时间,r.总分 as 在线考核分,s.得分 as 过程检测得分,t.得分 as 理化检测得分,p.得分 as 感观评测得分,nvl(r.总分,100) *");
str.Append(Rows[0]["Weight"].ToString());
str.Append("+ nvl(t.得分,100) * ");
str.Append(Rows[1]["Weight"].ToString());
str.Append("+ nvl(p.得分,100) * ");
str.Append(Rows[2]["Weight"].ToString());
str.Append("+ nvl(s.得分,100) * ");
str.Append(Rows[3]["Weight"].ToString());
str.Append(" as 总得分 from (");
str.Append(getOnlineScore());
str.Append(")r");
str.Append(" full join (");
str.Append(getProcessScore());
str.Append(") s on s.产品 = r.产品 and s.班组 = r.班组 and s.检测时间 = r.时间");
str.Append(" full join (");
str.Append(getPhycheScore());
str.Append(") t on (t.产品 = r.产品 and t.班组 = r.班组 and t.检测时间 = r.时间 ) or (t.产品 = s.产品 and t.班组 = s.班组 and t.检测时间 = s.检测时间 )");
str.Append(" full join (");
str.Append(getSensorScore());
str.Append(") p on (p.产品 = r.产品 and p.班组 = r.班组 and p.检测时间 = r.时间) or (p.产品 = s.产品 and p.班组 = s.班组 and p.检测时间 = s.检测时间 ) or (t.产品 = p.产品 and t.班组 = p.班组 and t.检测时间 = p.检测时间 ) ");
opt.UpDateOra("create or replace view hv_QLT_daily_report as " + str.ToString());
}
}
protected void btnDone_Click(object sender, EventArgs e)//
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
if (opt.GetSegValue("select flow_status from ht_eq_mclbr_plan where pz_code = '" + txtCode.Text + "'", "flow_status") != "2")
{
ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", "$('#dspcthor').hide();alert('请在正确状态下确认完成');", true);
return;
}
List <string> commandlist = new List <string>();
for (int i = 0; i <= GridView2.Rows.Count - 1; i++)
{
if (((CheckBox)GridView2.Rows[i].FindControl("chk")).Checked)
{
string ID = GridView2.DataKeys[i].Value.ToString();
commandlist.Add("update HT_EQ_MCLBR_PLAN_detail set STATUS = '5' where ID = '" + ID + "' and status = '4'");
}
}
if (commandlist.Count > 0)
{
string log_message = opt.TransactionCommand(commandlist) == "Success" ? "确认校准反馈成功" : "确认校准反馈失败";
InsertTlog(log_message);
string alter = opt.GetSegValue("select case when total = done then 1 else 0 end as status from (select count(distinct t.id) as total,count( distinct t1.id) as done from ht_eq_mclbr_plan_detail t left join ht_eq_mclbr_plan_detail t1 on t1.id = t.id and t1.status = '5' and t1.is_del = '0' where t.main_id = '" + txtCode.Text + "' and t.is_del = '0')", "status");
if (alter == "1")
{
opt.UpDateOra("update HT_EQ_MCLBR_PLAN set TASK_STATUS = '5' where PZ_CODE = '" + txtCode.Text + "' and TASK_STATUS = '4'");
bindGrid1();
}
bindGrid2(txtCode.Text);
}
}
protected void btnDel_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string query = "update HT_ENG_CONSUMPTION_ITEM set IS_DEL=1 where ID='" + ENERGYID.Text + "'";
opt.UpDateOra(query);
BindData();
}
protected void btnDel_Click(object sender, EventArgs e)
{
//DataBaseOperator opt = new DataBaseOperator();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string query = "update HT_ENG_MANUAL_DATA set IS_DEL=1 where ID='" + consumeID.Text + "'";
opt.UpDateOra(query);
BindData();
}
protected void btnDel2_Click(object sender, EventArgs e)
{
string query = "update HT_PUB_MATERIEL set IS_DEL = '1' where MATERIAL_CODE = '" + txtCode2.Text + "'";
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string log_message = opt.UpDateOra(query) == "Success" ? "物料删除成功" : "物料删除失败";
log_message += ",物料编码：" + txtCode2.Text;
InsertTlog(log_message);
}
protected void Delete_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string query = "delete from ht_qlt_collection where para_code = '" + txtID.Text + "'";
string log_message = opt.UpDateOra(query) == "Success" ? "删除数采条件成功" : "删除数采条件失败";
log_message += "--标识:" + txtID.Text;
InsertTlog(log_message);
setBlank();
}
protected static void getAuxFormalu_SQL(string id, string prodCode)
{
MSYS.Web.MateriaService.WsBaseDataInterfaceService service = new MSYS.Web.MateriaService.WsBaseDataInterfaceService();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
// List<string> commandlist = new List<string>();
try
{
auxFormulaVO info = service.getAuxFormulaById(id);
string temp;
if (info != null)
{
string[] seg = { "ID", "FORMULA_CODE", "FORMULA_NAME", "B_DATE", "CONTROL_STATUS", "CREATE_DATE", "CREATE_DEPT_ID", "CREATE_ID", "E_DATE", "IS_DEL", "IS_VALID", "MODIFY_ID", "MODIFY_TIME", "PROD_CODE", "REMARK", "STANDARD_VOL" };
//string formcode = info.formulaCode == "" ? "" : "703" + info.formulaCode;//"703" + (Convert.ToInt32(prod.coatFormulaCode)+3).ToString();
string formcode = info.formulaCode == "" ? "" : "703" + (Convert.ToInt32(info.formulaCode) + 3).ToString();
string[] value = { id, formcode, info.formulaName, info.BDate.ToString("yyyy-MM-dd HH:mm:ss"), info.controlStatus, info.createDate, info.createDept, info.createId, info.EDate.ToString("yyyy-MM-dd HH:mm:ss"), info.isDel, "1", info.modifyId, info.modifyTime, prodCode, info.remark, info.standardVol };
temp = opt.getMergeStr(seg, value, 2, "HT_QA_AUX_FORMULA");
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
if (info.auxSubList != null && info.auxSubList.Length > 0)
{
string[] subseg = { "ID", "MATER_CODE", "FORMULA_CODE", "AUX_PERCENT", "AUX_SCALE", "AUX_SORT", "IS_DEL", "MATER_TYPE", "mattreeName", "REMARK" };
foreach (tQaAuxFormulaDetail detail in info.auxSubList)
{
string[] subvalue = { detail.id.ToString(), detail.materCode, "703" + info.formulaCode, detail.auxPercent.ToString(), detail.auxScale.ToString(), detail.auxSort.ToString(), detail.isDel, detail.materType, detail.mattreeName, detail.remark };
temp = opt.getMergeStr(subseg, subvalue, 3, "HT_QA_AUX_FORMULA_DETAIL");
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
}
}
// return commandlist;
}
catch (Exception ee)
{
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string query = "delete from HT_SVR_LOGIN_RECORD where F_TIME between '" + StartTime.Text + "' and '" + EndTime.Text + "'";
string log_message = opt.UpDateOra(query) == "Success" ? "删除日志成功" : "删除日志失败";
log_message += "--开始时间：" + StartTime.Text + " 结束时间: " + EndTime.Text;
InsertTlog(log_message);
bindGrid();
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "alert", "alert('" + log_message + "')", true);
}
public string InsertLocalFromMaster()
{
MSYS.Web.MateriaService.WsBaseDataInterfaceService service = new MSYS.Web.MateriaService.WsBaseDataInterfaceService();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
List <string> commandlist = new List <string>();
productEntity[] prods = service.getAllProductList(new productEntity());
string[] matseg = { "ID", "PROD_CODE", "PROD_NAME", "PACK_NAME", "HAND_MODE", "MATER_FORMULA_CODE", "AUX_FORMULA_CODE", "COAT_FORMULA_CODE", "REMARK", "CREATEOR_ID", "CREATE_TIME", "MODIFY_ID", "MODIFY_TIME", "STANDARD_VALUE", "XY_PROD_CODE", "IS_VALID", "IS_DEL", "B_FLOW_STATUS" };
int SucCount = 0;
foreach (productEntity prod in prods)
{
// if (prod.prodCode.Substring(0, 3) == "703")
// {
commandlist.Clear();
if (prod.xyProdCode.Substring(0, 3) != "703")
{
continue;
}
string mformcode = ((prod.materFormulaCode == null) || prod.materFormulaCode.Length <= 3) ? "" : "7030" + (Convert.ToInt32(prod.materFormulaCode) + 20).ToString();
string aformcode = ((prod.auxFormulaCode == null) || prod.auxFormulaCode.Length <= 3) ? "" : "703" + prod.auxFormulaCode;
string cformcode = ((prod.coatFormulaCode == null) || prod.coatFormulaCode.Length <= 3) ? "" : "7030" + (Convert.ToInt32(prod.coatFormulaCode) + 3).ToString();
string[] value = { prod.id.ToString(), prod.xyProdCode, prod.prodName, prod.packName, Convert.ToInt32(prod.handMode).ToString()
, mformcode, aformcode, cformcode, prod.remark,prod.createorId, prod.createTime.ToString("yyyy-MM-dd HH:mm:ss"), prod.modifyId, prod.modifyTime.ToString("yyyy-MM-dd HH:mm:ss"), prod.standardValue, prod.prodCode, "1", prod.isDel, "2" };
string temp = opt.getMergeStr(matseg, value, 2, "HT_PUB_PROD_DESIGN");
commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
//getTechstdd_SQL(prod.techStddId, prod.xyProdCode); // java.math.BigInteger cannot be cast to java.lang.String
getMaterFormalu_SQL(prod.materFormulaId, prod.xyProdCode);
getAuxFormalu_SQL(prod.auxFormulaId, prod.xyProdCode); //java.math.BigDecimal cannot be cast to java.lang.Double
getCoatFormalu_SQL(prod.coatFormulaId, prod.xyProdCode);
if (opt.TransactionCommand(commandlist) == "Success")
{
commandlist.Clear();
//commandlist.Add("update ht_pub_prod_design t set tech_stdd_code = (select r.tech_code from ht_tech_stdd_code r where substr(t.tech_stdd_code,0,3)<>'TCH' and r.id = to_number( t.tech_stdd_code)),mater_formula_code = (select s.formula_code from ht_qa_mater_formula s where t.mater_formula_code is not null and s.id = to_number( t.mater_formula_code)),aux_formula_code = (select q.formula_code from ht_qa_aux_formula q where t.aux_formula_code is not null and q.id = to_number( t.aux_formula_code)),coat_formula_code = (select p.formula_code from ht_qa_coat_formula p where t.coat_formula_code is not null and p.id = to_number( t.coat_formula_code)) where t.prod_code = '" + prod.prodCode + "'");
commandlist.Add("update ht_qa_mater_formula_detail r set formula_code = (select t.formula_code from ht_qa_mater_formula t where t.id = r.formula_code) where r.formula_code = '" + prod.materFormulaId + "'");
commandlist.Add("update ht_qa_aux_formula_detail r set formula_code = (select t.formula_code from ht_qa_aux_formula t where t.id = r.formula_code) where r.formula_code = '" + prod.auxFormulaId + "'");
commandlist.Add("update ht_qa_coat_formula_detail r set formula_code = (select t.formula_code from ht_qa_coat_formula t where t.id = r.formula_code) where r.formula_code = '" + prod.coatFormulaId + "'");
commandlist.Add("update ht_qa_Fla_formula_detail r set formula_code = (select t.formula_code from ht_qa_Fla_formula t where t.id = r.formula_code) where r.formula_code = '" + prod.coatFormulaId + "'");
//commandlist.Add("update ht_tech_stdd_code_detail r set tech_code = (select t.tech_code from ht_tech_stdd_code t where t.id = r.tech_code) where r.tech_code = '" + prod.techStddId + "'");
//commandlist.Add("update ht_qa_mater_formula_detail t set t.mater_flag = (select r.mat_type from ht_pub_materiel r where r.material_code = t.mater_code)");
opt.TransactionCommand(commandlist);
System.Diagnostics.Debug.Write("产品更新成功" + prod.prodCode + prod.prodName);
SucCount++;
}
// }
}
return(SucCount.ToString() + "项产品更新成功,总记录条数：" + prods.Length);
}
protected void btnDel_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string query = "delete from HT_SVR_PRT_MENU where NAME = '" + txtMenu.Text + "'";
string log_message = opt.UpDateOra(query) == "Success" ? "删除父级菜单成功" : "删除父级菜单失败";
log_message += "--标识:" + txtMenu.Text;
InsertTlog(log_message);
BindList(RightTree.Nodes, "");
SetBlank();
}
protected void btnSegDel_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string query = "delete from HT_SYS_EXCEL_SEG where F_SHEETINDEX='"
+ Index.Text + "' and F_BOOK_ID = '" + listReport.SelectedValue + "' and f_des = '" + DesC.Text.Trim() + DesR.Text.Trim() + "'";
string log_message = opt.UpDateOra(query) == "Success" ? "删除报表记录成功" : "删除报表记录失败";
log_message += "标识:F_SHEETINDEX='" + Index.Text + "' and F_BOOK_ID = '" + listReport.SelectedValue + "' and f_des = '" + DesC.Text.Trim() + DesR.Text.Trim() + "'";
InsertTlog(log_message);
tvHtml = InitTreeR();
ScriptManager.RegisterStartupScript(UpdatePanel3, this.Page.GetType(), "", "initTreetoggle();", true);
}
//根据操作用户插入日志
public void InsertTlog(string record)
{
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"];
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string query = "insert into HT_SVR_LOGIN_RECORD(F_USER,F_COMPUTER,F_TIME,F_DESCRIPT)values('"
+ user.text + "','"
+ Page.Request.UserHostName.ToString() + "','"
+ DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','"
+ record + "')";
opt.UpDateOra(query);
}
protected void btnDspcth_Click(object sender, EventArgs e)//
{
bool ck = false;
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
//if (opt.GetSegValue("select flow_status from ht_eq_mt_plan where pz_code = '" + txtCode.Text + "'", "flow_status") != "2")
//{
// ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", "$('#dspcthor').hide();", true);
// return;
//}
for (int i = 0; i <= GridView2.Rows.Count - 1; i++)
{
if (((CheckBox)GridView2.Rows[i].FindControl("chk")).Checked)
{
ck = true;
string ID = GridView2.DataKeys[i].Value.ToString();
string query = "update ht_eq_mt_plan_detail set STATUS = '1' ,TEAM_CODE = '" + listdspcth.SelectedValue + "' where ID = '" + ID + "' and status <= '1'";
string log_message = opt.UpDateOra(query) == "Success" ? "下派维保计划成功" : "下派维保计划失败";
log_message += "--标识:" + ID;
InsertTlog(log_message);
}
}
string alter = opt.GetSegValue("select case when total = done then 1 else 0 end as status from (select count(distinct t.id) as total,count( distinct t1.id) as done from ht_eq_mt_plan_detail t left join ht_eq_mt_plan_detail t1 on t1.id = t.id and t1.status >= '1' and t1.is_del = '0' where t.main_id = '" + txtCode.Text + "' and t.is_del = '0')", "status");
if (alter == "1")
{
opt.UpDateOra("update ht_eq_mt_plan set TASK_STATUS = '1' where PZ_CODE = '" + txtCode.Text + "' and TASK_STATUS = '0'");
bindGrid1();
}
ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", "$('#dspcthor').hide();", true);
if (ck == true)
{
bindGrid2(txtCode.Text);
}
else
{
ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", "alert('请选择派工任务');", true);
}
}
//删除报表
protected void Delete_Click(object sender, EventArgs e)
{
string query;
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
query = "delete from HT_SYS_EXCEL_BOOK where F_NAME = '" + ReportName.Text.Trim() + "'";
string log_message = opt.UpDateOra(query) == "Success" ? "删除报表成功" : "删除报表失败";
log_message += "--标识:" + ReportName.Text;
InsertTlog(log_message);
tvHtml = InitTreeR();
ScriptManager.RegisterStartupScript(UpdatePanel3, this.Page.GetType(), "", "initTreetoggle();", true);
}
protected void btnDone_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in GridView2.Rows)
{
int index = row.RowIndex;
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string log_message = opt.UpDateOra("update HT_QLT_INSPECT_EVENT set status = '6' where RECORD_ID = '" + GridView2.DataKeys[index].Values[0].ToString() + "' and INSPECT_CODE = '" + GridView2.DataKeys[index].Values[1].ToString() + "' and status = '5'") == "Success" ? "反馈工艺质量事件成功" : "反馈工艺质量事件失败";
log_message += "--详情:" + GridView2.DataKeys[index].Values[0].ToString();
InsertTlog(log_message);
bindgrid2();
}
}
protected void btnGrid2Del_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
int rowIndex = ((GridViewRow)btn.NamingContainer).RowIndex;
string query = "update ht_sys_shift set IS_DEL = '1' where SHIFT_CODE = '" + GridView2.Rows[rowIndex].Cells[1].Text + "'";
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string log_message = opt.UpDateOra(query) == "Success" ? "删除班时成功" : "删除班时失败";
log_message += "--标识:" + GridView2.Rows[rowIndex].Cells[1].Text;
InsertTlog(log_message);
bindGrid2();
}
protected void btnDel1_Click(object sender, EventArgs e)
{
string query = "update HT_PUB_MATTREE set IS_DEL = '1' where MATTREE_CODE = '" + txtCode1.Text + "'";
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string log_message = opt.UpDateOra(query) == "Success" ? "分类删除成功" : "分类删除失败";
log_message += ", 分类编码：" + txtCode1.Text;
InsertTlog(log_message);
bindGrid(txtCode1.Text);
tvHtml = InitTree();
ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "init", " initTree();", true);
}
