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