protected void Page_Load(object sender, EventArgs e) { string strDormAreaID = Request.Params["DormAreaID"]; string strBuildingID = Request.Params["BuildingID"]; string strID = Request.Params["ID"]; string strUnitName = Request.Params["UnitName"]; int intID; UnitBLL mUnitBLL = new UnitBLL(); Int32.TryParse(strID, out intID); TB_Unit mTB_DormArea = new TB_Unit() { Creator = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.ADAccount), UpdateBy = (base.UserInfo == null?base.SystemAdminInfo.Account:base.UserInfo.ADAccount), ID = intID, BuildingID = Convert.ToInt32(strBuildingID), DormAreaID = Convert.ToInt32(strDormAreaID), SiteID = (base.UserInfo == null?base.SystemAdminInfo.SiteID:base.UserInfo.SiteID), Name = strUnitName.Trim(), }; mUnitBLL.Edit(mTB_DormArea); Response.Write(mUnitBLL.ErrMessage); mUnitBLL.ErrMessage = string.Empty; Response.End(); }
/// <summary> /// 编辑 /// </summary> /// <param name="tb_DormArea"></param> /// <returns></returns> public int Edit(TB_Unit tb_Unit) { DataTable dt = null; //查询宿舍区域名称是否存在 dt = _mTB_UnitDAL.GetTable(tb_Unit); if (dt != null && dt.Rows.Count > 0) { _errMessage = "名称重复!"; } else { //更新操作 if (tb_Unit.ID > 0) { _mTB_UnitDAL.Edit(tb_Unit); } //添加操作 else { tb_Unit.ID = _mTB_UnitDAL.Create(tb_Unit); } } return(tb_Unit.ID); }
/// <summary> /// 更新 /// </summary> /// <param name="info"></param> /// <returns></returns> public int Edit(TB_Unit 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_Unit mTB_Unit = null; UnitBLL mUnitBLL = new UnitBLL(); if (Int32.TryParse(strID, out intID)) { mTB_Unit = mUnitBLL.Get(intID); this.txtUnitName.Text = mTB_Unit.Name; this.ddlDormAreaName.SelectedValue = mTB_Unit.DormAreaID.ToString(); this.BindDDLBuilding(mTB_Unit.DormAreaID); this.ddlBuildingName.SelectedValue = mTB_Unit.BuildingID.ToString(); } } }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public DataTable GetTable(TB_Unit info) { DataTable dt = null; DbCommand dbCommandWrapper = null; try { string strSQL = @"select * from TB_Unit where 1=1"; StringBuilder strBuilder = new StringBuilder(strSQL); Database db = DBO.GetInstance(); dbCommandWrapper = db.DbProviderFactory.CreateCommand(); dbCommandWrapper.CommandType = CommandType.Text; if (info.ID > 0) { strBuilder.AppendLine(" AND ID <> @ID"); db.AddInParameter(dbCommandWrapper, "@ID", DbType.Int32, info.ID); } strBuilder.AppendLine(" AND SiteID = @SiteID"); db.AddInParameter(dbCommandWrapper, "@SiteID", DbType.String, info.SiteID); 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); strBuilder.AppendLine(" AND BuildingID = @BuildingID"); db.AddInParameter(dbCommandWrapper, "@BuildingID", DbType.String, info.BuildingID); dbCommandWrapper.CommandText = strBuilder.ToString(); dt = db.ExecuteDataSet(dbCommandWrapper).Tables[0]; return(dt); } catch (Exception ex) { throw ex; } finally { if (dbCommandWrapper != null) { dbCommandWrapper = null; } } }
/// <summary> /// GridView绑定 /// </summary> /// <param name="intCurrentIndex"></param> private void Bind(int intCurrentIndex) { TB_Unit mTB_Unit = new TB_Unit(); UnitBLL mUnitBLL = new UnitBLL(); Pager pager = new Pager(); pager.CurrentPageIndex = intCurrentIndex; pager.srcOrder = " ID desc"; mTB_Unit.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID); mTB_Unit.Name = this.txtUnitName.Text; mTB_Unit.DormAreaID = Convert.ToInt32(this.ddlDormArea.SelectedValue); mTB_Unit.BuildingID = Convert.ToInt32(Request.Form[this.ddlBuildingName.UniqueID.ToString()]); GridView1.DataSource = mUnitBLL.GetTable(mTB_Unit, 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> /// 根据ID获取对象 /// </summary> /// <param name="intID"></param> /// <returns></returns> public TB_Unit Get(int intID) { DataTable dt = null; DbCommand dbCommandWrapper = null; TB_Unit mTB_Unit = null; try { string strSQL = @"select * from TB_Unit 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_Unit = new TB_Unit() { DormAreaID = Convert.ToInt32(dt.Rows[0][TB_Unit.col_DormAreaID]), BuildingID = Convert.ToInt32(dt.Rows[0][TB_Unit.col_BuildingID]), Name = Convert.ToString(dt.Rows[0][TB_Unit.col_Name]), }; } return(mTB_Unit); } 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_Unit info, DbTransaction tran, Database db) { DbCommand dbCommandWrapper = null; int intId; string strInsertSql = "INSERT INTO TB_Unit (SiteID,DormAreaID,BuildingID,Name,Creator) VALUES(@SiteID,@DormAreaID,@BuildingID,@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, "@BuildingID", DbType.Int32, info.BuildingID); 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_Unit info, DbTransaction tran, Database db) { DbCommand dbCommandWrapper = null; string strUpdateSql = @"UPDATE TB_Unit SET DormAreaID=@DormAreaID,BuildingID=@BuildingID, 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, "@BuildingID", DbType.Int32, info.BuildingID); 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; } } }
/// <summary> /// 获取分页数据 /// </summary> /// <param name="tb_Unit"></param> /// <param name="pager"></param> /// <returns></returns> public DataTable GetTable(TB_Unit tb_Unit, ref Pager pager) { return(_mTB_UnitDAL.GetTable(tb_Unit, ref pager)); }
/// <summary> /// 获取分页数据集合 /// </summary> /// <param name="info"></param> /// <param name="pager"></param> /// <returns></returns> public DataTable GetTable(TB_Unit info, ref Pager pager) { DataTable dt = null; DbCommand dbCommandWrapper = null; try { string strSQL = @"SELECT A.*,B.Name AS BuildingName,C.Name AS DormAreaName FROM [TB_Unit] as A inner join TB_Building As B on A.BuildingID=B.ID inner join TB_DormArea AS C on A.DormAreaID=C.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 D on C.ID=D.[DormAreaID] where 1=1"); strBuilder.AppendLine(" AND D.[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); } if (info.BuildingID > 0) { strBuilder.AppendLine(" AND A.BuildingID = @BuildingID"); db.AddInParameter(dbCommandWrapper, "@BuildingID", DbType.String, info.BuildingID); } #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; } } }