private CompanyModel Getcm(DataRow dr, bool bj_child, bool bj_father, bool bj_branch, DB_OPT dbo) { CompanyModel model = new CompanyDal(); if (bj_father) { model.pk_corp = dr["FatherPK"].ToString(); model.FatherInfo = model.GetModel(false, false, true, dbo); } model.pk_corp = dr["pk_corp"].ToString(); model.Name = dr["Name"].ToString(); model.ShortName = dr["ShortName"].ToString(); model.KeyChar = dr["KeyChar"].ToString(); model.Country = dr["Country"].ToString(); model.Province = dr["Province"].ToString(); model.Area = dr["Area"].ToString(); model.Address = dr["Address"].ToString(); model.PostalCode = dr["PostalCode"].ToString(); model.Url = dr["Url"].ToString(); model.Email1 = dr["Email1"].ToString(); model.Email2 = dr["Email2"].ToString(); model.Email3 = dr["Email3"].ToString(); model.Phone1 = dr["Phone1"].ToString(); model.Phone2 = dr["Phone2"].ToString(); model.Phone3 = dr["Phone3"].ToString(); model.Fax1 = dr["Fax1"].ToString(); model.Fax2 = dr["Fax2"].ToString(); model.Fax3 = dr["Fax3"].ToString(); model.linkman1 = dr["linkman1"].ToString(); model.linkman2 = dr["linkman2"].ToString(); model.Holder = dr["Holder"].ToString(); if (dr["RegMoney"].ToString() != "") { model.RegMoney = decimal.Parse(dr["RegMoney"].ToString()); } model.BankPK = dr["BankPK"].ToString().Trim(); model.FPDWM = dr["FPDWM"].ToString(); model.InvoiceType = dr["InvoiceType"].ToString(); model.DutyNum = dr["DutyNum"].ToString(); model.Discription = dr["Discription"].ToString(); model.FatherPK = dr["FatherPK"].ToString().Trim(); model.IsHasBaby = dr["IsHasBaby"].ToString(); if (dr["Grade"].ToString() != "") { model.Grade = int.Parse(dr["Grade"].ToString()); } model.PKPath = dr["PKPath"].ToString(); model.ZXBJ = dr["ZXBJ"].ToString(); if (bj_father) { model.Childs_Branch = new BranchDal().GetModels("pk_corp='" + dr["pk_corp"].ToString() + "'", false, false, false, true, dbo); } if ((dr["IsHasBaby"].ToString() == "1") && !bj_child) { model.Childs_Company = this.GetChilds(model.pk_corp, true, dbo); } return model; }
private void UpdateCompany() { try { this.dbo = new DB_OPT(); this.dbo.Open(); if ((this.txtName.Text.Trim() == "") || (this.txtpk_corp.Text.Trim() == "")) { Const.ShowMessage("带*的数据必须填写!", this.Page); } else { CompanyModel model = new CompanyDal(); CompanyModel model2 = new CompanyDal { FatherPK = this.txtsjgspk.Value.Trim() }; if (model2.FatherPK != "") { model2.pk_corp = model2.FatherPK; model2 = model2.GetModel(false, false, false, this.dbo); if (model2.IsHasBaby == "0") { model.pk_corp = model2.pk_corp; model.UpdateHasBaby(this.dbo); } model.PKPath = model2.PKPath + model2.pk_corp + "|"; if (this.txtishasbaby.Value == "1") { Companybll.ChangeChildPkPath(base.Request.QueryString["PK"].ToString(), model.PKPath + base.Request.QueryString["PK"].ToString() + "|", model2.Grade + 2, this.dbo); } model.Grade = model2.Grade + 1; } else { model.Grade = 0; } model.FatherPK = this.txtsjgspk.Value.Trim(); model.IsHasBaby = this.txtishasbaby.Value; model.pk_corp = this.txtpk_corp.Text.Trim(); model.BH = this.txtcmbh.Value.Trim(); model.Name = this.txtName.Text.Trim(); model.IsHasBaby = this.txtishasbaby.Value.Trim(); model.Address = this.txtAddress.Text.Trim(); model.Area = this.txtArea.Text.Trim(); model.Country = this.txtCountry.Text.Trim(); model.Discription = this.txtDiscription.Text.Trim(); model.DutyNum = this.txtDutyNum.Text.Trim(); model.Email1 = this.txtEmail1.Text.Trim(); model.Email2 = this.txtEmail2.Text.Trim(); model.Email3 = this.txtEmail3.Text.Trim(); model.Fax1 = this.txtFax1.Text.Trim(); model.Fax2 = this.txtFax2.Text.Trim(); model.Fax3 = this.txtFax3.Text.Trim(); model.FPDWM = this.txtFPDWM.Text.Trim(); model.Holder = this.txtHolder.Text.Trim(); model.InvoiceType = this.txtInvoiceType.Text.Trim(); model.KeyChar = this.txtKeyChar.Text.Trim(); model.linkman1 = this.txtlinkman1.Text.Trim(); model.linkman2 = this.txtlinkman2.Text.Trim(); model.Name = this.txtName.Text.Trim(); model.Phone1 = this.txtPhone1.Text.Trim(); model.Phone2 = this.txtPhone2.Text.Trim(); model.Phone3 = this.txtPhone3.Text.Trim(); model.PostalCode = this.txtPostalCode.Text.Trim(); model.Province = this.txtProvince.Text.Trim(); if (this.txtRegMoney.Text.Trim() != "") { model.RegMoney = decimal.Parse(this.txtRegMoney.Text.Trim()); } model.ShortName = this.txtShortName.Text.Trim(); model.Url = this.txtUrl.Text.Trim(); model.PostalCode = this.txtPostalCode.Text.Trim(); Const.UpdateSuccess(model.Update(base.Request.QueryString["PK"].ToString().Trim(), this.dbo), this.Page); } } catch (Exception exception) { this.el = new ExceptionLog.ExceptionLog(); this.el.ErrClassName = base.GetType().ToString(); this.el.ErrMessage = exception.Message.ToString(); this.el.ErrMethod = "UpdateCompany()"; this.el.WriteExceptionLog(true); Const.OpenErrorPage("操作失败,请联系管理员!", this.Page); } finally { if (this.dbo != null) { this.dbo.Close(); } } }
private EmployeeModel Getem(DataRow dr, bool bj_child, bool bj_father, bool bj_company, bool bj_branch, bool bj_role, DB_OPT dbo) { EmployeeModel model = new EmployeeModel(); if (bj_father) { model.BranchPK = dr["FatherPK"].ToString(); model.FatherInfo = model.GetModel(false, false, false, false, true, dbo); } model.BranchPK = dr["BranchPK"].ToString().Trim(); if (bj_branch) { BranchModel model2 = new BranchDal { BranchPK = dr["BranchPK"].ToString() }; model2 = model2.GetModel(false, false, false, false, dbo); model.Branch = model2; } model.RolePK = dr["RolePK"].ToString().Trim(); if (bj_role) { RoleModel model3 = new RoleDal { RolePK = dr["RolePK"].ToString() }; model3 = model3.GetModel(false, false, dbo); model.Role = model3; } model.BH = dr["BH"].ToString(); model.Name = dr["Name"].ToString(); model.CardNum = dr["CardNum"].ToString(); model.Sex = dr["Sex"].ToString(); if (dr["Age"].ToString() != "") { model.Age = int.Parse(dr["Age"].ToString()); } if (dr["WorkAge"].ToString() != "") { model.WorkAge = int.Parse(dr["WorkAge"].ToString()); } if (dr["BirthDay"].ToString() != "") { model.BirthDay = DateTime.Parse(dr["BirthDay"].ToString()); } model.MZ = dr["MZ"].ToString(); model.Nationals = dr["Nationals"].ToString(); model.Province = dr["Province"].ToString(); model.Area = dr["Area"].ToString(); model.City = dr["City"].ToString(); model.Address = dr["Address"].ToString(); model.PostalCode = dr["PostalCode"].ToString(); model.OfficePhone = dr["OfficePhone"].ToString(); model.Phone = dr["Phone"].ToString(); model.Mobile1 = dr["Mobile1"].ToString(); model.Mobile2 = dr["Mobile2"].ToString(); model.Mobile3 = dr["Mobile3"].ToString(); model.QQNum = dr["QQNum"].ToString(); model.ICQNum = dr["ICQNum"].ToString(); model.MSNNum = dr["MSNNum"].ToString(); model.Email = dr["Email"].ToString(); model.OtherLink = dr["OtherLink"].ToString(); model.pk_corp = dr["pk_corp"].ToString(); if (bj_company) { CompanyModel model4 = new CompanyDal { pk_corp = dr["pk_corp"].ToString() }; model4 = model4.GetModel(false, false, false, dbo); model.Company = model4; } model.FatherPK = dr["FatherPK"].ToString().Trim(); model.IsHasBaby = dr["IsHasBaby"].ToString(); if (dr["Grade"].ToString() != "") { model.Grade = int.Parse(dr["Grade"].ToString()); } model.PKPath = dr["PKPath"].ToString(); if ((dr["IsHasBaby"].ToString() == "1") && bj_child) { this.GetChilds(model.EmployeePK, false, false, false, dbo); } return model; }
private string BingData(string pk_corp, DB_OPT dbo) { CompanyModel model = new CompanyDal { pk_corp = pk_corp }; model = model.GetModel(false, true, false, dbo); this.txtpk_corp.Text = base.Request["PK"].ToString(); this.txtcmbh.Value = model.BH; this.txtName.Text = model.Name; this.txtishasbaby.Value = model.IsHasBaby; this.txtAddress.Text = model.Address; this.txtArea.Text = model.Area; this.txtCountry.Text = model.Country; this.txtDiscription.Text = model.Discription; this.txtDutyNum.Text = model.DutyNum; this.txtEmail1.Text = model.Email1; this.txtEmail2.Text = model.Email2; this.txtEmail3.Text = model.Email3; this.txtFax1.Text = model.Fax1; this.txtFax2.Text = model.Fax2; this.txtFax3.Text = model.Fax3; this.txtFPDWM.Text = model.FPDWM; this.txtHolder.Text = model.Holder; this.txtInvoiceType.Text = model.InvoiceType; this.txtKeyChar.Text = model.KeyChar; this.txtlinkman1.Text = model.linkman1; this.txtlinkman2.Text = model.linkman2; this.txtName.Text = model.Name; this.txtPhone1.Text = model.Phone1; this.txtPhone2.Text = model.Phone2; this.txtPhone3.Text = model.Phone3; if (model.FatherInfo != null) { this.txtsjgs.Text = model.FatherInfo.Name; } this.txtsjgspk.Value = model.FatherPK; this.txtPostalCode.Text = model.PostalCode; this.txtProvince.Text = model.Province; this.txtRegMoney.Text = model.RegMoney.ToString(); this.txtShortName.Text = model.ShortName; this.txtUrl.Text = model.Url; this.txtPostalCode.Text = model.PostalCode; return model.PKPath; }