/// <summary> /// 修改客户信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnModify_Click(object sender, EventArgs e) { //插入和更新标志 bool isInsert = txtCompanyCD.Enabled; //公司代码 string companyCD = txtCompanyCD.Text; //最大角色数 string maxRoles = txtMaxRoles.Text; //最大用户数 string maxUser = txtMaxUser.Text; //文件总大小 string maxDocSize = txtMaxDocSize.Text; //最大单个文件大小 string singleDocSize = txtSingleDocSize.Text; //最大文件个数 string maxDocNum = txtMaxDocNum.Text; //开始时间 string openDate = txtOpenDate.Text.Replace("-", ""); //结束时间 string closeDate = txtCloseDate.Text.Replace("-", ""); //用户信息模板类 CompanyOpenServModel model = new CompanyOpenServModel(); //公司代码 model.CompanyCD = companyCD; //最大角色数 model.MaxRoles = maxRoles; //最大用户数 model.MaxUers = maxUser; //文件总大小 model.MaxDocSize = maxDocSize; //最大单个文件大小 model.SingleDocSize = singleDocSize; //最大文件个数 model.MaxDocNum = maxDocNum; //开始时间 model.OpenDate = openDate; //结束时间 model.CloseDate = closeDate; //备注 model.Remark = txtRemark.Text; //更新插入标志 if (isInsert) { model.IsInsert = true; } else { model.IsInsert = false; } //数据更新或插入 if (CompanyOpenServBus.ModifyCompanyOpenServInfo(model)) { string url = "CompanyOpenServ_Query.aspx?CompanyCD=" + companyCD; Response.Redirect(url); } }
/// <summary> /// 初期化页面 /// </summary> /// <param name="companyCD">公司代码</param> private void InitPage(string companyCD) { //没有参数时,新规追加用户 if (string.IsNullOrEmpty(companyCD)) { return; } //修改用户 //获取用户信息 CompanyOpenServModel model = CompanyOpenServBus.GetCompanyOpenServInfo(companyCD); //公司代码 txtCompanyCD.Text = companyCD; //CompanyCDTip.Visible = false; //公司代码变更不可 //txtCompanyCD.Enabled = false; if (model == null) { //设置错误信息 lblMessage.Text = MessageUtil.GetMessage("Common", "E007"); return; } //设置页面值 //最大角色数 txtMaxRoles.Text = model.MaxRoles; //最大用户数 txtMaxUser.Text = model.MaxUers; //文件总大小 txtMaxDocSize.Text = model.MaxDocSize; //最大单个文件大小 txtSingleDocSize.Text = model.SingleDocSize; //最大文件个数 txtMaxDocNum.Text = model.MaxDocNum; //开始时间 txtOpenDate.Text = model.OpenDate; //结束时间 txtCloseDate.Text = model.CloseDate; //备注 txtRemark.Text = model.Remark; }
/// <summary> /// 客户公司信息更新或者插入 /// </summary> /// <param name="model">公司信息</param> /// <returns>更新成功与否</returns> public static bool ModifyCompanyOpenServInfo(CompanyOpenServModel model) { //SQL拼写 StringBuilder sql = new StringBuilder(); //追加的场合 if (model.IsInsert) { sql.AppendLine(" INSERT INTO pubdba.companyOpenServ "); sql.AppendLine(" (CompanyCD "); sql.AppendLine(" ,MaxRoles "); sql.AppendLine(" ,MaxUers "); sql.AppendLine(" ,MaxDocSize "); sql.AppendLine(" ,SingleDocSize "); sql.AppendLine(" ,MaxDocNum "); sql.AppendLine(" ,OpenDate "); sql.AppendLine(" ,CloseDate "); sql.AppendLine(" ,ModifiedDate "); sql.AppendLine(" ,ModifiedUserID "); sql.AppendLine(" ,remark) "); sql.AppendLine(" VALUES "); sql.AppendLine(" (@CompanyCD "); sql.AppendLine(" ,@MaxRoles "); sql.AppendLine(" ,@MaxUers "); sql.AppendLine(" ,@MaxDocSize "); sql.AppendLine(" ,@SingleDocSize "); sql.AppendLine(" ,@MaxDocNum "); sql.AppendLine(" ,@OpenDate "); sql.AppendLine(" ,@CloseDate "); sql.AppendLine(" ,@ModifiedDate "); sql.AppendLine(" ,@ModifiedUserID "); sql.AppendLine(" ,@remark) "); } //更新的场合 else { sql.AppendLine(" UPDATE pubdba.companyOpenServ SET "); sql.AppendLine(" MaxRoles = @MaxRoles "); sql.AppendLine(" ,MaxUers = @MaxUers "); sql.AppendLine(" ,MaxDocSize = @MaxDocSize "); sql.AppendLine(" ,SingleDocSize = @SingleDocSize "); sql.AppendLine(" ,MaxDocNum = @MaxDocNum "); sql.AppendLine(" ,OpenDate = @OpenDate "); sql.AppendLine(" ,CloseDate = @CloseDate "); sql.AppendLine(" ,ModifiedDate = @ModifiedDate "); sql.AppendLine(" ,ModifiedUserID = @ModifiedUserID "); sql.AppendLine(" ,remark = @remark "); sql.AppendLine(" WHERE "); sql.AppendLine(" CompanyCD = @CompanyCD "); } //设置参数 SqlParameter[] param = new SqlParameter[11]; //客户代码 param[0] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD); //最大角色数,如果未输入,则登陆DBNull而不登陆0 if (string.IsNullOrEmpty(model.MaxRoles)) { param[1] = new SqlParameter("@MaxRoles", DBNull.Value); } else { param[1] = new SqlParameter("@MaxRoles", int.Parse(model.MaxRoles)); } //最大用户数,如果未输入,则登陆DBNull而不登陆0 if (string.IsNullOrEmpty(model.MaxUers)) { param[2] = new SqlParameter("@MaxUers", DBNull.Value); } else { param[2] = new SqlParameter("@MaxUers", int.Parse(model.MaxUers)); } //文档大小上限数,如果未输入,则登陆DBNull而不登陆0 if (string.IsNullOrEmpty(model.MaxDocSize)) { param[3] = new SqlParameter("@MaxDocSize", DBNull.Value); } else { param[3] = new SqlParameter("@MaxDocSize", int.Parse(model.MaxDocSize)); } //单个文档大小上限,如果未输入,则登陆DBNull而不登陆0 if (string.IsNullOrEmpty(model.SingleDocSize)) { param[4] = new SqlParameter("@SingleDocSize", DBNull.Value); } else { param[4] = new SqlParameter("@SingleDocSize", int.Parse(model.SingleDocSize)); } //文件个数上限,如果未输入,则登陆DBNull而不登陆0 if (string.IsNullOrEmpty(model.MaxDocNum)) { param[5] = new SqlParameter("@MaxDocNum", DBNull.Value); } else { param[5] = new SqlParameter("@MaxDocNum", int.Parse(model.MaxDocNum)); } //客户公司业务开通日期 param[6] = SqlHelper.GetParameter("@OpenDate", model.OpenDate); //客户公司业务结束日期 param[7] = SqlHelper.GetParameter("@CloseDate", model.CloseDate); //最后修改日期 param[8] = SqlHelper.GetParameter("@ModifiedDate", DateTime.Now); //最后修改者 param[9] = SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID); //备注 param[10] = SqlHelper.GetParameter("@remark", model.Remark); SqlHelper.ExecuteTransSql(sql.ToString(), param); return(SqlHelper.Result.OprateCount > 0 ? true : false); }
/// <summary> /// 客户公司信息更新或者插入 /// </summary> /// <param name="model">公司信息</param> /// <returns>更新成功与否</returns> public static bool ModifyCompanyOpenServInfo(CompanyOpenServModel model) { model.ModifiedUserID = "admin"; return(CompanyOpenServDBHelper.ModifyCompanyOpenServInfo(model)); }
/// <summary> /// 获取公司信息 /// </summary> /// <param name="companyCD">公司代码</param> /// <returns>客户公司信息</returns> public static CompanyOpenServModel GetCompanyOpenServInfo(string companyCD) { //SQL拼写 StringBuilder sql = new StringBuilder(); sql.AppendLine(" SELECT CompanyCD "); sql.AppendLine(" ,MaxRoles "); sql.AppendLine(" ,MaxUers "); sql.AppendLine(" ,MaxDocSize "); sql.AppendLine(" ,SingleDocSize "); sql.AppendLine(" ,MaxDocNum "); sql.AppendLine(" ,OpenDate "); sql.AppendLine(" ,CloseDate "); sql.AppendLine(" ,ModifiedDate "); sql.AppendLine(" ,ModifiedUserID "); sql.AppendLine(" ,remark,LogoImg "); sql.AppendLine(" FROM pubdba.companyOpenServ "); sql.AppendLine(" WHERE "); sql.AppendLine(" CompanyCD = @CompanyCD "); //设置参数 SqlParameter[] param = new SqlParameter[1]; param[0] = SqlHelper.GetParameter("@CompanyCD", companyCD); DataTable companyData = SqlHelper.ExecuteSql(sql.ToString(), param); if (companyData != null && companyData.Rows.Count > 0) { CompanyOpenServModel model = new CompanyOpenServModel(); //公司代码 model.CompanyCD = (string)companyData.Rows[0]["CompanyCD"]; //最大角色数 model.MaxRoles = companyData.Rows[0]["MaxRoles"].ToString(); //最大用户数 model.MaxUers = companyData.Rows[0]["MaxUers"].ToString(); //文件总大小 model.MaxDocSize = companyData.Rows[0]["MaxDocSize"].ToString(); //单个文件最大大小 model.SingleDocSize = companyData.Rows[0]["SingleDocSize"].ToString(); //最大文件个数 model.MaxDocNum = companyData.Rows[0]["MaxDocNum"].ToString(); model.LogoImg = companyData.Rows[0]["LogoImg"].ToString(); //开始日期 string openDate = companyData.Rows[0]["OpenDate"].ToString(); if (!string.IsNullOrEmpty(openDate) && openDate.Length == 8) { openDate = openDate.Substring(0, 4) + "-" + openDate.Substring(4, 2) + "-" + openDate.Substring(6); } model.OpenDate = openDate; //结束日期 string closeDate = (string)companyData.Rows[0]["CloseDate"]; if (!string.IsNullOrEmpty(closeDate) && closeDate.Length == 8) { closeDate = closeDate.Substring(0, 4) + "-" + closeDate.Substring(4, 2) + "-" + closeDate.Substring(6); } model.CloseDate = closeDate; //备注 model.Remark = (string)companyData.Rows[0]["remark"]; return(model); } return(null); }