protected void GD_CATE_RowDeleting(object sender, GridViewDeleteEventArgs e) { clsMySQL db = new clsMySQL(); try { GridViewRow gvrow = GD_CATE.Rows[e.RowIndex]; string stage = gvrow.Cells[1].Text; string Input = gvrow.Cells[2].Text; string sp = gvrow.Cells[3].Text; string md = gvrow.Cells[4].Text; string category = gvrow.Cells[5].Text; string kp = gvrow.Cells[6].Text; if (Input == " ") { Input = ""; } if (sp == " ") { sp = ""; } if (md == " ") { md = ""; } if (category == " ") { category = ""; } if (kp == " ") { kp = ""; } //lblError.Text = gvrow.Cells[1].Text + "////" + gvrow.Cells[2].Text; string strSQL_Delete = string.Format("Delete from npi_ep_category where EP_Cate_Stage='{0}' and EP_Cate_Iiitems='{1}' and EP_Cate_SpeChar='{2}' and EP_Cate_Md='{3}' and EP_Cate_Cate='{4}' and EP_Cate_KP='{5}'", stage, Input, sp, md, category, kp); if (db.QueryExecuteNonQuery(strSQL_Delete)) { RegisterStartupScript("訊息通知", "<script> alert('資料已刪除,成功!!');</script>"); Response.Redirect(Request.Url.AbsoluteUri); DBint(stage); } else { //lblError.Text = strSQL_Delete; RegisterStartupScript("訊息通知", "<script> alert('資料刪除,失敗!!');</script>"); } } catch (FormatException ex) { lblError.Text = "[Error Message::NPI Category Form Delete Function]: " + ex.ToString(); } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { //lblError.Text = e.Keys["C_Code"].ToString() + "////" + e.Values.ToString(); clsMySQL db = new clsMySQL(); try { GridViewRow gvrow = GridView1.Rows[e.RowIndex]; lblError.Text = gvrow.Cells[1].Text + "////" + gvrow.Cells[2].Text; string strSQL_Delete = string.Format("Delete from npiManual where New_Customer='{0}' and New_Device='{1}'", gvrow.Cells[1].Text.Trim(), gvrow.Cells[2].Text.Trim()); if (db.QueryExecuteNonQuery(strSQL_Delete)) { RegisterStartupScript("訊息通知", "<script> alert('資料已刪除,成功!!');</script>"); ChangeViewMode(); } else { //lblError.Text = strSQL_Delete; RegisterStartupScript("訊息通知", "<script> alert('資料刪除,失敗!!');</script>"); } } catch (FormatException ex) { lblError.Text = "[Error Message::NPI Manual Form Delete Function]: " + ex.ToString(); } }
protected void GD_CAP_RowDeleting1(object sender, GridViewDeleteEventArgs e) { clsMySQL db = new clsMySQL(); try { GridViewRow gvrow = GD_CAP.Rows[e.RowIndex]; //lblError.Text = gvrow.Cells[1].Text + "////" + gvrow.Cells[2].Text; string strSQL_Delete = string.Format("Delete from npiManual where CAP_EP_Name='{0}'", gvrow.Cells[1].Text.Trim()); if (db.QueryExecuteNonQuery(strSQL_Delete)) { RegisterStartupScript("訊息通知", "<script> alert('資料已刪除,成功!!');</script>"); //ChangeViewMode(); } else { //lblError.Text = strSQL_Delete; RegisterStartupScript("訊息通知", "<script> alert('資料刪除,失敗!!');</script>"); } } catch (FormatException ex) { lblError.Text = "[Error Message::NPI Manual Form Delete Function]: " + ex.ToString(); } }
protected void insert_cate(int item_num, List <string> Cate_Iiitems, List <string> Cate_SpeChar, List <string> Cate_Md, List <string> Cate_Cate, List <string> Cate_KP, string name, string status, string stage) { clsMySQL db = new clsMySQL(); List <int> success_insert = new List <int>(); List <int> fail_insert = new List <int>(); int success_count = 0; int fail_count = 0; List <string> history_cate = new List <string>(); for (int i = 0; i < item_num; i++) { String insert_cate = string.Format("insert into npi_cap_ep" + "(npi_EP_Cate_Username,npi_EP_Cate_UpdateTime,npi_EP_Cate_Status," + "EP_Cate_Stage,EP_Cate_Iiitems,EP_Cate_SpeChar," + "EP_Cate_Md,EP_Cate_Cate,EP_Cate_KP)values" + "('{0}',NOW(),'{1}'," + "'{2}','{3}','{4}','{5}','{6}','{7}')" , name, status, stage, Cate_Iiitems[i], Cate_SpeChar[i], Cate_Md[i], Cate_Cate[i], Cate_KP[i]); if (db.QueryExecuteNonQuery(insert_cate) == true) { success_count++; } else { fail_count++; history_cate.Add(Cate_Iiitems[i] + "|" + Cate_SpeChar[i] + "|" + Cate_Md[i] + "|" + Cate_Cate[i] + "|" + Cate_KP[i]); } } /* * try * { * /*if (Text_Packge_insert.Text.Trim() == "") * { * string strScript = string.Format("<script language='javascript'>alert('您沒有輸入Packge_Name!');</script>"); * Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); * } * if () * { * string strScript = string.Format("<script language='javascript'>alert('Category新增成功');</script>"); * Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); * * } * else * { * string strScript = string.Format("<script language='javascript'>alert('Category新增成功');</script>"); * Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); * } * } * catch (Exception ex) * { * throw ex; * } * */ }
protected void but_Save_lv_Click(object sender, EventArgs e) { clsMySQL db = new clsMySQL(); string SpeChar = ""; string md = ""; string cate = ""; string key = ""; string t = ""; string f = ""; for (int i = 0; i < GridView1.Rows.Count; i++) { SpeChar = GridView1.Rows[i].Cells[0].Text; md = GridView1.Rows[i].Cells[1].Text; cate = GridView1.Rows[i].Cells[2].Text; key = GridView1.Rows[i].Cells[3].Text; DropDownList ddl_Lv = (DropDownList)GridView1.Rows[i].Cells[4].FindControl("Doe_Lv"); String insert_cap = string.Format("insert into npi_eptra_doe_lv" + "(Lv_filename,Lv_stage,Lv_SpecChar," + "Lv_Iiitems,Lv_md,Lv_cate," + "Lv_kp,Lv_TraLv)values" + "('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", "ver.1", "PI1", SpeChar, "PI Thickness (um)", md, cate, key, ddl_Lv.SelectedItem); try { if (db.QueryExecuteNonQuery(insert_cap) == true) { t += Convert.ToString(i) + ","; } else { f += Convert.ToString(i) + ","; } } catch (Exception ex) { throw ex; } } //string strScript = string.Format("<script language='javascript'>alert("+f+"\n"+t+");</script>"); //Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); }
protected void LinkButton_Insert_Add_Click(object sender, EventArgs e) { clsMySQL db = new clsMySQL(); string Status = "Y"; string User_Name = "CIM"; String insert_cap = string.Format("insert into npi_ep_category" + "(npi_EP_Cate_Username,npi_EP_Cate_UpdateTime,npi_EP_Cate_Status," + "EP_Cate_Stage,EP_Cate_Iiitems,EP_Cate_SpeChar," + "EP_Cate_Md,EP_Cate_Cate,EP_Cate_KP)values" + "('{0}',NOW(),'{1}','{2}','{3}','{4}','{5}','{6}','{7}')", text_ad_cate_user.Text, Status, text_ad_cate_stage.Text, text_ad_cate_input.Text, text_ad_cate_sp.Text, text_ad_cate_md.Text, text_ad_cate_cate.Text, text_ad_cate_kp.Text); try { if (text_ad_cate_stage.Text.Trim() == "") { string strScript = string.Format("<script language='javascript'>alert('您沒有輸入Stage,請重新輸入!');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); Panel_Add_Category.Visible = true; Panel_Category_View.Visible = false; Panel_update_category.Visible = false; Panel_Category.Visible = false; } else if (db.QueryExecuteNonQuery(insert_cap) == true) { string strScript = string.Format("<script language='javascript'>alert('Stage:" + text_ad_cate_stage.Text + "新增成功');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); Panel_Add_Category.Visible = false; Panel_update_category.Visible = false; Panel_Category.Visible = true; Response.Redirect(Request.Url.AbsoluteUri); DBint(text_ad_cate_stage.Text); } else { string strScript = string.Format("<script language='javascript'>alert('新增失敗');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); } } catch (Exception ex) { throw ex; } }
protected void up_lv_signoff_sta(string sign, int rowindex, string com) { string ver = GridView1.Rows[rowindex].Cells[2].Text; string Lv_Sign = Lv_sign.Value; string sign_Name = "jj"; clsMySQL db = new clsMySQL(); String update_Lv = string.Format("UPDATE npieptra_main_signoff_status " + "SET Signoff_Status='{0}',Signoff_Name='{1}',Signoff_Time=NOW(),Signoff_Command='{2}'" + "where Ver_Name='{3}' and Signoff_Status='{4}' " , sign, sign_Name, com, ver, "NA"); string str_eptraver_main_sta = "select * from npieptra_main_signoff_status where Ver_Name='" + ver + "'"; try { if (db.QueryExecuteNonQuery(update_Lv) == true) { if (Lv_Sign == "Acc") { string strScript = string.Format("<script language='javascript'>alert('" + ver + "簽核完成!');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); } else if (Lv_Sign == "Rej") { string strScript = string.Format("<script language='javascript'>alert('" + ver + "簽核完成!');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); } Panel_gv2.Visible = true; clsMySQL.DBReply dr = db.QueryDS(str_eptraver_main_sta); GridView2.DataSource = dr.dsDataSet.Tables[0].DefaultView; GridView2.DataBind(); set_sta_srt("gv2"); } else { lblError.Text = update_Lv; } } catch (Exception ex) { throw ex; } db.Close(); }
/*public void getData() * { * DataTable aTb = WebUtility.GetSQLdata("select * from product where id='0';", "teachDB"); * * if (aTb.Rows.Count == 0) * { * * aTb.Rows.Add(aTb.NewRow()); * * GridView1.DataSource = aTb; * GridView1.DataBind(); * * * int columnCount = GridView1.Rows[0].Cells.Count; * GridView1.Rows[0].Cells.Clear(); * GridView1.Rows[0].Cells.Add(new TableCell()); * * GridView1.Rows[0].Cells[0].ColumnSpan = columnCount; * GridView1.Rows[0].Cells[0].Text = "無資料!"; * GridView1.RowStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center; * } * else * { * GridView1.DataSource = aTb; * GridView1.DataBind(); * } * * * }*/ protected void Button_Update_Click(object sender, EventArgs e) { clsMySQL db = new clsMySQL(); int index; string Status = "Y"; index = Convert.ToInt32(Session["gvrow_index"].ToString()); GridViewRow gvrow = GD_CATE.Rows[index]; Session.Clear(); String update_cate = string.Format("update npi_ep_category set " + "npi_EP_Cate_Username='******',npi_EP_Cate_UpdateTime=NOW(),npi_EP_Cate_Status='{1}'," + "EP_Cate_Stage='{2}',EP_Cate_Iiitems='{3}',EP_Cate_SpeChar='{4}'," + "EP_Cate_Md='{5}',EP_Cate_Cate='{6}',EP_Cate_KP='{7}' " + "where EP_Cate_Stage='{8}' and EP_Cate_Iiitems='{9}' and EP_Cate_SpeChar='{10}'" + "and EP_Cate_Md='{11}'and EP_Cate_Cate='{12}' and EP_Cate_KP='{13}' " , text_up_cate_user.Text, Status, text_cate_stage.Text, text_cate_input.Text , text_cate_sp.Text, text_cate_md.Text, text_cate_cate.Text, text_cate_kp.Text , gvrow.Cells[1].Text.Trim(), gvrow.Cells[2].Text.Trim(), gvrow.Cells[3].Text.Trim() , gvrow.Cells[4].Text.Trim(), gvrow.Cells[5].Text.Trim(), gvrow.Cells[6].Text.Trim()); try { if (db.QueryExecuteNonQuery(update_cate)) { RegisterStartupScript("訊息通知", "<script> alert('資料更新,成功!!');</script>"); Panel_update_category.Visible = false; Panel_Category.Visible = true; DBint(text_cate_stage.Text); //ChangeViewMode(); } else { //lblError.Text = strSQL_Delete; RegisterStartupScript("訊息通知", "<script> alert('資料更新,失敗!!');</script>"); } } catch (FormatException ex) { lblError.Text = "[Error Message::NPI Manual Form Delete Function]: " + ex.ToString(); } }
public static string test_pass(string str) { List <string> DOE_list = new List <string>(); clsMySQL db = new clsMySQL(); //string File_Name = .Session["Version_Name"].ToString(); string[] str_list = str.Split('|'); for (int i = 0; i < str_list.Length; i++) { DOE_list.Add(str_list[i]); } String insert_DOE = string.Format("insert into npi_eptra_doe" + "(eptra_filename,doe_stage,doe_SpeChar,doe_md," + "doe_cate,doe_kp,doe_legs_1,doe_legs_2,doe_wafer," + "doe_wt_dm,doe_wt_pc,doe_wt_live,doe_attr,doe_note," + "doe_lot,doe_duedate,doe_result)values" + "('{0}','{1}','{2}'," + "'{3}','{4}','{5}','{6}','{7}'," + "'{8}','{9}','{10}','{11}','{12}'," + "'{13}','{14}','{15}','{16}')" , DOE_list[0], DOE_list[1], DOE_list[2], DOE_list[3], DOE_list[4], DOE_list[5], DOE_list[6], DOE_list[7], DOE_list[8], DOE_list[9], DOE_list[10], DOE_list[11], DOE_list[12], DOE_list[13], DOE_list[14], DOE_list[15], "bruno"); try { if (db.QueryExecuteNonQuery(insert_DOE)) { return("1"); } else { return("0"); } } catch (Exception ex) { throw ex; } }
protected void up_lv_signoff_sta(int RowIndex, string com) { string ver = gv_display_Lv_signoffdata.Rows[RowIndex].Cells[1].Text; string up_Name = "bruno"; clsMySQL db = new clsMySQL(); String update_Lv = string.Format("UPDATE npieptra_lv_main_status " + " SET Ver_Status='{0}',UpdateName='{1}',UpdateTime=NOW(),LV_Signoff_Status_Change_Command='{2}'" + "where Ver_Name='{3}' and Ver_Status='{4}'", "Disable", up_Name, com, ver, "Enable"); string str_eptraver_main_sta = "select * from npieptra_lv_main_Status where Ver_Name='" + ver + "'"; try { if (db.QueryExecuteNonQuery(update_Lv) == true) { Panel_gv1.Visible = false; Panel_gv2.Visible = true; clsMySQL.DBReply dr = db.QueryDS(str_eptraver_main_sta); signoff_gv2.DataSource = dr.dsDataSet.Tables[0].DefaultView; signoff_gv2.DataBind(); set_sta_srt("gv2"); } else { lblError.Text = update_Lv + db.ToString(); } } catch (Exception ex) { throw ex; } db.Close(); }
public static string DEL_Category(string str_stage) { string strError = ""; string[] category_spilit_inf = new string[6]; category_spilit_inf = str_stage.Split('|'); for (int i = 0; i < category_spilit_inf.Length; i++) { if (category_spilit_inf[i] == " ") { category_spilit_inf[i] = ""; } } string strSQL_Delete = string.Format("Delete from npi_ep_category where EP_Cate_Stage='{0}' and EP_Cate_Iiitems='{1}' and EP_Cate_SpeChar='{2}' and EP_Cate_Md='{3}' and EP_Cate_Cate='{4}' and EP_Cate_KP='{5}'", category_spilit_inf[0], category_spilit_inf[1], category_spilit_inf[2], category_spilit_inf[3], category_spilit_inf[4], category_spilit_inf[5]); clsMySQL db = new clsMySQL(); if (db.QueryExecuteNonQuery(strSQL_Delete)) { strError = "刪除成功!"; //DBint(category_spilit_inf[0]); HttpContext.Current.Session["value_del_stage"] = category_spilit_inf[0]; db.Close(); } else { strError = "Error Message:[NPI ManualForm] Delete Fail!!"; } return(strError); }
protected void cmdFilter_Click(object sender, EventArgs e) { string CreateName = "cre_CIM"; string UpName = "up_CIM"; string Signoff_SendName = "sing_CIM"; clsMySQL db = new clsMySQL(); String insert_lv = string.Format("insert into npieptra_lv_main_status" + "(Ver_Name,Ver_No,Ver_Status,CreateTime,CreateName,UpdateTime,UpdateName," + "LV_Signoff_Status,LV_Signoff_SendName,LV_Signoff_SendTime)Values" + "('{0}','{1}','{2}',NOW(),'{3}',NOW(),'{4}','{5}','{6}',NOW())"+ "ON DUPLICATE KEY UPDATE LV_Signoff_SendName='{6}',LV_Signoff_SendTime=NOW(),UpdateTime=NOW(),UpdateName='{4}',LV_Signoff_Status='{5}'", global_Ver_Name, global_Ver_No, global_Ver_Sta, CreateName, UpName, "NA", Signoff_SendName); if (!db.QueryExecuteNonQuery(insert_lv)) { lblError.Text = insert_lv; string strScript = string.Format("<script language='javascript'>alert('送審失敗!');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); } else { Response.Write("<script language=javascript>alert('送審成功!')</script>"); Response.Write("<script language=javascript>window.location.href='EPTRA_LV_SigoffList.aspx'</script>"); } }
protected void GD_CATE_RowDeleting(object sender, GridViewDeleteEventArgs e) { clsMySQL db = new clsMySQL(); try { GridViewRow gvrow = GD_CATE.Rows[e.RowIndex]; string stage = gvrow.Cells[1].Text; string Input = gvrow.Cells[2].Text; string sp = gvrow.Cells[3].Text; string md = gvrow.Cells[4].Text; string category = gvrow.Cells[5].Text; string kp = gvrow.Cells[6].Text; if (Input == " ") Input = ""; if (sp == " ") sp = ""; if (md == " ") md = ""; if (category == " ") category = ""; if (kp == " ") kp = ""; //lblError.Text = gvrow.Cells[1].Text + "////" + gvrow.Cells[2].Text; string strSQL_Delete = string.Format("Delete from npi_ep_category where EP_Cate_Stage='{0}' and EP_Cate_Iiitems='{1}' and EP_Cate_SpeChar='{2}' and EP_Cate_Md='{3}' and EP_Cate_Cate='{4}' and EP_Cate_KP='{5}'", stage,Input,sp,md,category,kp); if (db.QueryExecuteNonQuery(strSQL_Delete)) { RegisterStartupScript("訊息通知", "<script> alert('資料已刪除,成功!!');</script>"); Response.Redirect(Request.Url.AbsoluteUri); DBint(stage); } else { //lblError.Text = strSQL_Delete; RegisterStartupScript("訊息通知", "<script> alert('資料刪除,失敗!!');</script>"); } } catch (FormatException ex) { lblError.Text = "[Error Message::NPI Category Form Delete Function]: " + ex.ToString(); } }
protected void all_lv_setting(string lv_sign, string keyitem, string stage, string SpeChar) { clsMySQL db = new clsMySQL(); string insert_sign = ""; String insert_lv = string.Format("insert into npieptra_lv_main" + "(Ver_Name,EPTRA_KeyItem,EPTRA_LV_Stage,EPTRA_LV_SpecChar,EPTRA_LV)Values" + "('{0}','{1}','{2}','{3}','{4}')" + "ON DUPLICATE KEY UPDATE EPTRA_KeyItem='{1}',EPTRA_LV_Stage='{2}',EPTRA_LV_SpecChar='{3}',EPTRA_LV='{4}'", global_Ver_Name, keyitem, stage, SpeChar, lv_sign); try { if (db.QueryExecuteNonQuery(insert_lv) == true) { //t += Convert.ToString(i) + ","; insert_sign = "true"; } else { //f += Convert.ToString(i) + ","; insert_sign = "false"; lblError.Text = insert_lv + db.ToString(); } } catch (Exception ex) { lblError.Text = ex.ToString(); throw ex; } }
public void ImportToDataTable() { string fileName = ""; lblMsg.Text = ""; try { fileName = Path.GetFileName(FileUploadToServer.PostedFile.FileName); string filePath = Server.MapPath("~\\FileUpload\\") + Path.GetFileName(FileUploadToServer.PostedFile.FileName); FileUploadToServer.SaveAs(filePath); DataTable dt = new DataTable(); //---------------取出file type : DIF/D_R/DRC,取檔名的前三字元 if (CheckExcelFile(fileName)) //判斷File是否為xlsx { string strType = fileName.Substring(0, 3); string strSQL = ""; switch (strType) { case "DIF": strSQL = "select Mtype,Mname,Mpos,MRow,MCol from npimap where mtype = 'DIF' order by mid"; break; case "Q_R": strSQL = "select Mtype,Mname,Mpos,MRow,MCol from npimap where mtype = 'Q_R' order by mid"; break; case "DRC": strSQL = "select Mtype,Mname,Mpos,MRow,MCol from npimap where mtype = 'DRC' order by mid"; break; default: lblMsg.ForeColor = System.Drawing.Color.Red; lblMsg.Text = "您選擇的檔案:["+ fileName +"]無法匯入,請重新選擇正確的Excel檔案!!!"; strSQL = ""; break; } //-------------------------------------------------------------------------------- var existingFile = new FileInfo(filePath); using (var package = new ExcelPackage(existingFile)) { ExcelWorkbook workBook = package.Workbook; if (workBook != null && strSQL != "") { if (workBook.Worksheets.Count > 0) { ExcelWorksheet worksheet = workBook.Worksheets.First();//Excel File的第一個Sheet1 DataTable dt_Pos = new DataTable(); clsMySQL db = new clsMySQL(); ArrayList arSQL = new ArrayList(); db.dbConn(); dt_Pos = db.dbQueryDT(strSQL);//db.QueryDataTable(strSQL); db.dbClose(); dt.Columns.Add("檔案類型"); dt.Columns.Add("欄位名稱"); dt.Columns.Add("欄位位置"); //dt.Columns.Add("Rows"); //dt.Columns.Add("Cols"); dt.Columns.Add("欄位內容"); //Get Customer and Device value---------------------------------------------------------------- string tmpCustomer = ""; string tmpDevice = ""; for (int t = 0; t <= 2; t++) { if (dt_Pos.Rows[t][1].ToString() == "Customer") { if (strType == "DRC") { string[] str2 = worksheet.Cells[Convert.ToInt32(dt_Pos.Rows[t][3].ToString()), Convert.ToInt32(dt_Pos.Rows[t][4].ToString())].Value.ToString().Split(':'); tmpCustomer = str2[1]; } else { tmpCustomer = worksheet.Cells[Convert.ToInt32(dt_Pos.Rows[t][3].ToString()), Convert.ToInt32(dt_Pos.Rows[t][4].ToString())].Value.ToString(); } } else { if (dt_Pos.Rows[t][1].ToString() == "Device") { if (strType == "DRC") { string[] str2 = worksheet.Cells[Convert.ToInt32(dt_Pos.Rows[t][3].ToString()), Convert.ToInt32(dt_Pos.Rows[t][4].ToString())].Value.ToString().Split(':'); tmpDevice = str2[1]; } else { tmpDevice = worksheet.Cells[Convert.ToInt32(dt_Pos.Rows[t][3].ToString()), Convert.ToInt32(dt_Pos.Rows[t][4].ToString())].Value.ToString(); } } } } //--------------------------------------------------------------------------------------------------------- for (int i = 0; i < dt_Pos.Rows.Count; i++) { DataRow dr = dt.NewRow(); string tmpValue = ""; int x = 0; db.dbConn(); dr[x++] = dt_Pos.Rows[i][0].ToString(); dr[x++] = dt_Pos.Rows[i][1].ToString(); dr[x++] = dt_Pos.Rows[i][2].ToString(); //dr[x++] = dt_Pos.Rows[i][3].ToString(); //dr[x++] = dt_Pos.Rows[i][4].ToString(); if (strType == "DRC" && (dt_Pos.Rows[i][2].ToString() == "B46" || dt_Pos.Rows[i][2].ToString() == "B47" || dt_Pos.Rows[i][2].ToString() == "B48")) { string[] str1 = worksheet.Cells[Convert.ToInt32(dt_Pos.Rows[i][3].ToString()), Convert.ToInt32(dt_Pos.Rows[i][4].ToString())].Value.ToString().Split(':'); dr[x++] = str1[1]; tmpValue = str1[1]; } else { dr[x++] = worksheet.Cells[Convert.ToInt32(dt_Pos.Rows[i][3].ToString()), Convert.ToInt32(dt_Pos.Rows[i][4].ToString())].Value; if (worksheet.Cells[Convert.ToInt32(dt_Pos.Rows[i][3].ToString()), Convert.ToInt32(dt_Pos.Rows[i][4].ToString())].Value == null) { tmpValue = ""; } else { tmpValue = worksheet.Cells[Convert.ToInt32(dt_Pos.Rows[i][3].ToString()), Convert.ToInt32(dt_Pos.Rows[i][4].ToString())].Value.ToString(); } } dt.Rows.Add(dr); gvRecord.DataSource = dt; gvRecord.DataBind(); //-----------------------------------insert MySql Database: npiImportData string strSQL_Query = string.Format("select * from npiImportData where New_Customer = '{0}' and New_Device ='{1}' and Stype='{2}' and Im_Pos='{3}'", tmpCustomer.Trim(), tmpDevice.Trim(), strType.Trim(), dt_Pos.Rows[i][2].ToString().Trim()); string strSQL_Del = string.Format("Delete from npiImportData where New_Customer='{0}' and New_Device='{1}' and Stype='{2}' and Im_Pos='{3}'", tmpCustomer.Trim(), tmpDevice.Trim(), strType.Trim(), dt_Pos.Rows[i][2].ToString().Trim()); arSQL.Add(strSQL_Del); string strSQL_Insert = string.Format("Insert into npiImportData (New_Customer,New_Device,Stype,UpdateTime,npiUser,Im_Name,Im_Pos,Im_Value) values (" + "'{0}','{1}','{2}',NOW(),'','{3}','{4}','{5}')", tmpCustomer.Trim(), tmpDevice.Trim(), strType.Trim(), dt_Pos.Rows[i][1].ToString().Trim(), dt_Pos.Rows[i][2].ToString().Trim(), tmpValue.Trim()); arSQL.Add(strSQL_Insert); lblMsg.ForeColor = System.Drawing.Color.Red; //if (db.QueryDataReader(strSQL_Query).HasRows) if (db.dbQueryDR(strSQL_Query).HasRows) { if (!db.myBatchNonQuery(arSQL)) { lblMsg.Text = "[Import Error Message] Delete/Insert Fail!!<br/>"; } } else { if (!db.QueryExecuteNonQuery(strSQL_Insert)) { lblMsg.Text = "[Import Error Message] Insert Fail!! <br/>"; } } arSQL.Clear(); lblMsg.Text = strSQL_Insert + "<br/>" + lblMsg.Text; //--------------------------------------- db.dbClose(); } lblMsg.ForeColor = System.Drawing.Color.Green; lblMsg.Text = "[" + fileName + "],完成資料匯入!!"; } else { lblMsg.ForeColor = System.Drawing.Color.Red; lblMsg.Text = "您選擇的[" + fileName + "]無法匯入,請重新選擇Excel檔案或檢查Excel檔案內容!!"; } } else { gvRecord.DataSource = dt; gvRecord.DataBind(); } } } File.Delete(filePath); //將IIS上的excel file刪除,C:\inetpub\wwwroot\BU3Web\FileUpload } catch (Exception exfile) { lblMsg.ForeColor = System.Drawing.Color.Red; if (fileName == "") { lblMsg.Text = "[Import Error Message] 請選擇要匯入的Excel檔案!!"; } else { lblMsg.Text = "[Import Error Message]您選擇的[" +fileName +"]無法匯入,請重新選擇Excel檔案或檢查Excel檔案內容!!"; } } }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { clsMySQL db = new clsMySQL(); int index; int i = 0; index = Convert.ToInt32(e.CommandArgument); GridViewRow selecteRow = GridView1.Rows[index]; TableCell Version = selecteRow.Cells[1]; TableCell Update_Time = selecteRow.Cells[2]; TableCell User = selecteRow.Cells[3]; TableCell Status = selecteRow.Cells[4]; TableCell Customer = selecteRow.Cells[5]; TableCell Device = selecteRow.Cells[6]; TableCell Site = selecteRow.Cells[7]; TableCell PKG = selecteRow.Cells[8]; TableCell WT = selecteRow.Cells[9]; TableCell FAB = selecteRow.Cells[10]; TableCell RVSI = selecteRow.Cells[11]; TableCell New_Customer = selecteRow.Cells[12]; TableCell New_Device = selecteRow.Cells[13]; if (e.CommandName == "Setting") { HttpContext.Current.Session["Version_Name"] = Version.Text ; global_Ver_Name = Version.Text; string sql_porgodlen = "select * from npieptraver_por where Ver_Name='" + Version.Text + "'"; string sql_newdevice = "select * from npieptraver_new where Ver_Name='" + Version.Text + "'"; string sql_gap = "select * from npieptraver_gap where Ver_Name='" + Version.Text + "'"; string sql_capability = "select * from npieptraver_cap where Ver_Name='" + Version.Text + "'"; string sql_no = "select * from npieptraver_main where Ver_Name = '" + Version.Text + "'"; ddl_select_alllv.SelectedIndex = 0; string del_str = "delete from npieptra_lv_main where Ver_Name='" + global_Ver_Name + "'"; if (!db.QueryExecuteNonQuery(del_str)) { lblError.Text = del_str; } Panel_EPTRA.Visible = true; display_PORGOlden_data(sql_porgodlen); display_NewDevice_data(sql_newdevice); display_Capability_data(sql_capability); display_gap_data(sql_gap); gap_compare(); Hide_Value.Value =count_white_lamp.ToString(); string strScript2 = string.Format("<script language='javascript'>var count_lamp =" + count_white_lamp + ";</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript2); count_white_lamp = 0; string str_no_sta = search_no_sta(sql_no); string[] temp_str = str_no_sta.Split('|'); global_Ver_No = Convert.ToInt32(temp_str[0]); global_Ver_Sta = temp_str[1]; Panel_Query_Vername.Visible = false; Panel_eptraview.Visible = false; } }
protected void Setting_Panel_Lv(Panel temp_Lv,Panel temp_stage,Panel temp_pot, string keyitem,string Lv_sign,Label lab_stage, Label lab_pot) { List<int> amount_Poten = new List<int>(); // 存放count_EffectLabel_stage 值 int amount_stage = count_Effectstage(keyitem); //int b = count_EffectLabel(keyitem); string temp_effect_name = ""; string temp_pot_name = ""; string br = ""; string temp_pot_name2 = ""; if (jude_keyitem(keyitem) == true) { for (int i = 0; i < amount_stage; i++) { Label effect = new Label(); ImageButton TraLv = new ImageButton(); Label Tratext = new Label(); temp_effect_name = display_Effectstage(keyitem, i); effect.ID ="KeyItem_"+ keyitem +"stage_" + temp_effect_name; TraLv.ID = "Imagebutton_" + keyitem + "_" + temp_effect_name; amount_Poten.Add(count_EffectLabel_stage(keyitem, temp_effect_name)); for (int j = 0; j < amount_Poten[i] + 1; j++) { br += "<br>"; } count_white_lamp++; effect.Text = temp_effect_name + br; temp_stage.Controls.Add(effect); Label Potential = new Label(); string str = ""; for (int k = 0; k < amount_Poten[i]; k++) /**/ { temp_pot_name = display_EffectLabel(keyitem, temp_effect_name, k); temp_pot_name2 += temp_pot_name + "<br />"; if (k != (amount_Poten[i] - 1)) { str += temp_pot_name + "|"; } else { str += temp_pot_name; } if (amount_Poten[i] - 1 == k) { Potential.Text += "<br>"; } //Potential.Attributes.Remove("href"); //temp_pot.Controls.Add(Potential); all_lv_setting(Lv_sign, keyitem, temp_effect_name, temp_pot_name); } if (Lv_sign == "自行選擇LV") { TraLv.ImageUrl = "icon/white.gif"; } else if (Lv_sign== "RC(Lv.3)") { TraLv.ImageUrl = "icon/red.gif"; } else if (Lv_sign == "MC(Lv.4)") { TraLv.ImageUrl = "icon/red.gif"; } else if (Lv_sign == "LC(Lv.5)") { TraLv.ImageUrl = "icon/green.gif"; } string session = "filename=" + global_Ver_Name + "&" + "keyitem=" + keyitem + "&" + "stage=" + temp_effect_name + ""; //TraLv.OnClientClick = "test(" + "\"" + session + "\"" + ");"; TraLv.OnClientClick = "AddWork_Lv_Setting('" + global_Ver_Name+"','" + keyitem+"','"+temp_effect_name+"')"; TraLv.Attributes.Add("onclick", "return false;"); TraLv.Width = Unit.Pixel(30); TraLv.Height = Unit.Pixel(30); temp_Lv.Controls.Add(TraLv); Tratext.Text = br; temp_Lv.Controls.Add(Tratext); br = ""; //string redirect = "File_Name='" + Version_name + "'&" + "keyitem='" + keyitem + "'&" + "stage='" + temp_effect_name + "'&" + "SpeChar='" + temp_pot_name + "'"; //string redirect = "File_Name='" + Version_name + "'&" + "keyitem='" + keyitem + "'&" + "stage='" + temp_effect_name + "'"; //string url = "DOE_yes.aspx?" + redirect; //Potential.NavigateUrl = url; //Potential.Target = "_self"; Potential.ID = "KeyItem" + "_" + keyitem + "Potential_" + temp_pot_name; Potential.Text = temp_pot_name2 + "<br />"; temp_pot_name2 = ""; temp_pot.Controls.Add(Potential); } } else { lab_stage.Text = "Not Defined!"; lab_stage.ForeColor = System.Drawing.Color.Red; lab_pot.Text = "Not Defined!"; lab_pot.ForeColor = System.Drawing.Color.Red; } } protected void all_lv_setting_update(string lv_sign, string keyitem, string stage, string SpeChar) { clsMySQL db = new clsMySQL(); string insert_sign = ""; String insert_lv = string.Format("insert into npieptra_lv_main" + "(Ver_Name,EPTRA_KeyItem,EPTRA_LV_Stage,EPTRA_LV_SpecChar,EPTRA_LV)Values" + "('{0}','{1}','{2}','{3}','{4}')" + "ON DUPLICATE KEY UPDATE EPTRA_KeyItem='{1}',EPTRA_LV_Stage='{2}',EPTRA_LV_SpecChar='{3}',EPTRA_LV='{4}'", global_Ver_Name, keyitem, stage, SpeChar, lv_sign); try { if (db.QueryExecuteNonQuery(insert_lv) == true) { //t += Convert.ToString(i) + ","; insert_sign = "true"; } else { //f += Convert.ToString(i) + ","; insert_sign = "false"; lblError.Text = insert_lv + db.ToString(); } } catch (Exception ex) { lblError.Text = ex.ToString(); throw ex; } } protected void all_lv_setting(string lv_sign,string keyitem,string stage,string SpeChar) { clsMySQL db = new clsMySQL(); string insert_sign = ""; String insert_lv = string.Format("insert into npieptra_lv_main" + "(Ver_Name,EPTRA_KeyItem,EPTRA_LV_Stage,EPTRA_LV_SpecChar,EPTRA_LV)Values" + "('{0}','{1}','{2}','{3}','{4}')"+ "ON DUPLICATE KEY UPDATE EPTRA_KeyItem='{1}',EPTRA_LV_Stage='{2}',EPTRA_LV_SpecChar='{3}',EPTRA_LV='{4}'", global_Ver_Name, keyitem, stage, SpeChar, lv_sign); try { if (db.QueryExecuteNonQuery(insert_lv) == true) { //t += Convert.ToString(i) + ","; insert_sign = "true"; } else { //f += Convert.ToString(i) + ","; insert_sign = "false"; lblError.Text = insert_lv+ db.ToString(); } } catch (Exception ex) { lblError.Text = ex.ToString(); throw ex; } } protected void all_lv_put_keyitem_data(string Lv_Sign) { if (lab_gap1.Text == "Y") { lab_Eff_01.Text = "--"; lab_Pot_01.Text = "--"; } else { lab_Eff_01.Text = "--"; lab_Pot_01.Text = "--"; } if (lab_gap2.Text == "Y") { lab_Eff_01.Text = "--"; lab_Pot_01.Text = "--"; } else { lab_Eff_01.Text = "--"; lab_Pot_01.Text = "--"; } if (lab_gap3.Text == "Y") { lab_Eff_01.Text = "--"; lab_Pot_01.Text = "--"; } else { lab_Eff_01.Text = "--"; lab_Pot_01.Text = "--"; } if (lab_gap4.Text == "Y") { lab_gap4.Text = "Y"; lab_gap4.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_4, Panel_Eff_04, Panel_Pot_04, Lab_keyitem_04.Text, Lv_Sign, lab_Eff_04, lab_Pot_04); } else { lab_gap4.Text = "N"; lab_gap4.ForeColor = System.Drawing.Color.Blue; lab_Eff_04.Text = "--"; lab_Pot_04.Text = "--"; } if (lab_gap5.Text == "Y") { lab_gap5.Text = "Y"; lab_gap5.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_5, Panel_Eff_05, Panel_Pot_05, Lab_keyitem_05.Text, Lv_Sign, lab_Eff_05, lab_Pot_05); } else { lab_gap5.Text = "N"; lab_gap5.ForeColor = System.Drawing.Color.Blue; lab_Eff_05.Text = "--"; lab_Pot_05.Text = "--"; } if (lab_gap6.Text == "Y") { lab_gap6.Text = "Y"; lab_gap6.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_6, Panel_Eff_06, Panel_Pot_06, Lab_keyitem_06.Text, Lv_Sign, lab_Eff_06, lab_Pot_06); } else { lab_gap6.Text = "N"; lab_gap6.ForeColor = System.Drawing.Color.Blue; lab_Eff_06.Text = "--"; lab_Pot_06.Text = "--"; } if (lab_gap7.Text == "Y") { lab_gap7.Text = "Y"; lab_gap7.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_7, Panel_Eff_07, Panel_Pot_07, Lab_keyitem_07.Text, Lv_Sign, lab_Eff_07, lab_Pot_07); } else { lab_gap7.Text = "N"; lab_gap7.ForeColor = System.Drawing.Color.Blue; lab_Eff_07.Text = "--"; lab_Pot_07.Text = "--"; } if (lab_gap8.Text == "Y") { lab_gap8.Text = "Y"; lab_gap8.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_8, Panel_Eff_08, Panel_Pot_08, Lab_keyitem_08.Text, Lv_Sign, lab_Eff_08, lab_Pot_08); } else { lab_gap8.Text = "N"; lab_gap8.ForeColor = System.Drawing.Color.Blue; lab_Eff_08.Text = "--"; lab_Pot_08.Text = "--"; } if (lab_gap9.Text == "Y") { lab_gap9.Text = "Y"; lab_gap9.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_9, Panel_Eff_09, Panel_Pot_09, Lab_keyitem_09.Text, Lv_Sign, lab_Eff_09, lab_Pot_09); } else { lab_gap9.Text = "N"; lab_gap9.ForeColor = System.Drawing.Color.Blue; lab_Eff_09.Text = "--"; lab_Pot_09.Text = "--"; } if (lab_gap10.Text == "Y") { lab_gap10.Text = "Y"; lab_gap10.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_10, Panel_Eff_10, Panel_Pot_10, Lab_keyitem_10.Text, Lv_Sign, lab_Eff_10, lab_Pot_10); } else { lab_gap10.Text = "N"; lab_gap10.ForeColor = System.Drawing.Color.Blue; lab_Eff_10.Text = "--"; lab_Pot_10.Text = "--"; } if (lab_gap11.Text == "Y") { lab_gap11.Text = "Y"; lab_gap11.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_11, Panel_Eff_11, Panel_Pot_11, Lab_keyitem_11.Text, Lv_Sign, lab_Eff_11, lab_Pot_11); } else { lab_gap11.Text = "N"; lab_gap11.ForeColor = System.Drawing.Color.Blue; lab_Eff_11.Text = "--"; lab_Pot_11.Text = "--"; } if (lab_gap12.Text == "Y") { lab_gap12.Text = "Y"; lab_gap12.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_12, Panel_Eff_12, Panel_Pot_12, Lab_keyitem_12.Text, Lv_Sign, lab_Eff_12, lab_Pot_12); } else { lab_gap12.Text = "N"; lab_gap12.ForeColor = System.Drawing.Color.Blue; lab_Eff_12.Text = "--"; lab_Pot_12.Text = "--"; } if (lab_gap13.Text == "Y") { lab_gap13.Text = "Y"; lab_gap13.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_13, Panel_Eff_13, Panel_Pot_13, Lab_keyitem_13.Text, Lv_Sign, lab_Eff_13, lab_Pot_13); } else { lab_gap13.Text = "N"; lab_gap13.ForeColor = System.Drawing.Color.Blue; lab_Eff_13.Text = "--"; lab_Pot_13.Text = "--"; } if (lab_gap14.Text == "Y") { lab_gap14.Text = "Y"; lab_gap14.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_14, Panel_Eff_14, Panel_Pot_14, Lab_keyitem_14.Text, Lv_Sign, lab_Eff_14, lab_Pot_14); } else { lab_gap14.Text = "N"; lab_gap14.ForeColor = System.Drawing.Color.Blue; lab_Eff_14.Text = "--"; lab_Pot_14.Text = "--"; } if (lab_gap15.Text == "Y") { lab_gap15.Text = "Y"; lab_gap15.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_15, Panel_Eff_15, Panel_Pot_15, Lab_keyitem_15.Text, Lv_Sign, lab_Eff_15, lab_Pot_15); } else { lab_gap15.Text = "N"; lab_gap15.ForeColor = System.Drawing.Color.Blue; lab_Eff_15.Text = "--"; lab_Pot_15.Text = "--"; } if (lab_gap16.Text == "Y") { lab_gap16.Text = "Y"; lab_gap16.ForeColor = System.Drawing.Color.Red; ///PI Thickness (um) Setting_Panel_Lv(Panel_Lv_16, Panel_Eff_16, Panel_Pot_16, Lab_keyitem_16.Text, Lv_Sign, lab_Eff_16, lab_Pot_16); } else { lab_gap16.Text = "N"; lab_gap16.ForeColor = System.Drawing.Color.Blue; lab_Eff_16.Text = "--"; lab_Pot_16.Text = "--"; } if (lab_gap17.Text == "Y") { lab_gap17.Text = "Y"; lab_gap17.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_17, Panel_Eff_17, Panel_Pot_17, Lab_keyitem_17.Text, Lv_Sign, lab_Eff_17, lab_Pot_17); } else { lab_gap17.Text = "N"; lab_gap17.ForeColor = System.Drawing.Color.Blue; lab_Eff_17.Text = "--"; lab_Pot_17.Text = "--"; } if (lab_gap18.Text == "Y") { lab_gap18.Text = "Y"; lab_gap18.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_18, Panel_Eff_18, Panel_Pot_18, Lab_keyitem_18.Text, Lv_Sign, lab_Eff_18, lab_Pot_18); } else { lab_gap18.Text = "N"; lab_gap18.ForeColor = System.Drawing.Color.Blue; lab_Eff_18.Text = "--"; lab_Pot_18.Text = "--"; } if (lab_gap19.Text == "Y") { lab_gap19.Text = "Y"; lab_gap19.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_19, Panel_Eff_19, Panel_Pot_19, Lab_keyitem_19.Text, Lv_Sign, lab_Eff_19, lab_Pot_19); } else { lab_gap19.Text = "N"; lab_gap19.ForeColor = System.Drawing.Color.Blue; lab_Eff_19.Text = "--"; lab_Pot_19.Text = "--"; } if (lab_gap20.Text == "Y") { lab_gap20.Text = "Y"; lab_gap20.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_20, Panel_Eff_20, Panel_Pot_20, Lab_keyitem_20.Text, Lv_Sign, lab_Eff_20, lab_Pot_20); } else { lab_gap20.Text = "N"; lab_gap20.ForeColor = System.Drawing.Color.Blue; lab_Eff_20.Text = "--"; lab_Pot_20.Text = "--"; } if (lab_gap21.Text == "Y") { lab_gap21.Text = "Y"; lab_gap21.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_21, Panel_Eff_21, Panel_Pot_21, Lab_keyitem_21.Text, Lv_Sign, lab_Eff_21, lab_Pot_21); } else { lab_gap21.Text = "N"; lab_gap21.ForeColor = System.Drawing.Color.Blue; lab_Eff_21.Text = "--"; lab_Pot_21.Text = "--"; } if (lab_gap22.Text == "Y") { lab_gap22.Text = "Y"; lab_gap22.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_22, Panel_Eff_22, Panel_Pot_22, Lab_keyitem_22.Text, Lv_Sign, lab_Eff_22, lab_Pot_22); } else { lab_gap22.Text = "N"; lab_gap22.ForeColor = System.Drawing.Color.Blue; lab_Eff_22.Text = "--"; lab_Pot_22.Text = "--"; } if (lab_gap23.Text == "Y") { lab_gap23.Text = "Y"; lab_gap23.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_23, Panel_Eff_23, Panel_Pot_23, Lab_keyitem_23.Text, Lv_Sign, lab_Eff_23, lab_Pot_23); } else { lab_gap23.Text = "N"; lab_gap23.ForeColor = System.Drawing.Color.Blue; lab_Eff_23.Text = "--"; lab_Pot_23.Text = "--"; } if (lab_gap24.Text == "Y") { lab_gap24.Text = "Y"; lab_gap24.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_24, Panel_Eff_24, Panel_Pot_24, Lab_keyitem_24.Text, Lv_Sign, lab_Eff_24, lab_Pot_24); } else { lab_gap24.Text = "N"; lab_gap24.ForeColor = System.Drawing.Color.Blue; lab_Eff_24.Text = "--"; lab_Pot_24.Text = "--"; } if (lab_gap25.Text == "Y") { lab_gap25.Text = "Y"; lab_gap25.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_25, Panel_Eff_25, Panel_Pot_25, Lab_keyitem_25.Text, Lv_Sign, lab_Eff_25, lab_Pot_25); } else { lab_gap25.Text = "N"; lab_gap25.ForeColor = System.Drawing.Color.Blue; lab_Eff_25.Text = "--"; lab_Pot_25.Text = "--"; } if (lab_gap26.Text == "Y") { lab_gap26.Text = "Y"; lab_gap26.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_26, Panel_Eff_26, Panel_Pot_26, Lab_keyitem_26.Text, Lv_Sign, lab_Eff_26, lab_Pot_26); } else { lab_gap26.Text = "N"; lab_gap26.ForeColor = System.Drawing.Color.Blue; lab_Eff_26.Text = "--"; lab_Pot_26.Text = "--"; } if (lab_gap27.Text == "Y") { lab_gap27.Text = "Y"; lab_gap27.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_27, Panel_Eff_27, Panel_Pot_27, Lab_keyitem_27.Text, Lv_Sign, lab_Eff_27, lab_Pot_27); } else { lab_gap27.Text = "N"; lab_gap27.ForeColor = System.Drawing.Color.Blue; lab_Eff_27.Text = "--"; lab_Pot_27.Text = "--"; } if (lab_gap28.Text == "Y") { lab_gap28.Text = "Y"; lab_gap28.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_28, Panel_Eff_28, Panel_Pot_28, Lab_keyitem_28.Text, Lv_Sign, lab_Eff_28, lab_Pot_28); } else { lab_gap28.Text = "N"; lab_gap28.ForeColor = System.Drawing.Color.Blue; lab_Eff_28.Text = "--"; lab_Pot_28.Text = "--"; } if (lab_gap29.Text == "Y") { lab_gap29.Text = "Y"; lab_gap29.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_29, Panel_Eff_29, Panel_Pot_29, Lab_keyitem_29.Text, Lv_Sign, lab_Eff_29, lab_Pot_29); } else { lab_gap29.Text = "N"; lab_gap29.ForeColor = System.Drawing.Color.Blue; lab_Eff_29.Text = "--"; lab_Pot_29.Text = "--"; } if (lab_gap30.Text == "Y") { lab_gap30.Text = "Y"; lab_gap30.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_30, Panel_Eff_30, Panel_Pot_30, Lab_keyitem_30.Text, Lv_Sign, lab_Eff_30, lab_Pot_30); } else { lab_gap30.Text = "N"; lab_gap30.ForeColor = System.Drawing.Color.Blue; lab_Eff_30.Text = "--"; lab_Pot_30.Text = "--"; } if (lab_gap31.Text == "Y") { lab_gap31.Text = "Y"; lab_gap31.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_31, Panel_Eff_31, Panel_Pot_31, Lab_keyitem_31.Text, Lv_Sign, lab_Eff_31, lab_Pot_31); } else { lab_gap31.Text = "N"; lab_gap31.ForeColor = System.Drawing.Color.Blue; lab_Eff_31.Text = "--"; lab_Pot_31.Text = "--"; } if (lab_gap32.Text == "Y") { lab_gap32.Text = "Y"; lab_gap32.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_32, Panel_Eff_32, Panel_Pot_32, Lab_keyitem_32.Text, Lv_Sign, lab_Eff_32, lab_Pot_32); } else { lab_gap32.Text = "N"; lab_gap32.ForeColor = System.Drawing.Color.Blue; lab_Eff_32.Text = "--"; lab_Pot_32.Text = "--"; } if (lab_gap33.Text == "Y") { lab_gap33.Text = "Y"; lab_gap33.ForeColor = System.Drawing.Color.Red; lab_Eff_33.Text = "--"; lab_Pot_33.Text = "--"; Setting_Panel_Lv(Panel_Lv_33, Panel_Eff_33, Panel_Pot_33, Lab_keyitem_33.Text, Lv_Sign, lab_Eff_33, lab_Pot_33); } else { lab_gap33.Text = "N"; lab_gap33.ForeColor = System.Drawing.Color.Blue; lab_Eff_33.Text = "--"; lab_Pot_33.Text = "--"; } if (lab_gap34.Text == "Y") { lab_gap34.Text = "Y"; lab_gap34.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_34, Panel_Eff_34, Panel_Pot_34, Lab_keyitem_34.Text, Lv_Sign, lab_Eff_34, lab_Pot_34); } else { lab_gap34.Text = "N"; lab_gap34.ForeColor = System.Drawing.Color.Blue; lab_Eff_34.Text = "--"; lab_Pot_34.Text = "--"; } if (lab_gap35.Text == "Y") { lab_gap35.Text = "Y"; lab_gap35.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_35, Panel_Eff_35, Panel_Pot_35, Lab_keyitem_35.Text, Lv_Sign, lab_Eff_35, lab_Pot_35); } else { lab_gap35.Text = "N"; lab_gap35.ForeColor = System.Drawing.Color.Blue; lab_Eff_35.Text = "--"; lab_Pot_35.Text = "--"; } if (lab_gap36.Text == "Y") { lab_gap36.Text = "Y"; lab_gap36.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_36, Panel_Eff_36, Panel_Pot_36, Lab_keyitem_36.Text, Lv_Sign, lab_Eff_36, lab_Pot_36); } else { lab_gap36.Text = "N"; lab_gap36.ForeColor = System.Drawing.Color.Blue; lab_Eff_36.Text = "--"; lab_Pot_36.Text = "--"; } if (lab_gap37.Text == "Y") { lab_gap37.Text = "Y"; lab_gap37.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_37, Panel_Eff_37, Panel_Pot_37, Lab_keyitem_37.Text, Lv_Sign, lab_Eff_37, lab_Pot_37); } else { lab_gap37.Text = "N"; lab_gap37.ForeColor = System.Drawing.Color.Blue; lab_Eff_37.Text = "--"; lab_Pot_37.Text = "--"; } if (lab_gap38.Text == "Y") { lab_gap38.Text = "Y"; lab_gap38.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_38, Panel_Eff_38, Panel_Pot_38, Lab_keyitem_38.Text, Lv_Sign, lab_Eff_38, lab_Pot_38); } else { lab_gap38.Text = "N"; lab_gap38.ForeColor = System.Drawing.Color.Blue; lab_Eff_38.Text = "--"; lab_Pot_38.Text = "--"; } if (lab_gap39.Text == "Y") { lab_gap39.Text = "Y"; lab_gap39.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_39, Panel_Eff_39, Panel_Pot_39, Lab_keyitem_39.Text, Lv_Sign, lab_Eff_39, lab_Pot_39); } else { lab_gap39.Text = "N"; lab_gap39.ForeColor = System.Drawing.Color.Blue; lab_Eff_39.Text = "--"; lab_Pot_39.Text = "--"; } if (lab_gap40.Text == "Y") { lab_gap40.Text = "Y"; lab_gap40.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_40, Panel_Eff_40, Panel_Pot_40, Lab_keyitem_40.Text, Lv_Sign, lab_Eff_40, lab_Pot_40); } else { lab_gap40.Text = "N"; lab_gap40.ForeColor = System.Drawing.Color.Blue; lab_Eff_40.Text = "--"; lab_Pot_40.Text = "--"; } if (lab_gap41.Text == "Y") { lab_gap41.Text = "Y"; lab_gap41.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_41, Panel_Eff_41, Panel_Pot_41, Lab_keyitem_41.Text, Lv_Sign, lab_Eff_41, lab_Pot_41); } else { lab_gap41.Text = "N"; lab_gap41.ForeColor = System.Drawing.Color.Blue; lab_Eff_41.Text = "--"; lab_Pot_41.Text = "--"; } if (lab_gap42.Text == "Y") { lab_gap42.Text = "Y"; lab_gap42.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_42, Panel_Eff_42, Panel_Pot_42, Lab_keyitem_42.Text, Lv_Sign, lab_Eff_42, lab_Pot_42); } else { lab_gap42.Text = "N"; lab_gap42.ForeColor = System.Drawing.Color.Blue; lab_Eff_42.Text = "--"; lab_Pot_42.Text = "--"; } if (lab_gap43.Text == "Y") { lab_gap43.Text = "Y"; lab_gap43.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_43, Panel_Eff_43, Panel_Pot_43, Lab_keyitem_43.Text, Lv_Sign, lab_Eff_43, lab_Pot_43); } else { lab_gap43.Text = "N"; lab_gap43.ForeColor = System.Drawing.Color.Blue; lab_Eff_43.Text = "--"; lab_Pot_43.Text = "--"; } if (lab_gap44.Text == "Y") { lab_gap44.Text = "Y"; lab_gap44.ForeColor = System.Drawing.Color.Red; //Setting_Panel_Lv(Panel_Lv_23, Panel_Eff_23, Panel_Pot_23, Lab_keyitem_23.Text, Lv_Sign, lab_Eff_23, lab_Pot_23); } else { lab_gap44.Text = "N"; lab_gap44.ForeColor = System.Drawing.Color.Blue; lab_Eff_44.Text = "--"; lab_Pot_44.Text = "--"; } if (lab_gap45.Text == "Y") { lab_gap45.Text = "Y"; lab_gap45.ForeColor = System.Drawing.Color.Red; //Setting_Panel_Lv(Panel_Lv_23, Panel_Eff_23, Panel_Pot_23, Lab_keyitem_23.Text, Lv_Sign, lab_Eff_23, lab_Pot_23); } else { lab_gap45.Text = "N"; lab_gap45.ForeColor = System.Drawing.Color.Blue; lab_Eff_45.Text = "--"; lab_Pot_45.Text = "--"; } if (lab_gap46.Text == "Y") { lab_gap46.Text = "Y"; lab_gap46.ForeColor = System.Drawing.Color.Red; //Setting_Panel_Lv(Panel_Lv_23, Panel_Eff_23, Panel_Pot_23, Lab_keyitem_23.Text, Lv_Sign, lab_Eff_23, lab_Pot_23); } else { lab_gap46.Text = "N"; lab_gap46.ForeColor = System.Drawing.Color.Blue; lab_Eff_46.Text = "--"; lab_Pot_46.Text = "--"; } if (lab_gap47.Text == "Y") { lab_gap47.Text = "Y"; lab_gap47.ForeColor = System.Drawing.Color.Red; //Setting_Panel_Lv(Panel_Lv_23, Panel_Eff_23, Panel_Pot_23, Lab_keyitem_23.Text, Lv_Sign, lab_Eff_23, lab_Pot_23); } else { lab_gap47.Text = "N"; lab_gap47.ForeColor = System.Drawing.Color.Blue; lab_Eff_47.Text = "--"; lab_Pot_47.Text = "--"; } if (lab_gap48.Text == "Y") { lab_gap48.Text = "Y"; lab_gap48.ForeColor = System.Drawing.Color.Red; //Setting_Panel_Lv(Panel_Lv_23, Panel_Eff_23, Panel_Pot_23, Lab_keyitem_23.Text, Lv_Sign, lab_Eff_23, lab_Pot_23); } else { lab_gap48.Text = "N"; lab_gap48.ForeColor = System.Drawing.Color.Blue; lab_Eff_48.Text = "--"; lab_Pot_48.Text = "--"; } if (lab_gap49.Text == "Y") { lab_gap49.Text = "Y"; lab_gap49.ForeColor = System.Drawing.Color.Red; //Setting_Panel_Lv(Panel_Lv_23, Panel_Eff_23, Panel_Pot_23, Lab_keyitem_23.Text, Lv_Sign, lab_Eff_23, lab_Pot_23); } else { lab_gap49.Text = "N"; lab_gap49.ForeColor = System.Drawing.Color.Blue; lab_Eff_49.Text = "--"; lab_Pot_49.Text = "--"; } if (lab_gap51.Text == "Y") { lab_gap51.Text = "Y"; lab_gap51.ForeColor = System.Drawing.Color.Red; //Setting_Panel_Lv(Panel_Lv_23, Panel_Eff_23, Panel_Pot_23, Lab_keyitem_23.Text, Lv_Sign, lab_Eff_23, lab_Pot_23); } else { lab_gap51.Text = "N"; lab_gap51.ForeColor = System.Drawing.Color.Blue; lab_Pot_51.Text = "--"; lab_Eff_51.Text = "--"; } if (lab_gap52.Text == "Y") { lab_gap52.Text = "Y"; lab_gap52.ForeColor = System.Drawing.Color.Red; //Setting_Panel_Lv(Panel_Lv_23, Panel_Eff_23, Panel_Pot_23, Lab_keyitem_23.Text, Lv_Sign, lab_Eff_23, lab_Pot_23); } else { lab_gap52.Text = "N"; lab_gap52.ForeColor = System.Drawing.Color.Blue; lab_Eff_52.Text = "--"; lab_Pot_52.Text = "--"; } if (lab_gap53.Text == "Y") { lab_gap53.Text = "Y"; lab_gap53.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_23, Panel_Eff_23, Panel_Pot_23, Lab_keyitem_23.Text, Lv_Sign, lab_Eff_23, lab_Pot_23); } else { lab_gap53.Text = "N"; lab_gap53.ForeColor = System.Drawing.Color.Blue; lab_Eff_53.Text = "--"; lab_Pot_53.Text = "--"; } if (lab_gap54.Text == "Y") { lab_gap54.Text = "Y"; lab_gap54.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_54, Panel_Eff_54, Panel_Pot_54, Lab_keyitem_45_4.Text, Lv_Sign, lab_Eff_54, lab_Pot_54); } else { lab_gap54.Text = "N"; lab_gap54.ForeColor = System.Drawing.Color.Blue; lab_Eff_54.Text = "--"; lab_Pot_54.Text = "--"; } if (lab_gap55.Text == "Y") { lab_gap55.Text = "Y"; lab_gap55.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_55, Panel_Eff_55, Panel_Pot_55, Lab_keyitem_46.Text, Lv_Sign, lab_Eff_55, lab_Pot_55); } else { lab_gap55.Text = "N"; lab_gap55.ForeColor = System.Drawing.Color.Blue; lab_Eff_55.Text = "--"; lab_Pot_55.Text = "--"; } if (lab_gap56.Text == "Y") { lab_gap56.Text = "Y"; lab_gap56.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_56, Panel_Eff_56, Panel_Pot_56, Lab_keyitem_47.Text, Lv_Sign, lab_Eff_56, lab_Pot_56); } else { lab_gap56.Text = "N"; lab_gap56.ForeColor = System.Drawing.Color.Blue; lab_Eff_56.Text = "--"; lab_Pot_56.Text = "--"; } if (lab_gap57.Text == "Y") { lab_gap57.Text = "Y"; lab_gap57.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_57, Panel_Eff_57, Panel_Pot_57, Lab_keyitem_48.Text, Lv_Sign, lab_Eff_57, lab_Pot_57); } else { lab_gap57.Text = "N"; lab_gap57.ForeColor = System.Drawing.Color.Blue; lab_Eff_57.Text = "--"; lab_Pot_57.Text = "--"; } if (lab_gap58.Text == "Y") { lab_gap58.Text = "Y"; lab_gap58.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_58, Panel_Eff_58, Panel_Pot_58, Lab_keyitem_49.Text, Lv_Sign, lab_Eff_58, lab_Pot_58); } else { lab_gap58.Text = "N"; lab_gap58.ForeColor = System.Drawing.Color.Blue; lab_Eff_58.Text = "--"; lab_Pot_58.Text = "--"; } if (lab_gap59.Text == "Y") { lab_gap59.Text = "Y"; lab_gap59.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_59, Panel_Eff_59, Panel_Pot_59, Lab_keyitem_59.Text, Lv_Sign, lab_Eff_59, lab_Pot_59); } else { lab_gap59.Text = "N"; lab_gap59.ForeColor = System.Drawing.Color.Blue; lab_Eff_59.Text = "--"; lab_Pot_59.Text = "--"; } if (lab_gap60.Text == "Y") { lab_gap60.Text = "Y"; lab_gap60.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_60, Panel_Eff_60, Panel_Pot_60, Lab_keyitem_60.Text, Lv_Sign, lab_Eff_60, lab_Pot_60); } else { lab_gap60.Text = "N"; lab_gap60.ForeColor = System.Drawing.Color.Blue; lab_Eff_60.Text = "--"; lab_Pot_60.Text = "--"; } if (lab_gap61.Text == "Y") { lab_gap61.Text = "Y"; lab_gap61.ForeColor = System.Drawing.Color.Red; Setting_Panel_Lv(Panel_Lv_61, Panel_Eff_61, Panel_Pot_61, Lab_keyitem_61.Text, Lv_Sign, lab_Eff_61, lab_Pot_61); } else { lab_gap61.Text = "N"; lab_gap61.ForeColor = System.Drawing.Color.Blue; lab_Eff_61.Text = "--"; lab_Pot_61.Text = "--"; } if (lab_gap62.Text == "Y") { lab_gap62.Text = "Y"; lab_gap62.ForeColor = System.Drawing.Color.Red; lab_Eff_62.Text = "--"; lab_Pot_62.Text = "--"; } else { lab_gap62.Text = "N"; lab_gap62.ForeColor = System.Drawing.Color.Blue; lab_Eff_62.Text = "--"; lab_Pot_62.Text = "--"; } if (lab_gap63.Text == "Y") { lab_gap63.Text = "Y"; lab_gap63.ForeColor = System.Drawing.Color.Red; lab_Eff_63.Text = "--"; lab_Pot_63.Text = "--"; } else { lab_gap63.Text = "N"; lab_gap63.ForeColor = System.Drawing.Color.Blue; lab_Pot_63.Text = "--"; lab_Eff_63.Text = "--"; } if (lab_gap64.Text == "Y") { lab_gap64.Text = "Y"; lab_gap64.ForeColor = System.Drawing.Color.Red; lab_Eff_64.Text = "--"; lab_Pot_64.Text = "--"; } else { lab_gap64.Text = "N"; lab_gap64.ForeColor = System.Drawing.Color.Blue; lab_Eff_64.Text = "--"; lab_Pot_64.Text = "--"; } if (lab_gap65.Text == "Y") { lab_gap65.Text = "Y"; lab_gap65.ForeColor = System.Drawing.Color.Red; lab_Eff_65.Text = "--"; lab_Pot_65.Text = "--"; } else { lab_gap65.Text = "N"; lab_gap65.ForeColor = System.Drawing.Color.Blue; lab_Eff_65.Text = "--"; lab_Pot_65.Text = "--"; } } [System.Web.Services.WebMethod] public static void jyny(string prefix) { //Response.Redirect("EP_TRA.aspx"); int i = 0; } protected void ddl_select_alllv_SelectedIndexChanged(object sender, EventArgs e) { clsMySQL db = new clsMySQL(); string lv_sign = ddl_select_alllv.SelectedValue; switch(lv_sign) { case "自行選擇LV": //ddl_select_alllv.SelectedIndex = 3; string strScript = string.Format("<script language='javascript'>ALL_Level('" + lv_sign + "','" + select_lv_before + "');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); select_lv_before = ddl_select_alllv.SelectedValue; break; case "RC(Lv.3)": string strScript2 = string.Format("<script language='javascript'>ALL_Level('" + lv_sign + "','" + select_lv_before + "');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript2); hf_Lvsign.Value = lv_sign; /*if(hf_sign.Value=="t") { all_lv_put_keyitem_data(select_lv_before); }*/ select_lv_before = ddl_select_alllv.SelectedValue; break; case "MC(Lv.4)": string strScript3 = string.Format("<script language='javascript'>ALL_Level('" + lv_sign + "','" + select_lv_before + "');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript3); hf_Lvsign.Value = lv_sign; /*if (hf_sign.Value == "t") { all_lv_put_keyitem_data(select_lv_before); }*/ select_lv_before = ddl_select_alllv.SelectedValue; break; case "LC(Lv.5)": string strScript4 = string.Format("<script language='javascript'>ALL_Level('" + lv_sign + "','" + select_lv_before + "');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript4); hf_Lvsign.Value = lv_sign; /*if (hf_sign.Value == "t") { all_lv_put_keyitem_data(select_lv_before); }*/ select_lv_before = ddl_select_alllv.SelectedValue; break; } } protected void cmdFilter_Click(object sender, EventArgs e) { string CreateName = "cre_CIM"; string UpName = "up_CIM"; string Signoff_SendName = "sing_CIM"; clsMySQL db = new clsMySQL(); String insert_lv = string.Format("insert into npieptra_lv_main_status" + "(Ver_Name,Ver_No,Ver_Status,CreateTime,CreateName,UpdateTime,UpdateName," + "LV_Signoff_Status,LV_Signoff_SendName,LV_Signoff_SendTime)Values" + "('{0}','{1}','{2}',NOW(),'{3}',NOW(),'{4}','{5}','{6}',NOW())", global_Ver_Name, global_Ver_No, global_Ver_Sta, CreateName, UpName, "NA", Signoff_SendName); if (!db.QueryExecuteNonQuery(insert_lv)) { lblError.Text = insert_lv; string strScript = string.Format("<script language='javascript'>alert('送審失敗!');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); } else { Response.Write("<script language=javascript>alert('送審成功!')</script>"); Response.Write("<script language=javascript>window.location.href='EPTRA_LV_Setting.aspx'</script>"); } }
protected void btnUpload_Click(object sender, EventArgs e) { string sheet_name = ""; int sheet_num; int dLastNum; int cate_items = 0; String Cate_Username = "******"; String Cate_Status = "Y"; DateTime dt = DateTime.Now; string inf_ID = ""; List<string> List_Inf_ID = new List<string>(); Boolean sign_count = false; /*List<string> Cate_Iiitems = new List<string>(); List<string> Cate_SpeChar = new List<string>(); List<string> Cate_Md = new List<string>(); List<string> Cate_Cate = new List<string>(); List<string> Cate_KP = new List<string>(); */ List<int> success_insert = new List<int>(); List<int> fail_insert = new List<int>(); int success_count = 0; int fail_count = 0; List<string> history_cate = new List<string>(); string fileName = ""; string time = ""; string count_sheet_name = ""; int debug_count=0; Boolean sign = false; Boolean sign_repeat = false; clsMySQL db = new clsMySQL(); try { fileName = Path.GetFileName(FileUploadToServer.PostedFile.FileName); //string filePath = Server.MapPath("~\\bruno\\FileUpload_Folder\\") + Path.GetFileName(FileUploadToServer.PostedFile.FileName); string filePath = Server.MapPath("FileUpload_Folder\\") + Path.GetFileName(FileUploadToServer.PostedFile.FileName); FileUploadToServer.SaveAs(filePath); if (CheckExcelFile(fileName)) { /* if (FileUploadToServer.HasFile) { } */ XSSFWorkbook wk = new XSSFWorkbook(FileUploadToServer.FileContent); XSSFSheet hst; XSSFRow hr; DataTable myDT = new DataTable(); sheet_num = wk.NumberOfSheets; for (int k = 0; k < sheet_num; k++) //從每張工作表開始做 { hst = (XSSFSheet)wk.GetSheetAt(k); cate_items = hst.LastRowNum; //每一張工作表有幾筆資料 sheet_name = hst.SheetName; if (k != sheet_num - 1) //顯示匯入的Stage有哪些 count_sheet_name += sheet_name + ","; else count_sheet_name += sheet_name; hr = (XSSFRow)hst.GetRow(0); dLastNum = hr.LastCellNum; //每一列的欄位數 /* for (int i = hr.FirstCellNum; i < hr.LastCellNum; i++) { if (hr.GetCell(i) != null) { DataColumn myColumn = new DataColumn(hr.GetCell(i).StringCellValue); myDT.Columns.Add(myColumn); } }*/ for (int j = 1; j <= cate_items; j++) { hr = (XSSFRow)hst.GetRow(j); //XSSFRow row = (XSSFRow) mySheet.GetRow(i); DataRow myrow = myDT.NewRow(); /*for(int i=1;i<dLastNum;i++) { //string strcell = hr.GetCell(i) == null ? "0" : hr.GetCell(i).ToString(); myrow = }*/ String insert_cate = string.Format("insert into npi_ep_category" + "(npi_EP_Cate_Username,npi_EP_Cate_UpdateTime,npi_EP_Cate_Status," + "EP_Cate_Stage,EP_Cate_Iiitems,EP_Cate_SpeChar," + "EP_Cate_Md,EP_Cate_Cate,EP_Cate_KP)values" + "('{0}',NOW(),'{1}'," + "'{2}','{3}','{4}','{5}','{6}','{7}')" , Cate_Username, Cate_Status, sheet_name, hr.GetCell(0), hr.GetCell(1), hr.GetCell(2), hr.GetCell(3), hr.GetCell(4)); string excel_sql = sheet_name +"|"+ hr.GetCell(0) + "|" + hr.GetCell(1) + "|" + hr.GetCell(2) + "|" + hr.GetCell(3) + "|" + hr.GetCell(4); Label1.Text = dt.ToString("yyyy/MM/dd hh:mm:ss"); time = Label1.Text; if (jude_npiepcategory_data(excel_sql, sheet_name) == true) { if (db.QueryExecuteNonQuery(insert_cate) == true) { success_count++; sign = true; } else { fail_count++; history_cate.Add(hr.GetCell(0) + "|" + hr.GetCell(1) + "|" + hr.GetCell(2) + "|" + hr.GetCell(3) + "|" + hr.GetCell(4)); } debug_count++; } else { List_Inf_ID.Add(Session["value_ID"].ToString()); sign_repeat = true; sign_count = true; } Session.Clear(); debug_count = 0; } } wk = null; hst = null; hr = null; } else { lblMsg.ForeColor = System.Drawing.Color.Red; lblMsg.Text = "您選擇的[" + fileName + "]無法匯入,請重新選擇Excel檔案或檢查Excel檔案內容!!"; } /*string strScript2 = string.Format("<script language='javascript'>alert('完成匯入\\n成功匯入筆數:" + success_count + "\\n匯入的Stage:" + count_sheet_name + "');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript2);*/ Lab_item.Text = success_count.ToString(); Lab_Stage.Text = count_sheet_name; lblMsg.Text = fileName + "上傳成功!!"; System.IO.File.Delete(filePath); if (sign_count == true) { for (int i = 0; i < List_Inf_ID.Count; i++) { inf_ID += List_Inf_ID[i]; } string[] spilit_inf_id = inf_ID.Split(','); string strScript2 = string.Format("<script language='javascript'>alert('重複資料筆數:"+List_Inf_ID.Count.ToString()+"\\n資料重複編號:" + str_id(spilit_inf_id) + "');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript2); } } catch (Exception exfile) { lblMsg.ForeColor = System.Drawing.Color.Red; excp.Text = exfile.ToString(); if (fileName == "") { lblMsg.Text = "[Import Error Message] 請選擇要匯入的Excel檔案!!"; } else { lblMsg.Text = "[Import Error Message]您選擇的[" + fileName + "]無法匯入,請重新選擇Excel檔案或檢查Excel檔案內容!!"; } } finally { /*string strScript = string.Format("<script language='javascript'>alert('您沒有輸入Packge_Name!');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript);*/ } string sql_cate_datetime = "select * from npi_ep_category where npi_ep_category.npi_EP_Cate_UpdateTime >= DATE_FORMAT('" + time+ "', '%Y/%m/%d %H:%i:%s')"; //DATE_FORMAT('2016/04/28 11:26:00', '%Y/%m/%d %H:%i:%s') if (sign == true) { clsMySQL ds = new clsMySQL(); clsMySQL.DBReply dr = ds.QueryDS(sql_cate_datetime); gvRecord.DataSource = dr.dsDataSet.Tables[0].DefaultView; gvRecord.DataBind(); ds.Close(); } /*if(sign==true) { clsMySQL ds = new clsMySQL(); clsMySQL.DBReply dr = ds.QueryDS(sql_cate_datetime); gvRecord2.DataSource = dr.dsDataSet.Tables[0].DefaultView; gvRecord2.DataBind(); ds.Close(); }*/ }
protected void LinkButton1_Click(object sender, EventArgs e) { clsMySQL db = new clsMySQL(); string temp = ""; temp = Session["value_cap_pkgname"].ToString(); string Status = "Y"; string User_Name = "CIM"; String update_cap = string.Format("update npi_cap_ep set " + "CAP_EP_Name='{0}',Update_Time=NOW(),npiuser='******',CAP_EP_Status='{2}'," + "CAP_EP_01='{3}',CAP_EP_02='{4}',CAP_EP_03='{5}',CAP_EP_04='{6}',CAP_EP_05='{7}'," + "CAP_EP_06='{8}',CAP_EP_07='{9}',CAP_EP_08='{10}',CAP_EP_09='{11}',CAP_EP_10='{12}'," + "CAP_EP_11='{13}',CAP_EP_12='{14}',CAP_EP_13='{15}',CAP_EP_14='{16}',CAP_EP_15='{17}'," + "CAP_EP_16='{18}',CAP_EP_17='{19}',CAP_EP_18='{20}',CAP_EP_19='{21}',CAP_EP_20='{22}'," + "CAP_EP_21='{23}',CAP_EP_22='{24}',CAP_EP_23='{25}',CAP_EP_24='{26}',CAP_EP_25='{27}'," + "CAP_EP_26='{28}',CAP_EP_27='{29}',CAP_EP_28='{30}',CAP_EP_29='{31}',CAP_EP_30='{32}'," + "CAP_EP_31='{33}',CAP_EP_32='{34}',CAP_EP_33='{35}',CAP_EP_34='{36}',CAP_EP_35='{37}'," + "CAP_EP_36='{38}',CAP_EP_37='{39}',CAP_EP_38='{40}',CAP_EP_39='{41}',CAP_EP_40='{42}'," + "CAP_EP_41='{43}',CAP_EP_42='{44}',CAP_EP_43='{45}',CAP_EP_44='{46}',CAP_EP_45='{47}'," + "CAP_EP_46='{48}',CAP_EP_47='{49}',CAP_EP_48='{50}',CAP_EP_49='{51}',CAP_EP_50='{52}'," + "CAP_EP_51='{53}',CAP_EP_52='{54}',CAP_EP_53='{55}',CAP_EP_54='{56}',CAP_EP_55='{57}'," + "CAP_EP_56='{58}',CAP_EP_57='{59}',CAP_EP_58='{60}',CAP_EP_59='{61}',CAP_EP_60='{62}'," + "CAP_EP_61='{63}',CAP_EP_62='{64}',CAP_EP_63='{65}',CAP_EP_64='{66}',CAP_EP_65='{67}'," + "CAP_POR_EP_01='{68}',CAP_POR_EP_02='{69}',CAP_POR_EP_03='{70}',CAP_POR_EP_04='{71}',CAP_POR_EP_05='{72}'," + "CAP_POR_EP_06='{73}',CAP_POR_EP_07='{74}',CAP_POR_EP_08='{75}',CAP_POR_EP_09='{76}',CAP_POR_EP_10='{77}'," + "CAP_POR_EP_11='{78}',CAP_POR_EP_12='{79}',CAP_POR_EP_13='{80}',CAP_POR_EP_14='{81}',CAP_POR_EP_15='{82}' where CAP_EP_Name='" + temp + "'" , Text_UP_PK_Name.Text, User_Name, Status, Text__UP_CAP_1.Text, Text__UP_CAP_2.Text, Text__UP_CAP_3.Text, Text__UP_CAP_4.Text, Text__UP_CAP_5.Text, Text__UP_CAP_6.Text, Text__UP_CAP_7.Text, Text__UP_CAP_8.Text, Text__UP_CAP_9.Text, Text__UP_CAP_10.Text, Text__UP_CAP_11.Text, Text__UP_CAP_12.Text, Text__UP_CAP_13.Text, Text__UP_CAP_14.Text, Text__UP_CAP_15.Text, Text__UP_CAP_16.Text, Text__UP_CAP_17.Text, Text__UP_CAP_18.Text, Text__UP_CAP_19.Text, Text__UP_CAP_20.Text, Text__UP_CAP_21.Text, Text__UP_CAP_21.Text, Text__UP_CAP_22.Text, Text__UP_CAP_23.Text, Text__UP_CAP_25.Text, Text__UP_CAP_26.Text, Text__UP_CAP_27.Text, Text__UP_CAP_28.Text, Text__UP_CAP_29.Text, Text__UP_CAP_30.Text, Text__UP_CAP_31.Text, Text__UP_CAP_32.Text, Text__UP_CAP_33.Text, Text__UP_CAP_34.Text, Text__UP_CAP_35.Text, Text__UP_CAP_36.Text, Text__UP_CAP_37.Text, Text__UP_CAP_38.Text, Text__UP_CAP_39.Text, Text__UP_CAP_40.Text, Text__UP_CAP_41.Text, Text__UP_CAP_42.Text, Text__UP_CAP_43.Text, Text__UP_CAP_44.Text, Text__UP_CAP_45.Text, Text__UP_CAP_46.Text, Text__UP_CAP_47.Text, Text__UP_CAP_48.Text, Text__UP_CAP_49.Text, Text__UP_CAP_50.Text, Text__UP_CAP_51.Text, Text__UP_CAP_52.Text, Text__UP_CAP_53.Text, Text__UP_CAP_54.Text, Text__UP_CAP_55.Text, Text__UP_CAP_56.Text, Text__UP_CAP_57.Text, Text__UP_CAP_58.Text, Text__UP_CAP_59.Text, Text__UP_CAP_60.Text, Text__UP_CAP_61.Text, Text__UP_CAP_62.Text, Text__UP_CAP_63.Text, Text__UP_CAP_64.Text, Text__UP_CAP_65.Text, Text_UP_CAP_POR_1.Text, Text_UP_CAP_POR_2.Text, Text_UP_CAP_POR_3.Text, Text_UP_CAP_POR_4.Text, Text_UP_CAP_POR_5.Text, Text_UP_CAP_POR_6.Text, Text_UP_CAP_POR_7.Text, Text_UP_CAP_POR_8.Text, Text_UP_CAP_POR_9.Text, Text_UP_CAP_POR_10.Text, Text_UP_CAP_POR_11.Text, Text_UP_CAP_POR_12.Text, Text_UP_CAP_POR_13.Text, Text_UP_CAP_POR_14.Text, Text_UP_CAP_POR_15.Text); try { if (db.QueryExecuteNonQuery(update_cap)) { RegisterStartupScript("訊息通知", "<script> alert('資料更新,成功!!');</script>"); Panel_CAP_Table_View.Visible = false; Panel_CAP_Table_Update.Visible = false; Panel_CAP_table.Visible = false; Panel_Packge.Visible = true; DBint(); //ChangeViewMode(); } else { //lblError.Text = strSQL_Delete; RegisterStartupScript("訊息通知", "<script> alert('資料更新,失敗!!');</script>"); } } catch (FormatException ex) { lblError.Text = "[Error Message::NPI Manual Form Delete Function]: " + ex.ToString(); } }
protected void up_lv_signoff_sta(string sign,int rowindex,string com) { string ver = GridView1.Rows[rowindex].Cells[2].Text; string Lv_Sign = Lv_sign.Value; string sign_Name = "jj"; clsMySQL db = new clsMySQL(); String update_Lv = string.Format("UPDATE npieptra_lv_main_status " + "SET LV_Signoff_Status='{0}',LV_Signoff_Name='{1}',LV_Signoff_Time=NOW(),LV_Signoff_Command='{2}'" + "where Ver_Name='{3}' and LV_Signoff_Status='{4}' " ,sign, sign_Name,com, ver, "NA"); string str_eptraver_main_sta = "select * from npieptra_lv_main_Status where Ver_Name='" + ver + "'"; try { if (db.QueryExecuteNonQuery(update_Lv) == true) { if(Lv_Sign == "Acc") { string strScript = string.Format("<script language='javascript'>alert('"+ver+"簽核完成!');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); } else if(Lv_Sign == "Rej") { string strScript = string.Format("<script language='javascript'>alert('" + ver + "簽核完成!');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); } clsMySQL.DBReply dr = db.QueryDS(str_eptraver_main_sta); GridView2.DataSource = dr.dsDataSet.Tables[0].DefaultView; GridView2.DataBind(); set_sta_srt("gv2"); } else { lblError.Text = update_Lv; } } catch (Exception ex) { throw ex; } db.Close(); }
protected void Button_Add_Click(object sender, EventArgs e) { clsMySQL db = new clsMySQL(); string Status = "Y"; string User_Name = "CIM"; String insert_cap = string.Format("insert into npi_cap_ep" + "(CAP_EP_Name,Update_Time,npiuser,CAP_EP_Status," + "CAP_EP_01,CAP_EP_02,CAP_EP_03,CAP_EP_04,CAP_EP_05," + "CAP_EP_06,CAP_EP_07,CAP_EP_08,CAP_EP_09,CAP_EP_10," + "CAP_EP_11,CAP_EP_12,CAP_EP_13,CAP_EP_14,CAP_EP_15," + "CAP_EP_16,CAP_EP_17,CAP_EP_18,CAP_EP_19,CAP_EP_20," + "CAP_EP_21,CAP_EP_22,CAP_EP_23,CAP_EP_24,CAP_EP_25," + "CAP_EP_26,CAP_EP_27,CAP_EP_28,CAP_EP_29,CAP_EP_30," + "CAP_EP_31,CAP_EP_32,CAP_EP_33,CAP_EP_34,CAP_EP_35," + "CAP_EP_36,CAP_EP_37,CAP_EP_38,CAP_EP_39,CAP_EP_40," + "CAP_EP_41,CAP_EP_42,CAP_EP_43,CAP_EP_44,CAP_EP_45," + "CAP_EP_46,CAP_EP_47,CAP_EP_48,CAP_EP_49,CAP_EP_50," + "CAP_EP_51,CAP_EP_52,CAP_EP_53,CAP_EP_54,CAP_EP_55," + "CAP_EP_56,CAP_EP_57,CAP_EP_58,CAP_EP_59,CAP_EP_60," + "CAP_EP_61,CAP_EP_62,CAP_EP_63,CAP_EP_64,CAP_EP_65," + "CAP_POR_EP_01,CAP_POR_EP_02,CAP_POR_EP_03,CAP_POR_EP_04,CAP_POR_EP_05," + "CAP_POR_EP_06,CAP_POR_EP_07,CAP_POR_EP_08,CAP_POR_EP_09,CAP_POR_EP_10," + "CAP_POR_EP_11,CAP_POR_EP_12,CAP_POR_EP_13,CAP_POR_EP_14,CAP_POR_EP_15)values" + "('{0}',NOW(),'{1}','{2}'," + "'{3}','{4}','{5}','{6}','{7}'," + "'{8}','{9}','{10}','{11}','{12}'," + "'{13}','{14}','{15}','{16}','{17}'," + "'{18}','{19}','{20}','{21}','{22}'," + "'{23}','{24}','{25}','{26}','{27}'," + "'{28}','{29}','{30}','{31}','{32}'," + "'{33}','{34}','{35}','{36}','{37}'," + "'{38}','{39}','{40}','{41}','{42}'," + "'{43}','{44}','{45}','{46}', '{47}'," + "'{48}','{49}','{50}','{51}','{52}'," + "'{53}','{54}','{55}','{56}','{57}'," + "'{58}','{59}','{60}','{61}','{62}'," + "'{63}','{64}','{65}','{66}','{67}'," + "'{68}','{69}','{70}','{71}','{72}'," + "'{73}','{74}','{75}','{76}','{77}'," + "'{78}','{79}','{80}','{81}','{82}')" , Text_Packge_insert.Text, User_Name, Status, Text__CAP_1.Text, Text__CAP_2.Text, Text__CAP_3.Text, Text__CAP_4.Text, Text__CAP_5.Text, Text__CAP_6.Text, Text__CAP_7.Text, Text__CAP_8.Text, Text__CAP_9.Text, Text__CAP_10.Text, Text__CAP_11.Text, Text__CAP_12.Text, Text__CAP_13.Text, Text__CAP_14.Text, Text__CAP_15.Text, Text__CAP_16.Text, Text__CAP_17.Text, Text__CAP_18.Text, Text__CAP_19.Text, Text__CAP_20.Text, Text__CAP_21.Text, Text__CAP_21.Text, Text__CAP_22.Text, Text__CAP_23.Text, Text__CAP_25.Text, Text__CAP_26.Text, Text__CAP_27.Text, Text__CAP_28.Text, Text__CAP_29.Text, Text__CAP_30.Text, Text__CAP_31.Text, Text__CAP_32.Text, Text__CAP_33.Text, Text__CAP_34.Text, Text__CAP_35.Text, Text__CAP_36.Text, Text__CAP_37.Text, Text__CAP_38.Text, Text__CAP_39.Text, Text__CAP_40.Text, Text__CAP_41.Text, Text__CAP_42.Text, Text__CAP_43.Text, Text__CAP_44.Text, Text__CAP_45.Text, Text__CAP_46.Text, Text__CAP_47.Text, Text__CAP_48.Text, Text__CAP_49.Text, Text__CAP_50.Text, Text__CAP_51.Text, Text__CAP_52.Text, Text__CAP_53.Text, Text__CAP_54.Text, Text__CAP_55.Text, Text__CAP_56.Text, Text__CAP_57.Text, Text__CAP_58.Text, Text__CAP_59.Text, Text__CAP_60.Text, Text__CAP_61.Text, Text__CAP_62.Text, Text__CAP_63.Text, Text__CAP_64.Text, Text__CAP_65.Text, Text_CAP_POR_EP_01.Text, Text_CAP_POR_EP_2.Text, Text_CAP_POR_EP_3.Text, Text_CAP_POR_EP_4.Text, Text_CAP_POR_EP_5.Text, Text_CAP_POR_EP_6.Text, Text_CAP_POR_EP_7.Text, Text_CAP_POR_EP_8.Text, Text_CAP_POR_EP_9.Text, Text_CAP_POR_EP_10.Text, Text_CAP_POR_EP_11.Text, Text_CAP_POR_EP_12.Text, Text_CAP_POR_EP_13.Text, Text_CAP_POR_EP_14.Text, Text_CAP_POR_EP_15.Text); try { if (Text_Packge_insert.Text.Trim() == "") { string strScript = string.Format("<script language='javascript'>alert('您沒有輸入Packge_Name!');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); } else if (db.QueryExecuteNonQuery(insert_cap) == true) { string strScript = string.Format("<script language='javascript'>alert('Packge:" + Text_Packge_insert.Text + "新增成功');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); Panel_CAP_table.Visible = false; Panel_Packge.Visible = true; DBint(); } else { string strScript = string.Format("<script language='javascript'>alert('Packge:" + Text_Packge_insert.Text + "新增失敗');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); } } catch (Exception ex) { throw ex; } }
protected void btnInsert_Click(object sender, EventArgs e) { string user = "******"; string vn = Session["Version_Name"].ToString(); string keyitem = Session["keyitem"].ToString(); string stage = Session["stage"].ToString(); clsMySQL db = new clsMySQL(); string SpeChar = ""; string md = ""; string cate = ""; string kp = ""; string t = ""; string f = ""; for (int i = 0; i < GridView1.Rows.Count; i++) { SpeChar = GridView1.Rows[i].Cells[0].Text; md = GridView1.Rows[i].Cells[1].Text; cate = GridView1.Rows[i].Cells[2].Text; kp = GridView1.Rows[i].Cells[3].Text; DropDownList ddl_Lv = (DropDownList)GridView1.Rows[i].Cells[4].FindControl("Doe_Lv"); string select_str2 = ddl_Lv.SelectedValue; String insert_cap = string.Format("insert into npi_eptra_doe_lv" + "(Lv_filename,Lv_User,Lv_UpdateTime,Lv_stage,Lv_SpecChar," + "Lv_Iiitems,Lv_md,Lv_cate," + "Lv_kp,Lv_TraLv)values" + "('{0}','{1}',NOW(),'{2}','{3}','{4}','{5}','{6}','{7}','{8}')", vn, user, stage, SpeChar, keyitem, md, cate, kp, select_str2); try { if (db.QueryExecuteNonQuery(insert_cap) == true) { t += Convert.ToString(i) + ","; } else { f += Convert.ToString(i) + ","; } } catch (Exception ex) { throw ex; } } //Response.Redirect("EP_TRA_DOE_Create.aspx"); string strScript = string.Format("<script language='javascript'>temp(" + stage + ");</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); }
protected void LinkButton1_Click(object sender, EventArgs e) { clsMySQL db = new clsMySQL(); string temp = ""; temp = Session["value_cap_pkgname"].ToString(); string Status = "Y"; string User_Name = "CIM"; String update_cap = string.Format("update npi_cap_ep set " + "CAP_EP_Name='{0}',Update_Time=NOW(),npiuser='******',CAP_EP_Status='{2}'," + "CAP_EP_01='{3}',CAP_EP_02='{4}',CAP_EP_03='{5}',CAP_EP_04='{6}',CAP_EP_05='{7}'," + "CAP_EP_06='{8}',CAP_EP_07='{9}',CAP_EP_08='{10}',CAP_EP_09='{11}',CAP_EP_10='{12}'," + "CAP_EP_11='{13}',CAP_EP_12='{13}',CAP_EP_13='{14}',CAP_EP_14='{15}',CAP_EP_15='{16}'," + "CAP_EP_16='{17}',CAP_EP_17='{18}',CAP_EP_18='{19}',CAP_EP_19='{20}',CAP_EP_20='{21}'," + "CAP_EP_21='{22}',CAP_EP_22='{23}',CAP_EP_23='{24}',CAP_EP_24='{25}',CAP_EP_25='{26}'," + "CAP_EP_26='{27}',CAP_EP_27='{28}',CAP_EP_28='{29}',CAP_EP_29='{30}',CAP_EP_30='{31}'," + "CAP_EP_31='{32}',CAP_EP_32='{33}',CAP_EP_33='{34}',CAP_EP_34='{35}',CAP_EP_35='{36}'," + "CAP_EP_36='{37}',CAP_EP_37='{38}',CAP_EP_38='{39}',CAP_EP_39='{40}',CAP_EP_40='{41}'," + "CAP_EP_41='{42}',CAP_EP_42='{43}',CAP_EP_43='{44}',CAP_EP_44='{45}',CAP_EP_45='{46}'," + "CAP_EP_46='{47}',CAP_EP_47='{48}',CAP_EP_48='{49}',CAP_EP_49='{50}',CAP_EP_50='{51}'," + "CAP_EP_51='{52}',CAP_EP_52='{53}',CAP_EP_53='{54}',CAP_EP_54='{55}',CAP_EP_55='{56}'," + "CAP_EP_56='{57}',CAP_EP_57='{58}',CAP_EP_58='{59}',CAP_EP_59='{60}',CAP_EP_60='{61}'," + "CAP_EP_61='{62}',CAP_EP_62='{63}',CAP_EP_63='{64}',CAP_EP_64='{65}',CAP_EP_65='{66}'," + "CAP_POR_EP_01='{67}',CAP_POR_EP_02='{68}',CAP_POR_EP_03='{69}',CAP_POR_EP_04='{70}',CAP_POR_EP_05='{70}'," + "CAP_POR_EP_06='{71}',CAP_POR_EP_07='{72}',CAP_POR_EP_08='{73}',CAP_POR_EP_09='{74}',CAP_POR_EP_10='{75}'," + "CAP_POR_EP_11='{76}',CAP_POR_EP_12='{77}',CAP_POR_EP_13='{78}',CAP_POR_EP_14='{79}',CAP_POR_EP_15='{80}' where CAP_EP_Name='" + temp + "'" , Text_UP_PK_Name.Text, User_Name, Status, Text__UP_CAP_1.Text, Text__UP_CAP_2.Text, Text__UP_CAP_3.Text, Text__UP_CAP_4.Text, Text__UP_CAP_5.Text, Text__UP_CAP_6.Text, Text__UP_CAP_7.Text, Text__UP_CAP_8.Text, Text__UP_CAP_9.Text, Text__UP_CAP_10.Text, Text__UP_CAP_11.Text, Text__UP_CAP_12.Text, Text__UP_CAP_13.Text, Text__UP_CAP_14.Text, Text__UP_CAP_15.Text, Text__UP_CAP_16.Text, Text__UP_CAP_17.Text, Text__UP_CAP_18.Text, Text__UP_CAP_19.Text, Text__UP_CAP_20.Text, Text__UP_CAP_21.Text, Text__UP_CAP_21.Text, Text__UP_CAP_22.Text, Text__UP_CAP_23.Text, Text__UP_CAP_25.Text, Text__UP_CAP_26.Text, Text__UP_CAP_27.Text, Text__UP_CAP_28.Text, Text__UP_CAP_29.Text, Text__UP_CAP_30.Text, Text__UP_CAP_31.Text, Text__UP_CAP_32.Text, Text__UP_CAP_33.Text, Text__UP_CAP_34.Text, Text__UP_CAP_35.Text, Text__UP_CAP_36.Text, Text__UP_CAP_37.Text, Text__UP_CAP_38.Text, Text__UP_CAP_39.Text, Text__UP_CAP_40.Text, Text__UP_CAP_41.Text, Text__UP_CAP_42.Text, Text__UP_CAP_43.Text, Text__UP_CAP_44.Text, Text__UP_CAP_45.Text, Text__UP_CAP_46.Text, Text__UP_CAP_47.Text, Text__UP_CAP_48.Text, Text__UP_CAP_49.Text, Text__UP_CAP_50.Text, Text__UP_CAP_51.Text, Text__UP_CAP_52.Text, Text__UP_CAP_53.Text, Text__UP_CAP_54.Text, Text__UP_CAP_55.Text, Text__UP_CAP_56.Text, Text__UP_CAP_57.Text, Text__UP_CAP_58.Text, Text__UP_CAP_59.Text, Text__UP_CAP_60.Text, Text__UP_CAP_61.Text, Text__UP_CAP_62.Text, Text__UP_CAP_63.Text, Text__UP_CAP_64.Text, Text__UP_CAP_65.Text, Text_UP_CAP_POR_1.Text, Text_UP_CAP_POR_2.Text, Text_UP_CAP_POR_3.Text, Text_UP_CAP_POR_4.Text, Text_UP_CAP_POR_5.Text, Text_UP_CAP_POR_6.Text, Text_UP_CAP_POR_7.Text, Text_UP_CAP_POR_8.Text, Text_UP_CAP_POR_9.Text, Text_UP_CAP_POR_10.Text, Text_UP_CAP_POR_11.Text, Text_UP_CAP_POR_12.Text, Text_UP_CAP_POR_13.Text, Text_UP_CAP_POR_14.Text, Text_UP_CAP_POR_15.Text); try { if (db.QueryExecuteNonQuery(update_cap)) { RegisterStartupScript("訊息通知", "<script> alert('資料更新,成功!!');</script>"); Panel_CAP_Table_View.Visible = false; Panel_CAP_Table_Update.Visible = false; Panel_CAP_table.Visible = false; Panel_Packge.Visible = true; DBint(); //ChangeViewMode(); } else { //lblError.Text = strSQL_Delete; RegisterStartupScript("訊息通知", "<script> alert('資料更新,失敗!!');</script>"); } } catch (FormatException ex) { lblError.Text = "[Error Message::NPI Manual Form Delete Function]: " + ex.ToString(); } }
protected void btnInsert_Click(object sender, EventArgs e) { string user = "******"; string vn = Session["Version_Name"].ToString(); string keyitem = Session["keyitem"].ToString(); string stage = Session["stage"].ToString(); int Max = 0, count = 0;; string sign_Lv = ""; string CreateName = "cre_CIM"; string UpName = "up_CIM"; string sta = "Y"; clsMySQL db = new clsMySQL(); string SpeChar = ""; string md = ""; string cate = ""; string kp = ""; string t = ""; string f = ""; string insert_sign = ""; string up_sign = ""; string[] split_vn = vn.Split('_'); string temp_no = split_vn[2]; char[] pat = new char[] { 'V', 'e', 'r' };/**/ string[] str_no = temp_no.Split(pat); int no = Convert.ToInt32(str_no[3]); if (jude_Lv(vn, stage, keyitem, SpeChar)) { for (int i = 0; i < GridView1.Rows.Count; i++) { SpeChar = GridView1.Rows[i].Cells[2].Text; DropDownList ddl_Lv = (DropDownList)GridView1.Rows[i].Cells[3].FindControl("Doe_Lv"); string select_str2 = ddl_Lv.SelectedValue; String insert_lv = string.Format("insert into npieptra_lv_main" + "(Ver_Name,Ver_No,Ver_Status,CreateTime,CreateName," + "UpdateName,LV_Signoff_Status,LV_Signoff_Name,LV_Signoff_Time," + "EPTRA_KeyItem,EPTRA_LV_Stage,EPTRA_LV_SpecChar,EPTRA_LV)values" + "('{0}','{1}','{2}',NOW(),'{3}','{4}','{5}','{6}',NOW(),'{7}','{8}','{9}','{10}')", vn, no, sta, CreateName, "", "NA", CreateName, keyitem, stage, SpeChar, select_str2); try { if (db.QueryExecuteNonQuery(insert_lv) == true) { //t += Convert.ToString(i) + ","; insert_sign = "true"; } else { //f += Convert.ToString(i) + ","; insert_sign = "false"; lblError.Text = insert_lv; break; } } catch (Exception ex) { throw ex; } } if (insert_sign == "true") { string str1 = string.Format("<script language='javascript'>alert('EPTRA_Lv新增成功!');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", str1); } else { string str1 = string.Format("<script language='javascript'>alert('EPTRA_Lv新增失敗!');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", str1); } } else { for (int i = 0; i < GridView1.Rows.Count; i++) { SpeChar = GridView1.Rows[i].Cells[2].Text; DropDownList ddl_Lv = (DropDownList)GridView1.Rows[i].Cells[3].FindControl("Doe_Lv"); string select_str2 = ddl_Lv.SelectedValue; /*create user & update user 問題*/ String update_Lv = string.Format("UPDATE npieptra_lv_main " + " SET EPTRA_LV='{0}',UpdateTime=NOW(),UpdateName='{1}'" + "where Ver_Name='{2}' and Ver_No='{3}' and EPTRA_KeyItem='{4}' and EPTRA_LV_Stage='{5}' and EPTRA_LV_SpecChar='{6}'" , select_str2, UpName, vn, no, keyitem, stage, SpeChar); try { if (db.QueryExecuteNonQuery(update_Lv) == true) { //t += Convert.ToString(i) + ","; up_sign = "true"; } else { //f += Convert.ToString(i) + ","; up_sign = "false"; lblError.Text = update_Lv; break; } } catch (Exception ex) { throw ex; } }
protected void GD_CAP_RowDeleting1(object sender, GridViewDeleteEventArgs e) { clsMySQL db = new clsMySQL(); try { GridViewRow gvrow = GD_CAP.Rows[e.RowIndex]; //lblError.Text = gvrow.Cells[1].Text + "////" + gvrow.Cells[2].Text; string strSQL_Delete = string.Format("Delete from npi_cap_ep where CAP_EP_Name='{0}'", gvrow.Cells[1].Text.Trim()); if (db.QueryExecuteNonQuery(strSQL_Delete)) { RegisterStartupScript("訊息通知", "<script> alert('資料已刪除,成功!!');</script>"); DBint(); //ChangeViewMode(); } else { //lblError.Text = strSQL_Delete; RegisterStartupScript("訊息通知", "<script> alert('資料刪除,失敗!!');</script>"); } } catch (FormatException ex) { lblError.Text = "[Error Message::NPI Manual Form Delete Function]: " + ex.ToString(); } }
protected void btnUpload_Click(object sender, EventArgs e) { String SavePath = "D:\\brunohuang\\FileUpload_Folder\\"; string sheet_name = ""; int sheet_num; int dLastNum; int cate_items = 0; String Cate_Username = "******"; String Cate_Status = "Y"; /*List<string> Cate_Iiitems = new List<string>(); * List<string> Cate_SpeChar = new List<string>(); * List<string> Cate_Md = new List<string>(); * List<string> Cate_Cate = new List<string>(); * List<string> Cate_KP = new List<string>(); */ List <int> success_insert = new List <int>(); List <int> fail_insert = new List <int>(); int success_count = 0; int fail_count = 0; List <string> history_cate = new List <string>(); string fileName = ""; clsMySQL db = new clsMySQL(); try { fileName = Path.GetFileName(FileUploadToServer.PostedFile.FileName); string filePath = Server.MapPath("~\\FileUpload\\") + Path.GetFileName(FileUploadToServer.PostedFile.FileName); FileUploadToServer.SaveAs(filePath); lblMsg.Text = "上傳成功!!" + SavePath; if (CheckExcelFile(fileName)) { /* * if (FileUploadToServer.HasFile) * { * * } */ XSSFWorkbook wk = new XSSFWorkbook(FileUploadToServer.FileContent); XSSFSheet hst; XSSFRow hr; DataTable myDT = new DataTable(); sheet_num = wk.NumberOfSheets; for (int k = 0; k < sheet_num; k++) { hst = (XSSFSheet)wk.GetSheetAt(k); cate_items = hst.LastRowNum; //每一張工作表有幾筆資料 sheet_name = hst.SheetName; hr = (XSSFRow)hst.GetRow(0); dLastNum = hr.LastCellNum; //每一列的欄位數 for (int i = hr.FirstCellNum; i < hr.LastCellNum; i++) { if (hr.GetCell(i) != null) { DataColumn myColumn = new DataColumn(hr.GetCell(i).StringCellValue); myDT.Columns.Add(myColumn); } } for (int j = 1; j <= cate_items; j++) { hr = (XSSFRow)hst.GetRow(j); XSSFRow row = (XSSFRow)mySheet.GetRow(i); DataRow myrow = myDT.NewRow(); for (int i = 1; i < dLastNum; i++) { //string strcell = hr.GetCell(i) == null ? "0" : hr.GetCell(i).ToString(); myrow = } String insert_cate = string.Format("insert into npi_ep_category" + "(npi_EP_Cate_Username,npi_EP_Cate_UpdateTime,npi_EP_Cate_Status," + "EP_Cate_Stage,EP_Cate_Iiitems,EP_Cate_SpeChar," + "EP_Cate_Md,EP_Cate_Cate,EP_Cate_KP)values" + "('{0}',NOW(),'{1}'," + "'{2}','{3}','{4}','{5}','{6}','{7}')" , Cate_Username, Cate_Status, sheet_name, hr.GetCell(0), hr.GetCell(1), hr.GetCell(2), hr.GetCell(3), hr.GetCell(4)); if (db.QueryExecuteNonQuery(insert_cate) == true) { success_count++; } else { fail_count++; history_cate.Add(hr.GetCell(0) + "|" + hr.GetCell(1) + "|" + hr.GetCell(2) + "|" + hr.GetCell(3) + "|" + hr.GetCell(4)); } } } } else { lblMsg.ForeColor = System.Drawing.Color.Red; lblMsg.Text = "您選擇的[" + fileName + "]無法匯入,請重新選擇Excel檔案或檢查Excel檔案內容!!"; } } catch (Exception exfile) { lblMsg.ForeColor = System.Drawing.Color.Red; if (fileName == "") { lblMsg.Text = "[Import Error Message] 請選擇要匯入的Excel檔案!!"; } else { lblMsg.Text = "[Import Error Message]您選擇的[" + fileName + "]無法匯入,請重新選擇Excel檔案或檢查Excel檔案內容!!"; } } }
protected void Button_Add_Click(object sender, EventArgs e) { clsMySQL db = new clsMySQL(); string Status = "Y"; string User_Name = "CIM"; String insert_cap = string.Format("insert into npi_cap_ep" + "(CAP_EP_Name,Update_Time,npiuser,CAP_EP_Status," + "CAP_EP_01,CAP_EP_02,CAP_EP_03,CAP_EP_04,CAP_EP_05," + "CAP_EP_06,CAP_EP_07,CAP_EP_08,CAP_EP_09,CAP_EP_10," + "CAP_EP_11,CAP_EP_12,CAP_EP_13,CAP_EP_14,CAP_EP_15," + "CAP_EP_16,CAP_EP_17,CAP_EP_18,CAP_EP_19,CAP_EP_20," + "CAP_EP_21,CAP_EP_22,CAP_EP_23,CAP_EP_24,CAP_EP_25," + "CAP_EP_26,CAP_EP_27,CAP_EP_28,CAP_EP_29,CAP_EP_30," + "CAP_EP_31,CAP_EP_32,CAP_EP_33,CAP_EP_34,CAP_EP_35," + "CAP_EP_36,CAP_EP_37,CAP_EP_38,CAP_EP_39,CAP_EP_40," + "CAP_EP_41,CAP_EP_42,CAP_EP_43,CAP_EP_44,CAP_EP_45," + "CAP_EP_46,CAP_EP_47,CAP_EP_48,CAP_EP_49,CAP_EP_50," + "CAP_EP_51,CAP_EP_52,CAP_EP_53,CAP_EP_54,CAP_EP_55," + "CAP_EP_56,CAP_EP_57,CAP_EP_58,CAP_EP_59,CAP_EP_60," + "CAP_EP_61,CAP_EP_62,CAP_EP_63,CAP_EP_64,CAP_EP_65," + "CAP_POR_EP_01,CAP_POR_EP_02,CAP_POR_EP_03,CAP_POR_EP_04,CAP_POR_EP_05," + "CAP_POR_EP_06,CAP_POR_EP_07,CAP_POR_EP_08,CAP_POR_EP_09,CAP_POR_EP_10," + "CAP_POR_EP_11,CAP_POR_EP_12,CAP_POR_EP_13,CAP_POR_EP_14,CAP_POR_EP_15)values" + "('{0}',NOW(),'{1}','{2}'," + "'{3}','{4}','{5}','{6}','{7}'," + "'{8}','{9}','{10}','{11}','{12}'," + "'{13}','{14}','{15}','{16}','{17}'," + "'{18}','{19}','{20}','{21}','{22}'," + "'{23}','{24}','{25}','{26}','{27}'," + "'{28}','{29}','{30}','{31}','{32}'," + "'{33}','{34}','{35}','{36}','{37}'," + "'{38}','{39}','{40}','{41}','{42}'," + "'{43}','{44}','{45}','{46}', '{47}'," + "'{48}','{49}','{50}','{51}','{52}'," + "'{53}','{54}','{55}','{56}','{57}'," + "'{58}','{59}','{60}','{61}','{62}'," + "'{63}','{64}','{65}','{66}','{67}'," + "'{68}','{69}','{70}','{71}','{72}'," + "'{73}','{74}','{75}','{76}','{77}'," + "'{78}','{79}','{80}','{81}','{82}')" , Text_Packge_insert.Text, User_Name, Status, Text__CAP_1.Text, Text__CAP_2.Text, Text__CAP_3.Text, Text__CAP_4.Text, Text__CAP_5.Text, Text__CAP_6.Text, Text__CAP_7.Text, Text__CAP_8.Text, Text__CAP_9.Text, Text__CAP_10.Text, Text__CAP_11.Text, Text__CAP_12.Text, Text__CAP_13.Text, Text__CAP_14.Text, Text__CAP_15.Text, Text__CAP_16.Text, Text__CAP_17.Text, Text__CAP_18.Text, Text__CAP_19.Text, Text__CAP_20.Text, Text__CAP_21.Text, Text__CAP_21.Text, Text__CAP_22.Text, Text__CAP_23.Text, Text__CAP_25.Text, Text__CAP_26.Text, Text__CAP_27.Text, Text__CAP_28.Text, Text__CAP_29.Text, Text__CAP_30.Text, Text__CAP_31.Text, Text__CAP_32.Text, Text__CAP_33.Text, Text__CAP_34.Text, Text__CAP_35.Text, Text__CAP_36.Text, Text__CAP_37.Text, Text__CAP_38.Text, Text__CAP_39.Text, Text__CAP_40.Text, Text__CAP_41.Text, Text__CAP_42.Text, Text__CAP_43.Text, Text__CAP_44.Text, Text__CAP_45.Text, Text__CAP_46.Text, Text__CAP_47.Text, Text__CAP_48.Text, Text__CAP_49.Text, Text__CAP_50.Text, Text__CAP_51.Text, Text__CAP_52.Text, Text__CAP_53.Text, Text__CAP_54.Text, Text__CAP_55.Text, Text__CAP_56.Text, Text__CAP_57.Text, Text__CAP_58.Text, Text__CAP_59.Text, Text__CAP_60.Text, Text__CAP_61.Text, Text__CAP_62.Text, Text__CAP_63.Text, Text__CAP_64.Text, Text__CAP_65.Text, Text_CAP_POR_EP_01.Text, Text_CAP_POR_EP_2.Text, Text_CAP_POR_EP_3.Text, Text_CAP_POR_EP_4.Text, Text_CAP_POR_EP_5.Text, Text_CAP_POR_EP_6.Text, Text_CAP_POR_EP_7.Text, Text_CAP_POR_EP_8.Text, Text_CAP_POR_EP_9.Text, Text_CAP_POR_EP_10.Text, Text_CAP_POR_EP_11.Text, Text_CAP_POR_EP_12.Text, Text_CAP_POR_EP_13.Text, Text_CAP_POR_EP_14.Text, Text_CAP_POR_EP_15.Text); try { if (Text_Packge_insert.Text.Trim()=="") { string strScript = string.Format("<script language='javascript'>alert('您沒有輸入Packge_Name!');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); } else if(db.QueryExecuteNonQuery(insert_cap) == true) { string strScript = string.Format("<script language='javascript'>alert('Packge:" + Text_Packge_insert.Text + "新增成功');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); Panel_CAP_table.Visible = false; Panel_Packge.Visible = true; DBint(); } else { string strScript = string.Format("<script language='javascript'>alert('Packge:" + Text_Packge_insert.Text + "新增失敗');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); } } catch (Exception ex) { throw ex; } }
protected void Button_Cancel_Click(object sender, EventArgs e) { clsMySQL db = new clsMySQL(); Panel_Query_Vername.Visible = true; Panel_eptraview.Visible = true; Panel_EPTRA.Visible = false; string del_str = "delete from npieptra_lv_main where Ver_Name='" + global_Ver_Name + "'"; if (!db.QueryExecuteNonQuery(del_str)) { lblError.Text = del_str; } }
/*public void getData() { DataTable aTb = WebUtility.GetSQLdata("select * from product where id='0';", "teachDB"); if (aTb.Rows.Count == 0) { aTb.Rows.Add(aTb.NewRow()); GridView1.DataSource = aTb; GridView1.DataBind(); int columnCount = GridView1.Rows[0].Cells.Count; GridView1.Rows[0].Cells.Clear(); GridView1.Rows[0].Cells.Add(new TableCell()); GridView1.Rows[0].Cells[0].ColumnSpan = columnCount; GridView1.Rows[0].Cells[0].Text = "無資料!"; GridView1.RowStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center; } else { GridView1.DataSource = aTb; GridView1.DataBind(); } }*/ protected void Button_Update_Click(object sender, EventArgs e) { clsMySQL db = new clsMySQL(); int index; string Status = "Y"; index = Convert.ToInt32(Session["gvrow_index"].ToString()); GridViewRow gvrow = GD_CATE.Rows[index]; Session.Clear(); String update_cate = string.Format("update npi_ep_category set " + "npi_EP_Cate_Username='******',npi_EP_Cate_UpdateTime=NOW(),npi_EP_Cate_Status='{1}'," + "EP_Cate_Stage='{2}',EP_Cate_Iiitems='{3}',EP_Cate_SpeChar='{4}'," + "EP_Cate_Md='{5}',EP_Cate_Cate='{6}',EP_Cate_KP='{7}' " + "where EP_Cate_Stage='{8}' and EP_Cate_Iiitems='{9}' and EP_Cate_SpeChar='{10}'" + "and EP_Cate_Md='{11}'and EP_Cate_Cate='{12}' and EP_Cate_KP='{13}' " , text_up_cate_user.Text, Status, text_cate_stage.Text, text_cate_input.Text , text_cate_sp.Text, text_cate_md.Text, text_cate_cate.Text, text_cate_kp.Text , gvrow.Cells[1].Text.Trim(), gvrow.Cells[2].Text.Trim(), gvrow.Cells[3].Text.Trim() , gvrow.Cells[4].Text.Trim(), gvrow.Cells[5].Text.Trim(), gvrow.Cells[6].Text.Trim()); try { if (db.QueryExecuteNonQuery(update_cate)) { RegisterStartupScript("訊息通知", "<script> alert('資料更新,成功!!');</script>"); Panel_update_category.Visible = false; Panel_Category.Visible = true; DBint(text_cate_stage.Text); //ChangeViewMode(); } else { //lblError.Text = strSQL_Delete; RegisterStartupScript("訊息通知", "<script> alert('資料更新,失敗!!');</script>"); } } catch (FormatException ex) { lblError.Text = "[Error Message::NPI Manual Form Delete Function]: " + ex.ToString(); } }
protected void but_lv_int_Click(object sender, EventArgs e) { //string parameter = Request["__EVENTARGUMENT"]; //string[] allParams = parameter.Split('|'); clsMySQL db = new clsMySQL(); string del_str = "delete from npieptra_lv_main where Ver_Name='" + global_Ver_Name + "'"; if (!db.QueryExecuteNonQuery(del_str)) { lblError.Text = del_str; } count_white_lamp = 0; gap_compare(); string strScript_count = string.Format("<script language='javascript'>var count_lamp =" + count_white_lamp + ";</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript_count); Hide_Value.Value = count_white_lamp.ToString(); count_white_lamp = 0; }
/* protected void DBint() { string sql_category = ""; //string mySQL = "select * from npi_ep_category where EP_Cate_Stage='PI1'"; int number=0; catch (Exception ex) { Label2.Text = ex.ToString() + number.ToString(); } } */ protected void insert_cate(int item_num, List<string> Cate_Iiitems, List<string> Cate_SpeChar, List<string> Cate_Md, List<string> Cate_Cate, List<string> Cate_KP, string name,string status,string stage) { clsMySQL db = new clsMySQL(); List<int> success_insert = new List<int>(); List<int> fail_insert = new List<int>(); int success_count = 0; int fail_count = 0; List<string> history_cate = new List<string>(); for (int i = 0; i < item_num; i++) { String insert_cate = string.Format("insert into npi_cap_ep" + "(npi_EP_Cate_Username,npi_EP_Cate_UpdateTime,npi_EP_Cate_Status," + "EP_Cate_Stage,EP_Cate_Iiitems,EP_Cate_SpeChar," + "EP_Cate_Md,EP_Cate_Cate,EP_Cate_KP)values" + "('{0}',NOW(),'{1}'," + "'{2}','{3}','{4}','{5}','{6}','{7}')" , name, status, stage, Cate_Iiitems[i], Cate_SpeChar[i], Cate_Md[i], Cate_Cate[i], Cate_KP[i]); if (db.QueryExecuteNonQuery(insert_cate) == true) { success_count++; } else { fail_count++; history_cate.Add(Cate_Iiitems[i] + "|" + Cate_SpeChar[i] + "|" + Cate_Md[i] + "|" + Cate_Cate[i] + "|" + Cate_KP[i]); } } /* try { /*if (Text_Packge_insert.Text.Trim() == "") { string strScript = string.Format("<script language='javascript'>alert('您沒有輸入Packge_Name!');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); } if () { string strScript = string.Format("<script language='javascript'>alert('Category新增成功');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); } else { string strScript = string.Format("<script language='javascript'>alert('Category新增成功');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); } } catch (Exception ex) { throw ex; } */ }
protected void btnInsert_Click(object sender, EventArgs e) { string user = "******"; string vn = Session["Version_Name"].ToString(); string keyitem = Session["keyitem"].ToString(); string stage = Session["stage"].ToString(); int Max = 0, count = 0;; string sign_Lv = ""; clsMySQL db = new clsMySQL(); string SpeChar = ""; string md = ""; string cate = ""; string kp = ""; string t = ""; string f = ""; if (jude_Lv(vn, stage, keyitem, SpeChar)) { for (int i = 0; i < GridView1.Rows.Count; i++) { SpeChar = GridView1.Rows[i].Cells[2].Text; DropDownList ddl_Lv = (DropDownList)GridView1.Rows[i].Cells[3].FindControl("Doe_Lv"); string select_str2 = ddl_Lv.SelectedValue; String insert_cap = string.Format("insert into npi_eptra_doe_lv" + "(Lv_filename,Lv_User,Lv_UpdateTime,Lv_Iiitems,Lv_stage,Lv_SpecChar," + "Lv_TraLv)values" + "('{0}','{1}',NOW(),'{2}','{3}','{4}','{5}')", vn, user, keyitem, stage, SpeChar, select_str2); try { if (db.QueryExecuteNonQuery(insert_cap) == true) { t += Convert.ToString(i) + ","; } else { f += Convert.ToString(i) + ","; } } catch (Exception ex) { throw ex; } } } else { for (int i = 0; i < GridView1.Rows.Count; i++) { SpeChar = GridView1.Rows[i].Cells[2].Text; DropDownList ddl_Lv = (DropDownList)GridView1.Rows[i].Cells[3].FindControl("Doe_Lv"); string select_str2 = ddl_Lv.SelectedValue; String update_Lv = string.Format("UPDATE npi_eptra_doe_lv " + " SET Lv_TraLv='{0}'" + "where Lv_filename='{1}'and Lv_User='******'and Lv_Iiitems='{3}' and Lv_stage='{4}' and Lv_SpecChar='{5}'" , select_str2, vn, user, keyitem, stage, SpeChar); try { if (db.QueryExecuteNonQuery(update_Lv) == true) { t += Convert.ToString(i) + ","; } else { f += Convert.ToString(i) + ","; } } catch (Exception ex) { throw ex; } } } Max = count_sum_Lv(vn, stage, keyitem); count = count_Lv(vn, stage, keyitem); if (count > (Max / 2)) { sign_Lv = "l.1"; } else { sign_Lv = "l.2"; } string strScript = string.Format("<script language='javascript'>temp('" + keyitem + "'" + ',' + "'" + stage + "'" + ",'" + sign_Lv + "'" + ");</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript); }
public void ImportToDataTable() { string fileName = ""; lblMsg.Text = ""; try { fileName = Path.GetFileName(FileUploadToServer.PostedFile.FileName); string filePath = Server.MapPath("~\\FileUpload\\") + Path.GetFileName(FileUploadToServer.PostedFile.FileName); FileUploadToServer.SaveAs(filePath); DataTable dt = new DataTable(); //---------------取出file type : DIF/D_R/DRC,取檔名的前三字元 if (CheckExcelFile(fileName)) //判斷File是否為xlsx { string strType = fileName.Substring(0, 3); string strSQL = ""; switch (strType) { case "DIF": strSQL = "select Mtype,Mname,Mpos,MRow,MCol from npimap where mtype = 'DIF' order by mid"; break; case "Q_R": strSQL = "select Mtype,Mname,Mpos,MRow,MCol from npimap where mtype = 'Q_R' order by mid"; break; case "DRC": strSQL = "select Mtype,Mname,Mpos,MRow,MCol from npimap where mtype = 'DRC' order by mid"; break; default: lblMsg.ForeColor = System.Drawing.Color.Red; lblMsg.Text = "您選擇的檔案:[" + fileName + "]無法匯入,請重新選擇正確的Excel檔案!!!"; strSQL = ""; break; } //-------------------------------------------------------------------------------- var existingFile = new FileInfo(filePath); using (var package = new ExcelPackage(existingFile)) { ExcelWorkbook workBook = package.Workbook; if (workBook != null && strSQL != "") { if (workBook.Worksheets.Count > 0) { ExcelWorksheet worksheet = workBook.Worksheets.First();//Excel File的第一個Sheet1 DataTable dt_Pos = new DataTable(); clsMySQL db = new clsMySQL(); ArrayList arSQL = new ArrayList(); db.dbConn(); dt_Pos = db.dbQueryDT(strSQL);//db.QueryDataTable(strSQL); db.dbClose(); dt.Columns.Add("檔案類型"); dt.Columns.Add("欄位名稱"); dt.Columns.Add("欄位位置"); //dt.Columns.Add("Rows"); //dt.Columns.Add("Cols"); dt.Columns.Add("欄位內容"); //Get Customer and Device value---------------------------------------------------------------- string tmpCustomer = ""; string tmpDevice = ""; for (int t = 0; t <= 2; t++) { if (dt_Pos.Rows[t][1].ToString() == "Customer") { if (strType == "DRC") { string[] str2 = worksheet.Cells[Convert.ToInt32(dt_Pos.Rows[t][3].ToString()), Convert.ToInt32(dt_Pos.Rows[t][4].ToString())].Value.ToString().Split(':'); tmpCustomer = str2[1]; } else { tmpCustomer = worksheet.Cells[Convert.ToInt32(dt_Pos.Rows[t][3].ToString()), Convert.ToInt32(dt_Pos.Rows[t][4].ToString())].Value.ToString(); } } else { if (dt_Pos.Rows[t][1].ToString() == "Device") { if (strType == "DRC") { string[] str2 = worksheet.Cells[Convert.ToInt32(dt_Pos.Rows[t][3].ToString()), Convert.ToInt32(dt_Pos.Rows[t][4].ToString())].Value.ToString().Split(':'); tmpDevice = str2[1]; } else { tmpDevice = worksheet.Cells[Convert.ToInt32(dt_Pos.Rows[t][3].ToString()), Convert.ToInt32(dt_Pos.Rows[t][4].ToString())].Value.ToString(); } } } } //--------------------------------------------------------------------------------------------------------- for (int i = 0; i < dt_Pos.Rows.Count; i++) { DataRow dr = dt.NewRow(); string tmpValue = ""; int x = 0; db.dbConn(); dr[x++] = dt_Pos.Rows[i][0].ToString(); dr[x++] = dt_Pos.Rows[i][1].ToString(); dr[x++] = dt_Pos.Rows[i][2].ToString(); //dr[x++] = dt_Pos.Rows[i][3].ToString(); //dr[x++] = dt_Pos.Rows[i][4].ToString(); if (strType == "DRC" && (dt_Pos.Rows[i][2].ToString() == "B46" || dt_Pos.Rows[i][2].ToString() == "B47" || dt_Pos.Rows[i][2].ToString() == "B48")) { string[] str1 = worksheet.Cells[Convert.ToInt32(dt_Pos.Rows[i][3].ToString()), Convert.ToInt32(dt_Pos.Rows[i][4].ToString())].Value.ToString().Split(':'); dr[x++] = str1[1]; tmpValue = str1[1]; } else { dr[x++] = worksheet.Cells[Convert.ToInt32(dt_Pos.Rows[i][3].ToString()), Convert.ToInt32(dt_Pos.Rows[i][4].ToString())].Value; if (worksheet.Cells[Convert.ToInt32(dt_Pos.Rows[i][3].ToString()), Convert.ToInt32(dt_Pos.Rows[i][4].ToString())].Value == null) { tmpValue = ""; } else { tmpValue = worksheet.Cells[Convert.ToInt32(dt_Pos.Rows[i][3].ToString()), Convert.ToInt32(dt_Pos.Rows[i][4].ToString())].Value.ToString(); } } dt.Rows.Add(dr); gvRecord.DataSource = dt; gvRecord.DataBind(); //-----------------------------------insert MySql Database: npiImportData string strSQL_Query = string.Format("select * from npiImportData where New_Customer = '{0}' and New_Device ='{1}' and Stype='{2}' and Im_Pos='{3}'", tmpCustomer.Trim(), tmpDevice.Trim(), strType.Trim(), dt_Pos.Rows[i][2].ToString().Trim()); string strSQL_Del = string.Format("Delete from npiImportData where New_Customer='{0}' and New_Device='{1}' and Stype='{2}' and Im_Pos='{3}'", tmpCustomer.Trim(), tmpDevice.Trim(), strType.Trim(), dt_Pos.Rows[i][2].ToString().Trim()); arSQL.Add(strSQL_Del); string strSQL_Insert = string.Format("Insert into npiImportData (New_Customer,New_Device,Stype,UpdateTime,npiUser,Im_Name,Im_Pos,Im_Value) values (" + "'{0}','{1}','{2}',NOW(),'','{3}','{4}','{5}')", tmpCustomer.Trim(), tmpDevice.Trim(), strType.Trim(), dt_Pos.Rows[i][1].ToString().Trim(), dt_Pos.Rows[i][2].ToString().Trim(), tmpValue.Trim()); arSQL.Add(strSQL_Insert); lblMsg.ForeColor = System.Drawing.Color.Red; //if (db.QueryDataReader(strSQL_Query).HasRows) if (db.dbQueryDR(strSQL_Query).HasRows) { if (!db.myBatchNonQuery(arSQL)) { lblMsg.Text = "[Import Error Message] Delete/Insert Fail!!<br/>"; } } else { if (!db.QueryExecuteNonQuery(strSQL_Insert)) { lblMsg.Text = "[Import Error Message] Insert Fail!! <br/>"; } } arSQL.Clear(); lblMsg.Text = strSQL_Insert + "<br/>" + lblMsg.Text; //--------------------------------------- db.dbClose(); } lblMsg.ForeColor = System.Drawing.Color.Green; lblMsg.Text = "[" + fileName + "],完成資料匯入!!"; } else { lblMsg.ForeColor = System.Drawing.Color.Red; lblMsg.Text = "您選擇的[" + fileName + "]無法匯入,請重新選擇Excel檔案或檢查Excel檔案內容!!"; } } else { gvRecord.DataSource = dt; gvRecord.DataBind(); } } } File.Delete(filePath); //將IIS上的excel file刪除,C:\inetpub\wwwroot\BU3Web\FileUpload } catch (Exception exfile) { lblMsg.ForeColor = System.Drawing.Color.Red; if (fileName == "") { lblMsg.Text = "[Import Error Message] 請選擇要匯入的Excel檔案!!"; } else { lblMsg.Text = "[Import Error Message]您選擇的[" + fileName + "]無法匯入,請重新選擇Excel檔案或檢查Excel檔案內容!!"; } } }
public static string DEL_Category(string str_stage) { string strError = ""; string[] category_spilit_inf = new string[6]; category_spilit_inf = str_stage.Split('|'); for (int i = 0; i < category_spilit_inf.Length; i++) { if (category_spilit_inf[i] == " ") { category_spilit_inf[i] = ""; } } string strSQL_Delete = string.Format("Delete from npi_ep_category where EP_Cate_Stage='{0}' and EP_Cate_Iiitems='{1}' and EP_Cate_SpeChar='{2}' and EP_Cate_Md='{3}' and EP_Cate_Cate='{4}' and EP_Cate_KP='{5}'", category_spilit_inf[0], category_spilit_inf[1], category_spilit_inf[2], category_spilit_inf[3], category_spilit_inf[4], category_spilit_inf[5]); clsMySQL db = new clsMySQL(); if (db.QueryExecuteNonQuery(strSQL_Delete)) { strError = "刪除成功!"; //DBint(category_spilit_inf[0]); HttpContext.Current.Session["value_del_stage"] = category_spilit_inf[0]; db.Close(); } else { strError = "Error Message:[NPI ManualForm] Delete Fail!!"; } return strError; }
protected void FormView1_ItemInserting(object sender, FormViewInsertEventArgs e) { DropDownList myddPOR_01 = (DropDownList)FormView1.FindControl("ddPOR01"); //Porduction Site DropDownList myddPOR_02 = (DropDownList)FormView1.FindControl("ddPOR02"); //PKG TextBox myPOR_03 = (TextBox)FormView1.FindControl("text_POR03"); //WaferTech //TextBox myPOR_04 = (TextBox)FormView1.FindControl("text_POR04"); DropDownList myddPOR_04 = (DropDownList)FormView1.FindControl("ddPOR04"); //FAB //TextBox myPOR_05 = (TextBox)FormView1.FindControl("text_POR05"); DropDownList myddPOR_05 = (DropDownList)FormView1.FindControl("ddPOR05"); //WaferPSVTypeThickness TextBox myPOR_06 = (TextBox)FormView1.FindControl("text_POR06"); //PRType DropDownList myddPOR_07 = (DropDownList)FormView1.FindControl("ddPOR07"); //TietchingChemical DropDownList myddPOR_08 = (DropDownList)FormView1.FindControl("ddPOR08"); //TinShellBake DropDownList myddPOR_09 = (DropDownList)FormView1.FindControl("ddPOR09"); //PIRougness DropDownList myddPOR_10 = (DropDownList)FormView1.FindControl("ddPOR10"); //BumpResistanceCapability DropDownList myddPOR_11 = (DropDownList)FormView1.FindControl("ddPOR11"); //推大球 DropDownList myddPOR_12 = (DropDownList)FormView1.FindControl("ddPOR12"); //LowK DropDownList myddPOR_13 = (DropDownList)FormView1.FindControl("ddPOR13"); //PRThickness DropDownList myddPOR_14 = (DropDownList)FormView1.FindControl("ddPOR14"); //Customer //------------POR_15 For Pord--------------------------- Label mylab_Pord = (Label)FormView1.FindControl("lab_Pord"); DropDownList myddPord = (DropDownList)FormView1.FindControl("ddPord"); TextBox mytext_No = (TextBox)FormView1.FindControl("text_No"); string myPOR_15 = mylab_Pord.Text + "-" + myddPord.SelectedValue.ToString() + "-" + mytext_No.Text; //------------For Pord End----------------------- DropDownList myddPOR_16 = (DropDownList)FormView1.FindControl("ddPOR16"); //UBMTypeThickness TextBox myPOR_17 = (TextBox)FormView1.FindControl("text_POR17"); //Device Label myPOR_18 = (Label)FormView1.FindControl("labPOR18"); TextBox myPOR_19 = (TextBox)FormView1.FindControl("text_POR19"); DropDownList myddPOR_20 = (DropDownList)FormView1.FindControl("ddPOR20"); DropDownList myddPOR_21 = (DropDownList)FormView1.FindControl("ddPOR21"); TextBox myPOR_22 = (TextBox)FormView1.FindControl("text_POR22"); DropDownList myddPOR_23 = (DropDownList)FormView1.FindControl("ddPOR23"); DropDownList myddPOR_24 = (DropDownList)FormView1.FindControl("ddPOR24"); DropDownList myddPOR_25 = (DropDownList)FormView1.FindControl("ddPOR25"); DropDownList myddPOR_26 = (DropDownList)FormView1.FindControl("ddPOR26"); TextBox myPOR_27 = (TextBox)FormView1.FindControl("text_POR27"); DropDownList myddPOR_28 = (DropDownList)FormView1.FindControl("ddPOR28"); TextBox myPOR_29 = (TextBox)FormView1.FindControl("text_POR29"); TextBox myPOR_30 = (TextBox)FormView1.FindControl("text_POR30"); TextBox myPOR_31 = (TextBox)FormView1.FindControl("text_POR31"); TextBox myPOR_32 = (TextBox)FormView1.FindControl("text_POR32"); DropDownList myddPOR_33 = (DropDownList)FormView1.FindControl("ddPOR33"); TextBox myPOR_34 = (TextBox)FormView1.FindControl("text_POR34"); TextBox myPOR_35 = (TextBox)FormView1.FindControl("text_POR35"); TextBox myPOR_36 = (TextBox)FormView1.FindControl("text_POR36"); TextBox myPOR_37 = (TextBox)FormView1.FindControl("text_POR37"); //POR38,POR39,POR40,POR41 Default Text = "NA"----------------------------------------------- TextBox myPOR_38 = (TextBox)FormView1.FindControl("text_POR38"); myPOR_38.Text = "NA"; TextBox myPOR_39 = (TextBox)FormView1.FindControl("text_POR39"); myPOR_39.Text = "NA"; TextBox myPOR_40 = (TextBox)FormView1.FindControl("text_POR40"); myPOR_40.Text = "NA"; TextBox myPOR_41 = (TextBox)FormView1.FindControl("text_POR41"); myPOR_41.Text = "NA"; //------------------------------------------------------------------ TextBox myPOR_42 = (TextBox)FormView1.FindControl("text_POR42"); TextBox myPOR_43 = (TextBox)FormView1.FindControl("text_POR43"); TextBox myPOR_44 = (TextBox)FormView1.FindControl("text_POR44"); TextBox myPOR_45 = (TextBox)FormView1.FindControl("text_POR45"); DropDownList myddPOR_46 = (DropDownList)FormView1.FindControl("ddPOR46"); TextBox myPOR_47 = (TextBox)FormView1.FindControl("text_POR47"); Label myPOR_48 = (Label)FormView1.FindControl("labPOR48"); //套公式: POR19-POR45 Label myPOR_49 = (Label)FormView1.FindControl("labPOR49"); //套公式: POR29/POR36 Label myPOR_50 = (Label)FormView1.FindControl("labPOR50"); //套公式: (Math.PI * (POR29 * POR29/4) * POR53) / (POR51 * POR52) * 1000000 TextBox myPOR_51 = (TextBox)FormView1.FindControl("text_POR51"); TextBox myPOR_52 = (TextBox)FormView1.FindControl("text_POR52"); TextBox myPOR_53 = (TextBox)FormView1.FindControl("text_POR53"); TextBox myPOR_54 = (TextBox)FormView1.FindControl("text_POR54"); TextBox myPOR_55 = (TextBox)FormView1.FindControl("text_POR55"); clsMySQL db = new clsMySQL(); DataSet ds; if (myddPOR_14.SelectedValue.ToString() == "") { RegisterStartupScript("訊息通知", "<script> alert('必須填寫POR Customer!!');</script>"); } else { if (myPOR_17.Text == "") { RegisterStartupScript("訊息通知", "<script> alert('必須填寫POR Device!!');</script>"); } else { if (myddPOR_01.SelectedValue.ToString() == "") { RegisterStartupScript("訊息通知", "<script> alert('必須填寫Production Site!!');</script>"); } else { string strSQL_Query = "select * from npipor where POR_Customer = '" + myddPOR_14.SelectedValue.ToString() + "' and POR_Device = '" + myPOR_17.Text + "' and POR_01 = '" + myddPOR_01.SelectedValue.ToString() + "'"; ds = db.QueryDataSet(strSQL_Query); try { string strSQL_Insert = string.Format("Insert into npiPor " + "(POR_Customer, POR_Device, Stype, UpdateTime, npiUser, POR_Status," + "POR_01, POR_02, POR_03, POR_04, POR_05, POR_06, POR_07, POR_08, POR_09, POR_10," + "POR_11, POR_12, POR_13, POR_14, POR_15, POR_16, POR_17, POR_18, POR_19, POR_20, POR_21, POR_22," + "POR_23, POR_24, POR_25, POR_26, POR_27, POR_28, POR_29, POR_30, POR_31, POR_32, POR_33, POR_34," + "POR_35, POR_36, POR_37, POR_38, POR_39, POR_40, POR_41, POR_42, POR_43, POR_44, POR_45, POR_46," + "POR_47, POR_48, POR_49, POR_50, POR_51, POR_52, POR_53, POR_54, POR_55)values " + "('{13}','{16}','POR',NOW(),'','Y','{0}','{1}','{2}','{3}','{4}'," + "'{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}'," + "'{22}','{23}','{24}','{25}','{26}','{27}','{28}','{29}','{30}','{31}','{32}','{33}','{34}','{35}','{36}','{37}'," + "'{38}','{39}','{40}','{41}','{42}','{43}','{44}','{45}','{46}','{47}','{48}','{49}','{50}','{51}','{52}','{53}'," + "'{54}')", myddPOR_01.SelectedValue.ToString().Trim(), myddPOR_02.SelectedValue.ToString().Trim(), myPOR_03.Text.Trim(), myddPOR_04.SelectedValue.ToString().Trim(), myddPOR_05.SelectedValue.ToString().Trim(), myPOR_06.Text.Trim(), myddPOR_07.SelectedValue.ToString().Trim(), myddPOR_08.SelectedValue.ToString().Trim(), myddPOR_09.SelectedValue.ToString().Trim(), myddPOR_10.SelectedValue.ToString().Trim(), myddPOR_11.SelectedValue.ToString().Trim(), myddPOR_12.SelectedValue.ToString().Trim(), myddPOR_13.SelectedValue.ToString().Trim(), myddPOR_14.SelectedValue.ToString().Trim(), myPOR_15.Trim(), myddPOR_16.SelectedValue.ToString().Trim(), myPOR_17.Text.Trim(), myPOR_18.Text.Trim(), myPOR_19.Text.Trim(), myddPOR_20.SelectedValue.ToString().Trim(), myddPOR_21.SelectedValue.ToString().Trim(), myPOR_22.Text.Trim(), myddPOR_23.SelectedValue.ToString().Trim(), myddPOR_24.SelectedValue.ToString().Trim(), myddPOR_25.SelectedValue.ToString().Trim(), myddPOR_26.SelectedValue.ToString().Trim(), myPOR_27.Text.Trim(), myddPOR_28.SelectedValue.ToString().Trim(), myPOR_29.Text.Trim(), myPOR_30.Text.Trim(), myPOR_31.Text.Trim(), myPOR_32.Text.Trim(), myddPOR_33.SelectedValue.ToString().Trim(), myPOR_34.Text.Trim(), myPOR_35.Text.Trim(), myPOR_36.Text.Trim(), myPOR_37.Text.Trim(), myPOR_38.Text.Trim(), myPOR_39.Text.Trim(), myPOR_40.Text.Trim(), myPOR_41.Text.Trim(), myPOR_42.Text.Trim(), myPOR_43.Text.Trim(), myPOR_44.Text.Trim(), myPOR_45.Text.Trim(), myddPOR_46.SelectedValue.ToString().Trim(), myPOR_47.Text.Trim(), myPOR_48.Text.Trim(), myPOR_49.Text.Trim(), myPOR_50.Text.Trim(), myPOR_51.Text.Trim(), myPOR_52.Text.Trim(), myPOR_53.Text.Trim(), myPOR_54.Text.Trim(), myPOR_55.Text.Trim()); //lblError.Text = strSQL_Insert; if (db.QueryExecuteNonQuery(strSQL_Insert)) { RegisterStartupScript("訊息通知", "<script> alert('POR資料新增,成功!!');</script>"); ClearTextBox(); ChangeViewMode(); } else { //lblError.Text = strSQL_Insert; RegisterStartupScript("訊息通知", "<script> alert('POR資料新增,失敗!!');</script>"); } } catch (Exception ex) { ClearTextBox(); lblError.Text = "[POR Insert Error Message]:" + ex.ToString(); } } } } }
protected void btnUpload_Click(object sender, EventArgs e) { String SavePath = "D:\\brunohuang\\FileUpload_Folder\\"; string sheet_name = ""; int sheet_num; int dLastNum; int cate_items = 0; String Cate_Username = "******"; String Cate_Status = "Y"; DateTime dt = DateTime.Now; string inf_ID = ""; List <string> List_Inf_ID = new List <string>(); Boolean sign_count = false; /*List<string> Cate_Iiitems = new List<string>(); * List<string> Cate_SpeChar = new List<string>(); * List<string> Cate_Md = new List<string>(); * List<string> Cate_Cate = new List<string>(); * List<string> Cate_KP = new List<string>(); */ List <int> success_insert = new List <int>(); List <int> fail_insert = new List <int>(); int success_count = 0; int fail_count = 0; List <string> history_cate = new List <string>(); string fileName = ""; string time = ""; string count_sheet_name = ""; int debug_count = 0; Boolean sign = false; clsMySQL db = new clsMySQL(); try { fileName = Path.GetFileName(FileUploadToServer.PostedFile.FileName); //string filePath = Server.MapPath("~\\bruno\\FileUpload_Folder\\") + Path.GetFileName(FileUploadToServer.PostedFile.FileName); string filePath = Server.MapPath("FileUpload_Folder\\") + Path.GetFileName(FileUploadToServer.PostedFile.FileName); FileUploadToServer.SaveAs(filePath); if (CheckExcelFile(fileName)) { /* * if (FileUploadToServer.HasFile) * { * * } */ XSSFWorkbook wk = new XSSFWorkbook(FileUploadToServer.FileContent); XSSFSheet hst; XSSFRow hr; DataTable myDT = new DataTable(); sheet_num = wk.NumberOfSheets; for (int k = 0; k < sheet_num; k++) //從每張工作表開始做 { hst = (XSSFSheet)wk.GetSheetAt(k); cate_items = hst.LastRowNum; //每一張工作表有幾筆資料 sheet_name = hst.SheetName; if (k != sheet_num - 1) //顯示匯入的Stage有哪些 { count_sheet_name += sheet_name + ","; } else { count_sheet_name += sheet_name; } hr = (XSSFRow)hst.GetRow(0); dLastNum = hr.LastCellNum; //每一列的欄位數 /* for (int i = hr.FirstCellNum; i < hr.LastCellNum; i++) * { * if (hr.GetCell(i) != null) * { * DataColumn myColumn = new DataColumn(hr.GetCell(i).StringCellValue); * myDT.Columns.Add(myColumn); * * } * * }*/ for (int j = 1; j <= cate_items; j++) { hr = (XSSFRow)hst.GetRow(j); //XSSFRow row = (XSSFRow) mySheet.GetRow(i); DataRow myrow = myDT.NewRow(); /*for(int i=1;i<dLastNum;i++) * { * //string strcell = hr.GetCell(i) == null ? "0" : hr.GetCell(i).ToString(); * myrow = * * }*/ String insert_cate = string.Format("insert into npi_ep_category" + "(npi_EP_Cate_Username,npi_EP_Cate_UpdateTime,npi_EP_Cate_Status," + "EP_Cate_Stage,EP_Cate_Iiitems,EP_Cate_SpeChar," + "EP_Cate_Md,EP_Cate_Cate,EP_Cate_KP)values" + "('{0}',NOW(),'{1}'," + "'{2}','{3}','{4}','{5}','{6}','{7}')" , Cate_Username, Cate_Status, sheet_name, hr.GetCell(0), hr.GetCell(1), hr.GetCell(2), hr.GetCell(3), hr.GetCell(4)); string excel_sql = sheet_name + "|" + hr.GetCell(0) + "|" + hr.GetCell(1) + "|" + hr.GetCell(2) + "|" + hr.GetCell(3) + "|" + hr.GetCell(4); Label1.Text = dt.ToString("yyyy/MM/dd hh:mm:ss"); time = Label1.Text; if (jude_npiepcategory_data(excel_sql) == true) { if (db.QueryExecuteNonQuery(insert_cate) == true) { success_count++; sign = true; } else { fail_count++; history_cate.Add(hr.GetCell(0) + "|" + hr.GetCell(1) + "|" + hr.GetCell(2) + "|" + hr.GetCell(3) + "|" + hr.GetCell(4)); } debug_count++; } else { List_Inf_ID.Add(Session["value_ID"].ToString() + "|"); sign_count = true; } Session.Clear(); } } wk = null; hst = null; hr = null; } else { lblMsg.ForeColor = System.Drawing.Color.Red; lblMsg.Text = "您選擇的[" + fileName + "]無法匯入,請重新選擇Excel檔案或檢查Excel檔案內容!!"; } /*string strScript2 = string.Format("<script language='javascript'>alert('完成匯入\\n成功匯入筆數:" + success_count + "\\n匯入的Stage:" + count_sheet_name + "');</script>"); * Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript2);*/ Lab_item.Text = success_count.ToString(); Lab_Stage.Text = count_sheet_name; lblMsg.Text = fileName + "上傳成功!!"; if (sign_count == true) { for (int i = 0; i < List_Inf_ID.Count; i++) { inf_ID += List_Inf_ID[i]; } string strScript2 = string.Format("<script language='javascript'>alert('資料重複編號:" + inf_ID + "');</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript2); } } catch (Exception exfile) { lblMsg.ForeColor = System.Drawing.Color.Red; if (fileName == "") { lblMsg.Text = "[Import Error Message] 請選擇要匯入的Excel檔案!!"; } else { lblMsg.Text = "[Import Error Message]您選擇的[" + fileName + "]無法匯入,請重新選擇Excel檔案或檢查Excel檔案內容!!"; } } finally { /*string strScript = string.Format("<script language='javascript'>alert('您沒有輸入Packge_Name!');</script>"); * Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", strScript);*/ } string sql_cate_datetime = "select * from npi_ep_category where npi_ep_category.npi_EP_Cate_UpdateTime >= DATE_FORMAT('" + time + "', '%Y/%m/%d %H:%i:%s')"; //DATE_FORMAT('2016/04/28 11:26:00', '%Y/%m/%d %H:%i:%s') if (sign == true) { clsMySQL ds = new clsMySQL(); clsMySQL.DBReply dr = ds.QueryDS(sql_cate_datetime); gvRecord.DataSource = dr.dsDataSet.Tables[0].DefaultView; gvRecord.DataBind(); ds.Close(); } }
protected void but_insert_Click(object sender, EventArgs e) { string user = "******"; string vn = Session["Version_Name"].ToString(); string keyitem = Session["keyitem"].ToString(); string stage = Session["stage"].ToString(); int Max = 0, count = 0;; string sign_Lv = ""; string CreateName = "cre_CIM"; string UpName = "up_CIM"; string sta = "Y"; clsMySQL db = new clsMySQL(); string SpeChar = ""; string md = ""; string cate = ""; string kp = ""; string t = ""; string f = ""; string insert_sign = ""; string up_sign = ""; string str_sign = ""; string[] split_vn = vn.Split('_'); string temp_no = split_vn[2]; char[] pat = new char[] { 'V', 'e', 'r' };/**/ string[] str_no = temp_no.Split(pat); int no = Convert.ToInt32(str_no[3]); if (jude_Lv(vn, stage, keyitem, SpeChar)) { for (int i = 0; i < GridView1.Rows.Count; i++) { SpeChar = GridView1.Rows[i].Cells[2].Text; DropDownList ddl_Lv = (DropDownList)GridView1.Rows[i].Cells[3].FindControl("Doe_Lv"); string select_str2 = ddl_Lv.SelectedValue; String insert_lv = string.Format("insert into npieptra_lv_main" + "(Ver_Name,EPTRA_KeyItem,EPTRA_LV_Stage,EPTRA_LV_SpecChar,EPTRA_LV)Values" + "('{0}','{1}','{2}','{3}','{4}')", vn, keyitem, stage, SpeChar, select_str2); try { if (db.QueryExecuteNonQuery(insert_lv) == true) { //t += Convert.ToString(i) + ","; insert_sign = "true"; } else { //f += Convert.ToString(i) + ","; insert_sign = "false"; lblError.Text = insert_lv; break; } } catch (Exception ex) { throw ex; } } if (insert_sign == "true") { str_sign = "EPTRA_Lv新增成功!"; } else { str_sign = "EPTRA_Lv新增失敗!"; } } else { for (int i = 0; i < GridView1.Rows.Count; i++) { SpeChar = GridView1.Rows[i].Cells[2].Text; DropDownList ddl_Lv = (DropDownList)GridView1.Rows[i].Cells[3].FindControl("Doe_Lv"); string select_str2 = ddl_Lv.SelectedValue; /*create user & update user 問題*/ String update_Lv = string.Format("UPDATE npieptra_lv_main " + " SET EPTRA_LV='{0}'" + "where Ver_Name='{1}' and EPTRA_KeyItem='{2}' and EPTRA_LV_Stage='{3}' and EPTRA_LV_SpecChar='{4}'" , select_str2, vn, keyitem, stage, SpeChar); try { if (db.QueryExecuteNonQuery(update_Lv) == true) { //t += Convert.ToString(i) + ","; up_sign = "true"; } else { //f += Convert.ToString(i) + ","; up_sign = "false"; lblError.Text = update_Lv; break; } } catch (Exception ex) { throw ex; } }