/// <summary>
/// 编辑
/// </summary>
/// <param name="tb_DormArea"></param>
/// <returns></returns>
public int Edit(TB_DormArea tb_DormArea)
{
DataTable dt = null;
//查询宿舍区域名称是否存在
dt = _mTB_DormAreaDAL.GetTable(tb_DormArea);
if (dt != null && dt.Rows.Count > 0)
{
_errMessage = "名称重复！";
}
else
{
//更新操作
if (tb_DormArea.ID > 0)
{
_mTB_DormAreaDAL.Edit(tb_DormArea);
}
//添加操作
else
{
tb_DormArea.ID = _mTB_DormAreaDAL.Create(tb_DormArea);
}
}
return(tb_DormArea.ID);
}
private void InitPageData()
{
string strUserID = Request.QueryString["id"];
TB_DormArea mTB_DormArea = new TB_DormArea();
DormAreaBLL mDormAreaBLL = new DormAreaBLL();
TB_User mTB_User = null;
UserBLL mUserBLL = new UserBLL();
RoleBLL mRoleBLL = new RoleBLL();
TB_Role mTB_Role = new TB_Role()
{
SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID),
};
Pager pager = null;
this.ddlRole.DataTextField = TB_Role.col_Name;
this.ddlRole.DataValueField = TB_Role.col_ID;
this.ddlRole.DataSource = mRoleBLL.GetPagerData(mTB_Role, ref pager);
this.ddlRole.DataBind();
this.ddlRole.Items.Insert(0, new ListItem()
{
Value = "0", Text = "--请选择--"
});
mTB_DormArea.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
DataTable dtLeft = mDormAreaBLL.GetTable(mTB_DormArea, ref pager);
DataTable dtRight = null;
if (null != strUserID && !string.IsNullOrEmpty(strUserID))
{
mTB_User = mUserBLL.Get(Convert.ToInt32(strUserID));
this.txtADAccount.Text = mTB_User.ADAccount;
this.txtEmployeeNo.Text = mTB_User.EmployeeNo;
this.txtCName.Text = mTB_User.CName;
this.txtEName.Text = mTB_User.EName;
this.ddlRole.SelectedValue = mTB_User.RoleID.ToString();
dtRight = mDormAreaBLL.GetTableByUserID(Convert.ToInt32(strUserID));
DataRow[] drFilter = null;
for (int i = dtLeft.Rows.Count - 1; i >= 0; i--)
{
drFilter = dtRight.Select("ID=" + dtLeft.Rows[i][TB_DormArea.col_ID] + "");
if (drFilter.Length > 0)
{
dtLeft.Rows.Remove(dtLeft.Rows[i]);
}
}
}
ViewState["dtLeft"] = dtLeft;
gdvLeft.DataSource = dtLeft;
gdvLeft.DataBind();
ViewState["dtRight"] = dtRight;
gdvRight.DataSource = dtRight;
gdvRight.DataBind();
}
/// <summary>
/// 更新
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int Edit(TB_DormArea 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)
{
string strID = Request.QueryString["id"];
int intID;
TB_DormArea mTB_DormArea = null;
DormAreaBLL mDormAreaBLL = new DormAreaBLL();
if (Int32.TryParse(strID, out intID))
{
mTB_DormArea = mDormAreaBLL.Get(intID);
this.txtDormAreaName.Text = mTB_DormArea.Name;
}
}
}
private void Bind(int intCurrentIndex)
{
TB_DormArea mTB_DormArea = new TB_DormArea();
DormAreaBLL mDormAreaBLL = new DormAreaBLL();
Pager pager = new Pager();
pager.CurrentPageIndex = intCurrentIndex;
pager.srcOrder = " ID desc";
mTB_DormArea.Name = txtDormAreaName.Text;
mTB_DormArea.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
GridView1.DataSource = mDormAreaBLL.GetTable(mTB_DormArea, ref pager);
GridView1.DataBind();
this.Pager1.ItemCount = pager.TotalRecord;
this.Pager1.PageCount = pager.TotalPage;
this.Pager1.CurrentIndex = pager.CurrentPageIndex;
this.Pager1.PageSize = pager.PageSize;
}
protected void Page_Load(object sender, EventArgs e)
{
string strDormAreaName = Request.Params["DormAreaName"];
string strID = Request.Params["ID"];
int intID;
DormAreaBLL mDormAreaBLL = new DormAreaBLL();
Int32.TryParse(strID, out intID);
TB_DormArea mTB_DormArea = new TB_DormArea()
{
SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID),
ID = intID,
Name = strDormAreaName.Trim(),
UpdateBy = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.ADAccount),
Creator = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.ADAccount),
};
mDormAreaBLL.Edit(mTB_DormArea);
Response.Write(mDormAreaBLL.ErrMessage);
mDormAreaBLL.ErrMessage = string.Empty;
Response.End();
}
/// <summary>
/// 根据ID获取对象
/// </summary>
/// <param name="intID"></param>
/// <returns></returns>
public TB_DormArea Get(int intID)
{
DataTable dt = null;
DbCommand dbCommandWrapper = null;
TB_DormArea mTB_DormArea = null;
try
{
string strSQL = @"select * from tb_DormArea 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_DormArea = new TB_DormArea()
{
Name = Convert.ToString(dt.Rows[0][TB_DormArea.col_Name]),
};
}
return(mTB_DormArea);
}
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_DormArea info, DbTransaction tran, Database db)
{
DbCommand dbCommandWrapper = null;
int intId;
string strInsertSql = "INSERT INTO TB_DormArea (SiteID,Name,Creator) VALUES(@SiteID,@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, "@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="tb_DormArea"></param>
/// <returns></returns>
public DataTable GetTable(TB_DormArea tb_DormArea)
{
DataTable dt = null;
DbCommand dbCommandWrapper = null;
try
{
string strSQL = @"select id from tb_DormArea 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, tb_DormArea.SiteID);
if (tb_DormArea.ID > 0)
{
strBuilder.AppendLine(" AND ID <> @ID");
db.AddInParameter(dbCommandWrapper, "@ID", DbType.Int32, tb_DormArea.ID);
}
strBuilder.AppendLine(" AND NAME = @NAME");
db.AddInParameter(dbCommandWrapper, "@NAME", DbType.String, tb_DormArea.Name);
dbCommandWrapper.CommandText = strBuilder.ToString();
dt = db.ExecuteDataSet(dbCommandWrapper).Tables[0];
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbCommandWrapper != null)
{
dbCommandWrapper = null;
}
}
}
private void BindSelect()
{
var lst = new List <TNameVal>();
lst.Add(new TNameVal("批准", "1"));
lst.Add(new TNameVal("拒绝", "2"));
ddlHandle.DataSource = lst;
ddlHandle.DataValueField = "Value";
ddlHandle.DataTextField = "Name";
ddlHandle.DataBind();
ddlHandle.SelectedIndex = 0;
//
var mTB_DormArea = new TB_DormArea();
var mDormAreaBLL = new DormAreaBLL();
Framework.Pager page = null;
var dt = mDormAreaBLL.GetTable(mTB_DormArea, ref page);
ddlDormArea.DataSource = dt;
ddlDormArea.DataValueField = "ID";
ddlDormArea.DataTextField = "Name";
ddlDormArea.DataBind();
}
/// <summary>
/// 事务更新
/// </summary>
/// <param name="info"></param>
/// <param name="tran"></param>
/// <param name="db"></param>
/// <returns></returns>
public int Edit(TB_DormArea info, DbTransaction tran, Database db)
{
DbCommand dbCommandWrapper = null;
string strUpdateSql = @"UPDATE TB_DormArea SET 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, "@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="mTB_DormArea"></param>
/// <param name="pager"></param>
/// <returns></returns>
public DataTable GetTable(TB_DormArea tb_DormArea, ref Pager pager)
{
return(_mTB_DormAreaDAL.GetTable(tb_DormArea, ref pager));
}
/// <summary>
/// 获取分页数据集合
/// </summary>
/// <param name="tb_DormArea"></param>
/// <param name="pager"></param>
/// <returns></returns>
public DataTable GetTable(TB_DormArea tb_DormArea, ref Pager pager)
{
DataTable dt = null;
DbCommand dbCommandWrapper = null;
try
{
string strSQL = @"select A.*,ISNULL(BB.Count, 0) Count,
case when A.[IsEnable] is null then '已启用'
when A.[IsEnable]='已禁用' then '已禁用'
when A.[IsEnable]='已启用' then '已启用'
else '已启用' end as IsEnable1
from tb_DormArea as A
left join (select DormAreaID ,Count(1) Count from TB_AssignDormArea Group by DormAreaID)
as BB on A.ID=BB.DormAreaID ";
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 B
on A.ID=B.[DormAreaID]
where 1=1");
strBuilder.AppendLine(" AND B.[UserID] = @UserID");
db.AddInParameter(dbCommandWrapper, "@UserID", DbType.Int32, ((TB_User)SessionHelper.Get(HttpContext.Current, TypeManager.User)).ID);
}
else
{
strBuilder.AppendLine(" where 1=1");
}
if (tb_DormArea.SiteID > 0)
{
strBuilder.AppendLine(" AND A.SiteID = @SiteID");
db.AddInParameter(dbCommandWrapper, "@SiteID", DbType.Int32, tb_DormArea.SiteID);
}
if (!string.IsNullOrEmpty(tb_DormArea.Name))
{
strBuilder.AppendLine(" AND A.NAME LIKE @NAME");
db.AddInParameter(dbCommandWrapper, "@NAME", DbType.String, "%" + tb_DormArea.Name + "%");
}
#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;
}
}
}
