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