/// <summary> /// 编辑 /// </summary> /// <param name="tb_Building"></param> /// <returns></returns> public int Edit(TB_Building tb_Building) { DataTable dt = null; //查询宿舍区域名称是否存在 dt = _mTB_BuildingDAL.GetTable(tb_Building); if (dt != null && dt.Rows.Count > 0) { _errMessage = "名称重复!"; } else { //更新操作 if (tb_Building.ID > 0) { _mTB_BuildingDAL.Edit(tb_Building); } //添加操作 else { tb_Building.ID = _mTB_BuildingDAL.Create(tb_Building); } } return(tb_Building.ID); }
/// <summary> /// 更新 /// </summary> /// <param name="info"></param> /// <returns></returns> public int Edit(TB_Building info) { try { Database db = DBO.CreateDatabase(); return(this.Edit(info, (DbTransaction)null, db)); } catch (Exception ex) { throw ex; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.ddlBind(); string strID = Request.QueryString["id"]; int intID; TB_Building mTB_Building = null; BuildingBLL mBuildingBLL = new BuildingBLL(); if (Int32.TryParse(strID, out intID)) { mTB_Building = mBuildingBLL.Get(intID); this.txtBuildingName.Text = mTB_Building.Name; this.ddlDormAreaName.SelectedValue = mTB_Building.DormAreaID.ToString(); } } }
/// <summary> /// GridView绑定 /// </summary> /// <param name="intCurrentIndex"></param> private void Bind(int intCurrentIndex) { TB_Building mTB_Building = new TB_Building(); BuildingBLL mBuildingBLL = new BuildingBLL(); Pager pager = new Pager(); pager.CurrentPageIndex = intCurrentIndex; pager.srcOrder = " DormAreaID desc"; mTB_Building.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID); mTB_Building.Name = this.txtBuildingName.Text; mTB_Building.DormAreaID = Convert.ToInt32(this.ddlDormArea.SelectedValue); GridView1.DataSource = mBuildingBLL.GetTable(mTB_Building, ref pager); GridView1.DataBind(); this.Pager1.ItemCount = pager.TotalRecord; this.Pager1.PageCount = pager.TotalPage; this.Pager1.CurrentIndex = pager.CurrentPageIndex; this.Pager1.PageSize = pager.PageSize; }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public DataTable GetTable(TB_Building info) { DataTable dt = null; DbCommand dbCommandWrapper = null; try { string strSQL = @"select id from tb_Building where 1=1"; StringBuilder strBuilder = new StringBuilder(strSQL); Database db = DBO.GetInstance(); dbCommandWrapper = db.DbProviderFactory.CreateCommand(); dbCommandWrapper.CommandType = CommandType.Text; strBuilder.AppendLine(" AND SiteID = @SiteID"); db.AddInParameter(dbCommandWrapper, "@SiteID", DbType.Int32, info.SiteID); if (info.ID > 0) { strBuilder.AppendLine(" AND ID <> @ID"); db.AddInParameter(dbCommandWrapper, "@ID", DbType.Int32, info.ID); } strBuilder.AppendLine(" AND NAME = @NAME"); db.AddInParameter(dbCommandWrapper, "@NAME", DbType.String, info.Name); strBuilder.AppendLine(" AND DormAreaID = @DormAreaID"); db.AddInParameter(dbCommandWrapper, "@DormAreaID", DbType.String, info.DormAreaID); dbCommandWrapper.CommandText = strBuilder.ToString(); dt = db.ExecuteDataSet(dbCommandWrapper).Tables[0]; return(dt); } catch (Exception ex) { throw ex; } finally { if (dbCommandWrapper != null) { dbCommandWrapper = null; } } }
/// <summary> /// 根据ID获取对象 /// </summary> /// <param name="intID"></param> /// <returns></returns> public TB_Building Get(int intID) { DataTable dt = null; DbCommand dbCommandWrapper = null; TB_Building mTB_Building = null; try { string strSQL = @"select * from TB_Building where 1=1"; StringBuilder strBuilder = new StringBuilder(strSQL); Database db = DBO.GetInstance(); dbCommandWrapper = db.DbProviderFactory.CreateCommand(); dbCommandWrapper.CommandType = CommandType.Text; strBuilder.AppendLine(" AND ID = @ID"); db.AddInParameter(dbCommandWrapper, "@ID", DbType.Int32, intID); dbCommandWrapper.CommandText = strBuilder.ToString(); dt = db.ExecuteDataSet(dbCommandWrapper).Tables[0]; if (dt != null && dt.Rows.Count > 0) { mTB_Building = new TB_Building() { DormAreaID = Convert.ToInt32(dt.Rows[0][TB_Building.col_DormAreaID]), Name = Convert.ToString(dt.Rows[0][TB_Building.col_Name]), }; } return(mTB_Building); } catch (Exception ex) { throw ex; } finally { if (dbCommandWrapper != null) { dbCommandWrapper = null; } } }
/// <summary> /// 事务添加 /// </summary> /// <param name="info"></param> /// <param name="tran"></param> /// <param name="db"></param> /// <returns></returns> public int Create(TB_Building info, DbTransaction tran, Database db) { DbCommand dbCommandWrapper = null; int intId; string strInsertSql = "INSERT INTO TB_Building (SiteID,DormAreaID,Name,Creator) VALUES(@SiteID,@DormAreaID,@Name,@Creator)"; string strSelectIdSql = ";SELECT SCOPE_IDENTITY()"; try { dbCommandWrapper = db.GetSqlStringCommand(strInsertSql + strSelectIdSql); #region Add parameters db.AddInParameter(dbCommandWrapper, "@SiteID", DbType.Int32, info.SiteID); db.AddInParameter(dbCommandWrapper, "@DormAreaID", DbType.Int32, info.DormAreaID); db.AddInParameter(dbCommandWrapper, "@Name", DbType.String, SetNullValue(string.IsNullOrEmpty(info.Name), info.Name)); db.AddInParameter(dbCommandWrapper, "@Creator", DbType.String, SetNullValue(string.IsNullOrEmpty(info.Creator), info.Creator)); #endregion if (tran == null) { intId = Convert.ToInt32(db.ExecuteScalar(dbCommandWrapper)); } else { intId = Convert.ToInt32(db.ExecuteScalar(dbCommandWrapper, tran)); } return(intId); } catch (Exception ex) { throw ex; } finally { if (dbCommandWrapper != null) { dbCommandWrapper = null; } } }
/// <summary> /// 事务更新 /// </summary> /// <param name="info"></param> /// <param name="tran"></param> /// <param name="db"></param> /// <returns></returns> public int Edit(TB_Building info, DbTransaction tran, Database db) { DbCommand dbCommandWrapper = null; string strUpdateSql = @"UPDATE TB_Building SET DormAreaID=@DormAreaID, Name=@Name,UpdateBy=@UpdateBy,UpdateDate=@UpdateDate WHERE ID=@ID"; try { dbCommandWrapper = db.GetSqlStringCommand(strUpdateSql); #region Add parameters db.AddInParameter(dbCommandWrapper, "@ID", DbType.Int32, info.ID); db.AddInParameter(dbCommandWrapper, "@DormAreaID", DbType.Int32, info.DormAreaID); db.AddInParameter(dbCommandWrapper, "@Name", DbType.String, SetNullValue(string.IsNullOrEmpty(info.Name), info.Name)); db.AddInParameter(dbCommandWrapper, "@UpdateBy", DbType.String, SetNullValue(string.IsNullOrEmpty(info.UpdateBy), info.UpdateBy)); db.AddInParameter(dbCommandWrapper, "@UpdateDate", DbType.DateTime, DateTime.Now); #endregion if (tran == null) { return(db.ExecuteNonQuery(dbCommandWrapper)); } else { return(db.ExecuteNonQuery(dbCommandWrapper, tran)); } } catch (Exception ex) { throw ex; } finally { if (dbCommandWrapper != null) { dbCommandWrapper = null; } } }
protected void Page_Load(object sender, EventArgs e) { string strDormAreaID = Request.Params["DormAreaID"]; string strID = Request.Params["ID"]; string strBuildingName = Request.Params["BuildingName"]; int intID; BuildingBLL mBuildingBLL = new BuildingBLL(); Int32.TryParse(strID, out intID); TB_Building mTB_DormArea = new TB_Building() { Creator = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.ADAccount), UpdateBy = (base.UserInfo == null?base.SystemAdminInfo.Account:base.UserInfo.ADAccount), ID = intID, DormAreaID = Convert.ToInt32(strDormAreaID), SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID), Name = strBuildingName.Trim(), }; mBuildingBLL.Edit(mTB_DormArea); Response.Write(mBuildingBLL.ErrMessage); mBuildingBLL.ErrMessage = string.Empty; Response.End(); }
/// <summary> /// 获取分页数据 /// </summary> /// <param name="tb_Building"></param> /// <param name="pager"></param> /// <returns></returns> public DataTable GetTable(TB_Building tb_Building, ref Pager pager) { return(_mTB_BuildingDAL.GetTable(tb_Building, ref pager)); }
/// <summary> /// 获取分页数据集合 /// </summary> /// <param name="info"></param> /// <param name="pager"></param> /// <returns></returns> public DataTable GetTable(TB_Building info, ref Pager pager) { DataTable dt = null; DbCommand dbCommandWrapper = null; try { string strSQL = @"select A.*,B.Name as DormAreaName , case when A.[IsEnable] is null then '已启用' when A.[IsEnable]='已禁用' then '已禁用' when A.[IsEnable]='已启用' then '已启用' else '已启用' end as IsEnable1 from [TB_Building] as A inner join TB_dormarea As B on A.DormAreaID=B.ID "; StringBuilder strBuilder = new StringBuilder(strSQL); Database db = DBO.GetInstance(); dbCommandWrapper = db.DbProviderFactory.CreateCommand(); dbCommandWrapper.CommandType = CommandType.Text; #region 拼接条件 if (null != SessionHelper.Get(HttpContext.Current, TypeManager.User)) { strBuilder.AppendLine(@"inner join [TB_UserConnectDormArea] AS C on B.ID=C.[DormAreaID] where 1=1"); strBuilder.AppendLine(" AND C.[UserID] = @UserID"); db.AddInParameter(dbCommandWrapper, "@UserID", DbType.Int32, ((TB_User)SessionHelper.Get(HttpContext.Current, TypeManager.User)).ID); } else { strBuilder.AppendLine(" where 1=1"); } if (info.SiteID > 0) { strBuilder.AppendLine(" AND A.SiteID = @SiteID"); db.AddInParameter(dbCommandWrapper, "@SiteID", DbType.Int32, info.SiteID); } if (!string.IsNullOrEmpty(info.Name)) { strBuilder.AppendLine(" AND A.NAME LIKE @NAME"); db.AddInParameter(dbCommandWrapper, "@NAME", DbType.String, "%" + info.Name + "%"); } if (info.DormAreaID > 0) { strBuilder.AppendLine(" AND A.DormAreaID = @DormAreaID"); db.AddInParameter(dbCommandWrapper, "@DormAreaID", DbType.String, info.DormAreaID); } #endregion if (pager != null && !pager.IsNull) { strSQL = pager.GetPagerSql4Count(strBuilder.ToString()); dbCommandWrapper.CommandText = strSQL; dt = db.ExecuteDataSet(dbCommandWrapper).Tables[0]; pager.TotalRecord = Convert.ToInt32(dt.Rows[0][0]); dbCommandWrapper.CommandText = pager.GetPagerSql4Data(strBuilder.ToString(), DataBaseTypeEnum.sqlserver); } else { dbCommandWrapper.CommandText = strBuilder.ToString(); } dt = db.ExecuteDataSet(dbCommandWrapper).Tables[0]; return(dt); } catch (Exception ex) { throw ex; } finally { if (dbCommandWrapper != null) { dbCommandWrapper = null; } } }