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()));
}
