/// <summary> /// 获取公司信息实体 /// </summary> /// <param name="CompanyId">公司编号</param> /// <param name="SystemId">系统编号</param> /// <returns></returns> public EyouSoft.Model.CompanyStructure.CompanyInfo GetModel(int CompanyId, int SystemId) { IList <EyouSoft.Model.CompanyStructure.CompanyAccount> CompanyAccountList = null; EyouSoft.Model.CompanyStructure.CompanyInfo model = null; string StrSql = string.Format("SELECT * FROM tbl_CompanyInfo where id={0} AND SystemId={1} SELECT * FROM tbl_CompanyAccount WHERE CompanyId={0}", CompanyId, SystemId); DbCommand dc = this._db.GetSqlStringCommand(StrSql); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db)) { if (dr.Read()) { model = new EyouSoft.Model.CompanyStructure.CompanyInfo() { CompanyAddress = dr.IsDBNull(dr.GetOrdinal("CompanyAddress")) ? "" : dr.GetString(dr.GetOrdinal("CompanyAddress")), CompanyEnglishName = dr.IsDBNull(dr.GetOrdinal("CompanyEnglishName")) ? "" : dr.GetString(dr.GetOrdinal("CompanyEnglishName")), CompanyName = dr.IsDBNull(dr.GetOrdinal("CompanyName")) ? "" : dr.GetString(dr.GetOrdinal("CompanyName")), CompanySiteUrl = dr.IsDBNull(dr.GetOrdinal("CompanySiteUrl")) ? "" : dr.GetString(dr.GetOrdinal("CompanySiteUrl")), CompanyType = dr.IsDBNull(dr.GetOrdinal("CompanyType")) ? "" : dr.GetString(dr.GetOrdinal("CompanyType")), CompanyZip = dr.IsDBNull(dr.GetOrdinal("CompanyZip")) ? "" : dr.GetString(dr.GetOrdinal("CompanyZip")), ContactFax = dr.IsDBNull(dr.GetOrdinal("ContactFax")) ? "" : dr.GetString(dr.GetOrdinal("ContactFax")), ContactMobile = dr.IsDBNull(dr.GetOrdinal("ContactMobile")) ? "" : dr.GetString(dr.GetOrdinal("ContactMobile")), ContactName = dr.IsDBNull(dr.GetOrdinal("ContactName")) ? "" : dr.GetString(dr.GetOrdinal("ContactName")), ContactTel = dr.IsDBNull(dr.GetOrdinal("ContactTel")) ? "" : dr.GetString(dr.GetOrdinal("ContactTel")), License = dr.IsDBNull(dr.GetOrdinal("License")) ? "" : dr.GetString(dr.GetOrdinal("License")), SystemId = dr.GetInt32(dr.GetOrdinal("SystemId")), Id = dr.GetInt32(dr.GetOrdinal("Id")), IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")) }; if (dr.NextResult()) { CompanyAccountList = new List <EyouSoft.Model.CompanyStructure.CompanyAccount>(); while (dr.Read()) { EyouSoft.Model.CompanyStructure.CompanyAccount Account = new EyouSoft.Model.CompanyStructure.CompanyAccount() { AccountName = dr.IsDBNull(dr.GetOrdinal("AccountName")) ? "" : dr.GetString(dr.GetOrdinal("AccountName")), BankName = dr.IsDBNull(dr.GetOrdinal("BankName")) ? "" : dr.GetString(dr.GetOrdinal("BankName")), BankNo = dr.IsDBNull(dr.GetOrdinal("BankNo")) ? "" : dr.GetString(dr.GetOrdinal("BankNo")), CompanyId = dr.GetInt32(dr.GetOrdinal("CompanyId")), }; CompanyAccountList.Add(Account); Account = null; } model.CompanyAccountList = CompanyAccountList; } } } return(model); }
/// <summary> /// 公司账户修改 /// </summary> /// <param name="model">公司账户信息实体</param> /// <returns></returns> public bool AccountUpdate(EyouSoft.Model.CompanyStructure.CompanyAccount model) { bool IsTrue = false; EyouSoft.Data.CompanyAccount DataModel = dcDal.CompanyAccount.FirstOrDefault(item => item.Id == model.Id && item.CompanyId == model.CompanyId ); if (DataModel != null) { DataModel.AccountName = model.AccountName; DataModel.BankName = model.BankName; DataModel.BankNo = model.BankNo; dcDal.SubmitChanges(); IsTrue = true; } DataModel = null; return(IsTrue); }
/// <summary> /// 公司账户新增 /// </summary> /// <param name="model">公司账户信息实体</param> /// <returns></returns> public bool AccountAdd(EyouSoft.Model.CompanyStructure.CompanyAccount model) { bool IsTrue = false; EyouSoft.Data.CompanyAccount AcountModel = new EyouSoft.Data.CompanyAccount() { AccountName = model.AccountName, BankName = model.BankName, BankNo = model.BankNo, CompanyId = model.CompanyId, }; dcDal.CompanyAccount.InsertOnSubmit(AcountModel); dcDal.SubmitChanges(); if (dcDal.ChangeConflicts.Count == 0) { IsTrue = true; } AcountModel = null; return(IsTrue); }
/// <summary> /// 初始化方法 /// </summary> void BindXC() { string tourId = Utils.GetQueryStringValue("tourId"); if (tourId == "") { Response.Write("未找到信息!"); return; } //声明bll对象 EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo); //声明散拼计划对象 EyouSoft.Model.TourStructure.TourInfo model = (EyouSoft.Model.TourStructure.TourInfo)bll.GetTourInfo(tourId); if (model != null) { //设置出团时间 xcTime = model.LDate; //发送专线 this.txtFromCompany.Text = SiteUserInfo.CompanyName; this.txtCompany.Text = SiteUserInfo.CompanyName; if (SiteUserInfo.ContactInfo != null) { //联系人姓名 this.txtFromName.Text = SiteUserInfo.ContactInfo.ContactName; //联系人传真 this.txtFromFax.Text = SiteUserInfo.ContactInfo.ContactFax; //联系人电话 this.txtFromTel.Text = SiteUserInfo.ContactInfo.ContactTel; this.txtContactTel.Text = SiteUserInfo.ContactInfo.ContactTel; } //线路名称 this.txtAreaName.Text = model.RouteName; //天数 this.txtDayCount.Text = model.TourDays.ToString(); //出发交通 this.txtLTraffic.Text = model.LTraffic; //返程交通 this.txtRTraffic.Text = model.RTraffic; //人数 //this.txtPeopleCount.Text = model.PlanPeopleNumber.ToString(); //设置游客信息 IList <EyouSoft.Model.TourStructure.TourOrderCustomer> customerList = new EyouSoft.BLL.TourStructure.TourOrder().GetTravellers(tourId).Where(x => x.CustomerStatus == EyouSoft.Model.EnumType.TourStructure.CustomerStatus.正常).ToList(); ; if (customerList != null && customerList.Count > 0) { visitorRowsCount = customerList.Count; //绑定旅客列表 this.rptCustomerList.DataSource = customerList; this.rptCustomerList.DataBind(); } //获取订单信息 EyouSoft.Model.TourStructure.TourOrder orderModel = new EyouSoft.BLL.TourStructure.TourOrder().GetOrderModel(SiteUserInfo.CompanyID, Utils.GetQueryStringValue("orderId")); int buyCompanyID = orderModel.BuyCompanyID; #region 接收方信息 EyouSoft.Model.CompanyStructure.CustomerInfo cModel = new EyouSoft.Model.CompanyStructure.CustomerInfo(); EyouSoft.BLL.CompanyStructure.Customer cBLL = new EyouSoft.BLL.CompanyStructure.Customer(); cModel = cBLL.GetCustomerModel(buyCompanyID); txtToCompany.Text = cModel.Name; txtToName.Text = cModel.ContactName; txtToFax.Text = cModel.Fax; txtToTel.Text = cModel.Phone; #endregion //标准版 if (model.ReleaseType == EyouSoft.Model.EnumType.TourStructure.ReleaseType.Normal) { //隐藏快速版行程安排 this.tblXCFast.Visible = false; //隐藏快速版服务标准 this.tblFastService.Visible = false; if (model.SentPeoples != null && model.SentPeoples.Count > 0) { //送团人信息 for (int i = 0; i < model.SentPeoples.Count; i++) { EyouSoft.Model.CompanyStructure.CompanyUser SendUserInfo = new EyouSoft.BLL.CompanyStructure.CompanyUser().GetUserInfo(model.SentPeoples[i].OperatorId); if (SendUserInfo != null) { //送团人 this.txtSendMan.Text += SendUserInfo.PersonInfo.ContactName == null ? "" : SendUserInfo.PersonInfo.ContactName + ","; //送团电话 this.txtSendTel.Text += SendUserInfo.PersonInfo == null ? "" : SendUserInfo.PersonInfo.ContactTel + ","; } } this.txtSendMan.Text = this.txtSendMan.Text.TrimEnd(','); this.txtSendTel.Text = this.txtSendTel.Text.TrimEnd(','); } if (model.TourNormalInfo != null) { //行程安排 this.xc_list.DataSource = model.TourNormalInfo.Plans; this.xc_list.DataBind(); //包含项目 this.rptProject.DataSource = model.TourNormalInfo.Services; this.rptProject.DataBind(); //不包含项目 this.lblNoPriject.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(model.TourNormalInfo.BuHanXiangMu); //儿童安排 this.lblChildren.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(model.TourNormalInfo.ErTongAnPai); //购物安排 this.lblShop.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(model.TourNormalInfo.GouWuAnPai); //赠送项目 this.lblZiFei.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(model.TourNormalInfo.ZiFeiXIangMu); //注意事项 this.lblZhuyi.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(model.TourNormalInfo.ZhuYiShiXiang); //温馨提醒 this.lblTiXing.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(model.TourNormalInfo.WenXinTiXing); } //获得报价说明 if (Utils.GetQueryStringValue("orderId") != "") { //EyouSoft.Model.TourStructure.TourOrder orderModel = new EyouSoft.BLL.TourStructure.TourOrder().GetOrderModel(SiteUserInfo.CompanyID, Utils.GetQueryStringValue("orderId")); if (orderModel != null) { //成人价格 this.lblManPrice.Text = EyouSoft.Common.Utils.FilterEndOfTheZeroString(orderModel.PersonalPrice.ToString("0.00")); //成人数 this.lblManCount.Text = orderModel.AdultNumber.ToString(); //儿童价格 this.lblChildPrice.Text = EyouSoft.Common.Utils.FilterEndOfTheZeroString(orderModel.ChildPrice.ToString("0.00")); //儿童数 this.lblChildCount.Text = orderModel.ChildNumber.ToString(); this.txtPeopleCount.Text = (orderModel.AdultNumber + orderModel.ChildNumber).ToString(); //总价格 this.lblAllPrice.Text = EyouSoft.Common.Utils.FilterEndOfTheZeroString(orderModel.SumPrice.ToString("0.00")); } else { //成人价格 this.lblManPrice.Text = "0"; //成人数 this.lblManCount.Text = "0"; //儿童价格 this.lblChildPrice.Text = "0"; //儿童数 this.lblChildCount.Text = "0"; //总价格 this.lblAllPrice.Text = "0"; } } else { //成人价格 this.lblManPrice.Text = "0"; //成人数 this.lblManCount.Text = "0"; //儿童价格 this.lblChildPrice.Text = "0"; //儿童数 this.lblChildCount.Text = "0"; //总价格 this.lblAllPrice.Text = "0"; } } //快速版 else { this.txtPeopleCount.Text = (orderModel.AdultNumber + orderModel.ChildNumber).ToString(); //隐藏标准版 行程安排 this.tblXingCheng.Visible = false; //隐藏标准版 服务 this.tblNoService.Visible = false; if (model.TourQuickInfo != null) { //设置行程安排 this.lclXingCheng.Text = model.TourQuickInfo.QuickPlan; //设置服务标准 this.lclService.Text = model.TourQuickInfo.Service; } } } EyouSoft.Model.CompanyStructure.CompanyInfo infoModel = new EyouSoft.BLL.CompanyStructure.CompanyInfo().GetModel(SiteUserInfo.CompanyID, SiteUserInfo.SysId); if (infoModel != null) { EyouSoft.Model.CompanyStructure.CompanyAccount account = null;//公司账户 if (infoModel.CompanyAccountList != null && infoModel.CompanyAccountList.Count > 0) { account = infoModel.CompanyAccountList[0]; this.lblCompanyName.Text = SiteUserInfo.CompanyName; this.lblBankName.Text = account.BankName; this.lblBankNum.Text = account.BankNo; this.lblBankUserName.Text = account.AccountName; } } }
protected void Page_Load(object sender, EventArgs e) { //判断权限 if (!CheckGrant(global::Common.Enum.TravelPermission.系统设置_公司信息_公司信息栏目)) { Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.系统设置_公司信息_公司信息栏目, true); return; } EyouSoft.BLL.CompanyStructure.CompanyInfo companyBll = new EyouSoft.BLL.CompanyStructure.CompanyInfo(); EyouSoft.Model.CompanyStructure.CompanyInfo infoModel = null;//公司信息实体 string method = Utils.GetFormValue("hidMethod"); if (method == "save") { #region 保存公司信息 if (Utils.InputText(txtCompanyName.Value) == "") { MessageBox.Show(this, "公司名称不为空"); return; } //保存 EyouSoft.Model.CompanyStructure.CompanyAccount account = new EyouSoft.Model.CompanyStructure.CompanyAccount(); //公司账户 infoModel = new EyouSoft.Model.CompanyStructure.CompanyInfo(); //公司信息实体 infoModel.CompanyAddress = Utils.InputText(txtAddress.Value); //地址 infoModel.ContactName = Utils.InputText(txtAdmin.Value); //负责人 account.BankName = Utils.InputText(txtBank.Value); //开户行 account.CompanyId = CurrentUserCompanyID; //公司编号 infoModel.CompanyZip = Utils.InputText(txtEmail.Value); //邮箱 account.AccountName = Utils.InputText(txtUserName.Value); //户名 account.BankNo = Utils.InputText(txtUserNo.Value); //账号 infoModel.CompanyEnglishName = Utils.InputText(txtEngName.Value); //公司英文名 infoModel.ContactFax = Utils.InputText(txtFax.Value); //公司传真 infoModel.License = Utils.InputText(txtLicence.Value); //公司许可证 infoModel.ContactMobile = Utils.InputText(txtMoible.Value); //公司手机 infoModel.CompanyName = Utils.InputText(txtCompanyName.Value); //公司名 infoModel.ContactTel = Utils.InputText(txtTel.Value); //电话 infoModel.CompanyType = Utils.InputText(txtType.Value); //旅行社类别 infoModel.CompanySiteUrl = Utils.InputText(txtWeb.Value); //网站 infoModel.CompanyAccountList = new List <EyouSoft.Model.CompanyStructure.CompanyAccount>(); infoModel.CompanyAccountList.Add(account); //添加到账户集合 infoModel.SystemId = CurrentUserCompanyID; //系统号 infoModel.Id = CurrentUserCompanyID; //公司号 bool result = false; result = companyBll.Update(infoModel); MessageBox.ShowAndRedirect(this, result?"保存成功!":"保存失败!", "/systemset/CompanyInfo.aspx"); #endregion } else { #region 初始化公司信息 //初始化 infoModel = companyBll.GetModel(CurrentUserCompanyID, CurrentUserCompanyID); if (infoModel != null) { EyouSoft.Model.CompanyStructure.CompanyAccount account = null;//公司账户 if (infoModel.CompanyAccountList != null && infoModel.CompanyAccountList.Count > 0) { account = infoModel.CompanyAccountList[0]; } txtAddress.Value = infoModel.CompanyAddress; //地址 txtAdmin.Value = infoModel.ContactName; //负责人 txtEmail.Value = infoModel.CompanyZip; //邮箱 txtEngName.Value = infoModel.CompanyEnglishName; //公司英文名 txtFax.Value = infoModel.ContactFax; //公司传真 txtLicence.Value = infoModel.License; //公司许可证 txtMoible.Value = infoModel.ContactMobile; //公司手机 txtCompanyName.Value = infoModel.CompanyName; //公司名 txtTel.Value = infoModel.ContactTel; //电话 txtType.Value = infoModel.CompanyType; //旅行社类别 if (account != null) { txtBank.Value = account.BankName; //开户行 txtUserName.Value = account.AccountName; //户名 txtUserNo.Value = account.BankNo; //账号 } txtWeb.Value = infoModel.CompanySiteUrl; //网站 } #endregion } }