/// <summary> /// 插入数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool InsertCompanyBaseInfo(CompanyBaseInfoModel model) { try { string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID; model.ModifiedUserID = loginUserID; return CompanyBaseInfoDBHelper.InsertCompanyBaseInfo(model); } catch(System .Exception ex) { throw ex; } }
/// <summary> /// 初始化页面 /// </summary> /// <param name="CompanyNo"></param> private void InitPage(string CompanyNo) { string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; txtCompanyCD.Text=companyCD; if (string.IsNullOrEmpty(CompanyNo)) { return; } //修改企业信息 //获取企业信息 CompanyBaseInfoModel CompanyBaseInfoModel = new CompanyBaseInfoModel(); CompanyBaseInfoModel model=CompanyBaseInfoBus.GetCompanyUnitInfo(companyCD,CompanyNo); txtCompanyNo.Text=model .CompanyNo; txtCompanyName.Text=model .CompanyName; txtDescription.Text=model.Description; }
/// <summary> /// 添加企业信息 /// </summary> /// <returns>bool</returns> public static bool InsertCompanyBaseInfo(CompanyBaseInfoModel model) { try { StringBuilder sql = new StringBuilder(); sql.AppendLine("INSERT INTO officedba.CompanyBaseInfo"); sql.AppendLine(" ( CompanyCD "); sql.AppendLine(" ,CompanyNo "); sql.AppendLine(" ,SuperCompanyID "); sql.AppendLine(" ,CompanyName "); sql.AppendLine(" ,UsedStatus "); sql.AppendLine(" ,Description "); sql.AppendLine(" ,ModifiedUserID ) "); sql.AppendLine("VALUES "); sql.AppendLine(" (@CompanyCD "); sql.AppendLine(" ,@CompanyNo "); sql.AppendLine(" ,@SuperCompanyID "); sql.AppendLine(" ,@CompanyName "); sql.AppendLine(" ,@UsedStatus "); sql.AppendLine(" ,@Description "); sql.AppendLine(" ,@ModifiedUserID)"); //设置参数 SqlParameter[] param = new SqlParameter[7]; param[0] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD); param[1] = SqlHelper.GetParameter("@CompanyNo", model.CompanyNo); param[2] = SqlHelper.GetParameter("@SuperCompanyID", model.SuperCompanyID); param[3] = SqlHelper.GetParameter("@CompanyName", model.CompanyName); param[4] = SqlHelper.GetParameter("@UsedStatus", model.UsedStatus); param[5] = SqlHelper.GetParameter("@Description", model.Description); param[6] = SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID); SqlHelper.ExecuteTransSql(sql.ToString(), param); bool flag = SqlHelper.Result.OprateCount > 0 ? true : false; return flag; } //SQL拼写 catch { return false; } }
public static CompanyBaseInfoModel GetCompanyUntiInfo(string CompanyCD, string CompanyNo) { string sql = "select ID, CompanyCD,CompanyNo,SuperCompanyID,CompanyName,case when UsedStatus='1'then '是'else '否'end as UsedStatus ,Description "; sql += "from officedba.CompanyBaseInfo"; sql += " where CompanyCD=@CompanyCD and CompanyNo=@CompanyNo"; SqlParameter[] parms = new SqlParameter[2]; parms[0] = SqlHelper.GetParameter("@CompanyCD", CompanyCD); parms[1] = SqlHelper.GetParameter("@CompanyNo", CompanyNo); DataTable dt = SqlHelper.ExecuteSql(sql, parms); if (dt != null && dt.Rows.Count > 0) { CompanyBaseInfoModel CompanyBaseInfoModel = new CompanyBaseInfoModel(); CompanyBaseInfoModel.UsedStatus = dt.Rows[0]["UsedStatus"].ToString(); CompanyBaseInfoModel.CompanyName = dt.Rows[0]["CompanyName"].ToString(); CompanyBaseInfoModel.Description = dt.Rows[0]["Description"].ToString(); CompanyBaseInfoModel.SuperCompanyID = Convert.ToInt32(dt.Rows[0]["SuperCompanyID"]); return CompanyBaseInfoModel; } return null; }
protected void btnModify_Click(object sender, EventArgs e) { CompanyBaseInfoModel Model = new CompanyBaseInfoModel(); Model.CompanyCD = companyCD; Model.CompanyNo = this.txtCompanyNo.Text.Trim(); Model.CompanyName = this.txtCompanyName.Text.Trim(); Model.Description = this.txtDescription.Text.Trim(); Model.UsedStatus = chkUsingFlag.Checked ? "1" : "0"; if (SuperCompany.Value=="0") { Model.SuperCompanyID =0; } else { Model.SuperCompanyID =Convert .ToInt32 ( SuperCompany.Value); } if (CompanyBaseInfoBus.InsertCompanyBaseInfo(Model)) { Response.Write("添加成功"); } }