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