private void DeleteItem(string ID) { NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text); NPI_Standard oStandard = oMgmt.InitialLeaveMgmt(); Model_PRELAUNCH_CHECKITEMCONFIG oModel = new Model_PRELAUNCH_CHECKITEMCONFIG(); oModel._ID = ID; try { Dictionary <string, object> result = oStandard.RecordOperation_PrelaunchItem(oModel, Status_Operation.DELETE); if ((bool)result["Result"]) { Alert("删除成功!"); BindCheckItem(cobDept.SelectedItem.Text); } else { Alert((string)result["ErrMsg"].ToString()); } } catch (Exception ex) { Alert(ex.ToString()); } }
protected void btnInsert_Click(object sender, DirectEventArgs e) { NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text); NPI_Standard oStandard = oMgmt.InitialLeaveMgmt(); #region [為空驗證] string ErrorMsg = ""; string dept = cobDept.SelectedItem.Text.Trim(); string CheckItem = txtCheckItem.Text.Trim(); string AttachmentFlag = cmbAttachment.SelectedItem.Value.Trim(); string UPDATE_USERID = lblLogonId.Text; if (string.IsNullOrEmpty(dept)) { ErrorMsg += "部門,"; } if (string.IsNullOrEmpty(CheckItem)) { ErrorMsg += "項目,"; } if (string.IsNullOrEmpty(AttachmentFlag)) { ErrorMsg += "上傳附件否,"; } if (ErrorMsg.Length > 0) { Alert(ErrorMsg.Substring(0, ErrorMsg.Length - 1) + "不能為空"); return; } #endregion Model_PRELAUNCH_CHECKITEMCONFIG oModel = new Model_PRELAUNCH_CHECKITEMCONFIG(); oModel._Bu = lblBu.Text; oModel._Building = lblBuilding.Text; oModel._Dept = dept; oModel._CheckItem = CheckItem; oModel._AttachmentFlag = AttachmentFlag; oModel._UpdateUser = UPDATE_USERID; oModel._UpdateTime = DateTime.Now; try { Dictionary <string, object> result = oStandard.RecordOperation_PrelaunchItem(oModel, Status_Operation.ADD); if ((bool)result["Result"]) { Alert("新增 CheckItem成功!"); BindCheckItem(""); } else { Alert((string)result["ErrMsg"].ToString()); } } catch (Exception ex) { Alert(ex.ToString()); } }
protected void btnConfirm_Click(object sender, DirectEventArgs e) { StringBuilder errMsg = new StringBuilder(); string file = FileAttachment.FileName; //string building = int total_num = 0; int ok_num = 0; int ng_num = 0; if (!FileAttachment.HasFile) { Alert("請選擇数据文件!"); return; } else { string type = file.Substring(file.LastIndexOf(".") + 1).ToLower(); if (type == "xlsx") { //把文件轉成流 Stream stream = FileAttachment.PostedFile.InputStream; if (stream.Length == 8889) { Alert("導入的資料表為空,請檢查!"); return; } try { DataTable dt = ReadByExcelLibrary(stream); if (dt.Rows.Count > 0) { NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text); NPI_Standard oStandard = oMgmt.InitialLeaveMgmt(); Model_PRELAUNCH_CHECKITEMCONFIG oModel = new Model_PRELAUNCH_CHECKITEMCONFIG(); DeleteExist(); foreach (DataRow dr in dt.Rows) { total_num = dt.Rows.Count; try { oModel._Bu = lblBu.Text; oModel._Building = lblBuilding.Text; oModel._Dept = dr["Dept"].ToString(); oModel._CheckItem = dr["CheckItem"].ToString(); oModel._AttachmentFlag = dr["AttachmentFlag"].ToString(); oModel._UpdateUser = lblLogonId.Text.Trim();; oModel._UpdateTime = DateTime.Now; Dictionary <string, object> result = oStandard.RecordOperation_PrelaunchItem(oModel, Status_Operation.ADD); if ((bool)result["Result"]) { ok_num += 1; } else { ng_num += 1; errMsg.Append(result["Result"].ToString() + "<br/>"); } } catch (Exception ex) { Alert(ex.ToString()); } } } } catch (Exception ex) { Alert("Excel數據有問題,錯誤信息: " + ex.Message); return; } } else { Alert("文件類型只能為xlsx"); } } BindCheckItem(cobDept.SelectedItem.Text); Alert(string.Format("上傳筆數:{0}<BR/>成功筆數:{1}<BR/>失敗筆數:{2}<BR/>錯誤信息:<BR/>{3}", total_num.ToString(), ok_num.ToString(), ng_num.ToString(), errMsg.ToString())); }