private decimal getCostData(string officeCode, string itemCode)
{
CostData cd = new CostData();
cd = cd.SelectCostMaster(itemCode, officeCode);
if (cd == null)
{
return(0);
}
return(cd.Cost);
}
private bool selectCostMaster(string costCode)
{
CostData cdp = new CostData();
cdp = cdp.SelectCostMaster(costCode, Convert.ToString(comboBoxOffice.SelectedValue));
if (cdp == null)
{
return(false);
}
dispSubcontractor(cdp);
return(true);
}
private void readyDataArray()
{
int daysInMonth = DateTime.DaysInMonth(procDate.Year, procDate.Month);
dayArray = new DateTime[daysInMonth];
dowArray = new int[daysInMonth];
hdayArray = new int[daysInMonth];
workHArray = new decimal[dataGridView1.RowCount, daysInMonth];
overHArray = new decimal[dataGridView1.RowCount, daysInMonth];
checkArray = new int[dataGridView1.RowCount, daysInMonth];
CalendarData cap = new CalendarData();
procDate.BeginOfMonth();
for (int i = 0; i < daysInMonth; i++)
{
dayArray[i] = procDate.AddDays(i);
dowArray[i] = ( int )dayArray[i].DayOfWeek;
hdayArray[i] = cap.ExitstenceHoliday(dayArray[i]) ? 1 : 0;
}
WorkReportData wrp = new WorkReportData();
CostData cdp = new CostData();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
string wkMCode = Convert.ToString(dataGridView1.Rows[i].Cells["MemberCode"].Value);
cdp = new CostData();
cdp = cdp.SelectCostMaster(Convert.ToString(dataGridView1.Rows[i].Cells["MemberCode"].Value), Convert.ToString(comboBoxOffice.SelectedValue), "A");
decimal[] workHour;
for (int j = 0; j < dayArray.Length; j++)
{
workHour = wrp.SelectSummaryWorkReport(Convert.ToString(dataGridView1.Rows[i].Cells["MemberCode"].Value), dayArray[j]);
workHArray[i, j] = workHour[0];
overHArray[i, j] = workHour[1];
checkArray[i, j] = ( int )workHour[2];
if (cdp != null && cdp.Unit == "時間")
{
if (workHour[0] > 0)
{
workHArray[i, j] = workHour[0] / 8;
}
}
}
}
curNo = 0;
displayWorkingData(dataGridView1, curNo);
}
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);
}