public FormPlanningCont(TaskEntryData ted, PlanningData[] plnd, int idx) { InitializeComponent(); this.ted = ted; this.plnd = plnd; this.idx = idx; }
//----------------------------------------------------------------------------// // Property // //----------------------------------------------------------------------------// //----------------------------------------------------------------------------// // Method // //----------------------------------------------------------------------------// static public PlanningData[] SummaryData(TaskEntryData ted, PlanningData[] plnd, int idx) { FormPlanningCont formPlanningCont = new FormPlanningCont(ted, plnd, idx); formPlanningCont.ShowDialog(); formPlanningCont.Dispose(); return(plnd); }
//----------------------------------------------------------------------------// // Property // //----------------------------------------------------------------------------// //----------------------------------------------------------------------------// // Method // //----------------------------------------------------------------------------// public static TaskEntryData DispData(TaskEntryData ted) { FormTaskEntry formTaskEntry = new FormTaskEntry(ted); formTaskEntry.ShowDialog(); formTaskEntry.Dispose(); return(ted); }
private void displayDetailLabel(TaskEntryData ted) { SqlHandling sh = new SqlHandling("M_Members"); string[] mCodeArray = new string[2]; string[] mNameArray = new string[2]; mCodeArray[0] = ted.LeaderMCode; mCodeArray[1] = ted.SalesMCode; MembersData md = new MembersData(); for (int i = 0; i < mCodeArray.Length; i++) { if (!String.IsNullOrEmpty(mCodeArray[i])) { mNameArray[i] = md.SelectMemberName(mCodeArray[i]); } } clearDetailLabel(); // 業務担当者 if (!String.IsNullOrEmpty(mNameArray[0])) { labelTtlLeader.Visible = true; labelLeaderName.Text = mNameArray[0]; } // 営業担当者 if (!String.IsNullOrEmpty(mNameArray[1])) { labelTtlSales.Visible = true; labelSalesMName.Text = mNameArray[1]; } // 契約日 if (DHandling.CheckDateMiniValue(ted.ContractDate)) { labelContractDate.Text = "契約日: " + DHandling.PickUpTopCharacters(Convert.ToString(ted.ContractDate), 10); } // 工期 開始日 if (DHandling.CheckDateMiniValue(ted.StartDate)) { labelStartDate.Text = "工期: " + DHandling.PickUpTopCharacters(Convert.ToString(ted.StartDate), 10); } // 工期 終了日 if (DHandling.CheckDateMiniValue(ted.EndDate)) { labelStartDate.Text += " ~ " + DHandling.PickUpTopCharacters(Convert.ToString(ted.EndDate), 10); } }
private bool dataCollection(string officeCode, string department) { string para = " WHERE OfficeCode = '" + officeCode + "' AND Department = '" + department + "'"; TaskEntryData ted = new TaskEntryData(); tedA = ted.SelectTaskEntryData(para); if (tedA == null) { return(false); } PlanningData[] wkPdA = new PlanningData[tedA.Length]; PlanningData pd = new PlanningData(); int j = 0; for (int i = 0; i < tedA.Length; i++) { pd = pd.LatestPlanningData(tedA[i].TaskEntryID); if (pd == null) { continue; } if (pd.ApPresidentStat == 0) { wkPdA[j] = new PlanningData(); wkPdA[j] = ( PlanningData )pd.Clone(); wkPdA[j].TaskCode = tedA[i].TaskCode; wkPdA[j].TaskName = tedA[i].TaskName; j++; } } if (j == 0) { return(false); } pdA = new PlanningData[j]; for (int i = 0; i < pdA.Length; i++) { pdA[i] = new PlanningData(); pdA[i] = ( PlanningData )wkPdA[i].Clone(); pdA[i].TaskCode = wkPdA[i].TaskCode; pdA[i].TaskName = wkPdA[i].TaskName; } return(true); }
private void displayLabalContents(int entryID) { clearLabel(); if (entryID < 1) { return; } ted = new TaskEntryData(); ted = ted.SelectTaskEntryData(entryID); if (ted == null) { return; } labelPartner.Text = ted.PartnerName; labelTaskPlace.Text = ted.TaskPlace; labelTaskCode.Text = ted.TaskCode; }
private void comboBox_TextChanged(object sender, EventArgs e) { if (iniPro) { return; } ComboBox cb = ( ComboBox )sender; ted = new TaskEntryData(); Conv.OfficeAndDepartZ(comboBoxOffice, comboBoxDepartment); ListFormDataOp lo = new ListFormDataOp(); switch (cb.Name) { case "comboBoxOffice": ted.OfficeName = cb.Text; create_cbDepart(); etcd = lo.SelectTaskEntryNameData(Conv.OfficeCode, Conv.DepartCode, null); tcd = lo.SelectTaskCodeNameData(Conv.OfficeCode, Conv.DepartCode, "DESC"); this.textBoxTaskName.Text = ""; clearLabel(); break; case "comboBoxDepartment": ted.DepartName = cb.Text; etcd = lo.SelectTaskEntryNameData(Conv.OfficeCode, Conv.DepartCode, null); tcd = lo.SelectTaskCodeNameData(Conv.OfficeCode, Conv.DepartCode, "DESC"); this.textBoxTaskName.Text = ""; clearLabel(); break; case "comboBoxCostType": ted.CostType = cb.Text; clearLabel(); break; default: break; } }
private void setTaskCodeToTaskEntryData(TaskIndData tid, TaskData td) { ted = new TaskEntryData(); ted.TaskEntryID = string.IsNullOrEmpty(labelTaskEntryID.Text) ? 0 : Convert.ToInt32(labelTaskEntryID.Text); ted.TaskCode = tid.TaskCode; ted.TaskName = tid.TaskName; ted.TaskPlace = td.TaskPlace ?? ""; ted.CostType = ""; ted.PartnerCode = td.PartnerCode; ted.OfficeCode = tid.OfficeCode; ted.Department = tid.Department; ted.LeaderMCode = tid.LeaderMCode; ted.SalesMCode = td.SalesMCode; ted.ContractDate = td.IssueDate; ted.StartDate = td.StartDate; ted.EndDate = td.EndDate; ted.TaskID = td.TaskID; ted.TaskIndID = tid.TaskIndID; }
public void CreateExcelFile(TaskEntryData ted, DataGridView dgv, string templateFileName, string sheetName) { Publish publ = new Publish(Folder.DefaultExcelTemplate(templateFileName)); PublishData pd = new PublishData(); pd.TaskCode = ted.TaskCode; pd.TaskName = ted.TaskName; pd.CostType = ted.CostType; pd.TaskPlace = ted.TaskPlace; pd.StartDate = ted.StartDate; pd.EndDate = ted.EndDate; pd.TaxRate = ted.TaxRate; pd.PartnerName = ted.PartnerName; pd.RecordedDate = dateTimePickerRecordedDate.Value.StripTime(); pd.OfficeCode = ted.OfficeCode; pd.OfficeName = ted.OfficeName; pd.PublishOffice = (checkBoxPublish.Checked) ? 1 : 0; publ.ExcelFile(sheetName, pd, dgv); return; }
private bool writeTaskCodeToTaskEntryData() { if (tcds == null) { return(false); } TaskEntryData tentd = new TaskEntryData(); if (tentd.ExistenceTaskEntryData("TaskCode", "@tCod", tcds.TaskCode, "Char")) { return(false); // 既存 } ted = new TaskEntryData(); tcds.OfficeCode = Convert.ToString(comboBoxOffice.SelectedValue); tcds.Department = Convert.ToString(comboBoxDepartment.SelectedValue); ted.EditTaskEntryData(ted, tcds, Convert.ToInt32(labelTaskEntryID.Text)); if (!ted.UpdateTaskEntryData(ted)) { return(false); } return(true); }
public FormContract(TaskEntryData ted) { InitializeComponent(); this.ted = ted; }
private void button_Click(object sender, EventArgs e) { Button btn = ( Button )sender; if (btn.Name == "buttonClose") { this.Close(); return; } if (btn.Name == "buttonStoreMWorkItems") { if (formImpMWorkItems == null || formImpMWorkItems.IsDisposed) { formImpMWorkItems = new FormImpMWorkItems(hp); formImpMWorkItems.Show(); } else { MessageBox.Show(msgAlready); } return; } TaskEntryData itd = new TaskEntryData(); if (btn.Name == "buttonAdd") { //itd.OfficeCode = Convert.ToString( comboBoxOffice.SelectedValue ); //itd.Department = Convert.ToString( comboBoxDepartment.SelectedValue ); //itd.OfficeName = comboBoxOffice.Text; //itd.DepartName = comboBoxDepartment.Text; //labelTaskEntryID.Text = ""; } else { if (labelTaskEntryID.Text == "" || labelTaskEntryID.Text == "0") { DMessage.DataNotEnough(); return; } itd = itd.SelectTaskEntryData(Convert.ToInt32(labelTaskEntryID.Text)); itd.MemberCode = hp.MemberCode; itd.TaxRate = hp.TaxRate; itd.AdminCostRate = hp.AdminCostRate; itd.OthersCostRate = hp.OthersCostRate; itd.Expenses = hp.Expenses; itd.OfficeCode = Conv.OfficeCode; itd.Department = Conv.DepartCode; itd.PartnerName = labelPartner.Text; } switch (btn.Name) { case "buttonEstimate": formEstimate = new FormEstimate(itd); formEstimate.Show(); break; case "buttonPlanning": formPlanning = new FormPlanning(itd); formPlanning.Show(); break; case "buttonOsDetail": formOutsource = new FormOutsource(itd); formOutsource.Show(); break; case "buttonContract": formContract = new FormContract(itd); formContract.Show(); break; case "buttonRegular": formRegular = new FormRegular(itd); formRegular.Show(); break; case "buttonVolumeInvoice": formVolumeInvoice = new FormVolumeInvoice(itd); formVolumeInvoice.Show(); break; case "buttonInvoice": formInvoice = new FormInvoice(itd); formInvoice.Show(); break; //case "buttonDetail": // displayDetailLabel(ted); // break; case "buttonAdd": itd.OfficeCode = Conv.OfficeCode; itd.Department = Conv.DepartCode; itd.OfficeName = Conv.Office; itd.DepartName = Conv.Depart; labelTaskEntryID.Text = ""; itd = FormTaskEntry.DispData(itd); displayDetailLabel(itd); comboBoxCostType.Text = itd.CostType; textBoxTaskName.Text = itd.TaskName; labelPartner.Text = itd.PartnerName; labelTaskPlace.Text = itd.TaskPlace; labelTaskCode.Text = itd.TaskCode; labelTaskEntryID.Text = Convert.ToString(itd.TaskEntryID); // ? 仮版 : 正式版 labelTaskName.Text = (labelTaskCode.Text.Trim() == "") ? "": itd.TaskName; ListFormDataOp lo = new ListFormDataOp(); etcd = lo.SelectTaskEntryNameData(itd.OfficeCode, itd.Department, null); buttonTask.Enabled = string.IsNullOrEmpty(labelTaskCode.Text.Trim()) ? true : false; buttonTask.Visible = string.IsNullOrEmpty(labelTaskCode.Text.Trim()) ? true : false; break; case "buttonTask": if (String.IsNullOrEmpty(textBoxTaskName.Text)) { MessageBox.Show("対応する見積・計画用業務名がありません"); return; } tcds = FormTaskCodeNameList.ReceiveItems(tcd); if (!writeTaskCodeToTaskEntryData()) { return; } if (!displayTaskData(tcds)) { return; } break; default: break; } }
private bool displayTaskData(TaskCodeNameData tcds) { if (tcds == null) { return(false); } textBoxTaskName.Text = tcds.TaskName; if (String.IsNullOrEmpty(tcds.TaskCode.Trim())) { // 仮業務番号で運用中 TaskEntryData tid = new TaskEntryData(); tid = tid.SelectTaskEntryData(tcds.TaskID); MembersData md = new MembersData(); labelLeaderName.Text = "業務責任者: " + md.SelectMemberName(tid.LeaderMCode); labelTaskPlace.Text = tid.TaskPlace; labelSalesMName.Text = "営業責任者: " + md.SelectMemberName(tid.SalesMCode); if (DHandling.CheckDateMiniValue(tid.StartDate)) { labelStartDate.Text = "工期: " + tid.StartDate.ToString("d"); } if (DHandling.CheckDateMiniValue(tid.EndDate)) { labelStartDate.Text += " ~ " + tid.EndDate.ToString("d"); } PartnersData pd = new PartnersData(); labelPartner.Text = pd.SelectPartnerName(tid.PartnerCode); labelPartnerCode.Text = tid.PartnerCode; } else { // 正式な業務番号が設定されている labelTaskCode.Text = tcds.TaskCode; labelTtlTName.Visible = true; labelTaskName.Text = tcds.TaskName; TaskIndData tid = new TaskIndData(); tid = tid.SelectTaskIndData(tcds.TaskCode); if (tid == null) { return(false); } MembersData md = new MembersData(); // 業務担当者名 labelTtlLeader.Visible = true; labelLeaderName.Text = md.SelectMemberName(tid.LeaderMCode); TaskData td = new TaskData(); td = td.SelectTaskData(tid.TaskID); if (td == null) { return(false); } labelTaskPlace.Text = td.TaskPlace; // 営業担当者名 labelTtlSales.Visible = true; labelSalesMName.Text = md.SelectMemberName(td.SalesMCode); labelContractDate.Text = "契約日: " + td.IssueDate.ToString("yyyy/MM/dd"); if (DHandling.CheckDateMiniValue(td.StartDate)) { labelStartDate.Text = "工期: " + td.StartDate.ToString("d"); } if (DHandling.CheckDateMiniValue(td.EndDate)) { labelStartDate.Text += " ~ " + td.EndDate.ToString("d"); } PartnersData pd = new PartnersData(); labelPartner.Text = pd.SelectPartnerName(td.PartnerCode); labelPartnerCode.Text = td.PartnerCode; setTaskCodeToTaskEntryData(tid, td); } return(true); }
public FormInvoice(TaskEntryData ted) { InitializeComponent(); this.ted = ted; }
public FormRegular(TaskEntryData ted) { InitializeComponent(); this.ted = ted; }
//----------------------------------------------------------------------------// // Constructor // //----------------------------------------------------------------------------// public FormOutsource(TaskEntryData ted) { InitializeComponent(); this.ted = ted; }