/// <summary>
/// 事务更新
/// </summary>
/// <param name="info"></param>
/// <param name="tran"></param>
/// <param name="db"></param>
/// <returns></returns>
public int Edit(TB_BU info, DbTransaction tran, Database db)
{
DbCommand dbCommandWrapper = null;
string strUpdateSql = @"UPDATE TB_BU SET Name=@Name 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, info.Name);
#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="info"></param>
/// <returns></returns>
public int Edit(TB_BU info)
{
try
{
Database db = DBO.CreateDatabase();
return(this.Edit(info, (DbTransaction)null, db));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="tb_BU"></param>
/// <returns></returns>
public int Edit(TB_BU tb_BU)
{
TB_BUDAL mTB_BUDAL = new TB_BUDAL();
//编辑
if (tb_BU.ID > 0)
{
return(mTB_BUDAL.Edit(tb_BU));
}
//添加
else
{
return(mTB_BUDAL.Create(tb_BU));
}
}
public DataTable GetTable(TB_BU tb_BU, ref Pager pager)
{
DataTable dt = null;
DbCommand dbCommandWrapper = null;
try
{
string strSQL = @"SELECT * FROM [TB_BU] 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_BU.SiteID);
if (!string.IsNullOrEmpty(tb_BU.Name))
{
strBuilder.AppendLine(" AND Name like @Name");
db.AddInParameter(dbCommandWrapper, "@Name", DbType.String, "%" + tb_BU.Name + "%");
}
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>
/// 根据ID获取对象
/// </summary>
/// <param name="intID"></param>
/// <returns></returns>
public TB_BU Get(int intID)
{
DataTable dt = new TB_BUDAL().Get(intID);
var query = (from v in dt.AsEnumerable()
select new
{
ID = v.Field <int>(TB_BU.col_ID),
Name = v.Field <string>(TB_BU.col_Name),
SiteID = v.Field <int>(TB_BU.col_SiteID),
}).ToList();
TB_BU mTB_BU = new TB_BU();
mTB_BU.ID = query.FirstOrDefault().ID;
mTB_BU.Name = query.FirstOrDefault().Name;
mTB_BU.SiteID = query.FirstOrDefault().SiteID;
return(mTB_BU);
}
private void BindBu()
{
TB_BU mTB_BU = new TB_BU();
BUBLL mBUBLL = new BUBLL();
Pager pager = null;
mTB_BU.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
var dtSource = mBUBLL.GetPagerData(mTB_BU, ref pager);
this.ddlBu.DataValueField = TB_BU.col_ID;
this.ddlBu.DataTextField = TB_BU.col_Name;
this.ddlBu.DataSource = dtSource;
this.ddlBu.DataBind();
this.ddlBu.Items.Insert(0, new ListItem()
{
Value = "0", Text = "--请选择--"
});
}
protected void btnSave_Click(object sender, EventArgs e)
{
TB_BU tb_BU = new TB_BU();
tb_BU.Name = this.txtBU.Text.Trim();
tb_BU.ID = Request.QueryString["id"] == null ? 0 : Convert.ToInt32(Request.QueryString["id"]);
tb_BU.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
try
{
new BUBLL().Edit(tb_BU);
Page.ClientScript.RegisterStartupScript(this.GetType(), "complete", "<script>saveComplete();</script>");
}
catch (Exception ex)
{
if (ex is System.Data.SqlClient.SqlException)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "error", "<script>alert('名称重复')</script>");
}
}
}
private void Bind(int intCurrentIndex)
{
TB_BU mTB_BU = new TB_BU();
BUBLL mBUBLL = new BUBLL();
Pager pager = new Pager();
DataTable dtSource = null;
pager.CurrentPageIndex = intCurrentIndex;
pager.srcOrder = " ID asc";
mTB_BU.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
mTB_BU.Name = this.txtBU.Text.Trim();
dtSource = mBUBLL.GetPagerData(mTB_BU, ref pager);
GridView1.DataSource = dtSource;
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>
/// <param name="tran"></param>
/// <param name="db"></param>
/// <returns></returns>
public int Create(TB_BU info, DbTransaction tran, Database db)
{
DbCommand dbCommandWrapper = null;
int intId;
string strInsertSql = "INSERT INTO TB_BU(SiteID,Name) VALUES(@SiteID,@Name)";
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, info.Name);
#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_Role"></param>
/// <param name="pager"></param>
/// <returns></returns>
public DataTable GetPagerData(TB_BU tb_BU, ref Pager pager)
{
return(new TB_BUDAL().GetTable(tb_BU, ref pager));
}
