private void getUser() { BTC btc = new BTC(); DataView dv = btc.getMasterSchool(); if (dv.Count != 0) { lblConUser.Text = btc.getEmpName(dv[0]["ConUser"].ToString()) + " : ผู้รับผิดชอบ"; } }
private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } string strSql = @"Select P.*, IsNull(P.SetBudget, 0) Set_Budget, D.MainSubDeptCode From Projects P Inner Join Department D On P.DeptCode = D.DeptCode Where ProjectsCode = '{0}' "; DataView dv = Conn.Select(string.Format(strSql, id)); DataView dv1 = Conn.Select(string.Format("Select StandardNationCode From dtStandardNation Where ProjectsCode = '" + id + "' ")); DataView dv2 = Conn.Select(string.Format("Select StandardMinistryCode From dtStandardMinistry Where ProjectsCode = '" + id + "' ")); DataView dv333 = Conn.Select(string.Format("Select StrategicObjectivesCode From dtStrategicObjectives Where ProjectsCode = '" + id + "' ")); DataView dv9 = Conn.Select(string.Format("Select StrategicCode From dtStrategic Where ProjectsCode = '" + id + "' ")); DataView dv18 = Conn.Select(string.Format("Select StrategicPlanID From dtStrategicPlan Where ProjectsCode = '" + id + "' ")); DataView dv19 = Conn.Select(string.Format("Select CorporateStrategyID From dtCorporateStrategy Where ProjectsCode = '" + id + "' ")); if (dv.Count != 0) { ddlYearS.SelectedValue = dv[0]["StudyYear"].ToString(); lblYearS.Text = ddlYearS.SelectedItem.Text; SetItem(); if (btc.CkUseData(id, "ProjectsCode", "Activity", " And DelFlag = 0 ")) { ddlYearS.Enabled = false; } ddlStrategicPlan.SelectedValue = dv[0]["StrategicPlanID"].ToString(); txtStrategicPlan.Text = dv[0]["StrategicPlan"].ToString(); txtProjects.Text = dv[0]["ProjectsName"].ToString(); hdfMainSubDeptCode.Value = dv[0]["MainSubDeptCode"].ToString(); txtIdentityName.Text = dv[0]["IdentityName"].ToString(); txtIdentityName2.Text = dv[0]["IdentityName2"].ToString(); txtPurpose.Text = dv[0]["Purpose"].ToString(); txtPurpose2.Text = dv[0]["Purpose2"].ToString(); txtTarget.Text = dv[0]["Target"].ToString(); txtTarget2.Text = dv[0]["Target2"].ToString(); txtPeriod1.Text = dv[0]["Period1"].ToString(); hdfCreateUser.Value = dv[0]["CreateUser"].ToString(); txtProjectsDetail.Text = dv[0]["ProjectsDetail"].ToString(); txtResponsibleName.Text = dv[0]["ResponsibleName"].ToString(); txtResponsiblePosition.Text = dv[0]["ResponsiblePosition"].ToString(); txtSort.Text = dv[0]["Sort"].ToString(); txtProjectRegistration.Text = dv[0]["ProjectRegistration"].ToString(); txtIOCode.Text = dv[0]["IOCode"].ToString(); rbtlProjectType.SelectedValue = dv[0]["ProjectTypeID"].ToString(); rbtlProjectType.Enabled = false; getrbtlSubProjectType(); rbtlSubProjectType.SelectedValue = dv[0]["SubProjectTypeID"].ToString(); rbtlSubProjectType.Enabled = false; txtPlace.Text = dv[0]["Place1"].ToString(); txtEvaTool.Text = dv[0]["EvaTool"].ToString(); btc.getddlDepartment(1, ddlDept, "", CurrentUser.DeptID, null); ddlDept.SelectedValue = dv[0]["DeptCode"].ToString(); lblDept.Text = ddlDept.SelectedItem.Text; btc.getddlDepartmentJoin(1, ddlDeptJoin, "", ddlDept.SelectedValue); ddlDeptJoin.SelectedValue = dv[0]["DeptJoinCode"].ToString(); if (!string.IsNullOrEmpty(dv[0]["DeptJoinCode"].ToString())) { lblDeptJoin.Text = ddlDeptJoin.SelectedItem.Text; } else { lblDeptJoin.Text = "-"; } ddlDeptJoin.Visible = false; ddlDept.Visible = false; txtConclusion.Text = dv[0]["Conclusion"].ToString(); txtPerformance.Text = dv[0]["Performance"].ToString(); txtProblem.Text = dv[0]["Problem"].ToString(); txtSolutions.Text = dv[0]["Solutions"].ToString(); if (!string.IsNullOrEmpty(dv[0]["SDate"].ToString())) { txtSDay.Text = Convert.ToDateTime(dv[0]["SDate"]).ToShortDateString(); } if (!string.IsNullOrEmpty(dv[0]["EDate"].ToString())) { txtEDay.Text = Convert.ToDateTime(dv[0]["EDate"]).ToShortDateString(); } } btc.getCreateUpdateUser(lblCreate, lblUpdate, "Projects", "ProjectsCode", id); if (!string.IsNullOrEmpty(dv[0]["IsApprove"].ToString())) { if (Convert.ToInt32(dv[0]["IsApprove"]) == 1) { lblApprove.Text = "<span style=\"font-weight:bold;\"> ͹ØÁѵÔâ¤Ã§¡ÒÃâ´Â : </span>" + btc.getEmpName(dv[0]["UserApprove"].ToString()) + "<br /><span style=\"font-weight:bold;\"> Çѹ·Õè : </span>" + Convert.ToDateTime(dv[0]["DateApprove"]).ToString("dd/MM/yyyy"); lblComment.Text = "<span style=\"font-weight:bold;\">¤ÇÒÁ¤Ô´àËç¹ : </span>" + dv[0]["Comment"].ToString(); lblApprove.ForeColor = System.Drawing.Color.Green; lblComment.ForeColor = System.Drawing.Color.Green; } else { lblApprove.Text = "<span style=\"font-weight:bold;\">äÁè͹ØÁѵÔâ¤Ã§¡ÒÃâ´Â : </span>" + btc.getEmpName(dv[0]["UserApprove"].ToString()) + "<br /><span style=\"font-weight:bold;\"> Çѹ·Õè : </span>" + Convert.ToDateTime(dv[0]["DateApprove"]).ToString("dd/MM/yyyy"); lblComment.Text = "<span style=\"font-weight:bold;\">¤ÇÒÁ¤Ô´àËç¹ : </span>" + dv[0]["Comment"].ToString(); lblApprove.ForeColor = System.Drawing.Color.Red; lblComment.ForeColor = System.Drawing.Color.Red; } } if (hdfCreateUser.Value != CurrentUser.ID) { if (CurrentUser.RoleLevel < 98) { btSave.Visible = false; } } else { //if (btc.ckApproveFlow(id)) //àªç¤ÇèÒÁÕ¡Òà Approve ä»áÅéÇËÃ×ÍÂѧ //{ // btSave.Visible = false; //} } //if (dv18.Count != 0) //{ // for (int i = 0; i <= cblStrategicPlan.Items.Count - 1; i++) // { // for (int j = 0; j <= dv18.Count - 1; j++) // { // if (cblStrategicPlan.Items[i].Value == dv18[j]["StrategicPlanID"].ToString()) // { // cblStrategicPlan.Items[i].Selected = true; // break; // } // } // } //} if (btc.ckIdentityName("ckStrategies")) { DataView dv100 = Conn.Select(string.Format("Select StrategiesCode From dtStrategies Where ProjectsCode = '" + id + "'")); if (dv100.Count != 0) { for (int i = 0; i <= cblStrategies.Items.Count - 1; i++) { for (int j = 0; j <= dv100.Count - 1; j++) { if (cblStrategies.Items[i].Value == dv100[j]["StrategiesCode"].ToString()) { cblStrategies.Items[i].Selected = true; break; } } } } } cblStrategies.Enabled = false; btc.getcblCorporateStrategy(divCorporateStrategy, cblCorporateStrategy, ddlYearS.SelectedValue, cblStrategies); //KPI if (dv19.Count != 0) { for (int i = 0; i <= cblCorporateStrategy.Items.Count - 1; i++) { for (int j = 0; j <= dv19.Count - 1; j++) { if (cblCorporateStrategy.Items[i].Value == dv19[j]["CorporateStrategyID"].ToString()) { cblCorporateStrategy.Items[i].Selected = true; break; } } } } cblCorporateStrategy.Enabled = false; if (dv1.Count != 0) { for (int i = 0; i <= cblStandardNation.Items.Count - 1; i++) { for (int j = 0; j <= dv1.Count - 1; j++) { if (cblStandardNation.Items[i].Value == dv1[j]["StandardNationCode"].ToString()) { cblStandardNation.Items[i].Selected = true; break; } } } } if (dv2.Count != 0) { for (int i = 0; i <= cblStandardMinistry.Items.Count - 1; i++) { for (int j = 0; j <= dv2.Count - 1; j++) { if (cblStandardMinistry.Items[i].Value == dv2[j]["StandardMinistryCode"].ToString()) { cblStandardMinistry.Items[i].Selected = true; break; } } } } if (dv333.Count != 0) { for (int i = 0; i <= cblStrategicObjectives.Items.Count - 1; i++) { for (int j = 0; j <= dv333.Count - 1; j++) { if (cblStrategicObjectives.Items[i].Value == dv333[j]["StrategicObjectivesCode"].ToString()) { cblStrategicObjectives.Items[i].Selected = true; break; } } } } if (dv9.Count != 0) { for (int i = 0; i <= cblStrategic.Items.Count - 1; i++) { for (int j = 0; j <= dv9.Count - 1; j++) { if (cblStrategic.Items[i].Value == dv9[j]["StrategicCode"].ToString()) { cblStrategic.Items[i].Selected = true; break; } } } } if (btc.ckIdentityName("iNameShow2")) { DataView dv101 = Conn.Select(string.Format("Select IdentityNameCode From dtIdentityName Where ProjectsCode = '" + id + "'")); if (dv101.Count != 0) { for (int i = 0; i <= cblIdentityName2.Items.Count - 1; i++) { for (int j = 0; j <= dv101.Count - 1; j++) { if (cblIdentityName2.Items[i].Value == dv101[j]["IdentityNameCode"].ToString()) { cblIdentityName2.Items[i].Selected = true; break; } } } } } cblIdentityName2.Enabled = false; }