public string EditFloor(TB_Floor tb_Floor)
{
FloorBLL mFloorBLL = new FloorBLL();
mFloorBLL.ErrMessage = string.Empty;
mFloorBLL.Edit(tb_Floor);
return(mFloorBLL.ErrMessage);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int Edit(TB_Floor info)
{
try
{
Database db = DBO.CreateDatabase();
return(this.Edit(info, (DbTransaction)null, db));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 事务更新
/// </summary>
/// <param name="info"></param>
/// <param name="tran"></param>
/// <param name="db"></param>
/// <returns></returns>
public int Edit(TB_Floor info, DbTransaction tran, Database db)
{
DbCommand dbCommandWrapper = null;
string strUpdateSql = @"UPDATE TB_Floor SET DormAreaID=@DormAreaID
,BuildingID=@BuildingID
,UnitID=@UnitID
,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, "@BuildingID", DbType.Int32, info.BuildingID);
db.AddInParameter(dbCommandWrapper, "@UnitID", DbType.Int32, info.UnitID);
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>
private void InitPage()
{
string strID = Request.QueryString["id"];
int intID;
TB_Floor mTB_Floor = null;
FloorBLL mFloorBLL = new FloorBLL();
if (Int32.TryParse(strID, out intID))
{
mTB_Floor = mFloorBLL.Get(intID);
this.txtFloor.Text = mTB_Floor.Name;
this.ddlDormArea.SelectedValue = mTB_Floor.DormAreaID.ToString();
this.BindDDLBuilding(mTB_Floor.DormAreaID);
this.ddlBuilding.SelectedValue = mTB_Floor.BuildingID.ToString();
this.BindDDLUnit(mTB_Floor.BuildingID);
this.ddlUnit.SelectedValue = mTB_Floor.UnitID.ToString();
}
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public DataTable GetTable(TB_Floor info)
{
DataTable dt = null;
DbCommand dbCommandWrapper = null;
try
{
string strSQL = @"select * from TB_Floor 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.Int32, 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.Int32, info.DormAreaID);
strBuilder.AppendLine(" AND BuildingID = @BuildingID");
db.AddInParameter(dbCommandWrapper, "@BuildingID", DbType.Int32, info.BuildingID);
strBuilder.AppendLine(" AND UnitID = @UnitID");
db.AddInParameter(dbCommandWrapper, "@UnitID", DbType.Int32, info.UnitID);
dbCommandWrapper.CommandText = strBuilder.ToString();
dt = db.ExecuteDataSet(dbCommandWrapper).Tables[0];
return(dt);
}
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_Floor info, DbTransaction tran, Database db)
{
DbCommand dbCommandWrapper = null;
int intId;
string strInsertSql = @"INSERT INTO TB_Floor (SiteID,DormAreaID,BuildingID,UnitID,Name,Creator)
VALUES(@SiteID,@DormAreaID,@BuildingID,@UnitID,@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, "@UnitID", DbType.Int32, info.UnitID);
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>
/// 根据ID获取对象
/// </summary>
/// <param name="intID"></param>
/// <returns></returns>
public TB_Floor Get(int intID)
{
DataTable dt = null;
DbCommand dbCommandWrapper = null;
TB_Floor mTB_Floor = null;
try
{
string strSQL = @"select * from TB_Floor 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_Floor = new TB_Floor()
{
DormAreaID = Convert.ToInt32(dt.Rows[0][TB_Floor.col_DormAreaID]),
BuildingID = Convert.ToInt32(dt.Rows[0][TB_Floor.col_BuildingID]),
UnitID = Convert.ToInt32(dt.Rows[0][TB_Floor.col_UnitID]),
Name = Convert.ToString(dt.Rows[0][TB_Floor.col_Name]),
};
}
return(mTB_Floor);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbCommandWrapper != null)
{
dbCommandWrapper = null;
}
}
}
/// <summary>
/// GridView绑定
/// </summary>
/// <param name="intCurrentIndex"></param>
private void Bind(int intCurrentIndex)
{
TB_Floor mTB_Floor = new TB_Floor();
FloorBLL mFloorBLL = new FloorBLL();
Pager pager = new Pager();
pager.CurrentPageIndex = intCurrentIndex;
pager.srcOrder = " ID desc";
mTB_Floor.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
mTB_Floor.Name = this.txtFloorName.Text.Trim();
mTB_Floor.DormAreaID = Convert.ToInt32(this.ddlDormArea.SelectedValue);
mTB_Floor.BuildingID = Convert.ToInt32(Request.Form[this.ddlBuildingName.UniqueID.ToString()]);
mTB_Floor.UnitID = Convert.ToInt32(Request.Form[this.ddlUnit.UniqueID.ToString()]);
GridView1.DataSource = mFloorBLL.GetTable(mTB_Floor, 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="tb_Floor"></param>
/// <returns></returns>
public int Edit(TB_Floor tb_Floor)
{
DataTable dt = null;
dt = _mTB_FloorDAL.GetTable(tb_Floor);
if (dt != null && dt.Rows.Count > 0)
{
_errMessage = "名称重复！";
}
else
{
//更新操作
if (tb_Floor.ID > 0)
{
_mTB_FloorDAL.Edit(tb_Floor);
}
//添加操作
else
{
tb_Floor.ID = _mTB_FloorDAL.Create(tb_Floor);
}
}
return(tb_Floor.ID);
}
/// <summary>
/// 获取分页数据集合
/// </summary>
/// <param name="info"></param>
/// <param name="pager"></param>
/// <returns></returns>
public DataTable GetTable(TB_Floor info, ref Pager pager)
{
DataTable dt = null;
DbCommand dbCommandWrapper = null;
try
{
string strSQL = @"select A.*
,B.Name as DormAreaName
,C.name as BuildingName
,D.Name As UnitName
from [TB_Floor] as A
inner join TB_dormarea As B
on A.DormAreaID=B.ID
inner join TB_building as C
on a.buildingid=c.id
inner join TB_Unit AS D
on a.UnitID=D.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 E
on B.ID=E.[DormAreaID]
where 1=1");
strBuilder.AppendLine(" AND E.[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.Int32, info.DormAreaID);
}
if (info.BuildingID > 0)
{
strBuilder.AppendLine(" AND A.BuildingID = @BuildingID");
db.AddInParameter(dbCommandWrapper, "@BuildingID", DbType.Int32, info.BuildingID);
}
if (info.UnitID > 0)
{
strBuilder.AppendLine(" AND A.UnitID = @UnitID");
db.AddInParameter(dbCommandWrapper, "@UnitID", DbType.Int32, info.UnitID);
}
#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;
}
}
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="tb_Floor"></param>
/// <param name="pager"></param>
/// <returns></returns>
public DataTable GetTable(TB_Floor tb_Floor, ref Pager pager)
{
return(_mTB_FloorDAL.GetTable(tb_Floor, ref pager));
}
