private bool viewOutsourceContToDgv(DataTable dt, DataGridView dgv, string partnerCode)
{
PartnersData pd = new PartnersData();
labelPartner.Text = pd.SelectPartnerName(partnerCode);
DataRow dr;
decimal sum = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
sum += Convert.ToDecimal(dr["Quantity"]); // 各月の数量の和 = 前月累計
dgv.Rows[i].Cells["ItemCode"].Value = Convert.ToString(dr["ItemCode"]);
dgv.Rows[i].Cells["Item"].Value = Convert.ToString(dr["Item"]);
if (Convert.ToString(dr["Item"]) == null || Convert.ToString(dr["Item"]) == "")
{
dgv.Rows[i].Cells["Item"].Value = Convert.ToString(dr["ItemDetail"]);
}
dgv.Rows[i].Cells["PQuantity"].Value = DHandling.DecimaltoStr(Convert.ToDecimal(dr["Quantity"]), "0.00");
dgv.Rows[i].Cells["Unit"].Value = Convert.ToString(dr["Unit"]);
dgv.Rows[i].Cells["Cost"].Value = DHandling.DecimaltoStr(Convert.ToDecimal(dr["Cost"]), "#,0");
dgv.Rows[i].Cells["PAmount"].Value = DHandling.DecimaltoStr(Convert.ToDecimal(dr["Quantity"]) * Convert.ToDecimal(dr["Cost"]), "#,0");
dgv.Rows[i].Cells["ContID"].Value = 0;
}
return(true);
}
private void editPartnersDataPart(PartnersData pd)
{
oWSheet.Cell(5, 3).Value = pd.PartnerName; // 発注者名
oWSheet.Cell(6, 3).Value = pd.Address; // 発注者住所
oWSheet.Cell(6, 12).Value = pd.TelNo; // 電話番号
oWSheet.Cell(7, 12).Value = pd.FaxNo; // FAX番号
}
private void edit_ResultsLabels(int idx)
{
if (ord == null)
{
return;
}
PartnersData pd = new PartnersData();
labelPartner.Text = pd.SelectPartnerName(ord[idx].PartnerCode);
labelOrderNo.Text = ord[idx].OrderNo;
labelPartnerCode.Text = ord[idx].PartnerCode;
}
private void edit_Labels()
{
labelTaskCode.Text = ted.TaskCode;
labelTask.Text = ted.TaskName;
PartnersData pd = new PartnersData();
labelPartner.Text = pd.SelectPartnerName(ted.PartnerCode);
MembersData md = new MembersData();
labelSalesM.Text = md.SelectMemberName(ted.SalesMCode);
labelLeader.Text = md.SelectMemberName(ted.LeaderMCode);
recordedDate = DHandling.EndOfMonth(dateTimePickerRecDate.Value);
labelOrderNo.Text = "";
labelSubCo.Text = "";
textBoxSubCo.Text = "";
}
private void edit_Labels()
{
labelTaskCode.Text = (ted.TaskCode == "") ? "" : ted.TaskCode;
labelTask.Text = ted.TaskName;
if (ted.PartnerName == "")
{
PartnersData pd = new PartnersData();
labelOPartner.Text = pd.SelectPartnerName(ted.PartnerCode);
}
else
{
labelOPartner.Text = ted.PartnerName;
}
MembersData md = new MembersData();
labelSalesM.Text = md.SelectMemberName(ted.SalesMCode);
labelLeader.Text = md.SelectMemberName(ted.LeaderMCode);
labelPartner.Text = "";
labelOrderNo.Text = "";
}
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 bool dispTaskInformation(string taskCode)
{
ListFormDataOp lo = new ListFormDataOp();
TaskCodeNameData tcnd = lo.SelectTaskCodeNameData(taskCode, Convert.ToString(comboBoxOffice.SelectedValue));
TaskData td = lo.SelectTaskData(taskCode);
if (td == null)
{
return(false);
}
labelTaskName.Text = td.TaskName;
labelTerm.Text = "工期：";
labelTerm.Text += (td.StartDate.StripTime()).ToString("yyyy年MM月dd日") + " ～ ";
labelTerm.Text += (td.EndDate.StripTime()).ToString("yyyy年MM月dd日");
if (td.PartnerCode != null)
{
PartnersData pd = new PartnersData();
labelPartnerName.Text = pd.SelectPartnerName(td.PartnerCode);
}
return(true);
}
private void dispTaskCodeNameList(string officeCode, string department)
{
//string wParam = "";
//if (officeCode == "H")
//{
// switch (department)
// {
// case "1": // 設計
// wParam = " AND (LEFT(TaskCode, 1) = 'B' OR LEFT(TaskCode, 1) = 'C' OR LEFT(TaskCode, 1) = 'F')";
// break;
// case "2": // 測量
// wParam = " AND (LEFT(TaskCode, 1) = 'A' OR LEFT(TaskCode, 1) = 'E' OR LEFT(TaskCode, 1) = 'F')";
// break;
// default:
// wParam = " AND (LEFT(TaskCode, 1) = 'D' OR LEFT(TaskCode, 1) = 'F' OR LEFT(TaskCode, 1) = 'G' OR LEFT(TaskCode, 1) = 'Z')";
// break;
// }
//}
ListFormDataOp lo = new ListFormDataOp();
////tcd = lo.SelectTaskCodeNameData(officeCode);
//tcd = lo.SelectTaskCodeNameData(officeCode, wParam, 1);
tcd = lo.SelectTaskCodeNameData(officeCode, department, null);
if (tcd == null)
{
return;
}
dataGridView1.Rows.Clear();
//dataGridView1.Rows.Add(tcd.GetLength(0) - 1);
//if (tcd.GetLength(0) <= 1)
if (tcd.Length <= 1)
{
dataGridView1.Rows.Add(1);
}
else
{
//dataGridView1.Rows.Add(tcd.GetLength(0) - 1);
dataGridView1.Rows.Add(tcd.Length - 1);
}
TaskData td = new TaskData();
PartnersData pd = new PartnersData();
//for ( int i = 0; i < tcd.GetLength( 0 ); i++ )
for (int i = 0; i < tcd.Length; i++)
{
dataGridView1.Rows[i].Cells["TaskNo"].Value = tcd[i].TaskCode;
dataGridView1.Rows[i].Cells["Task"].Value = tcd[i].TaskName;
td = td.SelectTaskData(tcd[i].TaskID); //taskIDからtaskを読みPartnerとStartDate,EndDateを得る
if (td.TaskName == null)
{
return;
}
dataGridView1.Rows[i].Cells["Partner"].Value = pd.SelectPartnerName(td.PartnerCode);
dataGridView1.Rows[i].Cells["StartDate"].Value = (td.StartDate.StripTime()).ToString("yyyy年MM月dd日");
dataGridView1.Rows[i].Cells["EndDate"].Value = (td.EndDate.StripTime()).ToString("yyyy年MM月dd日");
}
seqNoReNumbering(dataGridView1, "TSeq");
checkExistingTaskData();
}
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);
}
//----------------------------------------------------------------------
// SubRoutine
//----------------------------------------------------------------------
private void editExcelSheet(string sheetName, TaskData td, TaskNoteData tnd, TaskIndData[] tid, PartnersData pd, TaskOp tod)
{
string tempFile = Folder.DefaultLocation() + @"\.~temp.xlsx";
Cursor.Current = Cursors.WaitCursor; // マウスカーソルを砂時計(Wait)
using (oWBook = new XLWorkbook(FileName))
{
// シートを開く
//oWSheet = oWBook.Worksheet(sheetName);
oWSheet = oWBook.Worksheet(1);
// 編集
//MessageBox.Show("Excel書込み開始");
editTaskDataPart(td);
editTaskNoteDataPart(tnd);
editTaskIndDataPart(tid);
editPartnersDataPart(pd);
editPersonsDataPart(tod);
// 保存
oWBook.SaveAs(tempFile); // Excel保存
}
Cursor.Current = Cursors.Default; // マウスカーソルを戻す
System.Diagnostics.Process.Start("Excel.exe", tempFile); // 表示用Excel
//if (File.Exists(tempFile)) File.Delete(tempFile);
}
//---------------------------------------------------------/
// Method
//---------------------------------------------------------/
public void ExcelFile(TaskData td, TaskNoteData tnd, TaskIndData[] tid, PartnersData pd, TaskOp tod)
{
editExcelSheet("TaskTransfer", td, tnd, tid, pd, tod);
}
