protected void DropDownListYearMonth_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DropDownListWeekPeriod.Items.Clear();
PmsSysBiz pmsSysBiz = new PmsSysBiz();
string yearMonth = DropDownListYearMonth.SelectedValue.Trim();
IList <PmsSys> pmsSysList = pmsSysBiz.SelectData2ByTypeData1("PM", "RequirementPeriod", yearMonth);
DropDownListWeekPeriod.DataSource = pmsSysList;
DropDownListWeekPeriod.DataTextField = "data2";
DropDownListWeekPeriod.DataValueField = "data2";
DropDownListWeekPeriod.DataBind();
DropDownListWeekPeriod.Items.Insert(0, new ListItem());
DropDownListWeekPeriod.Items[0].Text = "";
DropDownListWeekPeriod.Items[0].Value = "";
ClearGrid();
}
catch
{
}
}
private bool FileTypeIsAllowable(string fileType)
{
////从web.config读取判断文件类型限制
//string strFileTypeLimit = ConfigurationManager.AppSettings["FileType"];
////当前文件扩展名是否包含在这个字符串中
//if (strFileTypeLimit.IndexOf(fileType.ToLower()) != -1)
//{
// return true;
//}
//else
// return false;
PmsSysBiz pmsSysBiz = new PmsSysBiz();
IList <PmsSys> listPmsSys = pmsSysBiz.SelectData1ByType("PM", "AttachmentType");
foreach (PmsSys pmsSys in listPmsSys)
{
if (fileType.ToLower().Trim().Equals(pmsSys.Data1))
{
return(true);
}
}
return(false);
}
protected void buttonGetFile_Click(object sender, EventArgs e)
{
PmsHead pmsHead = new PmsHead();
DateTime dtCurDate = PmsSysBiz.GetDBDateTime();
pmsHead.Creator = LoginName;
pmsHead.CreateDate = dtCurDate;
pmsHead.PmsId = PmsID;
pmsHead.CrId = CrID;
IList <PmsDocuments> listPmsDocuments = new PmsDocumentsBiz().GetPmsDocuments(pmsHead);
int saveResult = 0;
foreach (PmsDocuments pmsDocuments in listPmsDocuments)
{
IList <PmsDocuments> pmsDocList = new PmsDocumentsBiz().SelectPmsDocuments(pmsDocuments);
if (pmsDocList != null && pmsDocList.Count > 0)
{
continue;
}
saveResult = new PmsDocumentsBiz().InsertPmsDocuments(pmsDocuments);
if (saveResult <= 0)
{
Msgbox("Get File failure!");
return;
}
}
BindGrid(sender, e); // BindGrid时需判断projectType
}
private void BindDropDownListType()
{
try
{
//PmsSys pmsSys = new PmsSys();
//pmsSys.Vid = "PM";
//pmsSys.Type = "Type";
PmsSysBiz pmsSysBiz = new PmsSysBiz();
IList <PmsSys> pmsSysList = pmsSysBiz.SelectData1ByType("PM", "Type");
var pmsService = pmsSysList.Where(t => t.Data1 == "Service").FirstOrDefault();
pmsSysList.Remove(pmsService);
dropdownlistType.DataSource = pmsSysList;
dropdownlistType.DataTextField = "Data1";
dropdownlistType.DataValueField = "Data1";
dropdownlistType.DataBind();
//dropdownlistType.Items.Insert(0, new ListItem());
//dropdownlistType.Items[0].Text = "";
//dropdownlistType.Items[0].Value = "";
dropdownlistType.SelectedIndex = 0;
}
catch
{
Msgbox("Bind Type failure!");
}
}
//private void BindDropDownListDoMain()
//{
// try
// {
// BaseDataDomainBiz baseDataDomainBiz = new BaseDataDomainBiz();
// IList<BaseDataDomain> baseDataDomainList = baseDataDomainBiz.SelectBaseDataDomain(null);
// dropdownlistDomain.DataSource = baseDataDomainList;
// dropdownlistDomain.DataTextField = "Name";
// dropdownlistDomain.DataValueField = "Id";
// dropdownlistDomain.DataBind();
// dropdownlistDomain.SelectedIndex = 0;
// //dropdownlistDomain.Items.Insert(0, new ListItem());
// //dropdownlistDomain.Items[0].Text = "";
// //dropdownlistDomain.Items[0].Value = "";
// }
// catch
// {
// ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('Bind Domain failure');", true);
// }
//}
private void BindDropDownListPriority()
{
try
{
//PmsSys pmsSys = new PmsSys();
//pmsSys.Vid = "PM";
//pmsSys.Type = "Priority";
PmsSysBiz pmsSysBiz = new PmsSysBiz();
IList <PmsSys> pmsSysList = pmsSysBiz.SelectData1ByType("PM", "Priority");
dropdownlistPriority.DataSource = pmsSysList;
dropdownlistPriority.DataTextField = "Data1";
dropdownlistPriority.DataValueField = "Data1";
dropdownlistPriority.DataBind();
QWeb.SelectItem(dropdownlistPriority, "Normal");
//dropdownlistPriority.Items.Insert(0, new ListItem());
//dropdownlistPriority.Items[0].Text = "";
//dropdownlistPriority.Items[0].Value = "";
}
catch
{
Msgbox("Bind Priority failure!");
}
}
private void BindDropDownListPriority()
{
try
{
//PmsSys pmsSys = new PmsSys();
//pmsSys.Vid = "PM";
//pmsSys.Type = "Priority";
PmsSysBiz pmsSysBiz = new PmsSysBiz();
IList <PmsSys> pmsSysList = pmsSysBiz.SelectData1ByType("PM", "Priority");
dropdownlistPriority.DataSource = pmsSysList;
dropdownlistPriority.DataTextField = "Data1";
dropdownlistPriority.DataValueField = "Data1";
dropdownlistPriority.DataBind();
dropdownlistPriority.Items.Insert(0, new ListItem());
dropdownlistPriority.Items[0].Text = "";
dropdownlistPriority.Items[0].Value = "";
}
catch
{
ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('Bind Priority failure');", true);
this.dropdownlistPriority.Focus();
}
}
private void BindDropDownList()
{
try
{
PmsSysBiz pmsSysBiz = new PmsSysBiz();
IList <PmsSys> pmsSysList = pmsSysBiz.SelectData1Data2ByType("PM", "RequirementPeriod");
IList <string> listYearMonth = pmsSysList.Select(t => t.Data1).Distinct().ToList();
DropDownListYearMonth.DataSource = listYearMonth;
DropDownListYearMonth.DataBind();
DropDownListYearMonth.Items.Insert(0, new ListItem());
DropDownListYearMonth.Items[0].Text = "";
DropDownListYearMonth.Items[0].Value = "";
DropDownListWeekPeriod.DataSource = pmsSysList;
DropDownListWeekPeriod.DataTextField = "data2";
DropDownListWeekPeriod.DataValueField = "data2";
DropDownListWeekPeriod.DataBind();
DropDownListWeekPeriod.Items.Insert(0, new ListItem());
DropDownListWeekPeriod.Items[0].Text = "";
DropDownListWeekPeriod.Items[0].Value = "";
}
catch
{
ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('Bind Domain failure');", true);
this.DropDownListYearMonth.Focus();
}
}
private void BindDropDownList()
{
try
{
PmsSysBiz pmsSysBiz = new PmsSysBiz();
IList <PmsSys> pmsSysList = new List <PmsSys>();
pmsSysList = pmsSysBiz.SelectData2ByTypeData1("PM", "Report", "StatisticsInterval");
DropDownListStatisticsInterval.DataSource = pmsSysList;
DropDownListStatisticsInterval.DataTextField = "data2";
DropDownListStatisticsInterval.DataValueField = "data2";
DropDownListStatisticsInterval.DataBind();
DropDownListStatisticsInterval.Items.Insert(0, new ListItem());
DropDownListStatisticsInterval.Items[0].Text = "";
DropDownListStatisticsInterval.Items[0].Value = "";
pmsSysList = pmsSysBiz.SelectData1ByType("PM", "UserDept");
DropDownListUserDept.DataSource = pmsSysList;
DropDownListUserDept.DataTextField = "data1";
DropDownListUserDept.DataValueField = "data1";
DropDownListUserDept.DataBind();
DropDownListUserDept.Items.Insert(0, new ListItem());
DropDownListUserDept.Items[0].Text = "";
DropDownListUserDept.Items[0].Value = "";
}
catch
{
ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('Bind DropDownList failure');", true);
}
}
private bool DueDateChangedForRdReason(string pmsId)
{
bool result = false;
IList <PmsHeadH> listtPmsHeadH = new PmsHeadHBiz().SelectPmsHeadHByPmsId(pmsId);
foreach (var pmsHeadH in listtPmsHeadH)
{
string dueDate = pmsHeadH.DueDate.ToString("yyyy-MM-dd");
if (!dueDate.Equals("1900-01-01") && !dueDate.Equals("0001-01-01") && !dueDate.Equals("0000-00-00") && !dueDate.Equals("1899-12-30") && !dueDate.Equals("01-01-01"))
{
if (pmsHeadH.ReasonType != string.Empty)
{
PmsSysBiz pmsSysBiz = new PmsSysBiz();
IList <PmsSys> pmsSysList = pmsSysBiz.SelectData1ByTypeData5("PM", "ReasonType", "RD");
foreach (var pmsSys in pmsSysList)
{
if (pmsHeadH.ReasonType == pmsSys.Data1)
{
return(true);
}
}
}
}
}
return(result);
}
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);
}
private void BindDropDown()
{
PmsSysBiz pmsSysBiz = new PmsSysBiz();
IList <PmsSys> listPmsSys = pmsSysBiz.SelectData2ByTypeData1("PM", "MeetingMinute", "MeetingType");
DropDownListMeetingMinuteType.DataSource = listPmsSys;
DropDownListMeetingMinuteType.DataTextField = "data2";
DropDownListMeetingMinuteType.DataValueField = "data2";
DropDownListMeetingMinuteType.DataBind();
DropDownListMeetingMinuteType.Items.Insert(0, new ListItem());
DropDownListMeetingMinuteType.Items[0].Text = "";
DropDownListMeetingMinuteType.Items[0].Value = "";
IList <PmsSys> listPmsSysVenue = pmsSysBiz.SelectData2ByTypeData1("PM", "MeetingMinute", "Venue");
DropDownListVenue.DataSource = listPmsSysVenue;
DropDownListVenue.DataTextField = "data2";
DropDownListVenue.DataValueField = "data2";
DropDownListVenue.DataBind();
DropDownListVenue.Items.Insert(0, new ListItem());
DropDownListVenue.Items[0].Text = "";
DropDownListVenue.Items[0].Value = "";
IList <PmsSys> listPmsSysHour = pmsSysBiz.SelectData2ByTypeData1("PM", "MeetingTime", "Hour");
DropDownListStartHour.DataSource = listPmsSysHour;
DropDownListStartHour.DataTextField = "data2";
DropDownListStartHour.DataValueField = "data2";
DropDownListStartHour.DataBind();
DropDownListEndHour.DataSource = listPmsSysHour;
DropDownListEndHour.DataTextField = "data2";
DropDownListEndHour.DataValueField = "data2";
DropDownListEndHour.DataBind();
// 选中 10;
IList <PmsSys> listPmsSysMinute = pmsSysBiz.SelectData2ByTypeData1("PM", "MeetingTime", "Minute");
DropDownListStartMinute.DataSource = listPmsSysMinute;
DropDownListStartMinute.DataTextField = "data2";
DropDownListStartMinute.DataValueField = "data2";
DropDownListStartMinute.DataBind();
DropDownListEndMinute.DataSource = listPmsSysMinute;
DropDownListEndMinute.DataTextField = "data2";
DropDownListEndMinute.DataValueField = "data2";
DropDownListEndMinute.DataBind();
//选中 00;
}
protected Hashtable FileExtensionExportFormat()
{
PmsSysBiz pmsSysBiz = new PmsSysBiz();
IList <PmsSys> listPmsSys = pmsSysBiz.SelectData1Data2ByType("PM", "AttachmentType");
Hashtable hashTableContentTypes = new Hashtable();
foreach (PmsSys pmsSys in listPmsSys)
{
hashTableContentTypes.Add(pmsSys.Data1, pmsSys.Data2);
}
return(hashTableContentTypes);
}
private bool FileTypeIsAllowable(string fileType)
{
PmsSysBiz pmsSysBiz = new PmsSysBiz();
IList <PmsSys> listPmsSys = pmsSysBiz.SelectData1ByType("PM", "AttachmentType");
foreach (PmsSys pmsSys in listPmsSys)
{
if (fileType.ToLower().Trim().Equals(pmsSys.Data1))
{
return(true);
}
}
return(false);
}
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();
}
private bool CheckTaskType(string phase, string taskType, ref int taskTypeValue)
{
bool result = false;
IList <PmsSys> pmsSysList = new PmsSysBiz().SelectData2Data3ByType("PM", "TaskType", phase);
foreach (PmsSys pmsSys in pmsSysList)
{
if (pmsSys.Data3 == taskType)
{
taskTypeValue = int.Parse(pmsSys.Data2);
result = true;
}
}
return(result);
}
private void BindDropDownList(GridViewRow row)
{
DropDownList dropDownListStatus = (DropDownList)row.FindControl("DropDownListStatus");
if (dropDownListStatus != null)
{
PmsSysBiz pmsSysBiz = new PmsSysBiz();
IList <PmsSys> pmsSysList = pmsSysBiz.SelectData1Data2ByType("PM", "RequirementStatus");
dropDownListStatus.DataSource = pmsSysList;
dropDownListStatus.DataTextField = "data1";
dropDownListStatus.DataValueField = "data1";
dropDownListStatus.DataBind();
}
}
private IList <string> GetWeeks(string month)
{
IList <string> weeks = new List <string>();
PmsSysBiz pmsSysBiz = new PmsSysBiz();
IList <PmsSys> pmsSysList = pmsSysBiz.SelectData2ByTypeData1("PM", "RequirementPeriod", month);
if (pmsSysList.Count > 0)
{
foreach (var pmsSys in pmsSysList)
{
weeks.Add(pmsSys.Data2);
}
}
return(weeks);
}
private void BindDropDownListPriority()
{
try
{
PmsSysBiz pmsSysBiz = new PmsSysBiz();
IList <PmsSys> pmsSysList = pmsSysBiz.SelectData1ByType("PM", "Priority");
dropdownlistPriority.DataSource = pmsSysList;
dropdownlistPriority.DataTextField = "Data1";
dropdownlistPriority.DataValueField = "Data1";
dropdownlistPriority.DataBind();
QWeb.SelectItem(dropdownlistPriority, "Normal");
}
catch
{
Msgbox("Bind Priority failure!");
}
}
private void BindDropDownListProgramLanguage()
{
PmsSysBiz pmsSysBiz = new PmsSysBiz();
try
{
IList <PmsSys> pmsSysList = pmsSysBiz.SelectData1Data2ByType("PM", "ProgramLanguage");
this.DropDownListProgramLanguage.DataSource = pmsSysList;
this.DropDownListProgramLanguage.DataTextField = "Data2";
this.DropDownListProgramLanguage.DataValueField = "Data1";
this.DropDownListProgramLanguage.DataBind();
}
catch
{
ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('Bind ProgramLanguage failure');", true);
this.DropDownListProgramLanguage.Focus();
}
}
protected void InsertPmsDocuments(string fileName, string fileFullPath, string fileSize, out int saveResult)
{
PmsDocuments pmsDocuments = new PmsDocuments();
pmsDocuments.PmsId = PmsID;
pmsDocuments.DocTypeId = (int)PmsCommonEnum.DocumentType.Other;
pmsDocuments.FileName = fileName;
pmsDocuments.Path = fileFullPath;
pmsDocuments.Size = fileSize;
pmsDocuments.Creator = WSC.GlobalDefinition.Cookie_LoginUser.Replace(" ", ".");;
DateTime dtCurDate = PmsSysBiz.GetDBDateTime();
pmsDocuments.CreateDate = dtCurDate;
PmsDocumentsBiz pmsDocBiz = new PmsDocumentsBiz();
saveResult = pmsDocBiz.InsertPmsDocuments(pmsDocuments);
}
private void BindDropDownListTeamDomain()
{
try
{
PmsSysBiz pmsSysBiz = new PmsSysBiz();
IList <PmsSys> pmsSysList = pmsSysBiz.SelectData1ByType("PM", "Domain");
dropdownlistTeamDomain.DataSource = pmsSysList;
dropdownlistTeamDomain.DataTextField = "data1";
dropdownlistTeamDomain.DataValueField = "data1";
dropdownlistTeamDomain.DataBind();
dropdownlistTeamDomain.Items.Insert(0, new ListItem());
dropdownlistTeamDomain.Items[0].Text = "";
dropdownlistTeamDomain.Items[0].Value = "";
}
catch
{
Msgbox("Bind Team Domain failure!");
}
}
//private void InitDoMain()
//{
// try
// {
// string strDoMainName = "";
// BaseDataUserBiz baseDataUserBiz = new BaseDataUserBiz();
// IList<BaseDataUser> baseDataUserList = baseDataUserBiz.SelectDoMainNameByLoginName(LoginName);
// if (baseDataUserList != null && baseDataUserList.Count > 0)
// {
// strDoMainName = baseDataUserList[0].DoMainName.ToString().Trim();
// dropdownlistDomain.SelectedIndex = dropdownlistDomain.Items.IndexOf(dropdownlistDomain.Items.FindByText(strDoMainName));
// //QWeb.SelectItem(dropdownlistDomain, strDoMainName);
// }
// }
// catch
// {
// Msgbox("Init DoMain failure!");
// }
//}
#region 绑定DropDownList Site ImpactSite Domain
private void BindDropDownListSiteImpactSiteDomain()
{
PmsSysBiz pmsSysBiz = new PmsSysBiz();
IList <PmsSys> pmsSysList = pmsSysBiz.SelectData1ByType("PM", "Site");
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();
dropdownlistImpactSite.Items.Insert(0, "");
// QWeb.SelectItem(dropdownlistImpactSite, "QCS");
SystemListPopUpBiz systemListPopUpBiz = new SystemListPopUpBiz();
//IList<ItarmSystem> resultSite = systemListPopUpBiz.GetItarmSystemSite();
//dropdownlistSite.DataSource = resultSite;
//dropdownlistSite.DataTextField = "Site";
//dropdownlistSite.DataValueField = "Site";
//dropdownlistSite.DataBind();
//dropdownlistSite.Items.Insert(0, "");
//dropdownlistImpactSite.DataSource = resultSite;
//dropdownlistImpactSite.DataTextField = "Site";
//dropdownlistImpactSite.DataValueField = "Site";
//dropdownlistImpactSite.DataBind();
//QWeb.SelectItem(dropdownlistImpactSite, "QCS");
IList <string> resultDomain = systemListPopUpBiz.GetItarmSystemDomain();
dropdownlistDomain.DataSource = resultDomain;
dropdownlistDomain.DataBind();
dropdownlistDomain.Items.Insert(0, "");
}
private void BindDropDownListTaskComplexity()
{
PmsSysBiz pmsSysBiz = new PmsSysBiz();
try
{
IList <PmsSys> pmsSysList = pmsSysBiz.SelectData1Data2ByType("PM", "TaskComplexity");
this.DropDownListTaskComplexity.DataSource = pmsSysList;
this.DropDownListTaskComplexity.DataTextField = "Data2";
this.DropDownListTaskComplexity.DataValueField = "Data1";
this.DropDownListTaskComplexity.DataBind();
this.DropDownListTaskComplexity.Items.Insert(0, new ListItem());
this.DropDownListTaskComplexity.Items[0].Text = "";
this.DropDownListTaskComplexity.Items[0].Value = "";
}
catch
{
ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('Bind TaskComplexity failure');", true);
this.DropDownListTaskComplexity.Focus();
}
}
private void BindDropDownListDoMain()
{
try
{
PmsSysBiz pmsSysBiz = new PmsSysBiz();
//IList<BaseDataDomain> baseDataDomainList = baseDataDomainBiz.SelectBaseDataDomain(null);
IList <PmsSys> pmsSysList = pmsSysBiz.SelectData1ByType("PM", "Domain");
dropdownlistDomain.DataSource = pmsSysList;
dropdownlistDomain.DataTextField = "data1";
dropdownlistDomain.DataValueField = "data1";
dropdownlistDomain.DataBind();
dropdownlistDomain.Items.Insert(0, new ListItem());
dropdownlistDomain.Items[0].Text = "";
dropdownlistDomain.Items[0].Value = "";
}
catch
{
ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('Bind Domain failure');", true);
this.dropdownlistDomain.Focus();
}
}
public bool ImportSdpDetailBySerial(string serials)
{
string[] serialArray = serials.Split(';');
foreach (string serial in serialArray)
{
TmpSdpImportdetail tmpSdpImportdetail = new TmpSdpImportdetail();
tmpSdpImportdetail.Serial = int.Parse(serial.Trim());
TmpSdpImportdetailBiz tmpSdpImportdetailBiz = new TmpSdpImportdetailBiz();
var listTmpSdpImportdetail = tmpSdpImportdetailBiz.GetTmpSdpDetail(tmpSdpImportdetail);
if (listTmpSdpImportdetail == null || listTmpSdpImportdetail.Count == 0)
{
return(false);
}
else
{
tmpSdpImportdetail = listTmpSdpImportdetail[0];
}
//插入sdpDetail表
SdpDetailBiz sdpDetailBiz = new SdpDetailBiz();
SdpDetail sdpDetail = new SdpDetail();
DateTime dateTime = PmsSysBiz.GetDBDateTime();
sdpDetail.Pmsid = tmpSdpImportdetail.Pmsid;
sdpDetail.Phase = tmpSdpImportdetail.Phase;
sdpDetail.TaskName = tmpSdpImportdetail.TaskName;
sdpDetail.OperationType = tmpSdpImportdetail.OperationType;
sdpDetail.TaskType = tmpSdpImportdetail.TaskType;
sdpDetail.FunctionType = tmpSdpImportdetail.FunctionType;
sdpDetail.ProgramLanguage = tmpSdpImportdetail.ProgramLanguage;
sdpDetail.TaskComplexity = tmpSdpImportdetail.TaskComplexity;
//根据条件取，为空就为planCost
PmsSdpRefcost sdpRefcost = new PmsSdpRefcost();
sdpRefcost.OperationType = sdpDetail.OperationType;
sdpRefcost.TaskComplexity = sdpDetail.TaskComplexity;
sdpRefcost.Tasktype = sdpDetail.TaskType;
sdpRefcost.Functiontype = sdpDetail.FunctionType;
sdpRefcost.Programlanguage = sdpDetail.ProgramLanguage;
IList <PmsSdpRefcost> sdpRefcostlList = new PmsSdpRefcostBiz().SelectPmsSdpRefcost(sdpRefcost);
if (sdpRefcostlList == null || sdpRefcostlList.Count == 0)
{
sdpDetail.Refcost = tmpSdpImportdetail.Plancost;
}
else
{
sdpDetail.Refcost = sdpRefcostlList[0].Refcost;
}
sdpDetail.Plancost = tmpSdpImportdetail.Plancost;
sdpDetail.Auditor = new BaseDataUserBiz().SelectLeaderByLoginName(LoginName);
sdpDetail.Planstartday = tmpSdpImportdetail.Planstartday;
sdpDetail.Planendday = tmpSdpImportdetail.Planendday;
sdpDetail.Resource = tmpSdpImportdetail.Resource;
sdpDetail.Role = tmpSdpImportdetail.Role;
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;
if (new SdpDetailBiz().InsertSdpDetail(sdpDetail) < 0)
{
return(false);
}
//更新临时表Falg栏位为“Y”
TmpSdpImportdetail tmpSdpImportdetailForUpdate = new TmpSdpImportdetail();
tmpSdpImportdetailForUpdate.Serial = int.Parse(serial.Trim());
if (!tmpSdpImportdetailBiz.UpdateTmpSdpDetailFlag(tmpSdpImportdetailForUpdate))
{
return(false);
}
}
return(true);
}
protected void buttonSave_Click(object sender, EventArgs e)
{
try
{
#region Check Validity
if (dropdownlistDocType != null && dropdownlistDocType.Items.Count > 0)
{
if (dropdownlistDocType.SelectedItem.Text.ToString().Trim() == "")
{
Msgbox("Please select Document Type!");
dropdownlistDocType.Focus();
return;
}
}
if (textboxUrl.Text.Trim() == "")
{
Msgbox("Please input URL!");
textboxUrl.Focus();
return;
}
if (textboxUrl.Text.Length > 500)
{
Msgbox("The length of URL is larger than 500!");
textboxUrl.Focus();
return;
}
if (!ValidateUrl(textboxUrl.Text.Trim()))
{
Msgbox("The Url is not legal!");
textboxUrl.Focus();
return;
}
#endregion
#region For Insert PmsDocuments
PmsDocuments pmsDocuments = new PmsDocuments();
pmsDocuments.PmsId = PmsID;
pmsDocuments.DocTypeId = int.Parse(dropdownlistDocType.SelectedValue);
pmsDocuments.FileName = FileName;
if (textboxUrl.Text.Trim().LastIndexOf("\\") != -1)
{
pmsDocuments.FileName = Server.UrlDecode(textboxUrl.Text.Trim().Substring(textboxUrl.Text.Trim().LastIndexOf("\\") + 1));
}
else
{
pmsDocuments.FileName = Server.UrlDecode(textboxUrl.Text.Trim().Substring(textboxUrl.Text.Trim().LastIndexOf("/") + 1));
}
int documentTypeId = int.Parse(dropdownlistDocType.SelectedValue);
PmsHead pmsHead = new PmsHeadBiz().SelectCrIdSystemVersionByPmsId(PmsID);
string errorInfo;
if (!CheckFileName(pmsDocuments.FileName, documentTypeId, pmsHead.CrId, pmsHead.System, pmsHead.NewVersion, out errorInfo))
{
Msgbox(errorInfo);
return;
}
pmsDocuments.Path = textboxUrl.Text.Trim();
DateTime dtCurDate = PmsSysBiz.GetDBDateTime();
pmsDocuments.Creator = LoginName;
pmsDocuments.CreateDate = dtCurDate;
//默认给"0"
pmsDocuments.Size = "0";
PmsDocumentsBiz pmsDocBiz = new PmsDocumentsBiz();
IList <PmsDocuments> pmsDocList = pmsDocBiz.SelectPmsDocuments(pmsDocuments);
int saveResult = 0;
if (pmsDocList != null && pmsDocList.Count > 0)
{
Msgbox("File Exists!");
return;
}
saveResult = pmsDocBiz.InsertPmsDocuments(pmsDocuments);
if (saveResult <= 0)
{
Msgbox("Save failure!");
return;
}
#endregion
Session["DocPage_Refresh"] = "Y";
Msgbox("Save Successfully!");
PageRegisterStartupScript("window.close();");
}
catch
{
Msgbox("Save failure!");
}
}
//Abel 注释掉 on 2014-01-22
//private bool DevelopTestCheck(string type, out string message)
//{
// message = "";
// try
// {
// IList<string> phaseList = m_ProjectProgressBiz.SelectSdpDetailTemplatePhase(type);
// foreach (string phase in phaseList)
// {
// int intPhase = int.Parse(phase.Trim());
// if (intPhase == (int)PmsCommonEnum.EnumSdpPhase.Design)
// {
// string designCompletedPercent = PageProjectsInformation.DesignCompletedPercent;
// if (designCompletedPercent != "100.0%")
// {
// message = "Please finish the design phase of SDP!";
// return false;
// }
// }
// if (intPhase == (int)PmsCommonEnum.EnumSdpPhase.Development)
// {
// string developmentCompletedPercent = PageProjectsInformation.DevelopmentCompletedPercent;
// if (developmentCompletedPercent != "100.0%")
// {
// message = "Please finish the development phase of SDP!";
// return false;
// }
// }
// if (intPhase == (int)PmsCommonEnum.EnumSdpPhase.Test && type != PmsCommonEnum.ProjectTypeFlowId.Service.GetDescription())
// {
// string testCompletedPercent = PageProjectsInformation.TestCompletedPercent;
// if (testCompletedPercent != "100.0%")
// {
// message = "Please finish the test phase of SDP!";
// return false;
// }
// }
// }
// return true;
// }
// catch (Exception)
// {
// return false;
// }
//}
#endregion
protected void ImageButtonStage_Click(object sender, ImageClickEventArgs e)
{
#region 获取信息pmsHead
//从数据库中获取最新数据
PmsHead pmsHead = null;
PmsHeadBiz pmsHeadBiz = new PmsHeadBiz();
IList <PmsHead> pmsHeadList = pmsHeadBiz.SelectPmsHead(PmsID, null);
if (pmsHeadList != null && pmsHeadList.Count > 0)
{
pmsHead = pmsHeadList[0];
}
else
{
Msgbox("无相关资料！");
return;
}
#endregion
#region 检查是否符合推进条件
string message;
if (!CheckPromote(pmsHead, out message))
{
Msgbox(message);
return;
}
#endregion
#region 更新数据库（推进成功）
//获取当前的type类型对应的pmsFlow
int intPending = (int)PmsCommonEnum.ProjectStage.Pending;
int intHardClosed = (int)PmsCommonEnum.ProjectStage.HardClosed;
int intCancelled = (int)PmsCommonEnum.ProjectStage.Cancelled;
int intReactive = (int)PmsCommonEnum.ProjectStage.Reactive;
IList <int> stages = ProjectTypeStageList.Select(t => t)
.Where(p => (p.Typeid == ProjectType &&
p.Stageid != intPending &&
p.Stageid != intHardClosed &&
p.Stageid != intCancelled &&
p.Stageid != intReactive))
.OrderBy(m => m.Order)
.Select(t => t.Stageid)
.ToList();
int oldStage = Stage;
int newStage = 0;
for (int i = 0; i < stages.Count; i++)
{
if (oldStage == stages[i])
{
newStage = stages[i + 1];
}
}
string strAction = Enum.Parse(typeof(PmsCommonEnum.ProjectStage), oldStage.ToString()).GetDescription();
#region SDP confirm
//Pm or Sd must confirm the SDP Change only Sd confirm
//if (IsPm(pmsHead.Pm, CurrentUser.LoginName) || IsSd(pmsHead.Sd, CurrentUser.LoginName))
if (IsSd(pmsHead.Sd, CurrentUser.LoginName))
{
switch (pmsHead.Type)
{
case "CR":
case "Study":
case "Project":
if (strAction == PmsCommonEnum.ProjectStage.PIS_STP.GetDescription())
{
if (pmsHead.SDPConfirmDate.ToString("yyyy") == "0000" || pmsHead.SDPConfirmDate.ToString("yyyy") == "0001" ||
pmsHead.SDPConfirmDate.ToString("yyyy") == "1900")
{
Msgbox("Please Click SDP Confirm First");
return;
}
}
break;
case "Small CR":
if (strAction == PmsCommonEnum.ProjectStage.Develop_Test.GetDescription())
{
if (pmsHead.SDPConfirmDate.ToString("yyyy") == "0000" || pmsHead.SDPConfirmDate.ToString("yyyy") == "0001" ||
pmsHead.SDPConfirmDate.ToString("yyyy") == "1900")
{
Msgbox("Please Click SDP Confirm First");
return;
}
}
break;
default:
break;
}
}
#endregion
bool blResult = new BasicInformationDetailBiz().UpdateStages(PmsID, LoginName, oldStage, newStage, strAction);
//从waitingclose到Close,需要更新Head页签closeday事件
if (oldStage == (int)PmsCommonEnum.ProjectStage.WaitingClosed)
{
DateTime closeDate = PmsSysBiz.GetDBDateTime();
pmsHeadBiz.UpdatePmsHeadCloseDate(PmsID, LoginName, closeDate);
//修改BasicInformationDetail页面和Service页面上的close时间;
PageProjectsInformation.CloseDate = m_PmsCommonBiz.FormatDateTime(closeDate.ToString("yyyy-MM-dd").Trim());
PageProjectsInformation.CloseDateForService = m_PmsCommonBiz.FormatDateTime(closeDate.ToString("yyyy-MM-dd").Trim());
}
if (!blResult)
{
Msgbox("更新stage数据失败！");
}
#endregion
#region 重绘控件
//如果推进到release 则点亮BasicInformationDetail.ascx
if (newStage == (int)PmsCommonEnum.ProjectStage.Release)
{
PageProjectsInformation.SetReleaseButtonEnable();
}
Stage = newStage;
InitPmsFlow(Stage, ProjectType);
#endregion
#region 发送相关的mail
LoginName.Replace(".", " ");
pmsHead.UserName = LoginName;
new MailBiz().SendPromoteMail(pmsHead, newStage);
#endregion
}
protected void ButtonSave_Click(object sender, EventArgs e)
{
SdpDetailBiz sdpDetailBiz = new SdpDetailBiz();
SdpDetail sdpDetailPage = SdpDetailResult;
DateTime dateTime = PmsSysBiz.GetDBDateTime();
//Check 日期是否跨周、大于三天、超过dudate
PmsHead objHead = new PmsHeadBiz().SelectPmsHeadByPmsId(PmsId)[0];
if (!ValidatePlanDate((TextBox)DateTextBoxPlanStartDate, (TextBox)DateTextBoxPlanEndDate, int.Parse(Phase), objHead.DueDate, objHead.Type))
{
return;
}
//如果任务类型为 Review Meeting 不检查任务名和资源等重复
if (DropDownListTaskType.SelectedItem.Text.Trim() != "Review Meeting")
{
// 当TaskName或Resource发生改变时Check TaskName和Resource不能重复
if (SdpDetailResult.TaskName != TextBoxTaskName.Text.Trim() || SdpDetailResult.Resource != DropDownListResource.Text.Trim())
{
SdpDetail sdpDetail = new SdpDetail();
sdpDetail.Pmsid = PmsId;
sdpDetail.TaskName = TextBoxTaskName.Text.Trim();
sdpDetail.Phase = Phase.ToString();
sdpDetail.Role = DropDownListRole.Text.Trim();
sdpDetail.Resource = DropDownListResource.Text.Trim();
IList <SdpDetail> sdpDetailList = sdpDetailBiz.SelectSdpDetail(sdpDetail);
if (sdpDetailList != null && sdpDetailList.Count > 0)
{
if (sdpDetailList[0].TaskName == sdpDetail.TaskName && sdpDetailList[0].Resource == sdpDetail.Resource)
{
Msgbox("The same taskname and resource has been exist!");
return;
}
}
}
}
sdpDetailPage.TaskName = TextBoxTaskName.Text.Trim();
sdpDetailPage.TaskType = int.Parse(DropDownListTaskType.Text.Trim());
sdpDetailPage.FunctionType = int.Parse(DropDownListFunctionType.Text.Trim());
sdpDetailPage.ProgramLanguage = int.Parse(DropDownListProgramLanguage.Text.Trim());
sdpDetailPage.TaskComplexity = int.Parse(DropDownListTaskComplexity.Text.Trim());
//sdpDetailPage.Actualcost = double.Parse(TextBoxRefCost.Text.Trim());
sdpDetailPage.Refcost = double.Parse(HiddenFieldRefCost.Value.Trim());
sdpDetailPage.Plancost = double.Parse(TextBoxPlanCost.Text.Trim());
sdpDetailPage.Planstartday = DateTime.Parse(DateTextBoxPlanStartDate.Text.Trim());
sdpDetailPage.Planendday = DateTime.Parse(DateTextBoxPlanEndDate.Text.Trim());
sdpDetailPage.Resource = DropDownListResource.Text.Trim();
sdpDetailPage.Auditor = new BaseDataUserBiz().SelectLeaderByLoginName(LoginName);
HiddenFieldAuditor.Value = sdpDetailPage.Auditor;
//sdpDetailPage.Role = DropDownListRole.Text.Trim();
sdpDetailPage.Role = HiddenFieldRole.Value.Trim();
sdpDetailPage.ScheduleRemark = TextBoxPlanRemark.Text.Trim();
sdpDetailPage.Maintaindate = dateTime;
sdpDetailPage.Maintainuser = LoginName;
//获得对应AuditStatus
//SdpDetail sParms = new SdpDetail();
//sParms.Serial = Serial;
//SdpDetail sResult = new SdpDetailBiz().SelectSdpDetail(sParms)[0];
if (SdpDetailResult.AuditStatus == 0)
{
sdpDetailPage.AuditStatus = 1;
sdpDetailPage.TaskStatus = 1;
sdpDetailPage.Iseditable = "Y";
sdpDetailPage.Deleteflag = "N";
sdpDetailPage.Createdate = dateTime;
sdpDetailPage.Createuser = LoginName;
}
else
{
int auditStatus = GetAuditStatus(SdpDetailResult, sdpDetailPage);
if (auditStatus == -1)
{
return;
}
else
{
sdpDetailPage.AuditStatus = auditStatus;
}
}
if (sdpDetailBiz.UpdateSdpDetail(sdpDetailPage))
{
SdpDetailPage = sdpDetailPage;
HiddenFieldAuditStatus.Value = sdpDetailPage.AuditStatus.ToString();
HiddenFieldAuditStatusDesc.Value = System.Enum.Parse(typeof(PmsCommonEnum.AuditStatus), sdpDetailPage.AuditStatus.ToString()).GetDescription();
HiddenFieldTaskStatus.Value = sdpDetailPage.TaskStatus.ToString();
HiddenFieldTaskStatusDesc.Value = System.Enum.Parse(typeof(PmsCommonEnum.TaskStatus), sdpDetailPage.TaskStatus.ToString()).GetDescription();
ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "SaveSuccess();", true);
}
else
{
Msgbox("Update this item failed!");
return;
}
// 更新head表的PlanStartDate
new PmsHeadBiz().UpdatePmsHeadPlanStartDate(PmsId);
}
public bool UpdateSdpDetailBySerial(string serials, string sdpDetailSerials)
{
string[] serialArray = serials.Split(';');
string[] sdpDetailSerialArray = sdpDetailSerials.Split(';');
for (int i = 0; i < serialArray.Length; i++)
//foreach (string serial in serialArray)
{
TmpSdpImportdetail tmpSdpImportdetail = new TmpSdpImportdetail();
tmpSdpImportdetail.Serial = int.Parse(serialArray[i].Trim());
TmpSdpImportdetailBiz tmpSdpImportdetailBiz = new TmpSdpImportdetailBiz();
var listTmpSdpImportdetail = tmpSdpImportdetailBiz.GetTmpSdpDetail(tmpSdpImportdetail);
if (listTmpSdpImportdetail == null || listTmpSdpImportdetail.Count == 0)
{
return(false);
}
else
{
tmpSdpImportdetail = listTmpSdpImportdetail[0];
}
//更新sdpDetail表
SdpDetailBiz sdpDetailBiz = new SdpDetailBiz();
SdpDetail sdpDetail = new SdpDetail();
DateTime dateTime = PmsSysBiz.GetDBDateTime();
//根据pmsid和serial 定位要跟新的任务
sdpDetail.Pmsid = tmpSdpImportdetail.Pmsid;
sdpDetail.Serial = int.Parse(sdpDetailSerialArray[i]);
//获取已存在任务在 tmp_sdp_importdetail表中不存在的栏位
SdpDetail SdpDetailResult = new SdpDetailBiz().SelectSdpDetail(sdpDetail)[0];
sdpDetail = SdpDetailResult;
sdpDetail.TaskName = tmpSdpImportdetail.TaskName;
sdpDetail.OperationType = tmpSdpImportdetail.OperationType;
sdpDetail.TaskType = tmpSdpImportdetail.TaskType;
sdpDetail.FunctionType = tmpSdpImportdetail.FunctionType;
sdpDetail.ProgramLanguage = tmpSdpImportdetail.ProgramLanguage;
sdpDetail.TaskComplexity = tmpSdpImportdetail.TaskComplexity;
//根据条件取，取值为空->refCost=planCost
PmsSdpRefcost sdpRefcost = new PmsSdpRefcost();
sdpRefcost.OperationType = sdpDetail.OperationType;
sdpRefcost.TaskComplexity = sdpDetail.TaskComplexity;
sdpRefcost.Tasktype = sdpDetail.TaskType;
sdpRefcost.Functiontype = sdpDetail.FunctionType;
sdpRefcost.Programlanguage = sdpDetail.ProgramLanguage;
IList <PmsSdpRefcost> sdpRefcostlList = new PmsSdpRefcostBiz().SelectPmsSdpRefcost(sdpRefcost);
if (sdpRefcostlList == null || sdpRefcostlList.Count == 0)
{
sdpDetail.Refcost = tmpSdpImportdetail.Plancost;
}
else
{
sdpDetail.Refcost = sdpRefcostlList[0].Refcost;
}
sdpDetail.Plancost = tmpSdpImportdetail.Plancost;
sdpDetail.Auditor = new BaseDataUserBiz().SelectLeaderByLoginName(LoginName);
sdpDetail.Planstartday = tmpSdpImportdetail.Planstartday;
sdpDetail.Planendday = tmpSdpImportdetail.Planendday;
sdpDetail.Resource = tmpSdpImportdetail.Resource;
sdpDetail.Role = tmpSdpImportdetail.Role;
sdpDetail.Maintaindate = dateTime;
sdpDetail.Maintainuser = LoginName;
if (!sdpDetailBiz.UpdateSdpDetail(sdpDetail))
{
return(false);
}
//更新临时表Falg栏位为“Y”
TmpSdpImportdetail tmpSdpImportdetailForUpdate = new TmpSdpImportdetail();
tmpSdpImportdetailForUpdate.Serial = int.Parse(serialArray[i].Trim());
if (!tmpSdpImportdetailBiz.UpdateTmpSdpDetailFlag(tmpSdpImportdetailForUpdate))
{
return(false);
}
}
return(true);
}
