public bool EditTaskEntryData(TaskEntryData ted, TaskCodeNameData tcnd, int entryID)
{
ted.TaskEntryID = entryID;
ted.TaskCode = tcnd.TaskCode;
ted.TaskName = tcnd.TaskName;
ted.CostType = "";
ted.OfficeCode = tcnd.OfficeCode;
ted.Department = tcnd.Department;
TaskIndData tid = new TaskIndData();
tid = tid.SelectTaskIndData(tcnd.TaskCode);
ted.LeaderMCode = tid.LeaderMCode;
TaskData td = new TaskData();
td = td.SelectTaskData(tid.TaskID);
ted.PartnerCode = td.PartnerCode;
ted.SalesMCode = td.SalesMCode;
ted.ContractDate = td.IssueDate;
ted.StartDate = td.StartDate;
ted.EndDate = td.EndDate;
ted.TaskID = td.TaskID;
ted.TaskIndID = tid.TaskIndID;
PartnersData pd = new PartnersData();
ted.PartnerName = pd.SelectPartnerName(td.PartnerCode);
ted.TaskPlace = string.IsNullOrEmpty(td.TaskPlace) ? "" : td.TaskPlace;
return(true);
}
private TaskCodeNameData[] readTaskTextFile(string fileName)
{
int lc = 0;
using (var streamReader = new StreamReader(fileName, System.Text.Encoding.Default))
{
while (!streamReader.EndOfStream)
{
var line = streamReader.ReadLine();
lc++;
}
}
tcd = new TaskCodeNameData[lc];
using (var streamReader = new StreamReader(fileName, System.Text.Encoding.Default))
{
int i = 0;
while (!streamReader.EndOfStream)
{
tcd[i] = new TaskCodeNameData();
var line = streamReader.ReadLine();
var valArray = line.Split(',');
tcd[i].TaskCode = Convert.ToString(valArray[0]);
i++;
}
}
return(tcd);
}
/// <summary>
/// 処理対象となる業務番号、業務名、発注者名を検索しTaskCodeNameList(tcd)に格納する
/// </summary>
private void getInformationAboutTask()
{
string sqlStr = "dTI.TaskCode, dTI.TaskName, mP.PartnerName FROM D_TaskInd AS dTI LEFT JOIN D_Task AS dT ON dTI.TaskID = dT.TaskID "
+ "LEFT JOIN M_Partners AS mP ON dT.PartnerCode = mP.PartnerCode "
+ "WHERE dTI.OrdersType = 1 AND dTI.OfficeCode = '" + Conv.OfficeCode + "' AND LEFT(dTI.TaskCode,1) ";
//+ "WHERE dTI.OfficeCode = '" + officeCode + "' AND LEFT(dTI.TaskCode,1) ";
string addSql = "!= 'G' AND LEFT(dTI.TaskCode, 1) != 'Z' ORDER BY dTI.TaskCode";
string addSqlG = "= 'G'";
SqlHandling sh = new SqlHandling();
DataTable dt = sh.SelectFullDescription(sqlStr + addSql);
if (dt == null)
{
return;
}
tcd = new TaskCodeNameData[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
tcd[i] = new TaskCodeNameData(dt.Rows[i], i);
}
dt = sh.SelectFullDescription(sqlStr + addSqlG);
if (dt == null)
{
return;
}
tcdG = new TaskCodeNameData[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
tcdG[i] = new TaskCodeNameData(dt.Rows[i], i);
}
}
private TaskCodeNameData[] cleateTaskEntryNameData(string sqlString)
{
SqlHandling sh = new SqlHandling("D_TaskEntry");
DataTable dt = sh.SelectAllData(sqlString);
if (dt == null || dt.Rows.Count < 1)
{
return(null);
}
TaskCodeNameData[] tcd = new TaskCodeNameData[dt.Rows.Count];
DataRow dr;
for (int i = 0; i < dt.Rows.Count; i++)
{
tcd[i] = new TaskCodeNameData(dt.Rows[i]);
dr = dt.Rows[i];
string wkTaskCode = Convert.ToString(dr["TaskCode"]).Trim();
tcd[i].TaskCode = Convert.ToString(dr["TaskCode"]).Trim();
tcd[i].TaskName = Convert.ToString(dr["TaskName"]);
tcd[i].LeaderMCode = Convert.ToString(dr["LeaderMCode"]);
tcd[i].OfficeCode = Convert.ToString(dr["OfficeCode"]);
tcd[i].TaskID = Convert.ToInt32(dr["TaskEntryID"]);
tcd[i].TaskIndID = Convert.ToInt32(dr["TaskIndID"]);
tcd[i].Partner = Convert.ToString(dr["PartnerCode"]);
}
return(tcd);
}
private void textBox_KeyDown(object sender, KeyEventArgs e)
{
TextBox tbx = ( TextBox )sender;
if ((e.Modifiers & Keys.Control) != Keys.Control)
{
return; // Ctrlキーが押下された時のみ以下処理
}
switch (e.KeyCode)
{
case Keys.A:
if (etcd == null)
{
MessageBox.Show("Dataがありません。");
return;
}
TaskCodeNameData tcds = FormTaskCodeNameList.ReceiveItems(etcd);
if (tcds == null)
{
return;
}
textBoxTaskName.Text = tcds.TaskName;
labelTaskEntryID.Text = Convert.ToString(tcds.TaskID); // TaskEntryIDはTaskIDに格納されている
if (!displayTaskData(tcds))
{
return;
}
buttonTask.Enabled = string.IsNullOrEmpty(labelTaskCode.Text.Trim()) ? true : false;
buttonTask.Visible = string.IsNullOrEmpty(labelTaskCode.Text.Trim()) ? true : false;
break;
default:
break;
}
}
public TaskCodeNameData[] SelectTaskCodeNameFromOsWkReport(string pCode, DateTime dateFr)
{
DateTime dateTo = DHandling.EndOfMonth(dateFr);
string selParam = "DISTINCT WR.TaskCode AS TaskCode, TI.TaskName AS TaskName, TI.LeaderMCode AS LeaderMCode FROM "
+ "D_TaskInd TI INNER JOIN D_OsWkReport WR ON TI.TaskCode = WR.TaskCode "
+ "WHERE (WR.ReportDate BETWEEN '" + dateFr + "' AND '" + dateTo + "') AND WR.PartnerCode = '" + pCode + "' ORDER BY WR.TaskCode";
SqlHandling sh = new SqlHandling();
DataTable dt = sh.SelectFullDescription(selParam);
if (dt == null || dt.Rows.Count < 1)
{
return(null);
}
TaskCodeNameData[] tcd = new TaskCodeNameData[dt.Rows.Count];
DataRow dr;
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
tcd[i] = new TaskCodeNameData();
tcd[i].TaskCode = Convert.ToString(dr["TaskCode"]);
tcd[i].TaskName = Convert.ToString(dr["TaskName"]);
tcd[i].LeaderMCode = Convert.ToString(dr["LeaderMCode"]);
}
return(tcd);
}
private void chooseTaskCodeNameData(TaskCodeNameData[] tca, TextBox tBox, Label tLbl)
{
TaskCodeNameData tcnd = FormTaskCodeNameList.ReceiveItems(tca);
if (tcnd == null)
{
return;
}
tBox.Text = tcnd.TaskCode;
tLbl.Text = tcnd.TaskName;
}
private void chooseTaskCodeNameData()
{
TaskCodeNameData tcds = FormTaskCodeNameList.ReceiveItems(tcd);
if (tcds == null)
{
return;
}
textBoxTaskCode.Text = tcds.TaskCode;
textBoxTaskName.Text = tcds.TaskName;
dispTaskInformation(textBoxTaskCode.Text);
}
public TaskCodeNameData SelectTaskCodeNameData(string taskCode, string officeCode)
{
SqlHandling sh = new SqlHandling("D_TaskInd");
DataTable dt = sh.SelectAllData("WHERE OldVerMark = 0 AND TaskCode = '" + taskCode + "' AND OfficeCode = '" + officeCode + "'");
if (dt == null || dt.Rows.Count < 1)
{
return(null);
}
TaskCodeNameData tcd = new TaskCodeNameData(dt.Rows[0]);
return(tcd);
}
private TaskCodeNameData[] cleateTaskCodeNameData(string sqlString)
{
SqlHandling sh = new SqlHandling("D_TaskInd");
DataTable dt = sh.SelectAllData(sqlString);
if (dt == null || dt.Rows.Count < 1)
{
return(null);
}
TaskCodeNameData[] tcd = new TaskCodeNameData[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
tcd[i] = new TaskCodeNameData(dt.Rows[i]);
}
return(tcd);
}
public TaskCodeNameData[] SelectTaskCodeNameFromCostReport(DateTime dateFr, DateTime dateTo, string scCode, string officeCode)
{
string selParam = "DISTINCT TaskCode FROM D_CostReport WHERE ( ReportDate BETWEEN '" + dateFr + "' AND '" + dateTo + "') "
+ "AND OfficeCode = '" + officeCode + "' AND ";
selParam += scCode[0] == 'F' ? "SubCoCode = " : "ItemCode = ";
selParam += "'" + scCode + "' ORDER BY TaskCode";
SqlHandling sh = new SqlHandling();
DataTable dt = sh.SelectFullDescription(selParam);
if (dt == null || dt.Rows.Count < 1)
{
return(null);
}
string[] taskCdArray = new string[dt.Rows.Count];
DataRow dr;
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
taskCdArray[i] = Convert.ToString(dr["TaskCode"]);
}
StringUtility utl = new StringUtility();
TaskIndData tid = new TaskIndData();
TaskCodeNameData[] tcd = new TaskCodeNameData[taskCdArray.Length];
for (int i = 0; i < taskCdArray.Length; i++)
{
tcd[i] = new TaskCodeNameData();
tcd[i].TaskCode = taskCdArray[i];
tid = tid.SelectTaskIndData(utl.SubstringByte(tcd[i].TaskCode, 2, 3) == "999"
? utl.SubstringByte(tcd[i].TaskCode, 0, 1) + Convert.ToString(DHandling.FisicalYear() - 2000) + utl.SubstringByte(tcd[i].TaskCode, 1, 1) + "999"
: tcd[i].TaskCode);
tcd[i].TaskName = tid.TaskName;
tcd[i].LeaderMCode = tid.LeaderMCode;
}
return(tcd);
}
//----------------------------------------------------------------------------//
// SubRoutine //
//----------------------------------------------------------------------------//
// 業務名を業務名一覧画面から得る
//private void chooseTaskName( TaskCodeNameData[] tcd )
private void chooseTaskName( )
{
comboBoxCostType.Visible = false;
this.textBoxTaskName.Location = new Point(101, 61);
tcds = FormTaskCodeNameList.ReceiveItems(tcd);
if (tcds == null)
{
return;
}
ted.TaskEntryID = 0;
ted.EditTaskEntryData(ted, tcds, 0);
textBoxTaskName.Text = ted.TaskName;
comboBoxPartner.Text = ted.PartnerName;
textBoxTaskPlace.Text = ted.TaskPlace;
labelTaskCode.Text = ted.TaskCode;
}
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 editDgvRow(DataGridViewRow dgvRow, TaskCodeNameData tcnd, string itemIni)
{
CostReportData crdp = new CostReportData();
CostData cd = new CostData();
int[] monthArray = new int[] { 4, 5, 6, 7, 8, 9, 10, 11, 12, 1, 2, 3 };
int year = Convert.ToInt32(comboBoxFY.Text);
decimal cost = 0M;
decimal costSum = 0M;
dgvRow.Cells["TaskCode"].Value = tcnd.TaskCode;
dgvRow.Cells["PartnerName"].Value = tcnd.Partner;
dgvRow.Cells["TaskName"].Value = tcnd.TaskName;
for (int i = 0; i < monthArray.Length; i++)
{
cost = crdp.SumMonthlyCost(tcnd.TaskCode, Conv.OfficeCode, DateTime.ParseExact(Convert.ToString(year * 10000 + monthArray[i] * 100 + 1), "yyyyMMdd", null));
dgvRow.Cells["Cost" + i.ToString("00")].Value = decFormat(cost);
costSum += cost;
costArray[i] += cost;
}
dgvRow.Cells["CostSum"].Value = decFormat(costSum);
costSum = 0;
}
// 業務番号と業務名を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 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);
}
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);
}
textBoxTaskName.Text = td.TaskName;
labelTaskPlace.Text = td.TaskPlace;
labelStartDate.Text = (td.StartDate.StripTime()).ToString("yyyy年MM月dd日");
labelEndDate.Text = (td.EndDate.StripTime()).ToString("yyyy年MM月dd日");
labelSalesMCode.Text = td.SalesMCode;
DataTable dt;
DataRow dr;
SqlHandling sql;
if (td.PartnerCode != null)
{
sql = new SqlHandling("M_Partners");
if ((dt = sql.SelectAllData("WHERE PartnerCode = '" + td.PartnerCode + "'")) != null)
{
dr = dt.Rows[0];
labelPartnerName.Text = Convert.ToString(dr["PartnerName"]);
labelPartnerCode.Text = Convert.ToString(dr["PartnerCode"]);
}
}
// 20190302 asakawa
// add start
labelLeaderMName.Text = "";
labelSalesMName.Text = "";
// add end
//if (tcnd.LeaderMCode != null && tcnd.LeaderMCode != " ")
if (tcnd != null && tcnd.LeaderMCode != null && tcnd.LeaderMCode != " ")
{
sql = new SqlHandling("M_Members");
if ((dt = sql.SelectAllData("WHERE MemberCode = '" + tcnd.LeaderMCode + "'")) != null)
{
dr = dt.Rows[0];
labelLeaderMName.Text = Convert.ToString(dr["Name"]);
labelLeaderMCode.Text = tcnd.LeaderMCode;
}
}
if (td.SalesMCode != " ")
{
sql = new SqlHandling("M_Members");
if ((dt = sql.SelectAllData("WHERE MemberCode = '" + td.SalesMCode + "'")) != null)
{
dr = dt.Rows[0];
labelSalesMName.Text = Convert.ToString(dr["Name"]);
}
}
return(true);
}
/// <summary>
/// 現在保存している外注出来高データをDBから読取り表示する
/// </summary>
/// <param name="reportDate"></param>
/// <param name="costCode"></param>
/// <param name="officeCode"></param>
/// <param name="department"></param>
private void selectPaymentData(DataGridView dgv, DateTime reportDate, string officeCode, string department)
{
readyPro = true;
dgv.Enabled = true;
dgv.Rows.Clear();
dgv.Rows.Add(iniRCnt);
opd = new OsPaymentData();
DataTable dt = opd.SelectPayment(reportDate.EndOfMonth(), officeCode, department);
if (dt == null || dt.Rows.Count < 1)
{
labelMsg.Text = "表示できるデータはありません。";
seqNoReNumbering(dgv);
this.dataGridView1.CurrentCell = null;
readyPro = false;
return;
}
labelMsg.Text = "";
if (dt.Rows.Count > iniRCnt)
{
dgv.Rows.Add(dt.Rows.Count - iniRCnt + 5);
}
TaskData tdp = new TaskData();
ListFormDataOp lo = new ListFormDataOp();
DataRow dr;
string taskCode;
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
if (i == 0)
{
string[] ckItems = new string[] { "AdminCheck", "DirectorCheck", "PresidentCheck" };
string[] dtItems = new string[] { "ACheckDate", "DCheckDate", "PCheckDate" };
for (int j = 0; j < ckItems.Length; j++)
{
int checkStat = Convert.ToInt32(dr[ckItems[j]]);
ckArray[j].Checked = (checkStat == 1) ? true : false;
dtArray[j] = (checkStat == 1) ? Convert.ToDateTime(dr[dtItems[j]]) : DateTime.MinValue;
lbArray[j].Text = (checkStat == 1) ? dtArray[j].ToLongDateString() : "";
}
if (ckArray[2].Checked)
{
buttonDisEnabled();
}
else if (ckArray[1].Checked)
{
buttonDisEnabled();
buttonCost.Enabled = true;
}
else if (ckArray[0].Checked)
{
buttonEnabled();
buttonCost.Enabled = false;
}
}
dgv.Rows[i].Cells["ItemCode"].Value = Convert.ToString(dr["ItemCode"]);
dgv.Rows[i].Cells["Item"].Value = Convert.ToString(dr["Item"]);
dgv.Rows[i].Cells["OrderNo"].Value = Convert.ToString(dr["OrderNo"]);
taskCode = Convert.ToString(dr["TaskCode"]);
dgv.Rows[i].Cells["TaskCode"].Value = taskCode;
if (Convert.ToString(dr["OrderAmount"]) == "" || Convert.ToString(dr["OrderAmount"]) == "0.00")
{
dgv.Rows[i].Cells["OAmount"].Value =
opd.SelectOAmountPayment(Convert.ToString(dr["ItemCode"]), taskCode, Conv.OfficeCode, Conv.DepartCode, dateTimePickerEx1.Value);
}
else
{
dgv.Rows[i].Cells["OAmount"].Value = Convert.ToDecimal(dr["OrderAmount"]);
}
dgv.Rows[i].Cells["SAmount"].Value =
opd.SelectSumAmountPayment(Convert.ToString(dr["ItemCode"]), taskCode, Conv.OfficeCode, Conv.DepartCode, dateTimePickerEx1.Value);
dgv.Rows[i].Cells["Amount"].Value = Convert.ToDecimal(dr["Amount"]);
calculateInvolvedItems(dgv.Rows[i]);
dgv.Rows[i].Cells["LeaderMCode"].Value = Convert.ToString(dr["LeaderMCode"]);
dgv.Rows[i].Cells["SlipNo"].Value = Convert.ToInt32(dr["SlipNo"]) == 0 ? "" : Convert.ToString(dr["SlipNo"]);
dgv.Rows[i].Cells["CostReportID"].Value = Convert.ToInt32(dr["CostReportID"]) == 0 ? "" : Convert.ToString(dr["CostReportID"]);
dgv.Rows[i].Cells["PaymentID"].Value = Convert.ToString(dr["OsPaymentID"]);
dgv.Rows[i].Cells["Check"].Value = false;
TaskCodeNameData tcnd = lo.SelectTaskCodeNameData(taskCode, Conv.OfficeCode);
if (tcnd != null)
{
dgv.Rows[i].Cells["TaskName"].Value = tcnd.TaskName;
tdp = tdp.SelectTaskData(taskCode);
dgv.Rows[i].Cells["SalesMCode"].Value = "0" + tdp.SalesMCode;
dgv.Rows[i].Cells["PartnerCode"].Value = tdp.PartnerCode;
}
}
seqNoReNumbering(dgv);
this.dataGridView1.CurrentCell = null;
readyPro = false;
}
private void returnValue(DataGridView dgv)
{
tcds = (TaskCodeNameData)tcd[dgv.CurrentCellAddress.Y].Clone();
this.Close();
}
