private string selTaskCode(TaskData td, string officeCode, string department)
{
TaskIndData tid = new TaskIndData();
TaskIndData[] tidA = tid.SelectTaskIndDataByBaseCode(td.TaskBaseCode);
if (tidA == null)
{
return(td.TaskBaseCode);
}
for (int i = 0; i < tidA.Length; i++)
{
//if( tidA[i].OfficeCode == officeCode && tidA[i].Department == department )
if (tidA[i].OfficeCode == officeCode)
{
return(tidA[i].TaskCode);
}
}
return(tidA[0].TaskCode);
}
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;
}
private bool displayTaskData(DataGridView dgv, string officeCode, string department)
{
dgv.Rows.Clear();
TaskIndData tid = new TaskIndData();
tida = tid.SelectTaskIndData(officeCode, department);
if (tida == null)
{
return(false);
}
int addRCnt = (tida.GetLength(0) > iniRCnt) ? tida.GetLength(0) - 1 : iniRCnt;
dgv.Rows.Add(addRCnt);
MembersData md = new MembersData();
TaskData td = new TaskData();
PartnersData pd = new PartnersData();
//for( int i = 0; i < tida.GetLength( 0 ); i++ )
for (int i = 0; i < tida.Length; i++)
{
dgv.Rows[i].Cells["TaskCode"].Value = tida[i].TaskCode;
dgv.Rows[i].Cells["TaskName"].Value = tida[i].TaskName;
dgv.Rows[i].Cells["Cost"].Value = decFormat(tida[i].Contract);
dgv.Rows[i].Cells["LeaderM"].Value = md.SelectMemberName(tida[i].LeaderMCode);
td = td.SelectTaskData(tida[i].TaskID);
// Wakamatsu 20170315
//if (td == null) return false;
if (td != null)
{
dgv.Rows[i].Cells["DateFR"].Value = td.StartDate.ToString("yyyy/MM/dd");
dgv.Rows[i].Cells["DateTO"].Value = td.EndDate.ToString("yyyy/MM/dd");
dgv.Rows[i].Cells["IssueDate"].Value = td.IssueDate.ToString("yyyy/MM/dd");
dgv.Rows[i].Cells["SalesM"].Value = md.SelectMemberName(td.SalesMCode);
dgv.Rows[i].Cells["Customer"].Value = pd.SelectPartnerName(td.PartnerCode);
}
}
// Wakamatsu 20170315
this.dataGridView1.CurrentCell = null;
return(true);
}
private void FormTaskEntry_Load(object sender, EventArgs e)
{
labelPublisher.Text = ted.OfficeName + " " + ted.DepartName;
labelTaskCode.Text = "";
/***** ComboBox 「原価目標」作成 *****/
ComboBoxEdit cb = new ComboBoxEdit(comboBoxCostType);
cb.ComDataList("COST", ted.OfficeCode);
comboBoxCostType.Text = "選択してください"; // 初期値
/***** ComboBox 「事業所」作成 *****/
//cb = new ComboBoxEdit( comboBoxPartner );
//cb.TableData( "M_Partners", "PartnerCode", "PartnerName", " WHERE RelCusto = 1 ORDER BY PartnerCode" );
//comboBoxPartner.Text = "選択してください"; // 初期値
ListFormDataOp lo = new ListFormDataOp();
tcd = lo.SelectTaskCodeNameData(ted.OfficeCode, (ted.OfficeCode == Sign.HQOfficeCode ? ted.Department : "8"), null);
psd = lo.SelectPartnersCuData();
td = new TaskData();
tid = new TaskIndData();
}
// 業務番号と業務名をFormTaskCodeNameList画面から得る
private void chooseTaskCodeNameData(DataGridViewRow dgvRow)
{
if (tcd == null)
{
return;
}
TaskCodeNameData tcds = FormTaskCodeNameList.ReceiveItems(tcd);
if (tcds == null)
{
return;
}
dgvRow.Cells["TaskCode"].Value = tcds.TaskCode;
dgvRow.Cells["TaskName"].Value = tcds.TaskName;
TaskIndData tid = new TaskIndData();
tid = tid.SelectTaskIndData(tcds.TaskCode);
if (tid == null)
{
return;
}
dgvRow.Cells["LeaderMCode"].Value = "0" + tid.LeaderMCode;
}
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);
}
private bool editData(StreamReader stR, string bookName)
{
bool first = true;
string dataType;
int lno = 0;
int cntK = 0, cntK1 = 0, cntL = 0;
int cntA = 0, cntB = 0, cntC = 0, cntG = 0, cntD = 0, cntD1 = 0;
//TaskData td = new TaskData();
//TaskIndData tid = new TaskIndData();
CostData cd;
while (!stR.EndOfStream)
{
var line = stR.ReadLine();
var valArray = line.Split(',');
if (first)
{
wrep.ReportDate = Convert.ToDateTime(valArray[0]);
wrep.TaskCode = Convert.ToString(valArray[3]);
wrep.Note = Convert.ToString(valArray[6]);
wrep.Author = Convert.ToString(valArray[7]);
wrep.OfficeCode = Convert.ToString(valArray[11]);
wrep.Department = Convert.ToString(valArray[12]);
wrep.PartnerCode = Convert.ToString(valArray[2]); // 協力会社コードFXXX
wrep.PartnerName = Convert.ToString(valArray[1]); // 協力会社名
wrep.ContractForm = 1;
wrep.PNo = Convert.ToInt32(valArray[13]);
wrep.TotalP = Convert.ToInt32(valArray[14]);
wrep.CoTaskCode = "";
if (valArray.Length > 15)
{
wrep.CoTaskCode = String.IsNullOrEmpty(Convert.ToString(valArray[15])) ? "" : Convert.ToString(valArray[15]);
}
//wrep.CoTaskCode = Convert.ToString(valArray[15]) ;
TaskData td = new TaskData();
//td = td.SelectTaskData(wrep.TaskCode);
td = td.SelectTaskData((wrep.CoTaskCode == "") ? wrep.TaskCode : wrep.CoTaskCode);
wrep.SalesMCode = td.SalesMCode;
wrep.CustoCode = td.PartnerCode;
TaskIndData tid = new TaskIndData();
//string tempTaskCd = (wrep.CoTaskCode == "") ? wrep.TaskCode : wrep.CoTaskCode;
//tid = tid.SelectTaskIndData(wrep.TaskCode);
tid = tid.SelectTaskIndData((wrep.CoTaskCode == "") ? wrep.TaskCode : wrep.CoTaskCode);
//wrep.OfficeCode = tid.OfficeCode;
wrep.LeaderMCode = tid.LeaderMCode;
int volLine = Convert.ToInt32(valArray[8]);
int costLine = Convert.ToInt32(valArray[9]);
int costBLine = Convert.ToInt32(valArray[10]);
wdtl = new OsWkDetailData[volLine * 3 + costLine * 4 + costBLine * 2];
first = false;
}
else
{
wdtl[lno] = new OsWkDetailData();
dataType = Convert.ToString(valArray[0]);
if (Convert.ToString(valArray[1]) == "" || Convert.ToString(valArray[1]) == null)
{
wdtl[lno].ItemCode = "";
lno++;
continue;
}
wdtl[lno].ItemCode = Convert.ToString(valArray[1]);
wdtl[lno].Item = Convert.ToString(valArray[2]);
// Get CostData
cd = new CostData();
cd = cd.SelectCostMaster(wdtl[lno].ItemCode, wrep.OfficeCode);
wdtl[lno].Cost = (cd == null) ? 0M : cd.Cost;
if (Convert.ToString(valArray[5]) != "")
{
wdtl[lno].Quantity = Convert.ToDecimal(valArray[5]);
}
wdtl[lno].Unit = (valArray[6] == "") ? "式" : Convert.ToString(valArray[6]);
if (dataType != "K1")
{
//wdtl[lno].Unit = (valArray[6] == "") ? "": Convert.ToString(valArray[6]);
wdtl[lno].Subject = dataType;
wdtl[lno].ItemDetail = "";
wdtl[lno].Range = "";
}
switch (dataType)
{
case "K":
wdtl[lno].LNo = cntK;
cntK++;
break;
case "K1":
wdtl[lno].ItemDetail = Convert.ToString(valArray[3]);
wdtl[lno].Range = Convert.ToString(valArray[4]);
wdtl[lno].Subject = "K";
//wdtl[lno].Unit = "";
wdtl[lno].LNo = cntK1;
cntK1++;
break;
case "L":
wdtl[lno].LNo = cntL;
cntL++;
break;
case "A":
// costget
wdtl[lno].LNo = cntA;
cntA++;
break;
case "D":
wdtl[lno].LNo = cntD;
cntD++;
break;
case "C":
wdtl[lno].LNo = cntC;
cntC++;
break;
case "G":
wdtl[lno].LNo = cntG;
cntG++;
break;
case "B":
//costget
wdtl[lno].LNo = cntB;
cntB++;
break;
case "D1":
wdtl[lno].Subject = "D";
wdtl[lno].LNo = cntD1;
cntD1++;
break;
default:
break;
}
wdtl[lno].RecType = (dataType == "K" || dataType == "K1" || dataType == "L") ? 0 : 1;
lno++;
}
}
stR.Close();
return(true);
}
private bool errorCheck(StreamReader stR, string bookName)
{
errorCnt = 0;
bool first = true;
int errNo;
while (!stR.EndOfStream)
{
var line = stR.ReadLine();
var valArray = line.Split(',');
if (!first)
{
continue;
}
if (first)
{
first = false;
}
for (int i = 0; i < valArray.Length; i++)
{
errNo = -1;
if (i == 0 || i == 1 || i == 2 || i == 3 || i == 5 || i == 7)
{
if (Convert.ToString(valArray[i]) == "")
{
errNo = i;
}
else
{
if (i == 3)
{
//string tempTaskCd = string.IsNullOrEmpty( Convert.ToString( valArray[15] ) ) ? Convert.ToString( valArray[3] )
// : Convert.ToString( valArray[15] );
//TaskIndData tid = new TaskIndData();
//tid = tid.SelectTaskIndData( tempTaskCd );
TaskIndData tid = new TaskIndData();
if (valArray.Length > 15)
{
string tempTaskCd = string.IsNullOrEmpty(Convert.ToString(valArray[15])) ? Convert.ToString(valArray[3])
: Convert.ToString(valArray[15]);
tid = tid.SelectTaskIndData(tempTaskCd);
}
else
{
tid = tid.SelectTaskIndData(Convert.ToString(valArray[3]));
}
if (tid == null)
{
errNo = 4;
}
}
}
}
if (errNo > -1)
{
editErrorMsg(bookName, errNo);
errorCnt++;
totalErrorCnt++;
}
}
}
stR.Close();
if (errorCnt > 0)
{
return(false);
}
return(true);
}
