private void InitPage()
{
Serial = int.Parse(Request.Params["Serial"]);
string PmsId = Request.Params["PmsID"];
string crId = Request.Params["CrId"];
//Abel test用
//Serial = 697;
//PmsId = "PMS201303010003";
SdpDetail sdpDetailParms = new SdpDetail();
sdpDetailParms.Serial = Serial;
IList <PmsHead> pmsHead = new PmsHeadBiz().SelectPmsHeadByPmsId(PmsId);
;
PmsHead ph = pmsHead[0];
TextBoxCrNo.Text = crId;
TextBoxCrName.Text = ph.PmsName;
IList <SdpDetail> sdpDetailList = new SdpDetailBiz().SelectSdpDetail(sdpDetailParms);
if (sdpDetailList == null && sdpDetailList.Count == 0)
{
Msgbox("Data is null");
return;
}
SdpDetailResult = (sdpDetailList == null || sdpDetailList.Count == 0) ? new SdpDetail() : sdpDetailList[0];
ApprovedOutData();
ControlEnabled(SdpDetailResult.TaskStatus);
}
protected void ButtonSave_Click(object sender, EventArgs e)
{
SdpDetail sdpDetail = new SdpDetail();
SdpDetailBiz sdpDetailBiz = new SdpDetailBiz();
bool result = true;
sdpDetail.Resource = this.DropDownListNewResource.Text.Trim();
sdpDetail.Pmsid = PmsId;
string[] serialArray = Serials.Split(';');
foreach (string serial in serialArray)
{
sdpDetail.Serial = int.Parse(serial);
if (!sdpDetailBiz.UpdateSdpDetailResource(sdpDetail))
{
result = false;
}
}
if (!result)
{
Msgbox("Update resource failed!");
return;
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "SaveSuccess();", true);
}
}
protected void InitData(string detailSerial)
{
Qisda.PMS.Entity.SdpDetail detail = new SdpDetail();
detail.Serial = Convert.ToInt32(detailSerial);
detail = myTaskDetailBiz.GetDetailInfoBySerial(detail);
if (detail != null)
{
this.TextBoxActualCost.Text = detail.Actualcost.ToString();
this.TextBoxComplete.Text = (detail.Completedpercent == null) ? string.Empty : detail.Completedpercent.ToString();
//add by Abel.Li 2014-01-06
this.TextBoxTaskStatus.Text = (detail.TaskStatusDesc == null) ? string.Empty : detail.TaskStatusDesc;
//this.TextBoxForeTask.Text = (detail.PretaskNo == null) ? string.Empty : detail.PretaskNo.ToString();
this.TextBoxPlanCost.Text = (detail.Plancost == null) ? string.Empty : detail.Plancost.ToString();
this.TextBoxRemark.Text = (detail.Remark == null) ? string.Empty : detail.Remark.Trim();
this.TextBoxTaskName.Text = (detail.TaskName == null) ? string.Empty : detail.TaskName.Trim();
this.TextBoxPlanEnd.Text = pmsCommonBiz.ConvertDateToString(detail.Planendday);
this.TextBoxPlanStart.Text = pmsCommonBiz.ConvertDateToString(detail.Planstartday);
this.DateTextBoxActualEnd.Text = pmsCommonBiz.ConvertDateToString(detail.Actualendday);
this.DateTextBoxActualStart.Text = pmsCommonBiz.ConvertDateToString(detail.Actualstartday);
this.TextBoxRole.Text = (detail.Role == null) ? string.Empty : detail.Role.Trim();
this.TextBoxResource.Text = (detail.Resource == null) ? string.Empty : detail.Resource.Trim();
}
PmsHead head = new PmsHeadBiz().SelectPmsHeadByPmsId(detail.Pmsid)[0];
if (head != null)
{
this.TextBoxProjectName.Text = (head.PmsName == null) ? string.Empty : head.PmsName.Trim();
this.TextBoxSysName.Text = (head.System == null) ? string.Empty : head.System.Trim();
}
}
private void EditOutData()
{
SdpDetail sdpDetailParms = new SdpDetail();
sdpDetailParms.Serial = Serial;
sdpDetailParms.Pmsid = PmsId;
SdpDetailResult = new SdpDetailBiz().SelectSdpDetail(sdpDetailParms)[0];
this.TextBoxAuditStatus.Text = SdpDetailResult.AuditStatusDesc;
this.TextBoxTaskStatus.Text = SdpDetailResult.TaskStatusDesc;
this.TextBoxTaskName.Text = SdpDetailResult.TaskName;
this.DropDownListOperationType.SelectedValue = SdpDetailResult.OperationType.ToString();
this.DropDownListTaskType.SelectedValue = SdpDetailResult.TaskType.ToString();
this.DropDownListFunctionType.SelectedValue = SdpDetailResult.FunctionType.ToString();
this.DropDownListProgramLanguage.SelectedValue = SdpDetailResult.ProgramLanguage.ToString();
this.DropDownListTaskComplexity.SelectedValue = SdpDetailResult.TaskComplexity.ToString();
this.TextBoxRefCost.Text = (SdpDetailResult.Refcost.ToString() == "0") ? "" : SdpDetailResult.Refcost.ToString();
this.TextBoxPlanCost.Text = (SdpDetailResult.Plancost.ToString() == "0") ? "" : SdpDetailResult.Plancost.ToString();
this.DateTextBoxPlanStartDate.Text = new PmsCommonBiz().FormatDateTime(SdpDetailResult.Planstartday.ToString("yyyy-MM-dd").Trim());
this.DateTextBoxPlanEndDate.Text = new PmsCommonBiz().FormatDateTime(SdpDetailResult.Planendday.ToString("yyyy-MM-dd").Trim());
this.DropDownListResource.SelectedValue = SdpDetailResult.Resource;
this.DropDownListRole.Items.Add(new ListItem(SdpDetailResult.Role, SdpDetailResult.Role));
this.DropDownListRole.SelectedValue = SdpDetailResult.Role;
this.TextBoxPlanRemark.Text = SdpDetailResult.ScheduleRemark;
}
protected void ButtonSave_Click(object sender, EventArgs e)
{
if (Request.QueryString["Serial"] != null)
{
Qisda.PMS.Entity.SdpDetail detail = new SdpDetail();
detail.Serial = Convert.ToInt32(Request.QueryString["Serial"].ToString().Trim());
detail = myTaskDetailBiz.GetDetailInfoBySerial(detail);
detail.Actualstartday = pmsCommonBiz.ConvertDateTime(this.DateTextBoxActualStart.Text);
detail.Actualendday = pmsCommonBiz.ConvertDateTime(this.DateTextBoxActualEnd.Text);
detail.Actualcost = pmsCommonBiz.ConvertStringToFloat(this.TextBoxActualCost.Text);
detail.Completedpercent = pmsCommonBiz.ConvertStringToFloat(this.TextBoxComplete.Text);
detail.PretaskNo = pmsCommonBiz.ConvertStringToInt(this.TextBoxForeTask.Text);
detail.Remark = this.TextBoxRemark.Text.Trim();
detail.Maintaindate = DateTime.Now;
detail.Maintainuser = WSC.GlobalDefinition.Cookie_LoginUser.Replace(" ", ".");
if (myTaskDetailBiz.UpdatePmsSapDesignDetailInfo(detail))
{
ScriptManager.RegisterStartupScript(updateActualCost, this.GetType(),
"saveScript", "alert('Save Successful!');", true);
//ScriptManager.RegisterStartupScript(updateActualCost, this.GetType(),
// "updateScript", "window.close();", true);
//ScriptManager.RegisterStartupScript(this.updateActualCost, this.GetType(), "deleteScript", "window.close();", true);
Response.Write("<script>window.close();</script>");
}
else
{
ScriptManager.RegisterStartupScript(updateActualCost, this.GetType(),
"saveScript", "alert('Save Failed,Please try later!');", true);
}
}
}
protected SdpDetail getSdpDetail(string pmsID)
{
SdpDetail sdpDetail = new SdpDetail();
sdpDetail.Pmsid = pmsID;
sdpDetail.Type = "Service";
return(sdpDetail);
}
public bool UpdateSdpDetailAuditStatus(string serials, int auditStatus)
{
SdpDetail sdpDetail = new SdpDetail();
sdpDetail.Serials = "";
sdpDetail.AuditStatus = auditStatus;
return(new SdpDetailBiz().UpdateSdpDetailAuditStatus(sdpDetail));
}
protected void ButtonSave_Click(object sender, EventArgs e)
{
SdpDetailBiz sdpDetailBiz = new SdpDetailBiz();
SdpDetail sdpDetail = new SdpDetail();
DateTime dateTime = PmsSysBiz.GetDBDateTime();
sdpDetail.Pmsid = PmsId;
sdpDetail.Phase = Phase;
if (PhaseNull)
{
sdpDetail.Phase = DropDownListPhases.Text.Trim();
}
sdpDetail.TaskName = TextBoxTaskName.Text.Trim();
sdpDetail.OperationType = int.Parse(DropDownListOperationType.Text.Trim());
sdpDetail.TaskType = int.Parse(DropDownListTaskType.Text.Trim());
sdpDetail.FunctionType = int.Parse(DropDownListFunctionType.Text.Trim());
sdpDetail.ProgramLanguage = int.Parse(DropDownListProgramLanguage.Text.Trim());
sdpDetail.TaskComplexity = int.Parse(DropDownListTaskComplexity.Text.Trim());
//sdpDetail.Actualcost = double.Parse(TextBoxRefCost.Text.Trim());
sdpDetail.Refcost = double.Parse(HiddenFieldRefCost.Value.Trim());
sdpDetail.Plancost = double.Parse(TextBoxPlanCost.Text.Trim());
sdpDetail.Auditor = new BaseDataUserBiz().SelectLeaderByLoginName(LoginName);
HiddenFieldAuditor.Value = sdpDetail.Auditor;
IList <PmsSys> pmsSysList = new PmsSysBiz().SelectData2ByTypeData1("PM", "AuditAgent", sdpDetail.Auditor);
sdpDetail.AuditorAgent = (pmsSysList == null || pmsSysList.Count == 0) ? "" : pmsSysList.FirstOrDefault().Data2;
HiddenFieldAuditorAgent.Value = sdpDetail.AuditorAgent;
sdpDetail.Planstartday = DateTime.Parse(DateTextBoxPlanStartDate.Text.Trim());
sdpDetail.Planendday = DateTime.Parse(DateTextBoxPlanEndDate.Text.Trim());
sdpDetail.Resource = DropDownListResource.Text.Trim();
//sdpDetail.Role = DropDownListRole.Text.Trim();
sdpDetail.Role = HiddenFieldRole.Value.Trim();
sdpDetail.ScheduleRemark = TextBoxPlanRemark.Text.Trim();
sdpDetail.AuditStatus = 1;
sdpDetail.TaskStatus = 1;
sdpDetail.Taskno = 1;
sdpDetail.Iseditable = "Y";
sdpDetail.Deleteflag = "N";
sdpDetail.Createdate = dateTime;
sdpDetail.Createuser = LoginName;
sdpDetail.Maintaindate = dateTime;
sdpDetail.Maintainuser = LoginName;
TaskSerial = sdpDetailBiz.InsertSdpDetail(sdpDetail);
HiddenFieldSerial.Value = TaskSerial.ToString();
if (TaskSerial > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "SaveSuccess();", true);
}
else
{
Msgbox("Save the new item failed!");
return;
}
//更新head表的PlanStartDate
new PmsHeadBiz().UpdatePmsHeadPlanStartDate(PmsId);
}
public bool InsertCopyFromDevelopment(IList <SdpDetail> pmsSdpDetailIlist, string strPmsID, string strUser)
{
DateTime dateTime = PmsSysBiz.GetDBDateTime();
PmsCommonBiz pmsCommonBiz = new PmsCommonBiz();
try
{
m_PMSSqlConnection.BeginTransaction();
for (int i = 0; i < pmsSdpDetailIlist.Count; i++)
{
SdpDetail pmsSdpDetail = new SdpDetail();
pmsSdpDetail.Pmsid = strPmsID;
pmsSdpDetail.TaskName = pmsSdpDetailIlist[i].TaskName;
pmsSdpDetail.Phase = PmsCommonEnum.EnumSdpPhase.Test.ToString();
pmsSdpDetail.Role = pmsSdpDetailIlist[i].Role;
pmsSdpDetail.Resource = pmsSdpDetailIlist[i].Resource;
pmsSdpDetail.Taskno = int.Parse(pmsSdpDetailIlist[i].Taskno.ToString());
pmsSdpDetail.Plancost = double.Parse(pmsSdpDetailIlist[i].Plancost.ToString());
pmsSdpDetail.Actualcost = double.Parse(pmsSdpDetailIlist[i].Actualcost.ToString());
pmsSdpDetail.Completedpercent = double.Parse(pmsSdpDetailIlist[i].Completedpercent.ToString());
pmsSdpDetail.Planstartday = pmsSdpDetailIlist[i].Planstartday;
pmsSdpDetail.Planendday = pmsSdpDetailIlist[i].Planendday;
pmsSdpDetail.Actualstartday = pmsCommonBiz.ConvertDateTime("");
pmsSdpDetail.Actualendday = pmsCommonBiz.ConvertDateTime("");
pmsSdpDetail.PretaskNo = int.Parse(pmsSdpDetailIlist[i].PretaskNo.ToString());
pmsSdpDetail.Remark = pmsSdpDetailIlist[i].Remark;
pmsSdpDetail.Iseditable = "Y";
pmsSdpDetail.Deleteflag = "N";
pmsSdpDetail.Createdate = dateTime;
pmsSdpDetail.Createuser = strUser;
pmsSdpDetail.Maintaindate = dateTime;
pmsSdpDetail.Maintainuser = strUser;
int insertResult = InsertSdpDetail(pmsSdpDetail);
if (insertResult <= 0)
{
m_PMSSqlConnection.RollBackTransaction();
return(false);
}
}
m_PMSSqlConnection.CommitTransaction();
return(true);
}
catch (Exception ex)
{
m_PMSSqlConnection.RollBackTransaction();
m_Logger.Error("SdpDetailBiz/InsertFromCopyFromDevelopment:" + ex.Message.ToString());
return(false);
}
}
public IList <SdpDetail> SelectPmsSdpDetailInfo(SdpDetail pmsSdpDetail)
{
try
{
return(m_PMSSqlConnection.QueryForList <SdpDetail>("SelectPmsSdpDetailInfo", pmsSdpDetail));
}
catch (Exception ex)
{
m_Logger.Error("SdpDetailBiz/SelectPmsSdpDetailInfo" + ex.Message.ToString());
return(null);
}
}
/// <summary>
/// get sdp detail infromaton by serial ,then return object sdepdetail
/// </summary>
/// <param name="pmsSdpDetail"></param>
/// <returns></returns>
public SdpDetail GetDetailInfoBySerial(SdpDetail sdpDetail)
{
try
{
return(m_PMSSqlConnection.QueryForObject <SdpDetail>("SelectSdpDetail", sdpDetail));
}
catch (Exception ex)
{
m_Logger.Error("MyTaskDetailBiz/GetPmsSdpDetailBySerial" + ex.Message.ToString());
return(null);
}
}
public IList <SdpDetail> SelectSdpDetail(SdpDetail sdpDetail)
{
try
{
return(m_PMSSqlConnection.QueryForList <SdpDetail>("SelectSdpDetail", sdpDetail));
}
catch (Exception ex)
{
m_Logger.Error("SdpDetailBiz/SelectSdpDetail:" + ex.ToString());
return(null);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
bool updateTrue;
if (this.HiddenButtonName.Value == "Save" || this.HiddenButtonName.Value == "Reactive" || this.HiddenButtonName.Value == "Pending")
{
SdpDetailResult.Actualstartday = (this.DateTextBoxActualStartDate.Text.Trim() == "") ? new DateTime() : DateTime.Parse(this.DateTextBoxActualStartDate.Text.Trim());
SdpDetailResult.Actualendday = (this.DateTextBoxActualEndDate.Text.Trim() == "") ? new DateTime() : DateTime.Parse(this.DateTextBoxActualEndDate.Text.Trim());
SdpDetailResult.Actualcost = (this.TextBoxActualCost.Text.Trim() == "") ? 0 : double.Parse(this.TextBoxActualCost.Text.Trim());
SdpDetailResult.Completedpercent = (this.HiddenPercent.Value == "") ? 0 : double.Parse(this.HiddenPercent.Value);
SdpDetailResult.ExecuteRemark = this.TextBoxExecuteRemark.Text;
SdpDetailResult.TaskStatus = int.Parse(this.HiddenTaskStatus.Value);
updateTrue = new SdpDetailBiz().UpdateSdpDetail(SdpDetailResult);
}
else if (this.HiddenButtonName.Value == "HardClose")
{
SdpDetailResult.TaskStatus = int.Parse(this.HiddenTaskStatus.Value);
SdpDetailResult.Actualendday = PmsSysBiz.GetDBDateTime();
SdpDetailResult.Completedpercent = 100d;
updateTrue = new SdpDetailBiz().UpdateSdpDetail(SdpDetailResult);
}
else
{
SdpDetailResult.TaskStatus = int.Parse(this.HiddenTaskStatus.Value);
updateTrue = new SdpDetailBiz().UpdateSdpDetail(SdpDetailResult);
}
if (this.HiddenButtonName.Value == "Save" && updateTrue)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "SaveSuccess();", true);
//更新head表的ActualStartDate
new PmsHeadBiz().UpdatePmsHeadActualStartDate(SdpDetailResult.Pmsid);
}
if (!updateTrue)
{
Msgbox("Update fails!");
}
SdpDetail sdpDetailParms = new SdpDetail();
sdpDetailParms.Serial = Serial;
SdpDetailResult = new SdpDetailBiz().SelectSdpDetail(sdpDetailParms)[0];
this.TextBoxTaskStatus.Text = SdpDetailResult.TaskStatusDesc;
this.HiddenFieldResultTaskStatus.Value = SdpDetailResult.TaskStatus.ToString();
ControlEnabled(SdpDetailResult.TaskStatus);
InitPage();
}
public bool UpdatePmsSapDesignDetailInfo(SdpDetail sdpDetail)
{
try
{
object obj = m_PMSSqlConnection.Update("UpdatePmsSapDesignDetailInfo", sdpDetail);
return(true);
}
catch (Exception ex)
{
m_Logger.Error("MyTaskDetailBiz/UpdatePmsSapDesignDetailInfo:" + ex.Message.ToString());
return(false);
}
}
private void BindGrid()
{
SdpDetail sdpDetail = new SdpDetail();
sdpDetail.Pmsid = this.PmsID;
sdpDetail.Phase = this.Phase.ToString();
IList <SdpDetail> sdpDetailList = new SdpDetailBiz().SelectSdpDetail(sdpDetail);
if (sdpDetailList != null && sdpDetailList.Count > 0)
{
GridViewByPhase.DataSource = sdpDetailList;
GridViewByPhase.DataBind();
}
}
/// <summary>
/// Save Service Data
/// </summary>
/// <param name="pmsHead"></param>
/// <param name="sdpDetail"></param>
/// <param name="pmsFlow"></param>
/// <param name="pmsDocuments"></param>
/// <returns></returns>
public int InsertServiceDataToDB(PmsHead pmsHead, SdpDetail sdpDetail, PmsFlow pmsFlow, PmsDocuments pmsDocuments)
{
int returnResult = 0;
try
{
m_PMSSqlConnection.BeginTransaction();
// Insert PmsHead
pmsHead.Vid = "PM";
pmsHead.Stage = 1;
pmsHead.Pm = "";
pmsHead.Sd = "";
pmsHead.Se = "";
pmsHead.Qa = "";
// m_PMSSqlConnection.Insert("InsertPmsHead", pmsHead);
// Insert SdpDetail
SdpDetailBiz sdpDetailBiz = new SdpDetailBiz();
returnResult = sdpDetailBiz.InsertSdpDetailByTemplate(sdpDetail);
if (returnResult == 0)
{
m_PMSSqlConnection.RollBackTransaction();
return(returnResult);
}
// Insert PmsFlow
PmsFlowBiz pmsFlowBiz = new PmsFlowBiz();
pmsFlowBiz.InsertPmsFlow(pmsFlow);
// Insert PmsDocuments
if (pmsDocuments.FileName != string.Empty)
{
m_PMSSqlConnection.Insert("InsertPmsDocuments", pmsDocuments);
}
m_PMSSqlConnection.CommitTransaction();
}
catch (Exception ex)
{
m_PMSSqlConnection.RollBackTransaction();
m_Logger.Error("PmsHeadBiz/InsertServiceDataToDB" + ex.Message.ToString());
}
return(returnResult);
}
private void BindGrid()
{
SdpDetail sdpDetail = new SdpDetail();
sdpDetail.Pmsid = Request.QueryString["PmsId"];
sdpDetail.Phase = this.Phase.ToString();
sdpDetail.AuditStatus = (int)PmsCommonEnum.AuditStatus.HasApproved;
IList <SdpDetail> sdpDetailList = new SdpDetailBiz().SelectSdpDetail(sdpDetail);
if (sdpDetailList != null && sdpDetailList.Count > 0)
{
GridViewByPhase.DataSource = sdpDetailList;
GridViewByPhase.DataBind();
}
}
//add by Ename Wang on 20131227
public bool UpdateSdpDetailAuditStatus(SdpDetail sdpDetail)
{
bool updateResult = false;
try
{
m_PMSSqlConnection.Update("UpdateSdpDetailAuditStatus", sdpDetail);
updateResult = true;
}
catch (Exception ex)
{
m_Logger.Error("SdpDetailBiz/UpdateSdpDetail:" + ex.ToString());
}
return(updateResult);
}
protected void BindDataList(DataList dataList, PmsCommonEnum.EnumTime type)
{
MyTaskBiz myTaskBusiness = new MyTaskBiz();
SdpDetail detail = new SdpDetail();
detail.Resource = WSC.GlobalDefinition.Cookie_LoginUser.Trim().Replace(" ", ".");
dataList.DataSource = myTaskBusiness.GetMyTaskData(detail, type);
//dataList.DataSource = new List<MyTaskCondition>()
//{
//};
dataList.DataBind();
if (dataList.Items.Count == 0)
{
dataList.ShowHeader = false;
}
}
protected void GridViewByPhase_OnRowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
SdpDetail sdpDetail = e.Row.DataItem as SdpDetail;
if (sdpDetail != null)
{
e.Row.Attributes.Add("serial", sdpDetail.Serial.ToString());
e.Row.Attributes.Add("createuser", sdpDetail.Createuser == null ? "" : sdpDetail.Createuser.ToUpper());
e.Row.Attributes.Add("phase", this.Phase.ToString());
e.Row.Attributes.Add("auditstatus", sdpDetail.AuditStatus.ToString());
e.Row.Attributes.Add("taskstatus", sdpDetail.TaskStatus.ToString());
e.Row.Attributes.Add("resource", sdpDetail.Resource == null ? "" : sdpDetail.Resource.ToUpper());
e.Row.Attributes.Add("auditor", sdpDetail.Auditor == null ? "" : sdpDetail.Auditor.ToUpper());
e.Row.Attributes.Add("auditoragent", sdpDetail.AuditorAgent == null ? "" : sdpDetail.AuditorAgent.ToUpper());
}
}
}
public int InsertSdpDetailByTemplate(SdpDetail sdpDetail)
{
int returnSerial = 0;
try
{
object objResult = m_PMSSqlConnection.Insert("InsertSdpDetailByTemplate", sdpDetail);
if (objResult != null)
{
returnSerial = (int)objResult;
}
}
catch (Exception ex)
{
m_Logger.Error("SdpDetailBiz/InsertSdpDetailByTemplate" + ex.Message.ToString());
}
return(returnSerial);
}
public string CheckTaskNameAndResource(string taskName, string resource, string pmsid, string phase, string role)
{
SdpDetail sdpDetail = new SdpDetail();
sdpDetail.Pmsid = pmsid;
sdpDetail.TaskName = taskName;
sdpDetail.Phase = phase;
sdpDetail.Role = role;
sdpDetail.Resource = resource;
IList <SdpDetail> sdpDetailList = new SdpDetailBiz().SelectSdpDetail(sdpDetail);
if (sdpDetailList != null && sdpDetailList.Count > 0)
{
if (sdpDetailList[0].TaskName == sdpDetail.TaskName && sdpDetailList[0].Resource == sdpDetail.Resource)
{
return("{'Exist':'Y','TaskStatus':'" + sdpDetailList[0].TaskStatus + "','serial':'" + sdpDetailList[0].Serial + "'}");
}
}
return("{'Exist':'N','TaskStatus':'0','serial':'-1'}");
}
protected void GridViewByPhase_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
SdpDetail sdpDetail = e.Row.DataItem as SdpDetail;
if (sdpDetail != null)
{
e.Row.Attributes.Add("serial", sdpDetail.Serial.ToString());
e.Row.Attributes.Add("createuser", sdpDetail.Createuser == null ? "" : sdpDetail.Createuser.ToUpper().ToString());
e.Row.Attributes.Add("phase", this.Phase.ToString());
e.Row.Attributes.Add("taskname", sdpDetail.TaskName.ToString());
e.Row.Attributes.Add("tasktypedesc", sdpDetail.TaskTypeDesc.ToUpper().ToString());
e.Row.Attributes.Add("taskstatus", sdpDetail.TaskStatus.ToString());
e.Row.Attributes.Add("resource", sdpDetail.Resource == null ? "" : sdpDetail.Resource.ToUpper().ToString());
e.Row.Attributes.Add("auditor", sdpDetail.Auditor == null ? "" : sdpDetail.Auditor.ToUpper().ToString());
e.Row.Attributes.Add("auditoragent", sdpDetail.AuditorAgent == null ? "" : sdpDetail.AuditorAgent.ToUpper().ToString());
e.Row.Attributes.Add("completepercent", sdpDetail.Completedpercent.ToString());
e.Row.Attributes.Add("plancost", sdpDetail.Plancost.ToString());
e.Row.Attributes.Add("actualcost", sdpDetail.Actualcost.ToString());
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string PmsId = Request.QueryString["PmsID"];
string CrID = Request.QueryString["CrId"];
string Phase = Request.QueryString["Phase"];
int Serial = 0;
int.TryParse(Request.QueryString["Serial"], out Serial);
if (PmsId == null || CrID == null || Phase == null || Serial == 0)
{
return;
}
IList <PmsHead> pmsHeadList = new PmsHeadBiz().SelectPmsHead(PmsId, "");
PmsHead pmsHead;
if (pmsHeadList != null && pmsHeadList.Count > 0)
{
pmsHead = pmsHeadList[0];
}
else
{
return;
}
SdpDetail sdpDetailParms = new SdpDetail();
sdpDetailParms.Serial = Serial;
sdpDetailParms.Pmsid = PmsId;
IList <SdpDetail> sdpDetailList = new SdpDetailBiz().SelectSdpDetail(sdpDetailParms);
SdpDetail sdpDetailResult = (sdpDetailList == null || sdpDetailList.Count == 0) ? new SdpDetail() : sdpDetailList[0];
PmsCommonEnum.PlanPhase planPhase = (PmsCommonEnum.PlanPhase)System.Enum.Parse(typeof(PmsCommonEnum.PlanPhase), Phase);
string phaseDescription = planPhase.GetDescription();
string formatPlanstartday = new PmsCommonBiz().FormatDateTime(sdpDetailResult.Planstartday.ToString("yyyy-MM-dd").Trim());
string formatPlanendday = new PmsCommonBiz().FormatDateTime(sdpDetailResult.Planendday.ToString("yyyy-MM-dd").Trim());
string resultHtml = "<table class='ViewTaskTable'>"
+ "<tr><td><span class='ViewTaskSpan'>CR No</span></td><td colspan='3'><input type='text' class='ViewTaskOnlyTextBox' value='" + pmsHead.CrId + "' /></td></tr>"
+ "<tr><td><span class='ViewTaskSpan'>CR Name</span></td><td colspan='3'><input type='text' class='ViewTaskOnlyTextBox' value='" + pmsHead.PmsName + "'style='width: 325px;'/></td></tr>"
+ "<tr><td><span class='ViewTaskSpan'>任务阶段</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + phaseDescription + "'/></td>"
+ "<td><span class='ViewTaskSpan'>审核状态</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.AuditStatusDesc + "' /></td></tr>"
+ "<tr><td><span class='ViewTaskSpan'>任务状态</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.TaskStatusDesc + "' /></td><td> </td><td> </td></tr>" + "<tr><td><span class='ViewTaskSpan'>任务名称</span></td>"
+ "<td colspan='3'><div style=' border-bottom: 1px solid #CCCCCC;width: 325px; white-space: normal;text-overflow: ellipsis; text-align: Left'>" + sdpDetailResult.TaskName + "</div></td></tr>"
+ "<tr><td><span class='ViewTaskSpan'>作业方式</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.OperationTypeDesc + "'/></td>"
+ "<td><span class='ViewTaskSpan'>任务类型</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.TaskTypeDesc + "'/></td></tr>"
+ "<tr><td><span class='ViewTaskSpan'>功能分类</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.FunctionTypeDesc + "'/></td>"
+ "<td><span class='ViewTaskSpan'>语言</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.ProgramLanguageDesc + "'/></td></tr>"
+ "<tr><td><span class='ViewTaskSpan'>复杂度</span></td>"
+ "<td colspan='3'><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.TaskComplexityDesc + "'/></td></tr>"
+ "<tr><td><span class='ViewTaskSpan'>参考工时</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.Actualcost + "' /></td>"
+ "<td><span class='ViewTaskSpan'>计划工时</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.Plancost + "' /></td></tr>"
+ "<tr><td><span class='ViewTaskSpan'>计划开始</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + formatPlanstartday + "' /></td>"
+ "<td><span class='ViewTaskSpan'>计划结束</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + formatPlanendday + "' /> </td></tr>"
+ "<tr><td><span class='ViewTaskSpan'>指派给</span></td>"
+ "<td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.Resource + "'/></td><td><span class='ViewTaskSpan'>资源角色</span></td>"
+ "<td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.Role + "'/></td></tr>"
+ "<tr><td><span class='ViewTaskSpan'>说明</span></td>"
+ "<td colspan='3'><div style='border-bottom: 1px solid #CCCCCC; width: 325px; white-space: normal;text-overflow: ellipsis; text-align: Left'>" + sdpDetailResult.ScheduleRemark + "</div></td></tr>";
Response.Write(resultHtml);
}
private int GetAuditStatus(SdpDetail sdpDetailResult, SdpDetail sdpDetailPage)
{
int AuditStatus = -1;
switch (sdpDetailResult.AuditStatus)
{
case 1:
AuditStatus = 1;
break;
case 2:
SdpDetail sParms = new SdpDetail();
sParms.Serial = Serial;
IList <SdpDetail> sdpDetailList = new SdpDetailBiz().SelectSdpDetail(sParms);
if (sdpDetailList[0].AuditStatus != 2)
{
Msgbox("Audit status has changed, please refresh. ");
}
else
{
AuditStatus = 2;
}
break;
case 3:
if (sdpDetailResult.TaskStatus == 1)
{
AuditStatus = 1;
}
if (sdpDetailResult.TaskStatus == 3 ||
sdpDetailResult.TaskStatus == 4 ||
sdpDetailResult.TaskStatus == 5 ||
sdpDetailResult.TaskStatus == 6)
{
Msgbox("This audit status can not save! ");
break;
}
if (sdpDetailResult.TaskStatus == 2)
{
if (hidvalueIsSave.Value != "Y")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "Test();", true);
break;
}
else
{
SdpDetail oldParms = new SdpDetail();
oldParms.Serial = Serial;
SdpDetail oldSdpDetail = new SdpDetailBiz().SelectSdpDetail(oldParms)[0];
if (oldSdpDetail.Plancost != sdpDetailPage.Plancost ||
oldSdpDetail.Planstartday != sdpDetailPage.Planstartday ||
oldSdpDetail.Planendday != sdpDetailPage.Planendday)
{
AuditStatus = 1;
break;
}
else
{
AuditStatus = oldSdpDetail.AuditStatus;
}
}
}
break;
case 4:
AuditStatus = 1;
break;
}
return(AuditStatus);
}
/// <summary>
/// 检查是否已上传stage必要的文档
/// </summary>
/// <param name="pmsId">当前的PmsId</param>
/// <param name="stage">当前的项目进度Stage</param>
/// <param name="message">记录用以返回的必要的提示信息</param>
/// <returns>如果该Stage必要的所有文档都已上传，则返回true，否则返回false</returns>
public bool CheckDocuments(PmsHead pmsHead, int stage, out string message)
{
message = string.Empty;
// modified by Ename Wang on 20120209
string pmsId = pmsHead.PmsId;
PmsDocumentTypeBiz pmsDocumentTypeBiz = new PmsDocumentTypeBiz();
IList <PmsDocumentType> pmsDocumentTypeIdName = pmsDocumentTypeBiz.SelectDistinctDocTypeIdName(pmsId, stage);
//end modified
//STP属于PIS|STP阶段的产出文档，当由Develop|Test Premote到下一个Stage时要做额外的check。
//STC属于Develop|Test 阶段的产出文档，当由Develop|Test Stage Premote到下一个Stage时要做额外的check。
if (stage == (int)PmsCommonEnum.ProjectStage.Develop_Test)
{
if (pmsHead.NeedSTP == "Y")
{
PmsDocumentType pmsDocumentTypeSTP = new PmsDocumentType();
pmsDocumentTypeSTP.TypeId = (int)PmsCommonEnum.DocumentType.STP;
pmsDocumentTypeSTP.TypeName = PmsCommonEnum.DocumentType.STP.GetDescription();
pmsDocumentTypeIdName.Add(pmsDocumentTypeSTP);
}
if (pmsHead.NeedSTC == "Y")
{
PmsDocumentType pmsDocumentTypeSTC = new PmsDocumentType();
pmsDocumentTypeSTC.TypeId = (int)PmsCommonEnum.DocumentType.STC;
pmsDocumentTypeSTC.TypeName = PmsCommonEnum.DocumentType.STC.GetDescription();
pmsDocumentTypeIdName.Add(pmsDocumentTypeSTC);
}
}
// add by Ename Wang on 20130308 在点Release or Partial Release的时候，如果开发计划工时>80H 就必须上传STP,STC
if (stage == (int)PmsCommonEnum.ProjectStage.Release)
{
SdpDetailBiz sdpDetailBiz = new SdpDetailBiz();
SdpDetail sdpDetail = new SdpDetail();
sdpDetail.Pmsid = pmsHead.PmsId;
sdpDetail.Phase = "5";
IList <SdpDetail> sdpDetailList = sdpDetailBiz.SelectSdpDetail(sdpDetail);
decimal totalPlanCost = (decimal)sdpDetailList.Select(t => t.Plancost).Sum();
if (totalPlanCost > 80)
{
PmsDocumentType pmsDocumentTypeSTP = new PmsDocumentType();
pmsDocumentTypeSTP.TypeId = (int)PmsCommonEnum.DocumentType.STP;
pmsDocumentTypeSTP.TypeName = PmsCommonEnum.DocumentType.STP.GetDescription();
pmsDocumentTypeIdName.Add(pmsDocumentTypeSTP);
PmsDocumentType pmsDocumentTypeSTC = new PmsDocumentType();
pmsDocumentTypeSTC.TypeId = (int)PmsCommonEnum.DocumentType.STC;
pmsDocumentTypeSTC.TypeName = PmsCommonEnum.DocumentType.STC.GetDescription();
pmsDocumentTypeIdName.Add(pmsDocumentTypeSTC);
}
}
// end add
//TypeId为int型，所以需要不用加上‘’
string docTypeId = pmsDocumentTypeIdName.Aggregate(string.Empty, (current, pmsDocumentType) => + pmsDocumentType.TypeId + "," + current);
//如果docTypeId为空，则证明该stage不需要文档，因此返回true
if (string.IsNullOrEmpty(docTypeId))
{
message = string.Empty;
return(true);
}
//如果docTypeId不为空，则需要检查数据库中是否存在该stage必要上传的文件。
docTypeId = docTypeId.Substring(0, docTypeId.Length - 1);
PmsDocumentsBiz pmsDocumentsBiz = new PmsDocumentsBiz();
IList <PmsDocuments> pmsDocumentsDocTypeId = pmsDocumentsBiz.SelectPmsDocumentsDocTypeId(pmsHead.PmsId, docTypeId);
IList <int> typeIdExist = pmsDocumentsDocTypeId.Select(t => t.DocTypeId).ToList();
// IList<int> typeIdExist = pmsDocumentsBiz.SelectPmsDocumentsDocTypeId(pmsId, docTypeId);
bool result = true;
StringBuilder msg = new StringBuilder();
msg.Append("Please upload the necessary documents:");
foreach (PmsDocumentType documentType in pmsDocumentTypeIdName)
{
if (!typeIdExist.Contains(documentType.TypeId))
{
msg.Append(documentType.TypeName);
msg.Append(",");
result = false;
}
}
if (!result)
{
message = msg.ToString();
message = message.Substring(0, message.Length - 1) + "!";
}
return(result);
}
public int InsertPmsHeadAndDoc(PmsHead pmsHead, SdpDetail sdpDetail, PmsChangeHistory pmsChangeHistory, PmsItarmMapping pmsItarmMapping,
PmsFlow pmsFlow, ItarmCrList itarmCrList, IList <PmsDocuments> listPmsDocuments, out string errorInfo)
{
errorInfo = string.Empty;
int returnResult = 0;
try
{
m_PMSSqlConnection.BeginTransaction();
#region Insert PmsHead
//string type = pmsHead.PmsName.GetTypeCode;
m_PMSSqlConnection.Insert("InsertPmsHead", pmsHead);
#endregion
#region Insert PmsItarmMapping
PmsItarmMappingBiz pmsItarmMappingBiz = new PmsItarmMappingBiz();
pmsItarmMappingBiz.InsertPmsItarmMapping(pmsItarmMapping);
#endregion
#region Insert PmsDocuments
if (listPmsDocuments != null)
{
foreach (PmsDocuments pmsDocuments in listPmsDocuments)
{
if (pmsDocuments.DocTypeId == 0)
{
errorInfo = "DocTypeId is Invalid!";
return(returnResult);
}
if (pmsDocuments.FileName == string.Empty)
{
errorInfo = "FileName is Empty!";
return(returnResult);
}
if (pmsDocuments.FileName != string.Empty)
{
m_PMSSqlConnection.Insert("InsertPmsDocuments", pmsDocuments);
}
}
}
#endregion
#region Insert SdpDetail
SdpDetailBiz sdpDetailBiz = new SdpDetailBiz();
returnResult = sdpDetailBiz.InsertSdpDetailByTemplate(sdpDetail);
if (returnResult == 0)
{
m_PMSSqlConnection.RollBackTransaction();
return(returnResult);
}
#endregion
#region Insert PmsChangeHistory
PmsChangeHistoryBiz pmsChangeHistoryBiz = new PmsChangeHistoryBiz();
pmsChangeHistoryBiz.InsertPmsChangeHistory(pmsChangeHistory);
#endregion
#region Insert PmsFlow
PmsFlowBiz pmsFlowBiz = new PmsFlowBiz();
pmsFlowBiz.InsertPmsFlow(pmsFlow);
#endregion
#region Insert ItarmCrList
bool resultInsertItarm = new PmsCRCreatBiz().InsertItarmCrList(itarmCrList);
if (!resultInsertItarm)
{
m_PMSSqlConnection.RollBackTransaction();
errorInfo = "Save Fail";
return(0);
}
#endregion
m_PMSSqlConnection.CommitTransaction();
}
catch (Exception ex)
{
m_PMSSqlConnection.RollBackTransaction();
errorInfo = "Save Fail";
m_Logger.Error("PmsHeadBiz/InsertPmsHeadAndDoc" + ex.Message.ToString());
}
return(returnResult);
}
//private void BindDropDownListSiteAndImpactSite()
//{
// try
// {
// PmsSys pmsSys = new PmsSys();
// pmsSys.Vid = "PM";
// pmsSys.Type = "Site";
// PmsSysBiz pmsSysBiz = new PmsSysBiz();
// IList<PmsSys> pmsSysList = pmsSysBiz.SelectData1ByType(pmsSys);
// dropdownlistSite.DataSource = pmsSysList;
// dropdownlistSite.DataTextField = "Data1";
// dropdownlistSite.DataValueField = "Data1";
// dropdownlistSite.DataBind();
// dropdownlistSite.Items.Insert(0, "");
// dropdownlistImpactSite.DataSource = pmsSysList;
// dropdownlistImpactSite.DataTextField = "Data1";
// dropdownlistImpactSite.DataValueField = "Data1";
// dropdownlistImpactSite.DataBind();
// QWeb.SelectItem(dropdownlistImpactSite, "QCS");
// //dropdownlistSite.Items.Insert(0, new ListItem());
// //dropdownlistSite.Items[0].Text = "";
// //dropdownlistSite.Items[0].Value = "";
// //dropdownlistImpactSite.Items.Insert(0, new ListItem());
// //dropdownlistImpactSite.Items[0].Text = "";
// //dropdownlistImpactSite.Items[0].Value = "";
// }
// catch
// {
// ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('Bind ImpactSite failure');", true);
// }
//}
#endregion
#endregion
protected void buttonSave_Click(object sender, EventArgs e)
{
try
{
//#region Define Variable
////string strSavePath = "";
////int iTypeID = 0;
//#endregion
//检查控件中的值
if (!CheckControlValue())
{
return;
}
//获取新的Pmsid，CrId以及他们的创建时间
DateTime dtCurDate;
string strPmsID = string.Empty;
string strCrId = string.Empty;
m_PmsCRCreatBiz.GetNewPmsIdTempCrId(out dtCurDate, out strPmsID, out strCrId);
#region Get StageID
PmsFlowTemplateBiz pmsFlowTemplateBiz = new PmsFlowTemplateBiz();
IList <PmsFlowTemplate> pmsFlowTemplateList = pmsFlowTemplateBiz.SelectPmsFlowTemplateByTypeId(dropdownlistType.SelectedValue.Trim());
int stageId = pmsFlowTemplateList[0].Stageid;
#endregion
#region For Insert PmsHead
PmsHead pmsHeadInsert = new PmsHead();
pmsHeadInsert.Vid = "PM";
pmsHeadInsert.PmsId = strPmsID;
pmsHeadInsert.PmsName = textboxPmsName.Text.Trim().Replace("'", "");
pmsHeadInsert.Type = dropdownlistType.SelectedItem.Text.Trim();
pmsHeadInsert.Description = textboxDescription.Text.Trim().Replace("'", "");
pmsHeadInsert.System = textboxSystem.Text.Trim().Replace("'", "");
pmsHeadInsert.Domain = dropdownlistDomain.SelectedItem.Text.Trim();
pmsHeadInsert.Priority = dropdownlistPriority.SelectedItem.Text.Trim();
pmsHeadInsert.Site = dropdownlistSite.SelectedValue;
pmsHeadInsert.ImpactSite = dropdownlistImpactSite.SelectedItem.Text.Trim();
pmsHeadInsert.NeedSTP = RadioButtonNeedSTPYes.Checked ? "Y" : "N";
pmsHeadInsert.NeedSTC = RadioButtonNeedSTCYes.Checked ? "Y" : "N";
//要插VB2Net add by ITO.Abel.Li 2014-01-06
pmsHeadInsert.Category = RadioButtonVB2NetYes.Checked ? "Y" : "N";
pmsHeadInsert.NewVersion = textboxNewVersion.Text.Trim().Replace("'", "");
// pmsHeadInsert.OldVersion = textboxOldVersion.Text.Trim().Replace("'", "");
pmsHeadInsert.OldVersion = HiddenFieldOldVersion.Value.Trim().Replace("'", "");
pmsHeadInsert.DueDate = DateTime.Parse(dateTextBoxDueDate.Text.Trim());
pmsHeadInsert.PlanStartDate = DateTime.Parse(dateTextBoxPlanStartDate.Text.Trim());
//pmsHeadInsert.ReleaseDate = 0;
//pmsHeadInsert.CloseDate = 0;
pmsHeadInsert.Stage = stageId;
pmsHeadInsert.Pm = textboxPM.Text.Trim().Replace("'", "");
pmsHeadInsert.Sd = "";
pmsHeadInsert.Se = "";
pmsHeadInsert.Qa = "";
pmsHeadInsert.AbnormalStage = 0;
pmsHeadInsert.Rerver1 = "";
pmsHeadInsert.Rerver2 = "";
pmsHeadInsert.Rerver3 = "";
pmsHeadInsert.Rerver4 = "";
pmsHeadInsert.Rerver5 = "";
pmsHeadInsert.CreateDate = dtCurDate;
pmsHeadInsert.Creator = LoginName;
//pmsHeadInsert.MaintainDate = dtCurDate;
pmsHeadInsert.MaintainUser = "";
pmsHeadInsert.OwnerDept = m_PmsCRCreatBiz.GetOwnerDept(LoginName) ?? string.Empty;
pmsHeadInsert.RelatedCrNo = textboxRelatedCrNo.Text.Trim();
#endregion
#region For Insert PMS_ITARM_Mapping
PmsItarmMapping pmsItarmMapping = new PmsItarmMapping();
pmsItarmMapping.PmsId = strPmsID;
pmsItarmMapping.CrId = strCrId;
pmsItarmMapping.Creator = LoginName;
pmsItarmMapping.CreateDate = dtCurDate;
#endregion
#region File(注释不用)
#region Get Document Type
//PmsDocumentType pmsDocType = new PmsDocumentType();
//pmsDocType.Vid = "PM";
//pmsDocType.TypeName = "PES";
//PmsDocumentTypeBiz pmsDocTypeBiz = new PmsDocumentTypeBiz();
//IList<PmsDocumentType> pmsDocTypeList = pmsDocTypeBiz.SelectPmsDocumentType(pmsDocType);
//if (pmsDocTypeList != null && pmsDocTypeList.Count > 0)
//{
// iTypeID = pmsDocTypeList[0].TypeId;
//}
#endregion
#region Get UploadFilePath
//PmsSys pmsSys = new PmsSys();
//pmsSys.Vid = "PM";
//pmsSys.Type = "UploadFilePath";
//PmsSysBiz pmsSysBiz = new PmsSysBiz();
//IList<PmsSys> pmsSysList = pmsSysBiz.SelectData1ByType(pmsSys);
//if (pmsSysList != null && pmsSysList.Count > 0)
//{
// strSavePath = pmsSysList[0].Data1.ToString().Trim();
//}
//else
//{
// ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('Please maintain UploadFilePath!');", true);
// return;
//}
#endregion
#region For Insert PmsDocuments
//PmsDocuments pmsDocuments = new PmsDocuments();
//pmsDocuments.PmsId = strPmsID;
//pmsDocuments.DocTypeId = iTypeID;
//pmsDocuments.FileName = pesUpload.PostedFile.FileName.Substring(pesUpload.PostedFile.FileName.LastIndexOf("\\") + 1);
//string strTmp = strSavePath + "\\" + strPmsID + "\\" + pmsDocuments.FileName;
//if (strTmp.Length > 150)
//{
// ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('The length of SavePath is larger than 150!');", true);
// pesUpload.Focus();
// return;
//}
//pmsDocuments.Path = strSavePath + "\\" + strPmsID + "\\" + pmsDocuments.FileName;
//pmsDocuments.Size = pesUpload.PostedFile.ContentLength.ToString().Trim();
//pmsDocuments.Creator = LoginName;
//pmsDocuments.CreateDate = dtCurDate;
//#endregion
//#region Upload PES File
//if (pmsDocuments.FileName != "")
//{
// strSavePath = strSavePath + "\\" + strPmsID;
// if (!QFile.CheckFolderExist(strSavePath))
// {
// QFile.CreateDirectory(strSavePath);
// }
// strSavePath = strSavePath + "\\" + pmsDocuments.FileName;
// pesUpload.PostedFile.SaveAs(strSavePath);
//}
#endregion
#endregion
#region For Insert SdpDetail
SdpDetail sdpDetail = new SdpDetail();
sdpDetail.Pmsid = strPmsID;
sdpDetail.Type = dropdownlistType.SelectedValue.Trim();
#endregion
#region For Insert PmsFlow
//pmsFlowTemplateList = pmsFlowTemplateBiz.SelectPmsFlowTemplateByTypeId(dropdownlistType.SelectedValue.Trim());
PmsFlow pmsFlow = new PmsFlow();
pmsFlow.FlowId = pmsFlowTemplateList[0].FlowId;
pmsFlow.PmsId = strPmsID;
pmsFlow.Creator = LoginName;
pmsFlow.CreateDate = dtCurDate;
#endregion
#region For Insert PMSChangeHistory
PmsChangeHistory pmsChangeHistory = new PmsChangeHistory();
pmsChangeHistory.PmsId = strPmsID;
pmsChangeHistory.ChangeContent = "";
pmsChangeHistory.Action = "CREATE";
pmsChangeHistory.CreateDate = dtCurDate;
pmsChangeHistory.Creator = LoginName;
#endregion
#region For Insert Itarm_Cr_List
ItarmCrList itarmCrList = new ItarmCrList();
itarmCrList.CrId = strCrId;
itarmCrList.CrName = textboxPmsName.Text.Trim().Replace("'", "");
itarmCrList.Site = dropdownlistSite.SelectedValue;
itarmCrList.Creator = LoginName;
itarmCrList.CreateDate = dtCurDate;
itarmCrList.Pm = textboxPM.Text.Trim().Replace("'", "");
itarmCrList.System = textboxSystem.Text.Trim().Replace("'", "");
#endregion
#region Insert
PmsHeadBiz pmsInsert = new PmsHeadBiz();
string errorInfo;
int insertResult = pmsInsert.InsertPmsHeadAndDoc(pmsHeadInsert, sdpDetail, pmsChangeHistory, pmsItarmMapping, pmsFlow, itarmCrList, null, out errorInfo);
if (insertResult == 0)
{
Msgbox("Save Fail!");
}
else
{
#region 更新系统版本表
bool upVerResult =
m_PmsCRCreatBiz.UpdateSysVersion(dropdownlistDomain.SelectedValue, textboxSystem.Text.Trim(), dropdownlistSite.SelectedValue, textboxNewVersion.Text.Trim());
if (!upVerResult)
{
Msgbox("Updated system version number fail!");
}
#endregion
// Session["InquiryPage_Refresh"] = "Y";
//发送创建成功的Mail
LoginName.Replace(".", " ");
pmsHeadInsert.UserName = LoginName;
new MailBiz().SendCreateMail(pmsHeadInsert);
Msgbox("Create Successful!");
PageRegisterStartupScript("window.close();");
}
#endregion
}
catch (Exception exception)
{
Msgbox("Save Fail!");
}
}
protected void ButtonSave_Click(object sender, EventArgs e)
{
try
{
//get creator,createDate,pmsID,crID
string creator = WSC.GlobalDefinition.Cookie_LoginUser.Replace(" ", ".");
DateTime createDate;
string pmsID = string.Empty;
string crId = string.Empty;
m_PmsCRCreatBiz.GetNewPmsIdTempCrId(out createDate, out pmsID, out crId);
//get pmsHead,pmsflow,sdpDetail,getPmsChangeHistory,getPmsItarmMapping,getPmsFlow,itarmCrList
PmsHead pmsHead = getPmsHead(creator, createDate, pmsID);
SdpDetail sdpDetail = getSdpDetail(pmsID);
PmsChangeHistory pmsChangeHistory = getPmsChangeHistory(creator, createDate, pmsID);
PmsItarmMapping pmsItarmMapping = getPmsItarmMapping(creator, createDate, pmsID, crId);
PmsFlow pmsFlow = getPmsFlow(creator, createDate, pmsID);
ItarmCrList itarmCrList = getItarmCrList(creator, createDate, crId);
IList <PmsDocuments> pmsDocuments = getPmsDocuments(creator, createDate, pmsID, crId);
if (pmsHead == null)
{
Msgbox("Save failed");
return;
}
//Insert
PmsHeadBiz pmsInsert = new PmsHeadBiz();
string errorInfo;
int insertResult = pmsInsert.InsertPmsHeadAndDoc(pmsHead, sdpDetail, pmsChangeHistory, pmsItarmMapping, pmsFlow, itarmCrList, pmsDocuments, out errorInfo);
if (insertResult == 0)
{
Msgbox(errorInfo);
}
else
{
//将TempFile文件夹里的文件移动到UploadFile下以CRNO命名的文件夹里并删除Temp里的文件。
MoveUploadFileDeleteTempFile(crId);
LoginName.Replace(".", " ");
pmsHead.UserName = LoginName;
new MailBiz().SendCreateMail(pmsHead);
// 更新Stage 自动把这个Cr推进到AssginMember
int oldStage = (int)PmsCommonEnum.ProjectStage.PES;
int newStage = (int)PmsCommonEnum.ProjectStage.AssignMember;
string strAction = Enum.Parse(typeof(PmsCommonEnum.ProjectStage), oldStage.ToString()).GetDescription();
bool blResult = new BasicInformationDetailBiz().UpdateStages(pmsID, LoginName, oldStage, newStage, strAction);
if (!blResult)
{
Msgbox("更新stage数据失败！");
return;
}
new MailBiz().SendPromoteMail(pmsHead, newStage);
Msgbox("Create Successful!");
PageRegisterStartupScript("window.close();");
}
}
catch (Exception exception)
{
throw new Exception(exception.ToString());
}
}
public bool UpdateSdpDetailAuditStatus(string serials, int auditStatus, string auditComment)
{
bool result = false;
string[] serialArray = serials.Split(';');
string serialAll = serialArray.Aggregate(string.Empty, (current, next) => current + "'" + next + "',").TrimEnd(',');
SdpDetail sdpDetail = new SdpDetail();
PmsSdpAudit pmsSdpAudit = new PmsSdpAudit();
sdpDetail.Serials = serialAll;
sdpDetail.AuditStatus = auditStatus;
if (new SdpDetailBiz().UpdateSdpDetailAuditStatus(sdpDetail))
{
//同意或拒绝会新增版本
if ((auditStatus == (int)PmsCommonEnum.AuditStatus.HasApproved) || auditStatus == (int)PmsCommonEnum.AuditStatus.BeenRejected)
{
PmsSdpVersion pmsSdpVersion = new PmsSdpVersion();
foreach (var serial in serialArray)
{
IList <PmsSdpVersion> PmsSdpVersionList = new PmsSdpVersionBiz().SelectPmsSdpVersionByTaskno(serial);
IList <SdpDetail> listSdpDetail = new SdpDetailBiz().SelectSdpDetail(new SdpDetail {
Serial = int.Parse(serial)
});
if (listSdpDetail == null || listSdpDetail.Count == 0)
{
return(result);
}
sdpDetail = listSdpDetail.FirstOrDefault();
pmsSdpVersion.Taskno = int.Parse(serial);
pmsSdpVersion.Pmsid = sdpDetail.Pmsid;
pmsSdpVersion.PlanStartDay = sdpDetail.Planstartday;
pmsSdpVersion.PlanEndDay = sdpDetail.Planendday;
pmsSdpVersion.PlanCost = (float)sdpDetail.Plancost;
pmsSdpVersion.RefCost = (float)sdpDetail.Refcost;
pmsSdpVersion.Creator = LoginName;
pmsSdpVersion.CreateDate = DateTime.Now;
pmsSdpVersion.Version = (PmsSdpVersionList == null || PmsSdpVersionList.Count == 0) ? 1.0f : PmsSdpVersionList.Max(t => t.Version) + 0.1f;
new PmsSdpVersionBiz().InsertPmsSdpVersion(pmsSdpVersion);
}
IList <PmsSdpAudit> pmsSdpAuditList = new PmsSdpAuditBiz().SelectPmsSdpAuditByPmsId(sdpDetail.Pmsid);
pmsSdpAudit.Pmsid = sdpDetail.Pmsid;
pmsSdpAudit.SdpVersion = (pmsSdpAuditList == null || pmsSdpAuditList.Count == 0) ? 1.0f : pmsSdpAuditList.Max(t => t.SdpVersion) + 0.1f;
pmsSdpAudit.Auditor = LoginName;
if (auditComment == "")
{
pmsSdpAudit.AuditResult = "Approve";
}
else
{
pmsSdpAudit.AuditResult = "Reject";
}
pmsSdpAudit.AuditComment = auditComment;
pmsSdpAudit.CreateDate = DateTime.Now;
pmsSdpAudit.Creator = LoginName;
new PmsSdpAuditBiz().InsertPmsSdpAudit(pmsSdpAudit);
}
//发mail通知相关人员(提交人或者审核人)
result = new MailBiz().TaskMail(serialArray[0], auditStatus);
}
return(result);
}
