protected void btnModify_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
List <string> commandlist = new List <string>();
if (rd1.Checked)
{
if (listProd2.SelectedValue == "" || listPlanno.SelectedValue == "" || listTeam2.SelectedValue == "" || txtDate.Text == "")
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "message", "alert('请录入完整的数据信息')", true);
return;
}
else
{
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"];
string[] seg = { "PLANNO", "PROD_CODE", "SECTION_CODE", "TEAM", "TIME", "PARA_CODE", "CREATOR", "VALUE" };
foreach (GridViewRow row in GridView2.Rows)
{
string paravalue = ((TextBox)row.FindControl("txtParavalue")).Text;
string paracode = ((DropDownList)row.FindControl("listPara")).SelectedValue;
if (((TextBox)row.FindControl("txtParavalue")).Text != "")
{
string[] value = { listPlanno.SelectedValue, listProd2.SelectedValue, paracode.Substring(0, 5), listTeam2.SelectedValue, txtDate.Text, paracode, user.text, paravalue };
commandlist.Add(opt.getMergeStr(seg, value, 6, "HT_PROD_REPORT_DETAIL"));
}
}
}
}
else
{
if (listProd2.SelectedValue == "" || listPlanno.SelectedValue == "")
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "message", "alert('请录入完整的数据信息')", true);
return;
}
else
{
foreach (GridViewRow row in GridView2.Rows)
{
string paravalue = ((TextBox)row.FindControl("txtParavalue")).Text;
string paracode = ((DropDownList)row.FindControl("listPara")).SelectedValue;
string[] seg = { "SECTION_CODE", "PLANNO", GridView2.DataKeys[row.RowIndex].Value.ToString() };
string[] value = { paracode.Substring(0, 5), listPlanno.SelectedValue, paravalue };
commandlist.Add(opt.getMergeStr(seg, value, 2, "HT_PROD_REPORT"));
}
}
}
string log_message = opt.TransactionCommand(commandlist) == "Success" ? "保存物料过程数据成功," : "保存物料过程数据失败,";
log_message += "--详情产品：" + listProd2.SelectedValue + "计划号:" + listPlanno.SelectedValue + "班组：" + listTeam.SelectedValue + "日期：" + txtDate.Text;
InsertTlog(log_message);
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", " $('.shade').fadeOut(100);", true);
bindGrid();
bindGrid3();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"];
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
//opt.bindDropDownList(tag, "select DISTINCT ALM_TAGNAME from fixalarms", "ALM_TAGNAME", "ALM_TAGNAME");
opt.bindDropDownList(area, "select DISTINCT ALM_ALMAREA from fixalarms order by ALM_ALMAREA", "ALM_ALMAREA", "ALM_ALMAREA");
}
}
protected void btnGridNew_Click(object sender, EventArgs e)
{
setBlank();
SetEnable("未提交");
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
txtCode.Text = "RP" + System.DateTime.Now.ToString("yyyyMMdd") + (Convert.ToInt16(opt.GetSegValue("select nvl( max(substr(pz_code,11,3)),0) as ordernum from HT_EQ_RP_PLAN where substr(pz_code,1,10) ='RP" + System.DateTime.Now.ToString("yyyyMMdd") + "'", "ordernum")) + 1).ToString().PadLeft(3, '0');
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"];
listEditor.SelectedValue = user.id;
listApt.SelectedValue = user.OwningBusinessUnitId;
bindGrid2("");
}
protected void btnGridNew_Click(object sender, EventArgs e)// 新增领退明细
{
setBlank();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
txtCode.Text = "SF" + System.DateTime.Now.ToString("yyyyMMdd") + (Convert.ToInt16(opt.GetSegValue("select nvl(max(substr(ORDER_SN,11,3)),0) as ordernum from HT_STRG_FLAVOR where substr(ORDER_SN,1,10) ='SF" + System.DateTime.Now.ToString("yyyyMMdd") + "'", "ordernum")) + 1).ToString().PadLeft(3, '0');
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"];
listCreator.SelectedValue = user.id;
listApt.SelectedValue = user.OwningBusinessUnitId;
bindGrid2();
SetEnable(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);
}
// private string currentTableId;
protected void Page_Load(object sender, EventArgs e)
{
base.PageLoad(sender, e);
if (!IsPostBack)
{
txtBtime.Text = System.DateTime.Now.ToString("yyyy-MM");
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"];
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
opt.bindDropDownList(listProd, "select prod_code,prod_name from ht_pub_prod_design where is_del= '0'", "prod_name", "prod_code");
bindgrid();
}
}
protected void Page_Load(object sender, EventArgs e)
{
base.PageLoad(sender, e);
if (!IsPostBack)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
opt.bindDropDownList(listEq, "select IDKEY,EQ_NAME from ht_eq_eqp_tbl where is_del = '0' and is_valid = '1'", "EQ_NAME", "IDKEY");
opt.bindDropDownList(listOptor, "select s.name,s.id from ht_svr_sys_role t left join ht_svr_sys_menu r on substr(t.f_right,r.f_id,1) = '1' left join ht_svr_user s on s.role = t.f_id where r.f_id = '" + this.RightId + "' union select q.name,q.id from ht_svr_sys_role t left join ht_svr_sys_menu r on substr(t.f_right,r.f_id,1) = '1' left join ht_svr_org_group s on s.f_role = t.f_id left join ht_svr_user q on q.levelgroupid = s.f_code where r.f_id = '" + this.RightId + "' order by id desc", "name", "ID");
opt.bindDropDownList(listArea, "select r.section_code,r.section_name from ht_pub_tech_section r where r.is_del = '0' and r.is_valid = '1' union select '' as section_code,'' as section_name from dual order by section_code", "section_name", "section_code");
opt.bindDropDownList(listSection, "select r.section_code,r.section_name from ht_pub_tech_section r where r.is_del = '0' and r.is_valid = '1' union select '' as section_code,'' as section_name from dual order by section_code", "section_name", "section_code");
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"];
txtOpttime.Text = System.DateTime.Now.ToString("yyyy-MM-dd");
listOptor.SelectedValue = user.id;
}
}
protected void Page_Load(object sender, EventArgs e)
{
base.PageLoad(sender, e);
if (!IsPostBack)
{
txtBtime.Text = System.DateTime.Now.ToString("yyyy-MM");
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"];
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
opt.bindDropDownList(prod_code, "select prod_code,prod_name from ht_pub_prod_design where is_del= '0'", "prod_name", "prod_code");
opt.bindDropDownList(address, "select distinct factory_address from ht_qlt_inspect_factory where is_del='0' and is_valid='1'", "factory_address", "factory_address");
opt.bindDropDownList(time, "select distinct factory_time from ht_qlt_inspect_factory where is_del='0' and is_valid='1'", "factory_time", "factory_time");
//bindgrid();
bindFactoryTables();
}
}
protected void btnNew_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string code = opt.GetSegValue("select nvl(max(substr(QLT_CODE,4,3)),0)+1 as code from ht_qlt_stdd_code t", "code");
txtCode.Text = "QLT" + code.PadLeft(3, '0');
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"];
txtCreator.Text = user.text;
txtCrtDate.Text = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
txtDscpt.Text = "";
txtEndDate.Text = "";
txtExeDate.Text = "";
txtName.Text = "";
txtVersion.Text = "";
listAprv.SelectedValue = "";
}
protected void btngrid2Sure_Click(object sender, EventArgs e)
{
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"];
Button btn = (Button)sender;
GridViewRow row = (GridViewRow)btn.NamingContainer;
int index = row.RowIndex;
string[] seg = { "RECORD_ID", "INSPECT_CODE", "STATUS", "SCORE", "CREAT_ID", "CREATE_TIME" };
string[] value = { GridView2.DataKeys[index].Values[0].ToString(), GridView2.DataKeys[index].Values[1].ToString(), "2", row.Cells[11].Text, user.id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") };
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string log_message = opt.MergeInto(seg, value, 1, "HT_QLT_INSPECT_EVENT") == "Success" ? "保存工艺质量事件成功" : "保存工艺质量事件失败";
log_message += "--详情:" + string.Join(",", value);
InsertTlog(log_message);
bindgrid2();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string str = opt.GetSegValue("select nvl(Max(substr(inspect_stdd_code,7,3)),0)+1 as code from HT_QLT_INSPECT_STDD t where is_del='0'", "CODE");
txtCode.Text = "ISP703" + str.PadLeft(3, '0');
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"];
listCreator.SelectedValue = user.id;
txtCrtDate.Text = System.DateTime.Now.ToString("yyyy-MM-dd");
btnSubmit.Enabled = true;
btnSubmit.CssClass = "btn1 auth";
txtName.Text = "";
txtVersion.Text = "";
txtDscpt.Text = "";
ckValid.Checked = false;
listAprv.SelectedValue = "";
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"];
foreach (GridViewRow row in GridView2.Rows)
{
if (((CheckBox)row.FindControl("ck")).Checked && ((Label)row.FindControl("labStatus")).Text == "未处理")
{
int index = row.RowIndex;
string[] seg = { "RECORD_ID", "INSPECT_CODE", "STATUS", "SCORE", "CREAT_ID", "CREATE_TIME" };
string[] value = { GridView2.DataKeys[index].Values[0].ToString(), GridView2.DataKeys[index].Values[1].ToString(), "2", row.Cells[11].Text, user.id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") };
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string log_message = opt.MergeInto(seg, value, 1, "HT_QLT_INSPECT_EVENT") == "Success" ? "确认工艺质量事件成功" : "确认工艺质量事件失败";
log_message += "--详情:" + string.Join(",", value);
InsertTlog(log_message);
}
}
bindgrid2();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string str = opt.GetSegValue("select nvl(Max(substr(tech_CODE,7,3)),0)+1 as code from ht_tech_stdd_code t where is_del='0'", "CODE");
txtCode.Text = "TCH703" + str.PadLeft(3, '0');
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"];
listCreator.SelectedValue = user.id;
txtCrtDate.Text = System.DateTime.Now.ToString("yyyy-MM-dd");
listCrtApt.SelectedValue = user.OwningBusinessUnitId;
btnSubmit.Enabled = true;
btnSubmit.CssClass = "btn1 auth";
txtName.Text = "";
txtVersion.Text = "";
txtExeDate.Text = "";
txtEndDate.Text = "";
listStatus.SelectedValue = "";
txtDscpt.Text = "";
ckValid.Checked = false;
listAprv.SelectedValue = "";
}
protected void initView()
{
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"];
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
opt.bindDropDownList(listProd, "select prod_code,prod_name from ht_pub_prod_design where is_del= '0'", "prod_name", "prod_code");
opt.bindDropDownList(prod_code, "select prod_code,prod_name from ht_pub_prod_design where is_del= '0'", "prod_name", "prod_code");
opt.bindDropDownList(listTeam, "select team_code,team_name from ht_sys_team where is_del = '0' order by team_code", "team_name", "team_code");
opt.bindDropDownList(listShift, "select shift_code,shift_name from ht_sys_shift where is_del = '0'", "shift_name", "shift_code");
listTeam.SelectedValue = opt.GetSegValue(" select team_code from ht_prod_schedule where date_begin < '" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' and date_end > '" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "'", "team_code");
listShift.SelectedValue = opt.GetSegValue(" select Shift_code from ht_prod_schedule where date_begin < '" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' and date_end > '" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "'", "Shift_code");
listEditor.Items.Clear();
ListItem item = new ListItem(user.text, user.id);
listEditor.Items.Add(item);
listEditor.SelectedValue = user.id;
txtProdTime.Text = System.DateTime.Now.ToString("yyyy-MM-dd");
string query = "select r.inspect_code,s.section_name ,r.inspect_name,0 as value,t.lower_value,t.upper_value,r.unit,'' as status,t.minus_score from ht_qlt_inspect_proj r left join ht_pub_tech_section s on s.section_code = r.inspect_group left join ht_qlt_inspect_stdd t on t.inspect_code = r.inspect_code and t.is_del = '0' where r.inspect_type = '0' and r.is_del = '0' order by s.section_name";
DataSet data = opt.CreateDataSetOra(query);
bindGrid1(data);
}
protected void btnAddR_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string str = opt.GetSegValue("select Max(Formula_code) as code from Ht_Qa_Mater_Formula ", "CODE");
if (str == "")
{
str = "00000000";
}
txtCode.Text = "70306" + (Convert.ToInt16(str.Substring(5)) + 1).ToString().PadLeft(3, '0');
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"];
listCreator.SelectedValue = user.id;
txtCrtDate.Text = System.DateTime.Now.ToString("yyyy-MM-dd");
listCrtApt.SelectedValue = user.OwningBusinessUnitId;
txtName.Text = "";
txtVersion.Text = "";
txtExeDate.Text = "";
txtEndDate.Text = "";
listStatus.SelectedValue = "";
txtDscpt.Text = "";
ckValid.Checked = false;
}
protected void btnModify_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
List <string> commandlist = new List <string>();
if (listProd2.SelectedValue == "" || listTeam2.SelectedValue == "" || txtDate.Text == "")
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "message", "alert('请录入完整的数据信息')", true);
return;
}
else
{
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"];
string[] seg = { "PROD_CODE", "PROD_DATE", "TEAM", "PARA_CODE", "PARA_VALUE", "RECORD_TIME", "EDITOR" };
foreach (GridViewRow row in GridView2.Rows)
{
string paravalue = ((TextBox)row.FindControl("txtParavalue")).Text;
string paracode = ((DropDownList)row.FindControl("listPara")).SelectedValue;
if (((TextBox)row.FindControl("txtParavalue")).Text != "")
{
string[] value = { listProd2.SelectedValue, txtDate.Text, listTeam2.SelectedValue, paracode, paravalue, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), user.id, };
commandlist.Add(opt.getMergeStr(seg, value, 4, "HT_PROD_INOUT_REPORT"));
}
}
}
string log_message = opt.TransactionCommand(commandlist) == "Success" ? "保存投入产出人工录入数据成功," : "保存投入产出人工录入数据失败,";
log_message += "--详情产品：" + listProd2.SelectedValue + listProd2.SelectedItem.Text + "班组：" + listTeam.SelectedValue + "日期：" + txtDate.Text;
InsertTlog(log_message);
ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", "alert('" + log_message + "'); ", true);
bindGrid();
}
protected void bindGrid1()
{
MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["user"];
string query = "select g1.tb_zt as 业务名,g1.tbr_name as 申请人,g3.f_name as 申请部门 ,g1.state as 主业务审批状态,g2.STATUS as 当前流程状态,g2.gongwen_id,g2.id ,g1.BUSIN_ID from HT_PUB_APRV_FLOWINFO g1 left join ht_pub_aprv_opinion g2 on g1.id = g2.gongwen_id and g2.rolename = '" + user.UserRole + "' left join ht_svr_org_group g3 on g3.f_code = g1.tb_bm_id where g1.TB_DATE between '" + txtStarttime.Text + "' and '" + txtEndtime.Text + "' and ISENABLE = '1'";
//调试期间用下面SQL，正式运行用上面
// string query = "select g1.tb_zt as 业务名,g1.tbr_name as 申请人,g1.tb_bm_name as 申请部门 ,g1.state as 主业务审批状态,g2.STATUS as 当前流程状态,g2.gongwen_id,g2.id ,g1.BUSIN_ID from HT_PUB_APRV_FLOWINFO g1 left join ht_pub_aprv_opinion g2 on g1.id = g2.gongwen_id where g1.TB_DATE between '" + txtStarttime.Text + "' and '" + txtEndtime.Text + "' and ISENABLE = '1'";
if (ckDone.Checked)
{
query += " and g1.state = '0'";
}
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
// query += " and g2.rolename = '" + opt.GetSegValue("select * from HT_SVR_USER where LOGINNAME = '" + "cookieName" + "'", "ROLE") + "'";
//该处思路是找到当前登陆用户的角色，在列表中显示当前角色应审批的流程部分，还有按流程顺序，前面未完的部分不应出现在列表中
DataSet data = opt.CreateDataSetOra(query);
GridView1.DataSource = data;
GridView1.DataBind();
if (data != null && data.Tables[0].Rows.Count > 0)
{
for (int i = GridView1.PageSize * GridView1.PageIndex; i < GridView1.PageSize * (GridView1.PageIndex + 1) && i < data.Tables[0].Rows.Count; i++)
{
DataRowView mydrv = data.Tables[0].DefaultView[i];
GridViewRow row = GridView1.Rows[i - GridView1.PageSize * GridView1.PageIndex];
Label labState1 = (Label)row.FindControl("labStatus1");
switch (mydrv["主业务审批状态"].ToString())
{
case "0":
labState1.Text = "办理中";
break;
case "1":
labState1.Text = "被驳回";
break;
case "2":
labState1.Text = "己办结";
break;
default:
labState1.Text = "办理中";
break;
}
Label labState2 = (Label)row.FindControl("labStatus2");
switch (mydrv["当前流程状态"].ToString())
{
case "0":
labState2.Text = "未审批";
break;
case "1":
labState2.Text = "未通过";
break;
case "2":
labState2.Text = "己通过";
break;
default:
labState2.Text = "未审批";
break;
}
}
}
}
