protected void BindCheckItem(string Dept)
{
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
BindData(grdInfo, oStandard.GetPrelaunchCheckItem(lblBu.Text, lblBuilding.Text, Dept));
}
private void DelTeamMember(string id)
{
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
Model_NPI_APP_MEMBER oModel_NPI_APP_Member = new Model_NPI_APP_MEMBER();
oModel_NPI_APP_Member._ID = int.Parse(id);
try
{
Dictionary <string, object> result = oStandard.RecordOperation_APPMemeber(oModel_NPI_APP_Member, Status_Operation.DELETE);
if ((bool)result["Result"])
{
Alert("刪除成功!");
}
else
{
Alert((string)result["ErrMsg"].ToString());
}
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void DelTeamMenber(string id, string enName)
{
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
Model_DFX_PARAM oModel = new Model_DFX_PARAM();
oModel._ID = id;
try
{
Dictionary <string, object> result = oStandard.PRAME_RecordOperation(oModel, Status_Operation.DELETE);
if ((bool)result["Result"])
{
//foreach (string list in Role)
//{
// oStandard.Role_Operation(list,enName, "Delete",null);
//}
ShowMsg("删除團隊成員成功!");
BindTeamMember(cobDept.SelectedItem.Text);
}
else
{
Alert((string)result["ErrMsg"].ToString());
}
}
catch (Exception ex)
{
Alert(ex.ToString());
}
}
private void DelTeamDept(string id)
{
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
Model_DFX_PARAM oModel = new Model_DFX_PARAM();
oModel._ID = id;
try
{
Dictionary <string, object> result = oStandard.PRAME_RecordOperation(oModel, Status_Operation.DELETE);
if ((bool)result["Result"])
{
Alert("刪除部門成功!");
BindTeamDept();
}
else
{
Alert((string)result["ErrMsg"].ToString());
}
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
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());
}
}
private void BindMemberList(Model_NPI_MEMBER oModel_Member)
{
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
DataTable dt = oStandard.GetNPIMemeberList(oModel_Member);
BindData(grdInfo, dt);
}
protected void BindMember(string DocNo, string Category)
{
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
DataTable dt = oStandard.GetAppMember(DocNo, Category);
BindGrid(dt, grdInfo);
}
protected void btnDelete_Click(object sender, DirectEventArgs e)
{
string Category = string.Empty;
string Dept = string.Empty;
string ename = string.Empty;
string Id = string.Empty;
RowSelectionModel sm = grdInfo.SelectionModel.Primary as RowSelectionModel;
if (sm.SelectedRows.Count <= 0)
{
Alert("請勾選需刪除的信息!");
return;
}
string json = e.ExtraParams["Values"];
Dictionary <string, string>[] sele = JSON.Deserialize <Dictionary <string, string>[]>(json);
StringBuilder msg = new StringBuilder();
foreach (Dictionary <string, string> row in sele)
{
Category = row["CATEGORY"].ToString();
Dept = row["DEPT"].ToString();
ename = row["ENAME"].ToString();
Id = row["ID"].ToString();
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
Model_NPI_MEMBER oModel = new Model_NPI_MEMBER();
oModel._ID = Id;
try
{
Dictionary <string, object> result = oStandard.RecordOperation_NPIMember(oModel, Status_Operation.DELETE);
if ((bool)result["Result"])
{
Alert("删除團隊成員成功!");
BindMemberList(oModel);
}
else
{
Alert((string)result["ErrMsg"].ToString());
}
}
catch (Exception ex)
{
msg.Append(string.Format("類別:{0},部門:{1},英文名稱:{2} 刪除作業失敗!ErrMsg:{3}<BR/>", Category, Dept, ename, ex.Message));
}
}
if (msg.Length > 0)
{
Alert(msg.ToString());
}
else
{
Alert(string.Format("刪除作業成功!"));
}
}
private void SPMAfterSend_DBIO(SPMTaskVariables SPMTaskVars, EFFormFields FormFields, ref IInterfaceHandleResult HandleResult, SPMRoutingVariable RoutingVariable)
{
try
{
string stepName = (string)SPMTaskVars.ReadDatum("STEPNAME");
int caseID = int.Parse((string)(SPMTaskVars.ReadDatum("CASEID")));
NPIMgmt oMgmt = new NPIMgmt(oUIControls.lblSite.Text, oUIControls.lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
Dictionary <string, object> result = new Dictionary <string, object>();
Model_PRELAUNCH_MAIN oModel = new Model_PRELAUNCH_MAIN();
string Handler = oPara.LoginId;
switch (RoutingVariable.Key)
{
case SPMRoutingVariableKey.spm_Recall:
//修改本单据数据状态为Abort
oModel._CaseId = caseID;
oModel._Status = "Abort";
result = oStandard.RecordOperation_PrelaunchMain(oModel, Status_Operation.UPDATE);
if (!(bool)result["Result"])
{
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = (string)result["ErrMsg"];
}
break;
case SPMRoutingVariableKey.spm_Jump:
//1.标示当前关卡已核准（如为最后一关，则变更状态为Finished）
string ApproverRemark = string.Empty;
string ApproverResult = string.Empty;
for (int i = 0; i < oUIControls.rgResult.Items.Count; i++)
{
if (oUIControls.rgResult.Items[i].Checked == true)
{
ApproverResult = oUIControls.rgResult.Items[i].BoxLabel.Trim();
}
}
result = oStandard.UpdateDOAHandlerStatus(caseID, stepName, Handler, ApproverResult, oUIControls.txtReslutOpinion.Text.Trim());
if (!(bool)result["Result"])
{
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = (string)result["ErrMsg"];
}
break;
}
}
catch (Exception e)
{
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = e.Message;
}
}
protected void SetApproveResultValue(NPIGating_HISUIShadow lUIControls, SPMTaskVariables SPMTaskVars)
{
string stepname = SPMTaskVars.ReadDatum("STEPNAME").ToString();
string caseid = SPMTaskVars.ReadDatum("CASEID").ToString();
NPIMgmt oMgmt = new NPIMgmt(oUIControls.lblSite.Text, oUIControls.lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
DataTable dt = new DataTable();
dt = oStandard.GetNPIApproveResult(caseid);
BindGrid(dt, lUIControls.grdResult);
}
protected void btnDelete_Click(object sender, DirectEventArgs e)
{
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
RowSelectionModel sm = this.grdInfo.SelectionModel.Primary as RowSelectionModel;
if (sm.SelectedRows.Count <= 0)
{
Alert("请选择须删除项!");
return;
}
string json = e.ExtraParams["Values"];
Dictionary <string, string>[] companies = JSON.Deserialize <Dictionary <string, string>[]>(json);
string id = string.Empty;
string dept = string.Empty;
string enName = string.Empty;
string errMsg = string.Empty;
foreach (Dictionary <string, string> row in companies)
{
id = row["ID"];
dept = row["PARAME_VALUE1"];
enName = row["PARAME_VALUE3"];
try
{
//string[] handler = enName.Split(';');
//foreach (string i in handler)
//{
// foreach (string list in Role)
// {
// oStandard.Role_Operation(list, i, "Delete", lblLogonId.Text);
// }
//}
DelTeamDept(id);
}
catch (Exception ex)
{
errMsg += string.Format("刪除部門{0}錯誤:{1}<br/>", dept, ex.Message);
}
}
if (errMsg.Length > 0)
{
Alert(errMsg);
}
else
{
Alert("部門刪除成功!");
}
BindTeamDept();
}
private void BindCheckItem(ref Aspose.Cells.Worksheet sheet, string FormNo, string Bu)
{
//page 格式設定
SetStyle(ref sheet, Aspose.Cells.PageOrientationType.Landscape);
Aspose.Cells.Cells cells = sheet.Cells;
Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook();
Aspose.Cells.Style style = wb.Styles[wb.Styles.Add()];
NPIMgmt oMgmt = new NPIMgmt("CZ", Bu);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
#region//獲取主表資訊
DataTable dtMaster = oStandard.GetPrelaunchInconformity(FormNo);
if (dtMaster.Rows.Count > 0)
{
int templateIndex = 1; //模板row起始位置
int insertIndexEnCounter = templateIndex + 1; //new row起始位置
cells.InsertRows(insertIndexEnCounter, dtMaster.Rows.Count - 1);
cells.CopyRows(cells, templateIndex, insertIndexEnCounter, dtMaster.Rows.Count - 1); //複製模板row格式至新行
string url = "http://icm651.liteon.com/WF_PrelaunchReport/";
for (int i = 0; i < dtMaster.Rows.Count; i++)
{
DataRow dr = dtMaster.Rows[i];
string FileName = dr["FileName"].ToString();
cells[i + templateIndex, 0].PutValue(dr["ID"].ToString());
cells[i + templateIndex, 1].PutValue(dr["Dept"].ToString());
cells[i + templateIndex, 2].PutValue(dr["CheckItem"].ToString());
cells[i + templateIndex, 3].PutValue(dr["Description"].ToString());
cells[i + templateIndex, 4].PutValue(dr["Status"].ToString());
cells[i + templateIndex, 5].PutValue(dr["Remark"].ToString());
cells[i + templateIndex, 6].PutValue(dr["Suggestion"].ToString());
cells[i + templateIndex, 7].PutValue(dr["CompleteDate"].ToString().Length > 0 ? Convert.ToDateTime(dr["CompleteDate"].ToString()).ToString("yyyy/MM/dd") : dr["CompleteDate"].ToString());
cells[i + templateIndex, 8].PutValue(dr["UpateUser"].ToString());
cells[i + templateIndex, 9].PutValue(dr["UpdateTime"].ToString().Length > 0 ? Convert.ToDateTime(dr["UpdateTime"].ToString()).ToString("yyyy/MM/dd") : dr["UpdateTime"].ToString());
if (!string.IsNullOrEmpty(FileName))
{
string destFileName = url + dr["AttacheFile"].ToString();
style.HorizontalAlignment = Aspose.Cells.TextAlignmentType.Center;
cells[i + templateIndex, 10].PutValue(FileName);
cells[i + templateIndex, 10].SetStyle(style);
sheet.Hyperlinks.Add(i + templateIndex, 10, 1, 1, destFileName);
cells.Merge(i + templateIndex, 10, 1, 3);
}
}
}
#endregion
}
protected void BindcobNum()
{
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
Model_DFX_PARAM oDFX_PARAM = new Model_DFX_PARAM();
oDFX_PARAM._FUNCTION_NAME = "NumRule";
oDFX_PARAM._PARAME_NAME = "CATEGORY";
oDFX_PARAM._PARAME_ITEM = lblBu.Text.Trim();
oDFX_PARAM._Building = lblBuilding.Text.Trim();
DataTable dt = oStandard.PARAME_GetBasicData_Filter(oDFX_PARAM);
BindData(cobNum, dt);
}
/// <summary>
/// 綁定部門清單信息
/// </summary>
protected void BindTeamDept()
{
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
Model_DFX_PARAM oDFX_PARAM = new Model_DFX_PARAM();
oDFX_PARAM._FUNCTION_NAME = "TeamMember";
oDFX_PARAM._PARAME_NAME = "Dept";
oDFX_PARAM._PARAME_ITEM = lblBu.Text.Trim();
oDFX_PARAM._Building = txtBuilding.Text.Trim();
DataTable dtDept = oStandard.PARAME_GetBasicData_Filter(oDFX_PARAM);
BindData(grdInfo, dtDept);
}
/// <summary>
/// 填充頁面數據
/// </summary>
/// <param name="sheet">worksheet</param>
/// <param name="docno">試產主單號</param>
/// <param name="subdocno">試產從單號</param>
private void BindExcel(ref Aspose.Cells.Worksheet sheet, string caseID, string Bu, string Building, string DocNo)
{
//page 格式設定
SetStyle(ref sheet, Aspose.Cells.PageOrientationType.Landscape);
Aspose.Cells.Cells cells = sheet.Cells;
//string logoPath = Page.Server.MapPath("") + "\\log.png";
//sheet.Pictures.Add(0, 0, 4, 10, logoPath);
NPIMgmt oMgmt = new NPIMgmt("CZ", Bu);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
#region//獲取主表資訊
DataTable dtMaster = oStandard.GetDFXInconformity(DocNo, "", "");
//string xmlReason = string.Empty;
//string xmlPMC = string.Empty;
//string xmlResult = string.Empty;
//string xmlReasonDetail = string.Empty;
if (dtMaster.Rows.Count > 0)
{
int templateIndexDFX = 5; //模板row起始位置
int insertIndexEnCounter = templateIndexDFX + 1; //new row起始位置
cells.InsertRows(insertIndexEnCounter, dtMaster.Rows.Count - 1);
cells.CopyRows(cells, templateIndexDFX, insertIndexEnCounter, dtMaster.Rows.Count - 1); //複製模板row格式至新行
for (int i = 0; i < dtMaster.Rows.Count; i++)
{
DataRow dr = dtMaster.Rows[i];
cells[i + templateIndexDFX, 1].PutValue(dr["ItemType"].ToString());
cells[i + templateIndexDFX, 2].PutValue(dr["Item"].ToString());
cells[i + templateIndexDFX, 3].PutValue(dr["Location"].ToString());
cells[i + templateIndexDFX, 4].PutValue(dr["Requirements"].ToString());
cells[i + templateIndexDFX, 5].PutValue("");
cells[i + templateIndexDFX, 6].PutValue(dr["Compliance"].ToString());
cells[i + templateIndexDFX, 7].PutValue(dr["PriorityLevel"].ToString());
cells[i + templateIndexDFX, 8].PutValue(dr["MaxPoints"].ToString());
cells[i + templateIndexDFX, 9].PutValue(dr["DFXPoints"].ToString());
cells[i + templateIndexDFX, 10].PutValue(dr["Comments"].ToString());
cells[i + templateIndexDFX, 11].PutValue(dr["Actions"].ToString());
cells[i + templateIndexDFX, 12].PutValue(dr["CompletionDate"].ToString().Length > 0 ? Convert.ToDateTime(dr["CompletionDate"].ToString()).ToString("yyyy/MM/dd"):dr["CompletionDate"].ToString());
cells[i + templateIndexDFX, 13].PutValue(dr["Tracking"].ToString());
cells[i + templateIndexDFX, 14].PutValue(dr["Remark"].ToString());
cells[i + templateIndexDFX, 15].PutValue(dr["WriteDept"].ToString());
}
}
#endregion
}
private void BindPFMA(ref Aspose.Cells.Worksheet sheet, string caseID, string Bu, string Building, string DocNo)
{
//page 格式設定
SetStyle(ref sheet, Aspose.Cells.PageOrientationType.Landscape);
Aspose.Cells.Cells cells = sheet.Cells;
//string logoPath = Page.Server.MapPath("") + "\\log.png";
//sheet.Pictures.Add(0, 0, 4, 10, logoPath);
NPIMgmt oMgmt = new NPIMgmt("CZ", Bu);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
#region//獲取主表資訊
DataTable dtMaster = oStandard.GetFMEAInconformity(DocNo, "", "", "");
if (dtMaster.Rows.Count > 0)
{
int templateIndexDFX = 6; //模板row起始位置
int insertIndexEnCounter = templateIndexDFX + 1; //new row起始位置
cells.InsertRows(insertIndexEnCounter, dtMaster.Rows.Count - 1);
cells.CopyRows(cells, templateIndexDFX, insertIndexEnCounter, dtMaster.Rows.Count - 1); //複製模板row格式至新行
for (int i = 0; i < dtMaster.Rows.Count; i++)
{
DataRow dr = dtMaster.Rows[i];
cells[i + templateIndexDFX, 1].PutValue(dr["Item"].ToString());
cells[i + templateIndexDFX, 2].PutValue(dr["Stantion"].ToString());
cells[i + templateIndexDFX, 3].PutValue(dr["Source"].ToString());
cells[i + templateIndexDFX, 4].PutValue(dr["Source"].ToString());
cells[i + templateIndexDFX, 5].PutValue(dr["PotentialFailureMode"].ToString());
cells[i + templateIndexDFX, 6].PutValue(dr["Loess"].ToString());
cells[i + templateIndexDFX, 8].PutValue(dr["Loess"].ToString());
cells[i + templateIndexDFX, 7].PutValue(dr["Sev"].ToString());
cells[i + templateIndexDFX, 8].PutValue(dr["Occ"].ToString());
cells[i + templateIndexDFX, 9].PutValue(dr["DET"].ToString());
cells[i + templateIndexDFX, 10].PutValue(dr["RPN"].ToString());
cells[i + templateIndexDFX, 11].PutValue(dr["PotentialFailure"].ToString());
cells[i + templateIndexDFX, 12].PutValue(dr["TargetCompletionDate"].ToString().Length > 0 ? Convert.ToDateTime(dr["TargetCompletionDate"].ToString()).ToString("yyyy/MM/dd") : dr["TargetCompletionDate"].ToString());
cells[i + templateIndexDFX, 13].PutValue(dr["ActionsTaken"].ToString());
cells[i + templateIndexDFX, 14].PutValue(dr["ResultsSev"].ToString());
cells[i + templateIndexDFX, 15].PutValue(dr["ResultsOcc"].ToString());
cells[i + templateIndexDFX, 16].PutValue(dr["ResultsDet"].ToString());
cells[i + templateIndexDFX, 17].PutValue(dr["ResultsRPN"].ToString());
cells[i + templateIndexDFX, 18].PutValue(dr["WriteDept"].ToString());
}
}
#endregion
}
protected void BindDept()
{
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
Model_APPLICATION_PARAM oModel_Param = new Model_APPLICATION_PARAM();
oModel_Param._APPLICATION_NAME = "NPI_REPORT";
oModel_Param._FUNCTION_NAME = "Configuration";
oModel_Param._PARAME_NAME = "SubscribeDept";
oModel_Param._PARAME_ITEM = lblBu.Text.Trim();
oModel_Param._PARAME_VALUE1 = lblBuilding.Text.Trim();
DataTable dt = oStandard.PARAME_GetBasicData_Filter(oModel_Param);
BindData(cobDept, dt);
}
protected DataTable BindParamer(string ParameName)
{
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
Model_APPLICATION_PARAM oModel_Param = new Model_APPLICATION_PARAM();
oModel_Param._APPLICATION_NAME = "NPI_REPORT";
oModel_Param._FUNCTION_NAME = "Configuration";
oModel_Param._PARAME_NAME = ParameName;
oModel_Param._PARAME_ITEM = lblBu.Text.Trim();
oModel_Param._PARAME_VALUE1 = lblBuilding.Text.Trim();
DataTable dt = oStandard.PARAME_GetBasicData_Filter(oModel_Param);
return(dt);
}
private void InitialControl_FormInfo()
{
//取單號
oUIControls.txtFormNo.Text = Borg_Tools.GetFormNO("NPI");
//日期控件初始化
oUIControls.txtDate.Text = DateTime.Today.ToString("yyyy/MM/dd");
//取登陸人信息
NPIMgmt oMgmt = new NPIMgmt(oUIControls.lblSite.Text, oUIControls.lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
//取登陸人信息
LiteOn.EA.CommonModel.Model_BorgUserInfo oModel_BorgUserInfo = new LiteOn.EA.CommonModel.Model_BorgUserInfo();
Borg_User oBorg_User = new Borg_User();
oModel_BorgUserInfo = oBorg_User.GetUserInfoByLogonId(oPara.LoginId);
}
protected void btnDelete_Click(object sender, DirectEventArgs e)
{
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
Model_DFX_PARAM oDFX_PARAM = new Model_DFX_PARAM();
RowSelectionModel sm = this.grdInfo.SelectionModel.Primary as RowSelectionModel;
if (sm.SelectedRows.Count <= 0)
{
Alert("请选择须删除项!");
return;
}
string json = e.ExtraParams["Values"];
Dictionary <string, string>[] companies = JSON.Deserialize <Dictionary <string, string>[]>(json);
string id = string.Empty;
string type = string.Empty;
string value = string.Empty;
string errMsg = string.Empty;
string bu = string.Empty;
foreach (Dictionary <string, string> row in companies)
{
id = row["ID"];
type = row["PARAME_NAME"];
value = row["PARAME_VALUE2"];
bu = row["PARAME_ITEM"];
try
{
DelTeamDept(id);
}
catch (Exception ex)
{
errMsg += string.Format("刪除錯誤,類型:{0} 名稱:{1},ErrMsg:{2}<br/>", type, value, ex.Message);
}
}
if (errMsg.Length > 0)
{
Alert(errMsg);
}
else
{
ShowMsg("刪除成功!");
}
BindNumRule("");
}
private void BindHomePage(ref Aspose.Cells.Worksheet sheet, string caseID, string Bu, string Building, string DocNo)
{
//page 格式設定
SetStyle(ref sheet, Aspose.Cells.PageOrientationType.Landscape);
Aspose.Cells.Cells cells = sheet.Cells;
//string logoPath = Page.Server.MapPath("") + "\\log.png";
//sheet.Pictures.Add(0, 0, 4, 10, logoPath);
NPIMgmt oMgmt = new NPIMgmt("CZ", Bu);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
#region//獲取主表資訊
DataTable dtMaster = oStandard.GetCLCAInconformity(DocNo, "", "");
if (dtMaster.Rows.Count > 0)
{
int templateIndexDFX = 7; //模板row起始位置
int insertIndexEnCounter = templateIndexDFX + 1; //new row起始位置
cells.InsertRows(insertIndexEnCounter, dtMaster.Rows.Count - 1);
cells.CopyRows(cells, templateIndexDFX, insertIndexEnCounter, dtMaster.Rows.Count - 1); //複製模板row格式至新行
for (int i = 0; i < dtMaster.Rows.Count; i++)
{
DataRow dr = dtMaster.Rows[i];
cells[i + templateIndexDFX, 1].PutValue(dr["PROCESS"].ToString());
cells[i + templateIndexDFX, 2].PutValue(dr["CTQ"].ToString());
cells[i + templateIndexDFX, 3].PutValue(dr["CONTROL_TYPE"].ToString());
cells[i + templateIndexDFX, 4].PutValue(dr["ACT"].ToString());
cells[i + templateIndexDFX, 5].PutValue(dr["RESULT"].ToString());
cells[i + templateIndexDFX, 6].PutValue(dr["DESCRIPTION"].ToString());
cells[i + templateIndexDFX, 7].PutValue(dr["ROOT_CAUSE"].ToString());
cells[i + templateIndexDFX, 8].PutValue(dr["D"].ToString());
cells[i + templateIndexDFX, 9].PutValue(dr["M"].ToString());
cells[i + templateIndexDFX, 10].PutValue(dr["P"].ToString());
cells[i + templateIndexDFX, 11].PutValue(dr["E"].ToString());
cells[i + templateIndexDFX, 12].PutValue(dr["W"].ToString());
cells[i + templateIndexDFX, 13].PutValue(dr["O"].ToString());
cells[i + templateIndexDFX, 14].PutValue(dr["TEMPORARY_ACTION"].ToString());
cells[i + templateIndexDFX, 15].PutValue(dr["CORRECTIVE_PREVENTIVE_ACTION"].ToString());
cells[i + templateIndexDFX, 16].PutValue(dr["COMPLETE_DATE"].ToString().Length > 0 ? Convert.ToDateTime(dr["COMPLETE_DATE"].ToString()).ToString("yyyy/MM/dd") : dr["COMPLETE_DATE"].ToString());
cells[i + templateIndexDFX, 17].PutValue(dr["IMPROVEMENT_STATUS"].ToString());
}
}
#endregion
}
private void BindDept()
{
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
Model_DFX_PARAM oDFX_PARAM = new Model_DFX_PARAM();
oDFX_PARAM._FUNCTION_NAME = "TeamMember";
oDFX_PARAM._PARAME_NAME = "Dept";
oDFX_PARAM._PARAME_ITEM = lblBu.Text.Trim();
oDFX_PARAM._Building = txtBuilding.Text.Trim();
oDFX_PARAM._PARAME_VALUE3 = lblLogonId.Text;
DataTable dt = oStandard.PARAME_GetBasicData_Filter(oDFX_PARAM);
BindData(cobDept, dt);
if (dt.Rows.Count > 0)
{
BindTeamMember(dt.Rows[0]["PARAME_VALUE1"].ToString());
}
}
protected void btnDelete_Click(object sender, DirectEventArgs e)
{
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
RowSelectionModel sm = this.grdInfo.SelectionModel.Primary as RowSelectionModel;
if (sm.SelectedRows.Count <= 0)
{
Alert("请选择须删除项!");
return;
}
string json = e.ExtraParams["Values"];
Dictionary <string, string>[] companies = JSON.Deserialize <Dictionary <string, string>[]>(json);
string id = string.Empty;
string dept = string.Empty;
string enName = string.Empty;
string errMsg = string.Empty;
foreach (Dictionary <string, string> row in companies)
{
id = row["ID"];
dept = row["DEPT"];
try
{
DelTeamMember(id);
}
catch (Exception ex)
{
errMsg += string.Format("刪除部門{0}錯誤:{1}<br/>", dept, ex.Message);
}
}
if (errMsg.Length > 0)
{
Alert(errMsg);
}
else
{
Alert("刪除成功!");
}
BindMember(txtDOC_NO.Text, string.Empty);
}
protected void cobNum_Select(object sender, DirectEventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.Add("PARAME_VALUE1");
dt.Columns.Add("PARAME_VALUE2");
DataRow dr = dt.NewRow();
cobType.Text = "";
string Type = cobNum.SelectedItem.Value;
switch (Type)
{
case "1":
dr["PARAME_VALUE1"] = "Dept";
dr["PARAME_VALUE2"] = "部門";
dt.Rows.Add(dr);
BindData(cobType, dt);
break;
case "2":
dr["PARAME_VALUE1"] = "Type";
dr["PARAME_VALUE2"] = "類別";
dt.Rows.Add(dr);
BindData(cobType, dt);
break;
case "3":
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
Model_DFX_PARAM oDFX_PARAM = new Model_DFX_PARAM();
oDFX_PARAM._FUNCTION_NAME = "NumRule";
oDFX_PARAM._PARAME_NAME = "Type";
oDFX_PARAM._PARAME_ITEM = lblBu.Text.Trim();
oDFX_PARAM._Building = lblBuilding.Text.Trim();
dt = oStandard.PARAME_GetBasicData_Filter(oDFX_PARAM);
BindData(cobType, dt);
break;
}
BindNumRule(null);
}
protected void BindNumRule(string Type)
{
NPIMgmt oMgmt = new NPIMgmt(lblSite.Text, lblBu.Text);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
Model_DFX_PARAM oDFX_PARAM = new Model_DFX_PARAM();
oDFX_PARAM._FUNCTION_NAME = "NumRule";
if (string.IsNullOrEmpty(Type))
{
oDFX_PARAM._PARAME_NAME = "Type";
}
else
{
oDFX_PARAM._PARAME_NAME = Type;
}
oDFX_PARAM._PARAME_ITEM = lblBu.Text.Trim();
oDFX_PARAM._Building = lblBuilding.Text.Trim();
DataTable dt = oStandard.PARAME_GetBasicData_Filter(oDFX_PARAM);
BindData(grdInfo, dt);
}
public NPI_Standard InitialLeaveMgmt()
{
NPI_Standard oStandard = new NPI_Standard(_SITE, _BU);
switch (_SITE)
{
case "CZ":
switch (_BU)
{
case "HIS":
oStandard = new NPI_CZ_HIS(_SITE, _BU);
break;
case "POWER":
oStandard = new NPI_CZ_POWER(_SITE, _BU);
break;
}
break;
}
return(oStandard);
}
private void BindIssuesList(ref Aspose.Cells.Worksheet sheet, string caseID, string Bu, string Building, string DocNo)
{
//page 格式設定
SetStyle(ref sheet, Aspose.Cells.PageOrientationType.Landscape);
Aspose.Cells.Cells cells = sheet.Cells;
//string logoPath = Page.Server.MapPath("") + "\\log.png";
//sheet.Pictures.Add(0, 0, 4, 10, logoPath);
NPIMgmt oMgmt = new NPIMgmt("CZ", Bu);
NPI_Standard oStandard = oMgmt.InitialLeaveMgmt();
#region//獲取主表資訊
DataTable dtMaster = oStandard.GetIssuesInconformity(DocNo, "", "");
if (dtMaster.Rows.Count > 0)
{
int templateIndexDFX = 6; //模板row起始位置
int insertIndexEnCounter = templateIndexDFX + 1; //new row起始位置
cells.InsertRows(insertIndexEnCounter, dtMaster.Rows.Count - 1);
cells.CopyRows(cells, templateIndexDFX, insertIndexEnCounter, dtMaster.Rows.Count - 1); //複製模板row格式至新行
for (int i = 0; i < dtMaster.Rows.Count; i++)
{
DataRow dr = dtMaster.Rows[i];
cells[i + templateIndexDFX, 1].PutValue(dr["Items"].ToString());
cells[i + templateIndexDFX, 2].PutValue(dr["STATION"].ToString());
cells[i + templateIndexDFX, 3].PutValue(dr["ISSUE_DESCRIPTION"].ToString());
cells[i + templateIndexDFX, 4].PutValue(dr["FILE_PATH"].ToString());
cells[i + templateIndexDFX, 5].PutValue(dr["ISSUE_LOSSES"].ToString());
cells[i + templateIndexDFX, 6].PutValue(dr["TEMP_MEASURE"].ToString());
cells[i + templateIndexDFX, 7].PutValue(dr["IMPROVE_MEASURE"].ToString());
cells[i + templateIndexDFX, 8].PutValue(dr["CURRENT_STATUS"].ToString());
cells[i + templateIndexDFX, 9].PutValue(dr["TRACKING"].ToString());
cells[i + templateIndexDFX, 10].PutValue(dr["REMARK"].ToString());
}
}
#endregion
}
protected void SetMainValue(NPIGating_HISUIShadow lUIControls, SPMTaskVariables SPMTaskVars, EFFormFields FormFields)
{
string caseid = SPMTaskVars.ReadDatum("CASEID").ToString();
string Site = FormFields["txtSite".ToUpper()];
string Bu = "HIS";
NPIMgmt oNPIMgmt = new NPIMgmt(Site, Bu);
NPI_Standard oStandard = oNPIMgmt.InitialLeaveMgmt();
DataTable dt = oStandard.GetMasterInfoHIS(caseid);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
oUIControls.txtFormNo.Text = dr["DOC_NO"].ToString();
oUIControls.txtCustomer.Text = dr["CUSTOMER"].ToString();
oUIControls.txtDate.Text = dr["APPLY_DATE"].ToString();
oUIControls.txtNotes.Text = dr["REMARK"].ToString();
oUIControls.cmbPhase.Text = dr["PHASE"].ToString();
oUIControls.cmbPlant.Text = dr["BUILDING"].ToString();
oUIControls.cbProductType.SelectedItem.Text = dr["PRODUCT_TYPE"].ToString();
oUIControls.txtModel.Text = dr["MODEL_NAME"].ToString();
oUIControls.cmbLayout.Text = dr["LAYOUT"].ToString();
oUIControls.txtPM.Text = dr["NPI_PM"].ToString();
oUIControls.txtRD.Text = dr["RD_ENGINEER"].ToString();
oUIControls.txtSales.Text = dr["SALES_OWNER"].ToString();
oUIControls.txtNextStage_BeginDate.Text = dr["NEXTSTAGE_DATE"].ToString();
oUIControls.cmbPM.SelectedItem.Text = dr["PM_LOC"].ToString();
oUIControls.txtPMExt.Text = dr["PM_EXT"].ToString();
oUIControls.cmbRD.SelectedItem.Text = dr["RD_LOC"].ToString();
oUIControls.txtRDExt.Text = dr["RD_EXT"].ToString();
oUIControls.cmbSales.SelectedItem.Text = dr["SALES_LOC"].ToString();
oUIControls.txtSalesExt.Text = dr["SALES_EXT"].ToString();
}
}
// Code for 'after send'
public override void SPMAfterSend(SPMSubmitMethod SubmitMethod, SPMTaskVariables SPMTaskVars, SPMVariables Variables, SPMRoutingVariable RoutingVariable, EFFormFields FormFields, ref IInterfaceHandleResult HandleResult)
{
string caseid = System.Web.HttpUtility.UrlDecode(Variables[SPMVariableKey.CaseId]);
if (RoutingVariable != null)
{
string sRoutingData = string.Empty;
switch (RoutingVariable.Key)
{
case SPMRoutingVariableKey.spm_Return:
sRoutingData = RoutingVariable.Data;
break;
case SPMRoutingVariableKey.spm_Jump:
sRoutingData = RoutingVariable.Data;
break;
}
}
//// Business logic
if (SubmitMethod != SPMSubmitMethod.CreateNewCase)
{
SPMAfterSend_DBIO(SPMTaskVars, FormFields, ref HandleResult, RoutingVariable);
}
else
{
////////1.待签核关卡及签核人写DB
NPIMgmt oNPIMgmt = new NPIMgmt(oUIControls.lblSite.Text, oUIControls.lblBu.Text);
NPI_Standard oStandard = oNPIMgmt.InitialLeaveMgmt();
Dictionary <string, object> result = oStandard.RecordDOAHandler(caseid, oUIControls.txtFormNo.Text, oUIControls.lblBu.Text, oUIControls.cmbPlant.SelectedItem.Text, oUIControls.cmbPhase.SelectedItem.Text);
if (!(bool)result["Result"])
{
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = (string)result["ErrMsg"];
}
else
{
StringBuilder sbLayout = new StringBuilder();
if (oUIControls.cmbLayout.SelectedItems.Count > 0)
{
foreach (SelectedListItem li in oUIControls.cmbLayout.SelectedItems)
{
sbLayout.AppendFormat("{0},", li.Text);
}
}
Model_NPI_APP_MAIN_HIS oModel_Main = new Model_NPI_APP_MAIN_HIS();
oModel_Main._DOC_NO = oUIControls.txtFormNo.Text.Trim();
oModel_Main._BU = oUIControls.lblBu.Text;
oModel_Main._BUILDING = oUIControls.cmbPlant.SelectedItem.Text;
oModel_Main._APPLY_DATE = oUIControls.txtDate.Text;
oModel_Main._APPLY_USERID = oPara.LoginId.Trim();
oModel_Main._MODEL_NAME = oUIControls.txtModel.Text;
oModel_Main._CUSTOMER = oUIControls.txtCustomer.Text;
oModel_Main._PRODUCT_TYPE = oUIControls.cbProductType.SelectedItem.Text;
oModel_Main._LAYOUT = sbLayout.ToString().TrimEnd(',');
oModel_Main._PHASE = oUIControls.cmbPhase.SelectedItem.Text;
oModel_Main._NEXTSTAGE_DATE = oUIControls.txtNextStage_BeginDate.SelectedDate.ToString("yyyy/MM/dd");
oModel_Main._NPI_PM = oUIControls.txtPM.Text;
oModel_Main._SALES_OWNER = oUIControls.txtSales.Text;
oModel_Main._RD_ENGINEER = oUIControls.txtRD.Text;
oModel_Main._REMARK = oUIControls.txtNotes.Text;
oModel_Main._CASEID = oPara.CaseId.ToString();
oModel_Main._UPDATE_USERID = oPara.LoginId;
oModel_Main._STATUS = "Pending";
oModel_Main._PMLOC = oUIControls.cmbPM.SelectedItem.Text.Trim();
oModel_Main._PMEXT = oUIControls.txtPMExt.Text.Trim();
oModel_Main._RDLOC = oUIControls.cmbRD.SelectedItem.Text.Trim();
oModel_Main._RDEXT = oUIControls.txtRDExt.Text.Trim();
oModel_Main._SALESLOC = oUIControls.cmbSales.SelectedItem.Text.Trim();
oModel_Main._SALESEXT = oUIControls.txtSalesExt.Text.Trim();
result = oStandard.RecordOperation_NPIMain(oModel_Main, Status_Operation.ADD);
//result = "true";
if (!(bool)result["Result"])
{
HandleResult.IsSuccess = false;
HandleResult.CustomMessage = (string)result["ErrMsg"];
}
}
}
base.SPMAfterSend(SubmitMethod, SPMTaskVars, Variables, RoutingVariable, FormFields, ref HandleResult);
}
