protected void btnSave_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string[] seg = { "INSPECT_CODE", "INSPECT_GROUP", "INSPECT_NAME", "INSPECT_TYPE", "REMARK", "CREATE_ID", "CREATE_TIME", "UNIT" }; string[] value = { txtCode.Text, listSection2.SelectedValue, txtName.Text, listType2.SelectedValue, txtRemark.Text, listCreator.SelectedValue, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), txtUnit.Text }; string log_message = opt.MergeInto(seg, value, 1, "ht_qlt_inspect_proj") == "Success" ? "保存工艺检查项目成功" : "保存工艺检查项目失败"; if (log_message == "保存工艺检查项目成功") { string[] procseg = { }; object[] procvalues = { }; if (listSection2.SelectedValue == "4") { opt.ExecProcedures("Create_Sensor_Report", procseg, procvalues); } else if (listSection2.SelectedValue.Length == 1 && listSection2.SelectedValue != "4") { opt.ExecProcedures("Create_phychem_Report", procseg, procvalues); } else { opt.ExecProcedures("Create_process_Report", procseg, procvalues); } } log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); bindGrid(); ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", " $('.shade').fadeOut(100);", true); }
protected void btnDel1_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); List <string> commandlist = new List <string>(); commandlist.Add("update HT_PUB_TECH_SECTION set IS_DEL = '1' where SECTION_CODE = '" + txtCode_1.Text + "'"); //commandlist.Add("update ht_pub_inspect_process set IS_DEL = '1' where substr(PROCESS_CODE,1,5) = '" + txtCode.Text + "'"); commandlist.Add("update HT_PUB_TECH_PARA set IS_DEL = '1' where substr(PARA_CODE,1,5) = '" + txtCode_1.Text + "'"); string log_message; if (opt.TransactionCommand(commandlist) == "Success") { log_message = "删除工艺段成功"; tvHtml = InitTree(); opt.bindDropDownList(listSection_2, "select section_code,section_name from ht_pub_tech_section where is_del = '0' and is_valid = '1' order by section_code", "section_name", "section_code"); opt.bindDropDownList(listSection, "select section_code,section_name from ht_pub_tech_section where is_valid = '1' and is_del = '0' order by section_code", "section_name", "section_code"); string[] procseg = { }; object[] procvalues = { }; opt.ExecProcedures("Create_Online_month_Report", procseg, procvalues); ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "sucess", "initTree();alert('删除成功');", true); } else { log_message = "删除工艺段失败"; } log_message += ",工艺段ID:" + txtCode_1.Text; InsertTlog(log_message); }
protected void btnModify1_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); { string[] seg = { "SECTION_CODE", "SECTION_NAME", "REMARK", "IS_PATH_CONFIG", "CREATE_ID", "CREATE_TIME" }; string[] value = { txtCode_1.Text, txtName_1.Text, txtDscrp_1.Text, Convert.ToInt16(rdValid_1.Checked).ToString(), ((MSYS.Data.SysUser)Session["user"]).id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }; string log_message; if (opt.MergeInto(seg, value, 1, "HT_PUB_TECH_SECTION") == "Success") { log_message = "保存工艺段成功"; tvHtml = InitTree(); opt.bindDropDownList(listSection_2, "select section_code,section_name from ht_pub_tech_section where is_del = '0' and is_valid = '1' order by section_code", "section_name", "section_code"); opt.bindDropDownList(listSection, "select section_code,section_name from ht_pub_tech_section where is_valid = '1' and is_del = '0' order by section_code", "section_name", "section_code"); string[] procseg = { }; object[] procvalues = { }; opt.ExecProcedures("Create_Online_month_Report", procseg, procvalues); ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "sucess", "initTree();alert('保存成功');", true); } else { log_message = "保存工艺段失败"; } log_message += "--数据详情:" + string.Join("-", value); InsertTlog(log_message); } }
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 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 projcode = GridView1.DataKeys[i].Value.ToString(); string query = "delete from ht_qlt_inspect_proj where INSPECT_CODE = '" + projcode + "'"; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string log_message = opt.UpDateOra(query) == "Success" ? "删除工艺检查项目成功" : "删除工艺检查项目失败"; if (log_message == "删除工艺检查项目成功") { string[] procseg = { }; object[] procvalues = { }; if (GridView1.Rows[i].Cells[2].Text == "感观评测") { opt.ExecProcedures("Create_Sensor_Report", procseg, procvalues); } else if (GridView1.Rows[i].Cells[1].Text == "成品检验" && GridView1.Rows[i].Cells[2].Text != "感观评测") { opt.ExecProcedures("Create_phychem_Report", procseg, procvalues); } else { opt.ExecProcedures("Create_process_Report", procseg, procvalues); } } log_message += "--标识:" + projcode; InsertTlog(log_message); } } bindGrid(); } catch (Exception ee) { Response.Write(ee.Message); } }
protected void btnGrid2DelSel_Click(object sender, EventArgs e)//删除选中记录 { for (int i = 0; i <= GridView2.Rows.Count - 1; i++) { if (((CheckBox)GridView2.Rows[i].FindControl("ck")).Checked) { string projcode = GridView2.DataKeys[i].Value.ToString(); string query = "delete from HT_QLT_SENSOR_STDD where INSPECT_CODE = '" + projcode + "'"; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string log_message = opt.UpDateOra(query) == "Success" ? "删除工艺检查标准成功" : "删除工艺检查标准失败"; if (log_message == "删除工艺检查标准成功") { string[] procseg = { }; object[] procvalues = { }; opt.ExecProcedures("Create_Sensor_Report", procseg, procvalues); } log_message += "--标识:" + projcode; InsertTlog(log_message); } } bindGrid2(); }
protected void btnDel_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string query = "delete from HT_PUB_TECH_PARA where PARA_CODE = '" + txtCode.Text + "'"; string log_message; if (opt.UpDateOra(query) == "Success") { log_message = "删除工艺参数点成功"; tvHtml = InitTree(); string[] procseg = { }; object[] procvalues = { }; opt.ExecProcedures("Create_Online_month_Report", procseg, procvalues); ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "sucess", "initTree();alert('删除成功');", true); } else { log_message = "删除工艺参数点失败"; } log_message += ",工艺参数点ID:" + txtCode.Text; InsertTlog(log_message); }
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) { string[] seg = { "INSPECT_CODE", "MINUS_SCORE", "REMARK", "CREATE_ID", "CREATE_TIME" }; string[] value = { ((DropDownList)row.FindControl("listInspect")).SelectedValue, ((TextBox)row.FindControl("txtScore")).Text, ((TextBox)row.FindControl("txtRemark")).Text, ((MSYS.Data.SysUser)Session["User"]).id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }; commandlist.Add(opt.getMergeStr(seg, value, 1, "HT_QLT_SENSOR_STDD")); } string log_message = opt.TransactionCommand(commandlist) == "Success" ? "保存感观评测标准成功" : "保存感观评测标准失败"; if (log_message == "保存感观评测标准成功") { string[] procseg = { }; object[] procvalues = { }; opt.ExecProcedures("Create_Sensor_Report", procseg, procvalues); } InsertTlog(log_message); bindGrid2(); ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "success", "alert('" + log_message + "')", true); }
//在服务器中找到报表模板,从数据库中选择数据,将数据写入模板中,把该文件保存在服务器的C://temp目录下;客户端再下载该文件,就能在客户端进行浏览 public string CreateExcel(string filename, string brand, string startDate, string endDate, string team, string style, string month, DateTime date, bool merge) { MSYS.Common.ExcelExport openXMLExcel = null; try { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string bookid = opt.GetSegValue("select F_ID from ht_sys_excel_book where F_NAME = '" + filename + "'", "F_ID"); string booktype = opt.GetSegValue("select F_TYPE from ht_sys_excel_book where F_NAME = '" + filename + "'", "F_TYPE"); string basedir = System.AppDomain.CurrentDomain.BaseDirectory.ToString(); string strFolderPath = basedir + @"\TEMP"; if (!System.IO.Directory.Exists(strFolderPath)) { // 目录不存在,建立目录 System.IO.Directory.CreateDirectory(strFolderPath); } DirectoryInfo dyInfo = new DirectoryInfo(strFolderPath); //获取文件夹下所有的文件 foreach (FileInfo feInfo in dyInfo.GetFiles()) { //判断文件日期是否小于今天,是则删除 if (feInfo.CreationTime < DateTime.Now.AddMinutes(-2)) { feInfo.Delete(); } } foreach (DirectoryInfo dir in dyInfo.GetDirectories()) { if (dir.CreationTime < DateTime.Now.AddMinutes(-2)) { dir.Delete(true); } } //导出文件模板所在位置 String sourcePath = basedir + @"templates\" + booktype + @"\" + filename + ".xls"; String filepath = basedir + @"TEMP\" + filename + date.ToString("HHmmss") + style; //bool isrewrite = true; // true=覆盖已存在的同名文件,false则反之 //System.IO.File.Copy(sourcePath, filepath, isrewrite); string query = "select * from ht_sys_excel_seg where F_BOOK_ID = '" + bookid + "' order by F_DES"; DataSet data = opt.CreateDataSetOra(query); //申明一个ExcelSaveAs对象,该对象完成将数据写入Excel的操作 openXMLExcel = new MSYS.Common.ExcelExport(sourcePath, false); if (data.Tables[0].Select().GetLength(0) > 0) { DataRow[] rows = data.Tables[0].Select(); foreach (DataRow row in rows) { string sqlstr = row["F_SQL"].ToString(); //设定选择的数据的日期及牌号等信息 if (brand != "") { sqlstr = sqlstr.Replace("$brand$", brand); } if (startDate != "") { sqlstr = sqlstr.Replace("$startDate$", startDate); } if (endDate != "") { sqlstr = sqlstr.Replace("$endDate$", endDate); } if (team != "") { sqlstr = sqlstr.Replace("$team$", team); } if (month != "") { sqlstr = sqlstr.Replace("$month$", month); } if (sqlstr != "") { //将选择的数据写入Excel if (sqlstr.Length > 4 && sqlstr.Substring(0, 3) == "STR") { sqlstr = sqlstr.Substring(4); Response.Write(openXMLExcel.SetCurrentSheet(Convert.ToInt32(row["F_SHEETINDEX"].ToString()))); Response.Write(openXMLExcel.WriteData(Convert.ToInt32(row["F_DESX"].ToString()), getColumn(row["F_DESY"].ToString()) + 1, sqlstr)); } if (sqlstr.Length > 5 && sqlstr.Substring(0, 4) == "Proc") { int pos = sqlstr.IndexOf('@'); int pos2 = sqlstr.IndexOf('#'); string proc = sqlstr.Substring(5, pos - 5); int paracount = Regex.Matches(sqlstr, @"@").Count; List <string> seglist = new List <string>(); List <string> paralist = new List <string>(); for (int i = 0; i < paracount; i++) { seglist.Add(sqlstr.Substring(pos + 1, pos2 - pos - 1)); pos = sqlstr.IndexOf('@', pos2); if (pos > 0) { paralist.Add(sqlstr.Substring(pos2 + 1, pos - pos2 - 1)); pos2 = sqlstr.IndexOf('#', pos); } else { paralist.Add(sqlstr.Substring(pos2 + 1)); } } opt.ExecProcedures(proc, seglist.ToArray(), paralist.ToArray()); } if (sqlstr.Length > 20 && sqlstr.Substring(0, 3) == "SQL") { sqlstr = sqlstr.Substring(4).Trim(); System.Diagnostics.Debug.WriteLine(sqlstr); bool hasCaption = false; if (sqlstr.Substring(0, 1) == "$") { hasCaption = true; sqlstr = sqlstr.Substring(1); } DataSet set = new DataSet(); if (sqlstr.Substring(0, 5) == "SHIFT") { sqlstr = sqlstr.Substring(6).Trim(); set = opt.ShiftTable(sqlstr); } else { set = opt.CreateDataSetOra(sqlstr); } if (set != null) { DataTable dt = set.Tables[0]; openXMLExcel.SetCurrentSheet(Convert.ToInt32(row["F_SHEETINDEX"].ToString())); if (merge) { if (hasCaption) { openXMLExcel.WriteDataRerangeWithCaption(Convert.ToInt32(row["F_DESX"].ToString()), getColumn(row["F_DESY"].ToString()) + 1, dt); } else { openXMLExcel.WriteDataRerange(Convert.ToInt32(row["F_DESX"].ToString()), getColumn(row["F_DESY"].ToString()) + 1, dt); } } else { if (hasCaption) { openXMLExcel.WriteDataIntoWorksheetWithCaption(Convert.ToInt32(row["F_DESX"].ToString()), getColumn(row["F_DESY"].ToString()) + 1, dt); } else { openXMLExcel.WriteDataIntoWorksheet(Convert.ToInt32(row["F_DESX"].ToString()), getColumn(row["F_DESY"].ToString()) + 1, dt); } } } } } } } ///客户端再下载该文件,在客户端进行浏览 FileInfo fi = new FileInfo(filepath); if (fi.Exists) //判断文件是否已经存在,如果存在就删除! { fi.Delete(); } if (style == ".xlsx" || style == ".xls") { openXMLExcel.SaveAs(filepath); } else { openXMLExcel.SaveAsHtm(filepath); System.Diagnostics.Debug.WriteLine("路径"); System.Diagnostics.Debug.WriteLine(filepath); } openXMLExcel.Dispose(); openXMLExcel = null; KillProcess("EXCEL.EXE"); return("Success"); } catch (Exception e) { if (openXMLExcel != null) { openXMLExcel.Dispose(); } return(e.Message); } finally { } }