private void InitContractInfo(string conId) { IncometContractBll incometContractBll = new IncometContractBll(); IncometContractModel model = incometContractBll.GetModel(conId); this.lblContractCode.Text = model.ContractCode; this.lblContractName.Text = model.ContractName; this.lblPrintDate.Text = DateTime.Now.ToShortDateString(); string userCode = this.Session["yhdm"].ToString(); DataTable dataTable = PersonnelAction.QueryPersonnelById(userCode); if (dataTable != null && dataTable.Rows.Count == 1) { this.lblBllProducer.Text = dataTable.Rows[0]["v_xm"].ToString(); } new PayoutBalance().GetBalancedAmount(conId, false); this.lblBalancedSum.Text = WebUtil.GetPaymentSum(model.ContractID, "Con_Incomet_Payment", "CllectionPrice"); bool containPending = this.paymentApply.GetById(this.ViewState["PaymentId"].ToString()).ContainPending; decimal paySum = this.paymentApply.GetPaySum(conId, containPending); this.lblPaySum.Text = paySum.ToString(); decimal num = Convert.ToDecimal(this.lblBalancedSum.Text) - paySum; this.lblDiff.Text = num.ToString(); this.lblContractMoney.Text = model.ContractPrice.ToString(); this.lblSignedDate.Text = model.SignedTime.Value.ToShortDateString(); }
protected void setData(string userCode) { DataTable dataTable = PersonnelAction.QueryPersonnelById(userCode); if (dataTable.Rows.Count == 1) { this.LbName.Text = dataTable.Rows[0]["v_xm"].ToString(); this.LbDeptName.Text = PersonnelAction.getDeptName(Convert.ToInt32(dataTable.Rows[0]["i_bmdm"].ToString())); if (dataTable.Rows[0]["Sex"].ToString() == "1") { this.LbSex.Text = "男"; } else { if (dataTable.Rows[0]["Sex"].ToString() == "2") { this.LbSex.Text = "女"; } } this.LbNation.Text = dataTable.Rows[0]["Nation"].ToString(); this.LbMobilePhoneCode.Text = dataTable.Rows[0]["MobilePhoneCode"].ToString(); if (dataTable.Rows[0]["Birthday"].ToString() != "") { this.LbBirthday.Text = Convert.ToDateTime(dataTable.Rows[0]["Birthday"]).ToString("yyyy-MM-dd"); } this.LbIDCard.Text = dataTable.Rows[0]["IDCard"].ToString(); this.LbPostAndCompetency.Text = dataTable.Rows[0]["PostAndCompetency"].ToString(); if (dataTable.Rows[0]["UserPhoto"].ToString() != "") { this.Image1.ImageUrl = "~" + dataTable.Rows[0]["UserPhoto"].ToString(); this.Image1.AlternateText = dataTable.Rows[0]["v_xm"].ToString() + "照片"; } } }
protected void Page_Load(object sender, System.EventArgs e) { if (!this.Page.IsPostBack) { this.BindDdl(); if (base.Request.QueryString["cc"].ToString() != "") { this.DeptID = System.Convert.ToInt32(base.Request.QueryString["cc"]); } else { this.DeptID = 0; } this.CorpCode = this.Session["corpcode"].ToString(); this.hdnDept.Value = this.DeptID.ToString(); this.txtDeptName.Text = PersonnelAction.getDeptName(this.DeptID); this.UserCode = base.Request.QueryString["uc"].ToString(); this.Combox_DataBind(); this.dbEnterCorpDate.Text = System.DateTime.Now.ToString("yyyy-MM-dd"); this.ddltDuty.DataBind(); if (this.ddltDuty.Items.Count < 1) { this.JS.Text = "top.ui.alert('请先在该部门下增加岗位!');"; this.BtnSave.Enabled = false; } } }
private void InitContractInfo(string conId) { PayoutContract payoutContract = new PayoutContract(); PayoutContractModel model = payoutContract.GetModel(conId); this.lblContractCode.Text = model.ContractCode; this.lblContractName.Text = model.ContractName; this.lblPrintDate.Text = DateTime.Now.ToShortDateString(); string userCode = this.Session["yhdm"].ToString(); DataTable dataTable = PersonnelAction.QueryPersonnelById(userCode); if (dataTable != null && dataTable.Rows.Count == 1) { this.lblBllProducer.Text = dataTable.Rows[0]["v_xm"].ToString(); } decimal balancedAmount = new PayoutBalance().GetBalancedAmount(conId, false); this.lblBalancedSum.Text = balancedAmount.ToString("0.000"); bool containPending = this.payoutPayment.GetModel(this.ViewState["PaymentId"].ToString()).ContainPending; decimal paySum = this.payoutPayment.GetPaySum(this.contractId, containPending); this.lblPaySum.Text = paySum.ToString("0.000"); decimal num = balancedAmount - paySum; this.lblDiff.Text = num.ToString("0.000"); this.lblContractMoney.Text = model.ModifiedMoney.ToString(); this.lblSignedDate.Text = model.SignDate.Value.ToShortDateString(); }
protected void Combox_DataBind() { this.CombNation.Values = PersonnelAction.GetDistinctRegister("Nation"); this.CombComputeLevel.Values = PersonnelAction.GetDistinctRegister("ComputeLevel"); this.CombDriveLevel.Values = PersonnelAction.GetDistinctRegister("DriveLevel"); this.CombEducationalBackground.Values = PersonnelAction.GetDistinctRegister("EducationalBackground"); this.CombEnglishLevel.Values = PersonnelAction.GetDistinctRegister("EnglishLevel"); }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { if (!string.IsNullOrEmpty(base.Request["planType"])) { string a = base.Request["planType"].ToString(); if (a == "0") { this.ShowAudit1.BusiCode = "130"; } else { this.ShowAudit1.BusiCode = "131"; } } DataTable dataTable = PersonnelAction.QueryPersonnelById(base.UserCode); if (dataTable != null && dataTable.Rows.Count == 1) { this.lblBllProducer.Text = dataTable.Rows[0]["v_xm"].ToString(); } this.lblPrintDate.Text = DateTime.Now.ToShortDateString(); if (base.Request.QueryString["type"] == "0") { PTDbsjBll pTDbsjBll = new PTDbsjBll(); PTDbsjModel modelByGID = pTDbsjBll.GetModelByGID(this.wkpid); pTDbsjBll.Delete(modelByGID.I_DBSJ_ID); } MainPlan model = new MainPlanAndAction().GetModel(new Guid(this.wkpid)); this.lblCode.Text = model.WkpUserCode; this.lblDate.Text = model.WkpRecordDate.ToShortDateString(); this.lblPart.Text = new MainPlanAndAction().BackDept(model.WkpDeptId); this.lblReportName.Text = new MainPlanAndAction().BackUserName(model.WkpReportUser); string sqlString = "select * from pm_workplan_plansummary where wkpid='" + new Guid(this.wkpid) + "'"; DataTable dataTable2 = publicDbOpClass.DataTableQuary(sqlString); if (dataTable2.Rows.Count > 0) { this.lblPlanSumm.Text = dataTable2.Rows[0]["wkpremarks"].ToString(); this.lblScore.Text = dataTable2.Rows[0]["wkpselfscore"].ToString(); this.lblSumm.Text = dataTable2.Rows[0]["wkpsummary"].ToString(); } else { this.lblPlanSumm.Text = ""; this.lblScore.Text = ""; this.lblSumm.Text = ""; } this.dl_Bind(); } }
private void InitTree(System.Web.UI.WebControls.TreeNodeCollection nodes, int parentID) { DataTable deptmentList = PersonnelAction.getDeptmentList(); DataRow[] array = deptmentList.Select("i_sjdm =" + parentID.ToString()); DataRow[] array2 = array; for (int i = 0; i < array2.Length; i++) { DataRow dataRow = array2[i]; System.Web.UI.WebControls.TreeNode treeNode = new System.Web.UI.WebControls.TreeNode(); treeNode.Value = dataRow["i_bmdm"].ToString(); treeNode.Text = dataRow["V_BMMC"].ToString(); treeNode.Target = "FraDuty"; treeNode.NavigateUrl = "DutyList.aspx?=DeptID=" + dataRow["i_bmdm"].ToString(); nodes.Add(treeNode); this.InitTree(treeNode.ChildNodes, Convert.ToInt32(treeNode.Value)); } }
private void InitContractInfo(string conId) { PayoutContract payoutContract = new PayoutContract(); PayoutContractModel model = payoutContract.GetModel(conId); this.lblContractCode.Text = model.ContractCode; this.lblContractName.Text = model.ContractName; this.lblPrintDate.Text = DateTime.Now.ToShortDateString(); string userCode = this.Session["yhdm"].ToString(); DataTable dataTable = PersonnelAction.QueryPersonnelById(userCode); if (dataTable != null && dataTable.Rows.Count == 1) { this.lblBllProducer.Text = dataTable.Rows[0]["v_xm"].ToString(); } this.lblContractMoney.Text = model.ModifiedMoney.ToString(); this.lblSignedDate.Text = model.SignDate.Value.ToShortDateString(); }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { this.TemGID = Guid.NewGuid().ToString(); string text = this.Session["yhdm"].ToString(); DataTable dataTable = PersonnelAction.QueryPersonnelById(text); if (dataTable != null && dataTable.Rows.Count == 1) { this.Session["HumanName"] = dataTable.Rows[0]["v_xm"].ToString(); } this.Session["HumanCode"] = text; if (this._Action == "edit") { this.FileLink1.Type = 1; this.FileLink1.FID = this._Ic; this.ToInitialize(); return; } if (this._Action == "add") { this.FileLink1.Type = 2; this.FileLink1.FID = this.TemGID.ToString(); if (this._PrjCode != "" && this._PrjCode.Length == 36) { PMModel pMModel = new PMModel(); pMModel = PMAction.GetSingleInfoByPrjGuid(this._PrjCode); if (pMModel != null) { this.txtaccountNum.Value = pMModel.PrjCode; this.txtacountName.Value = pMModel.PrjName; return; } } } else { this.FileLink1.Type = 0; this.FileLink1.FID = this._Ic; this.ToInitialize(); this.initSate(); } } }
protected void btnRe_Click(object sender, System.EventArgs e) { this.AspNetPager1.CurrentPageIndex = 1; string value = this.hdnUserCode.Value; if (PersonnelAction.RePerson(value)) { //DataTable dt = PersonnelAction.QueryPersonnelById(value); //string strRe = WXAPI.createWXry(dt.Rows[0]); //if (strRe != "0") //{ // this.JS.Text = "top.ui.alert('人员回到职位成功,同步到微信失败!');"; //} //else { this.JS.Text = "alert('人员回到职位成功!');"; //} this.BindData(); } }
protected void btnDel_Click(object sender, System.EventArgs e) { this.AspNetPager1.CurrentPageIndex = 1; string value = this.hdnUserCode.Value; if (PersonnelAction.DelPerson(value)) { //string strRe = WXAPI.deletedWXry(value); //if (strRe != "0") //{ // this.JS.Text = "top.ui.alert('人员离职成功,同步到微信失败!');"; //} //else //{ this.JS.Text = "alert('人员离职成功!');"; // } this.BindData(); } }
protected void Page_Load(object sender, System.EventArgs e) { if (!base.IsPostBack) { if (base.Request.QueryString["cc"].ToString() != "") { this.DeptID = System.Convert.ToInt32(base.Request.QueryString["cc"]); this.OldDeptID = System.Convert.ToInt32(base.Request.QueryString["cc"]); } else { this.DeptID = 0; this.OldDeptID = 0; } this.CorpCode = this.Session["CorpCode"].ToString(); this.Labbm.Text = PersonnelAction.getDeptName(System.Convert.ToInt32(this.DeptID.ToString())); this.UserCode = base.Request.QueryString["uc"].ToString(); this.setData(this.UserCode); this.Bind_Duty(); } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { this.gvBudget.PageSize = NBasePage.pagesize; string text = this.Session["yhdm"].ToString(); DataTable dataTable = PersonnelAction.QueryPersonnelById(text); if (dataTable != null && dataTable.Rows.Count == 1) { this.Session["HumanName"] = dataTable.Rows[0]["v_xm"].ToString(); } this.Session["HumanCode"] = text; if (base.Request["plantype"] != null) { this.plantype = base.Request["plantype"].ToString(); this.hfplantype.Value = this.plantype; } this.BindGv(); this.hfldAdjunctPath.Value = ConfigHelper.Get("PrjAccount"); } }
private void btnSignIn_Click(object sender, EventArgs e) { General general = new General(); Personnel personnel = new Personnel(); string pass; pass = personnel.md5crypto(tbxPassword.Text); if (lblCaptcha.Text != tbxCaptcha.Text) { MessageBox.Show("Captcha yanlış !", "HATA", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { bool result = personnel.personnelSignInControl(pass, General._personnelId); if (result) { PersonnelAction personnelAction = new PersonnelAction(); personnelAction.PersonnelId = General._personnelId; personnelAction.Action = "Giriş Yapıldı"; personnelAction.Date = DateTime.Now; personnelAction.PersonnelActionSave(personnelAction); frmMenu menu = new frmMenu(); menu.Show(); this.Hide(); } else { MessageBox.Show("Kullanıcı adı veya Şifreniz yanlış !", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Stop); lblCaptcha.Text = ""; Captcha(); tbxPassword.Text = ""; tbxCaptcha.Text = ""; } } }
protected void BtnSave_Click(object sender, System.EventArgs e) { if (string.IsNullOrEmpty(this.txtLogin.Text.Trim())) { this.JS.Text = "top.ui.alert('系统账户不能为空!');"; return; } if (!string.IsNullOrEmpty(this.txtIDCard.Text) && !Regex.IsMatch(this.txtIDCard.Text.Trim(), "([a-zA-Z]|\\d{17}|\\d{7}|\\d{8}(?:\\d|[xX])$)|(^\\d{15}$)")) { base.RegisterScript("top.ui.alert('输入的身份证格式不正确!');"); this.txtIDCard.Focus(); return; } DataTable dataTable = userManageDb.UserIsExist(this.txtLogin.Text.Trim()); if (dataTable.Rows.Count > 0) { this.JS.Text = "top.ui.alert('该系统帐户已存在,请重新填写!');"; return; } string[] array = PersonnelAction.setUserCode(this.DeptID.ToString()); int num = System.Convert.ToInt32(array[0]); System.Collections.Hashtable hashtable = new System.Collections.Hashtable(); hashtable.Add("i_xh", num.ToString()); hashtable.Add("v_yhdm", SqlStringConstructor.GetQuotedString(array[1])); hashtable.Add("v_xm", SqlStringConstructor.GetQuotedString(this.txtName.Text)); hashtable.Add("RelationCorp", SqlStringConstructor.GetQuotedString(this.CorpCode)); hashtable.Add("i_bmdm", this.DeptID.ToString()); hashtable.Add("I_DUTYID", this.ddltDuty.SelectedValue); int num2; if (this.txtAge.Text != "") { num2 = System.Convert.ToInt32(this.txtAge.Text); } else { num2 = 0; } hashtable.Add("Age", num2.ToString()); hashtable.Add("Sex", SqlStringConstructor.GetQuotedString(this.ddltSex.SelectedValue)); hashtable.Add("Nation", SqlStringConstructor.GetQuotedString(this.CombNation.Text)); hashtable.Add("EducationalBackground", SqlStringConstructor.GetQuotedString(this.CombEducationalBackground.Text.Trim())); hashtable.Add("Stature", SqlStringConstructor.GetQuotedString(this.txtStature.Text)); if (this.ddltPositionLevel.SelectedValue != "") { hashtable.Add("PositionLevel", this.ddltPositionLevel.SelectedValue); } hashtable.Add("ClassID", this.ddltClassID.SelectedValue); hashtable.Add("Address", SqlStringConstructor.GetQuotedString(this.txtAddress.Text)); hashtable.Add("RegisteredPlace", SqlStringConstructor.GetQuotedString(this.txtRegisteredPlace.Text)); hashtable.Add("PostAndRank", SqlStringConstructor.GetQuotedString(this.ddltPostAndRank.SelectedValue)); hashtable.Add("ComputeLevel", SqlStringConstructor.GetQuotedString(this.CombComputeLevel.Text)); hashtable.Add("EnglishLevel", SqlStringConstructor.GetQuotedString(this.CombEnglishLevel.Text)); hashtable.Add("DriveLevel", SqlStringConstructor.GetQuotedString(this.CombDriveLevel.Text)); hashtable.Add("Marriage", SqlStringConstructor.GetQuotedString(this.ddltMarriage.SelectedValue)); hashtable.Add("Postcode", SqlStringConstructor.GetQuotedString(this.txtPostcode.Text)); hashtable.Add("Tel", SqlStringConstructor.GetQuotedString(this.txtTel.Text)); if (this.txtExpectationSalary.Text != "") { hashtable.Add("ExpectationSalary", System.Convert.ToDecimal(this.txtExpectationSalary.Text).ToString()); } hashtable.Add("CommunicateAddress", SqlStringConstructor.GetQuotedString(this.txtCommunicateAddress.Text)); hashtable.Add("State", "1"); hashtable.Add("c_sfyx", SqlStringConstructor.GetQuotedString("y")); if (this.FileUpload1.HasFile) { HttpPostedFile postedFile = this.FileUpload1.PostedFile; com.jwsoft.pm.entpm.action.FileUpload fileUpload = new com.jwsoft.pm.entpm.action.FileUpload(); string[] array2 = fileUpload.Upload(postedFile, 5); hashtable.Add("UserPhoto", SqlStringConstructor.GetQuotedString(array2[1])); } hashtable.Add("MobilePhoneCode", SqlStringConstructor.GetQuotedString(this.txtMobilePhoneCode.Text)); if (!string.IsNullOrEmpty(this.dbBirthday.Text)) { hashtable.Add("Birthday", SqlStringConstructor.GetQuotedString(this.dbBirthday.Text.Trim())); } hashtable.Add("IDCard", SqlStringConstructor.GetQuotedString(this.txtIDCard.Text)); hashtable.Add("PoliticsFace", SqlStringConstructor.GetQuotedString(this.txtPoliticsFace.Text)); if (!string.IsNullOrEmpty(this.dbJoinPartyDate.Text)) { hashtable.Add("JoinPartyDate", SqlStringConstructor.GetQuotedString(this.dbJoinPartyDate.Text)); } hashtable.Add("JoinCorpMode", SqlStringConstructor.GetQuotedString(this.txtJoinCorpMode.Text)); hashtable.Add("Introducer", SqlStringConstructor.GetQuotedString(this.txtIntroducer.Text)); hashtable.Add("Specialty", SqlStringConstructor.GetQuotedString(this.txtSpecialty.Text)); hashtable.Add("GraduateSchool", SqlStringConstructor.GetQuotedString(this.txtGraduateSchool.Text)); hashtable.Add("Level", SqlStringConstructor.GetQuotedString(this.txtLevel.Text)); if (!string.IsNullOrEmpty(this.dbBeginWorkDate.Text)) { hashtable.Add("BeginWorkDate", SqlStringConstructor.GetQuotedString(this.dbBeginWorkDate.Text)); } hashtable.Add("PostAndCompetency", SqlStringConstructor.GetQuotedString(this.txtPostAndCompetency.Text)); if (this.cblInsurance.Items[0].Selected) { hashtable.Add("EndowmentInsurance", "1"); } else { hashtable.Add("EndowmentInsurance", "0"); } if (this.cblInsurance.Items[1].Selected) { hashtable.Add("MedicareInsurance", "1"); } else { hashtable.Add("MedicareInsurance", "0"); } if (this.cblInsurance.Items[2].Selected) { hashtable.Add("UnemploymentInsurance", "1"); } else { hashtable.Add("UnemploymentInsurance", "0"); } if (this.cblInsurance.Items[3].Selected) { hashtable.Add("InjuryInsurance", "1"); } else { hashtable.Add("InjuryInsurance", "0"); } if (this.cblInsurance.Items[4].Selected) { hashtable.Add("HousingAccumulationFund", "1"); } else { hashtable.Add("HousingAccumulationFund", "0"); } if (this.cblInsurance.Items[5].Selected) { hashtable.Add("PersonSuddennessInsurance", "1"); } else { hashtable.Add("PersonSuddennessInsurance", "0"); } hashtable.Add("rdeNature", SqlStringConstructor.GetQuotedString(this.ddlrdeNature.SelectedValue.ToString())); if (!string.IsNullOrEmpty(this.txtconEndDate.Text)) { hashtable.Add("conEndDate", SqlStringConstructor.GetQuotedString(this.txtconEndDate.Text)); } hashtable.Add("urgentCellMan", SqlStringConstructor.GetQuotedString(this.txturgentCellMan.Text)); hashtable.Add("ucmConcern", SqlStringConstructor.GetQuotedString(this.txtucmConcern.Text)); hashtable.Add("ucmTel", SqlStringConstructor.GetQuotedString(this.txtucmTel.Text)); if (!string.IsNullOrEmpty(this.txtFormalData.Text)) { hashtable.Add("FormalDate", SqlStringConstructor.GetQuotedString(this.txtFormalData.Text)); } hashtable.Add("userCode", SqlStringConstructor.GetQuotedString(this.txtUserCode.Text)); if (!this.chbIsChargeMan.Checked) { hashtable.Add("IsChargeMan", SqlStringConstructor.GetQuotedString("false")); } else { hashtable.Add("IsChargeMan", SqlStringConstructor.GetQuotedString("true")); } if (this.dbEnterCorpDate.Text != "") { hashtable.Add("EnterCorpDate", SqlStringConstructor.GetQuotedString(System.Convert.ToDateTime(this.dbEnterCorpDate.Text).ToShortDateString())); } hashtable.Add("RTXID", SqlStringConstructor.GetQuotedString(this.txtLogin.Text)); //添加人员 if (!PersonnelAction.AddPersonnel(hashtable)) { this.JS.Text = "top.ui.alert('保存失败!');"; return; } else { //DataTable dt = PersonnelAction.QueryPersonnelById(array[1].ToString()); //string strRe=WXAPI.createWXry(dt.Rows[0]); //if (strRe!="0") { // this.JS.Text = "top.ui.alert('同步到微信失败!');"; //}else { } } if (!this.chbIsChargeMan.Checked) { // 不是部门负责人 userManageDb.UserAdd(hashtable, this.txtLogin.Text.Trim()); this.JS.Text = "successed();"; return; } if (PersonnelAction.UpdatePT_yhmc(hashtable["v_yhdm"].ToString(), this.DeptID.ToString())) { userManageDb.UserAdd(hashtable, this.txtLogin.Text.Trim()); this.JS.Text = "successed();"; return; } this.JS.Text = "top.ui.alert('保存失败!');"; }
private void InitUpdateAndQuery() { string userCode = this.Session["yhdm"].ToString(); DataTable dataTable = PersonnelAction.QueryPersonnelById(userCode); if (dataTable != null && dataTable.Rows.Count == 1) { this.lblBllProducer.Text = dataTable.Rows[0]["v_xm"].ToString(); } this.materialWant.GetModel(this.wantplanCode); this.lblPrintDate.Text = System.DateTime.Now.ToShortDateString(); PayoutContractModel model = this.payoutContract.GetModel(ContractManage_PayoutContract_ParyoutContractQuery.contractID); if (model != null) { this.bindTarget(ContractManage_PayoutContract_ParyoutContractQuery.contractID); this.txtProject.Text = model.PrjName; this.txtPrjType.Text = this.GetPrjTypeName(new System.Guid(model.PrjGuid)); this.txtContractCode.Text = model.ContractCode; this.txtContractName.Text = model.ContractName; this.txtPreMoney.Text = ((!model.PrepayMoney.HasValue) ? string.Empty : model.PrepayMoney.ToString()); this.txtContractMoney.Text = ((!model.ContractMoney.HasValue) ? string.Empty : model.ContractMoney.ToString()); this.txtModifiedMoney.Text = ((!model.ModifiedMoney.HasValue) ? string.Empty : model.ModifiedMoney.ToString()); this.contractType.Text = this.getContractName(model.TypeID); IncometContractBll incometContractBll = new IncometContractBll(); IncometContractModel model2 = incometContractBll.GetModel(model.InContractID); if (model2 != null) { PrjInfoModel arg_1CE_0 = model2.Project; this.txtIncomeContract.Text = ((model2.ContractName == null) ? "" : model2.ContractName); } else { this.txtIncomeContract.Text = ""; } this.txtAName.Text = model.AName; this.txtBName.Text = model.CorpName; this.txtAddress.Text = model.Address; this.txtSignDate.Text = ((!model.SignDate.HasValue) ? string.Empty : System.Convert.ToDateTime(model.SignDate).ToShortDateString()); DataTable table = Common2.GetTable("dbo.XPM_Basic_CodeList", "where typeId=27 and ParentCodeID=0"); DataTable table2 = Common2.GetTable("dbo.XPM_Basic_CodeList", "where typeId=25 and ParentCodeID=0"); if (table.Rows.Count > 0) { foreach (DataRow dataRow in table.Rows) { if (dataRow["NoteID"].ToString() == model.BalanceMode) { this.txtBalanceMode.Text = dataRow["CodeName"].ToString(); } } } if (table2.Rows.Count > 0) { foreach (DataRow dataRow2 in table2.Rows) { if (dataRow2["NoteID"].ToString() == model.PayMode) { this.txtdropPayMode.Text = dataRow2["CodeName"].ToString(); } } } this.txtStartDate.Text = ((!model.StartDate.HasValue) ? string.Empty : System.Convert.ToDateTime(model.StartDate).ToShortDateString()); this.txtEndDate.Text = ((!model.EndDate.HasValue) ? string.Empty : System.Convert.ToDateTime(model.EndDate).ToShortDateString()); this.txtPaymentCondition.Text = model.PaymentCondition; this.txtMainItem.Text = model.MainItem; this.txtNotes.Text = model.Notes; this.txtCapitalNumber.Text = ((model.CapitalNumber == null) ? "" : model.CapitalNumber.ToString()); this.txtfinanceNumber.Text = ((model.FinanceNumber == null) ? "" : model.FinanceNumber.ToString()); this.txtfinanceProject.Text = ((model.FinanceProject == null) ? "" : model.FinanceProject.ToString()); this.Literal1.Text = this.FilesBind(1901, model.ContractID); if (model.ContractMoney.ToString() == "") { this.txtCapitalNumber.Text = ConverRMB.Convert(0m); } else { decimal number = System.Convert.ToDecimal(model.ContractMoney); this.txtCapitalNumber.Text = ConverRMB.Convert(number); } if (model.ModifiedMoney.ToString() == "") { this.txtCapitalizationModifiedMoney.Text = ConverRMB.Convert(0m); } else { decimal number2 = System.Convert.ToDecimal(model.ModifiedMoney); this.txtCapitalizationModifiedMoney.Text = ConverRMB.Convert(number2); } string key; switch (key = model.ConState.ToString()) { case "0": this.txtTypeName.Text = "执 行"; return; case "1": this.txtTypeName.Text = "中 止"; return; case "2": this.txtTypeName.Text = "保 内"; return; case "3": this.txtTypeName.Text = "保 外"; return; case "4": this.txtTypeName.Text = "解 除"; return; case "5": this.txtTypeName.Text = "终 止"; return; } this.txtTypeName.Text = "----"; } }
private void InitUpdateAndQuery() { string userCode = this.Session["yhdm"].ToString(); DataTable dataTable = PersonnelAction.QueryPersonnelById(userCode); if (dataTable != null && dataTable.Rows.Count == 1) { this.lblBllProducer.Text = dataTable.Rows[0]["v_xm"].ToString(); } this.lblPrintDate.Text = System.DateTime.Now.ToShortDateString(); IncometContractModel model = this.incometContractBll.GetModel(ContractManage_IncometContract_IncometContractQuery.contractID); if (model != null) { if (model.Project != null) { this.txtProject.Text = model.Project.PrjName; } this.txtContractCode.Text = model.ContractCode; this.txtContractName.Text = model.ContractName; this.txtContractMoney.Text = ((!model.ContractPrice.HasValue) ? string.Empty : WebUtil.GetEnPrice(model.ContractPrice.ToString(), model.ContractID)); this.contractType.Text = model.TypeID.TypeName; this.txtSignPeople.Text = WebUtil.GetUserNames(model.SignPepole); this.txtQualityPeriod.Text = model.QualityPeriod; if (model.Party != null) { this.txtAName.Text = model.Party.CorpName; } this.txtBName.Text = model.Second; this.txtCParty.Text = model.CParty; this.txtAddress.Text = model.SignedAddress; this.txtSignDate.Text = ((!model.SignedTime.HasValue) ? string.Empty : System.Convert.ToDateTime(model.SignedTime).ToShortDateString()); this.txtConState.Text = WebUtil.GetConState(model.ConState.ToString()); DataTable table = Common2.GetTable("dbo.XPM_Basic_CodeList", "where typeId=27 and ParentCodeID=0"); DataTable table2 = Common2.GetTable("dbo.XPM_Basic_CodeList", "where typeId=25 and ParentCodeID=0"); if (table.Rows.Count > 0) { foreach (DataRow dataRow in table.Rows) { if (dataRow["NoteID"].ToString() == model.BalanceMode) { this.txtBalanceMode.Text = dataRow["CodeName"].ToString(); } } } if (table2.Rows.Count > 0) { foreach (DataRow dataRow2 in table2.Rows) { if (dataRow2["NoteID"].ToString() == model.PayMode) { this.txtdropPayMode.Text = dataRow2["CodeName"].ToString(); } } } this.txtStartDate.Text = ((!model.StartDate.HasValue) ? string.Empty : System.Convert.ToDateTime(model.StartDate).ToShortDateString()); this.txtEndDate.Text = ((!model.EndDate.HasValue) ? string.Empty : System.Convert.ToDateTime(model.EndDate).ToShortDateString()); this.txtCllectionCondition.Text = model.CllectionCondition; this.txtMainItem.Text = model.MainProvision; this.txtNotes.Text = model.Remark; this.txtRefundDate.Text = Common2.GetTime(model.ReFundDate.ToString()); if (model.Project != null) { System.Collections.Generic.List <string> prjInfoIncoment = this.prjInfoBll.GetPrjInfoIncoment(model.Project.PrjGuid.ToString()); if (prjInfoIncoment.Count > 0) { this.lblPrjFundInfo.Text = prjInfoIncoment[3].ToString(); this.lblPrjFundWorkable.Text = prjInfoIncoment[0].ToString(); this.lblQualityClass.Text = prjInfoIncoment[2].ToString(); this.lblForecastProfitRate.Text = prjInfoIncoment[1].ToString(); } this.lblPrjType.Text = this.GetPrjTypeName(model.Project.PrjGuid); } else { System.Collections.Generic.List <string> prjInfoZTBIncoment = this.prjInfoBll.GetPrjInfoZTBIncoment(ContractManage_IncometContract_IncometContractQuery.contractID); if (prjInfoZTBIncoment.Count > 0) { this.lblPrjFundInfo.Text = prjInfoZTBIncoment[3].ToString(); this.lblPrjFundWorkable.Text = prjInfoZTBIncoment[0].ToString(); this.lblQualityClass.Text = prjInfoZTBIncoment[2].ToString(); this.lblForecastProfitRate.Text = prjInfoZTBIncoment[1].ToString(); this.txtProject.Text = prjInfoZTBIncoment[4].ToString(); } } this.ltlAnnex.Text = FileView.FilesBind(1905, model.ContractID); } }
protected void setData(string userCode) { DataTable dataTable = PersonnelAction.QueryPersonnelchInfoById(userCode); if (dataTable.Rows.Count == 1) { if (dataTable.Rows[0]["SuperordinateDuty"].ToString() != "") { int arg_5A_0 = (int)dataTable.Rows[0]["SuperordinateDuty"]; } this.Labbm.Text = PersonnelAction.getDeptName(System.Convert.ToInt32(this.DeptID.ToString())); this.labUserCode.Text = dataTable.Rows[0]["userCode"].ToString(); this.labname.Text = dataTable.Rows[0]["v_xm"].ToString(); this.labAge.Text = dataTable.Rows[0]["age"].ToString(); if (dataTable.Rows[0]["Sex"].ToString() != "") { if (dataTable.Rows[0]["Sex"].ToString() == "1") { this.labSex.Text = "男"; } else { this.labSex.Text = "女"; } } this.LabNation.Text = dataTable.Rows[0]["Nation"].ToString(); this.LabEducational.Text = dataTable.Rows[0]["EducationalBackground"].ToString(); this.Labhigt.Text = dataTable.Rows[0]["Stature"].ToString(); this.LabDuty.Text = dataTable.Rows[0]["dutyname"].ToString(); if (dataTable.Rows[0]["PositionLevel"].ToString() != "") { this.LabPositionLevel.Text = dataTable.Rows[0]["PositionLevel"].ToString() + "级"; } if (dataTable.Rows[0]["PostAndRank"].ToString() != "") { this.LabPostAndRank.Text = OAOfficeCommonClas.GetPostAndRank(dataTable.Rows[0]["PostAndRank"].ToString()); } this.LabAddress.Text = dataTable.Rows[0]["Address"].ToString(); this.LabRegisteredPlace.Text = dataTable.Rows[0]["RegisteredPlace"].ToString(); if (dataTable.Rows[0]["ClassID"].ToString() != "") { this.LabClassID.Text = DocumentAction.QueryOneDocumentClass(int.Parse(dataTable.Rows[0]["ClassID"].ToString())).Rows[0]["classname"].ToString(); } this.LabComputeLevel.Text = dataTable.Rows[0]["ComputeLevel"].ToString(); this.LabEnglishLevel.Text = dataTable.Rows[0]["EnglishLevel"].ToString(); if (dataTable.Rows[0]["Marriage"].ToString() != "") { this.LabMarriage.Text = dataTable.Rows[0]["Marriage"].ToString(); } this.LabPostcode.Text = dataTable.Rows[0]["Postcode"].ToString(); this.LabTel.Text = dataTable.Rows[0]["Tel"].ToString(); this.LabDriveLevel.Text = dataTable.Rows[0]["Drivelevel"].ToString(); if (!string.IsNullOrEmpty(dataTable.Rows[0]["ExpectationSalary"].ToString())) { this.LabtExpectationSalary.Text = System.Convert.ToInt32(dataTable.Rows[0]["ExpectationSalary"]).ToString(); } this.LabCommunicateAddress.Text = dataTable.Rows[0]["CommunicateAddress"].ToString(); if (dataTable.Rows[0]["UserPhoto"].ToString() != "") { this.Image1.ImageUrl = "~" + dataTable.Rows[0]["UserPhoto"].ToString(); this.annexName.InnerText = dataTable.Rows[0]["v_xm"].ToString() + "照片"; } else { this.Image1.ImageUrl = "~/images/PhotoDefault.gif"; } this.LabMobilePhoneCode.Text = dataTable.Rows[0]["MobilePhoneCode"].ToString(); if (!string.IsNullOrEmpty(dataTable.Rows[0]["Birthday"].ToString())) { this.LabBirthday.Text = System.DateTime.Parse(dataTable.Rows[0]["Birthday"].ToString()).ToShortDateString(); } this.LabIDCard.Text = dataTable.Rows[0]["IDCard"].ToString(); this.LabPoliticsFace.Text = dataTable.Rows[0]["PoliticsFace"].ToString(); if (!string.IsNullOrEmpty(dataTable.Rows[0]["JoinPartyDate"].ToString())) { this.LabJoinPartyDate.Text = System.DateTime.Parse(dataTable.Rows[0]["JoinPartyDate"].ToString()).ToShortDateString(); } this.LabJoinCorpMode.Text = dataTable.Rows[0]["JoinCorpMode"].ToString(); this.LabIntroducer.Text = dataTable.Rows[0]["Introducer"].ToString(); this.LabSpecialty.Text = dataTable.Rows[0]["Specialty"].ToString(); this.LabGraduateSchool.Text = dataTable.Rows[0]["GraduateSchool"].ToString(); this.LabLevel.Text = dataTable.Rows[0]["Level"].ToString(); if (!string.IsNullOrEmpty(dataTable.Rows[0]["BeginWorkDate"].ToString())) { this.LabBeginWorkDate.Text = System.DateTime.Parse(dataTable.Rows[0]["BeginWorkDate"].ToString()).ToShortDateString(); } if (!string.IsNullOrEmpty(dataTable.Rows[0]["EnterCorpDate"].ToString())) { this.LabEnterCorpDate.Text = System.DateTime.Parse(dataTable.Rows[0]["EnterCorpDate"].ToString()).ToShortDateString(); } this.LabtPostAndCompetency.Text = dataTable.Rows[0]["PostAndCompetency"].ToString(); this.Labnowstata.Text = dataTable.Rows[0]["statename"].ToString(); if (dataTable.Rows[0]["EndowmentInsurance"].ToString() == "1") { this.cblInsurance.Items[0].Selected = true; } if (dataTable.Rows[0]["MedicareInsurance"].ToString() == "1") { this.cblInsurance.Items[1].Selected = true; } if (dataTable.Rows[0]["UnemploymentInsurance"].ToString() == "1") { this.cblInsurance.Items[2].Selected = true; } if (dataTable.Rows[0]["InjuryInsurance"].ToString() == "1") { this.cblInsurance.Items[3].Selected = true; } if (dataTable.Rows[0]["HousingAccumulationFund"].ToString() == "1") { this.cblInsurance.Items[4].Selected = true; } if (dataTable.Rows[0]["PersonSuddennessInsurance"].ToString() == "1") { this.cblInsurance.Items[5].Selected = true; } if (!string.IsNullOrEmpty(dataTable.Rows[0]["conEndDate"].ToString())) { this.labconEndDate.Text = System.Convert.ToDateTime(dataTable.Rows[0]["conEndDate"]).ToString("yyyy-MM-dd"); } if (!string.IsNullOrEmpty(dataTable.Rows[0]["FormalDate"].ToString())) { this.labFormalData.Text = System.Convert.ToDateTime(dataTable.Rows[0]["FormalDate"].ToString()).ToString("yyyy-MM-dd"); } this.laburgentCellMan.Text = dataTable.Rows[0]["urgentCellMan"].ToString(); this.labucmConcern.Text = dataTable.Rows[0]["ucmConcern"].ToString(); this.labucmTel.Text = dataTable.Rows[0]["ucmTel"].ToString(); if (dataTable.Rows[0]["rdeNature"].ToString() != "") { this.labrdeNature.Text = dataTable.Rows[0]["rdeNature"].ToString(); } if (dataTable.Rows[0]["IsChargeMan"].ToString() == "True") { this.labChargeMan.Text = "是"; return; } this.labChargeMan.Text = "否"; } }