private void BindData()
{
InspectItemBLL bll = null;
DataPage dp = new DataPage();
InspectItemEntity condition = new InspectItemEntity();
try
{
bll = BLLFactory.CreateBLL <InspectItemBLL>();
condition.ItemCode = this.ItemCode.Text;
condition.ItemName = this.ItemName.Text;
PagerHelper.InitPageControl(this.AspNetPager1, dp, true);
dp = bll.GetList(condition, dp);
List <InspectItemEntity> list = dp.Result as List <InspectItemEntity>;
this.GvList.DataSource = list;
this.GvList.DataBind();
for (int i = 0; i < this.GvList.Rows.Count; i++)
{
string click = string.Format("return edit('{0}');", this.GvList.DataKeys[i]["Id"].ToString());
(this.GvList.Rows[i].Cells[6].Controls[0] as WebControl).Attributes.Add("onclick", click);
}
PagerHelper.SetPageControl(AspNetPager1, dp, true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取查询语句
/// </summary>
/// <param name="condition">查询条件</param>
/// <param name="parameters">查询</param>
/// <returns>查询语句</returns>
private string GetQuerySql(InspectItemEntity condition, ref List <DataParameter> parameters)
{
StringBuilder sqlBuilder = new StringBuilder();
StringBuilder whereBuilder = new StringBuilder();
sqlBuilder.Append(" SELECT Id,ItemCode, ");
sqlBuilder.Append(" ItemName,Unit,PointCount,Remark, ");
sqlBuilder.Append(" CREATEUSER,CREATETIME,UPDATEUSER,UPDATETIME ");
sqlBuilder.Append(" FROM InspectItemInfo A ");
//查询条件
if (!string.IsNullOrEmpty(condition.ItemCode))
{
whereBuilder.Append(" AND ItemCode like @ItemCode");
parameters.Add(new DataParameter {
ParameterName = "ItemCode", DataType = DbType.String, Value = "%" + condition.ItemCode + "%"
});
}
//查询条件
if (string.IsNullOrEmpty(condition.ItemName) == false)
{
whereBuilder.Append(" AND ItemName like @ItemName");
parameters.Add(new DataParameter {
ParameterName = "ItemName", DataType = DbType.String, Value = "%" + condition.ItemName + "%"
});
}
if (whereBuilder.Length > 0)
{
sqlBuilder.Append(" WHERE " + whereBuilder.ToString().Substring(4));
}
return(sqlBuilder.ToString());
}
private void BindData()
{
string Id = Request.QueryString["Id"];
InspectItemBLL bll = null;
InspectItemEntity info = new InspectItemEntity();
try
{
bll = BLLFactory.CreateBLL <InspectItemBLL>();
if (string.IsNullOrEmpty(Id) == false)
{
info.Id = Id;
info = bll.Get(info);
UIBindHelper.BindForm(this.Page, info);
this.hiID.Value = info.Id;
this.ItemCode.Text = info.ItemCode;
this.ItemName.Text = info.ItemName;
this.Unit.Text = info.Unit;
this.PointCount.Text = info.PointCount + "";
this.Remark.Text = info.Remark;
this.HiCREATEUSER.Value = info.CreateUser;
this.HiCREATETIME.Value = info.CreateTime.ToString();
}
else
{
info = new InspectItemEntity();
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取监测项目列表
/// </summary>
/// <param name="condition">条件</param>
/// <param name="page">数据页</param>
/// <returns>数据页</returns>
public DataPage GetList(InspectItemEntity condition, DataPage page)
{
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
try
{
sql = this.GetQuerySql(condition, ref parameters);
//分页关键字段及排序
page.KeyName = "Id";
if (string.IsNullOrEmpty(page.SortExpression))
{
page.SortExpression = "ItemCode ASC";
}
using (IDataSession session = AppDataFactory.CreateMainSession())
{
page = session.GetDataPage <InspectItemEntity>(sql, parameters.ToArray(), page);
}
return(page);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 删除监测项目信息
/// </summary>
/// <param name="itemInfo">监测项目信息</param>
/// <returns>删除个数</returns>
public int Delete(InspectItemEntity itemInfo)
{
int count = 0;
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
session.OpenTs();
//删除监测项目信息
string sql = "DELETE FROM InspectItemInfo WHERE Id=@Id";
count = session.ExecuteSql(sql, new DataParameter {
ParameterName = "Id", DataType = DbType.String, Value = itemInfo.Id
});
session.CommitTs();
}
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取监测项目信息
/// </summary>
/// <param name="itemInfo">条件</param>
/// <returns>获取监测项目信息</returns>
public InspectItemEntity Get(InspectItemEntity itemInfo)
{
StringBuilder sqlBuilder = new StringBuilder();
StringBuilder whereBuilder = new StringBuilder();
List <DataParameter> parameters = new List <DataParameter>();
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
sqlBuilder.Append(" SELECT Id,ItemCode, ");
sqlBuilder.Append(" ItemName,Unit,PointCount,Remark, ");
sqlBuilder.Append(" CREATEUSER,CREATETIME,UPDATEUSER,UPDATETIME ");
sqlBuilder.Append(" FROM InspectItemInfo A WHERE Id = @Id ");
parameters.Add(new DataParameter {
ParameterName = "Id", DataType = DbType.String, Value = itemInfo.Id
});
itemInfo = session.Get <InspectItemEntity>(sqlBuilder.ToString(), parameters.ToArray());
}
return(itemInfo);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btSave_Click(object sender, EventArgs e)
{
InspectItemEntity info = new InspectItemEntity();
InspectItemBLL bll = null;
try
{
UIBindHelper.BindModelByControls(this.Page, info);
bll = BLLFactory.CreateBLL <InspectItemBLL>();
if (this.hiID.Value == "")
{
bll.Insert(info);
}
else
{
info.Id = this.hiID.Value;
bll.Update(info);
}
ClientScript.RegisterStartupScript(this.GetType(), "myjs", "parent.refreshData();parent.closeAppWindow1();", true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 插入监测项目信息
/// </summary>
/// <param name="itemInfo">监测项目信息</param>
/// <returns>插入数</returns>
public DataResult <int> Insert(InspectItemEntity itemInfo)
{
try
{
DataResult <int> result = new DataResult <int>();
InspectItemDAL cmdDAL = new InspectItemDAL();
if (ExistsInspectItem(itemInfo))
{
result.Msg = "名称已存在";
result.Result = -1;
return(result);
}
itemInfo.Id = Guid.NewGuid().ToString();
itemInfo.CreateUser = this.LoginUser.UserID;
itemInfo.CreateTime = DateTime.Now;
itemInfo.UpdateUser = itemInfo.CreateUser;
itemInfo.UpdateTime = itemInfo.CreateTime;
result.Result = new InspectItemDAL().Insert(itemInfo);
result.IsSuccess = true;
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取监测项目信息
/// </summary>
/// <param name="itemInfo">条件</param>
/// <returns>监测项目信息</returns>
public InspectItemEntity Get(InspectItemEntity itemInfo)
{
try
{
return(new InspectItemDAL().Get(itemInfo));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取用户信息列表
/// </summary>
/// <param name="condition">条件</param>
/// <param name="page">数据页</param>
/// <returns>数据页</returns>
public List <InspectItemEntity> GetAllItemInfo(InspectItemEntity condition)
{
try
{
return(new InspectItemDAL().GetAllItemInfo(condition));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取监测项目列表
/// </summary>
/// <param name="condition">条件</param>
/// <param name="page">数据页</param>
/// <returns>数据页</returns>
public DataPage GetList(InspectItemEntity condition, DataPage page)
{
try
{
return(new InspectItemDAL().GetList(condition, page));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 判断名称是否存在
/// </summary>
/// <param name="">信息</param>
/// <returns>true:已存在；fasel:不存在。</returns>
public bool ExistsInspectItem(InspectItemEntity model)
{
try
{
return(new InspectItemDAL().ExistsInspectItem(model));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 删除监测项目信息
/// </summary>
/// <param name="itemInfo">删除监测项目信息</param>
/// <returns>删除行数</returns>
public int Delete(InspectItemEntity itemInfo)
{
int count = 0;
try
{
count = new InspectItemDAL().Delete(itemInfo);
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取监测项目信息列表
/// </summary>
/// <param name="condition">条件</param>
/// <param name="page">数据页</param>
/// <returns>数据页</returns>
public List <InspectItemEntity> GetAllItemInfo(InspectItemEntity condition)
{
List <InspectItemEntity> itemInfo = null;
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
try
{
sql = this.GetQuerySql(condition, ref parameters);
using (IDataSession session = AppDataFactory.CreateMainSession())
{
itemInfo = session.GetList <InspectItemEntity>(sql, parameters.ToArray()).ToList();
}
return(itemInfo);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新监测项目信息
/// </summary>
/// <param name="itemInfo">监测项目信息</param>
/// <returns>更新个数</returns>
public int Update(InspectItemEntity itemInfo)
{
int count = 0;
try
{
using (var session = AppDataFactory.CreateMainSession())
{
session.OpenTs();
//更新基本信息
count = session.Update <InspectItemEntity>(itemInfo);
session.CommitTs();
}
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 插入监测项目信息
/// </summary>
/// <param name="itemInfo">监测项目信息</param>
/// <returns>插入数</returns>
public int Insert(InspectItemEntity itemInfo)
{
int count = 0;
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
session.OpenTs();
//插入基本信息
session.Insert <InspectItemEntity>(itemInfo);
session.CommitTs();
}
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新监测项目信息
/// </summary>
/// <param name="user">监测项目信息</param>
/// <returns>更新个数</returns>
public DataResult <int> Update(InspectItemEntity itemInfo)
{
try
{
DataResult <int> result = new DataResult <int>();
if (ExistsInspectItem(itemInfo))
{
result.Msg = "名称已存在";
result.Result = -1;
return(result);
}
itemInfo.UpdateUser = this.LoginUser.UserID;
itemInfo.UpdateTime = DateTime.Now;
result.Result = new InspectItemDAL().Update(itemInfo);
result.IsSuccess = true;
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 判断名称是否存在
/// </summary>
/// <param name="info"></param>
/// <returns>true:已存在；fasel:不存在。</returns>
public bool ExistsInspectItem(InspectItemEntity model)
{
StringBuilder sqlBuilder = new StringBuilder();
StringBuilder whereBuilder = new StringBuilder();
List <DataParameter> parameters = new List <DataParameter>();
int count = 0;
try
{
sqlBuilder.Append("SELECT COUNT(0) FROM inspectiteminfo");
whereBuilder.Append(" AND Id <> @Id ");
parameters.Add(new DataParameter {
ParameterName = "Id", DataType = DbType.String, Value = model.Id
});
if (!string.IsNullOrEmpty(model.ItemCode))
{
whereBuilder.Append(" AND ItemCode = @ItemCode ");
parameters.Add(new DataParameter {
ParameterName = "ItemCode", DataType = DbType.String, Value = model.ItemCode
});
}
if (whereBuilder.Length > 0)
{
sqlBuilder.Append(" WHERE " + whereBuilder.ToString().Substring(4));
}
using (IDataSession session = AppDataFactory.CreateMainSession())
{
count = Convert.ToInt32(session.ExecuteSqlScalar(sqlBuilder.ToString(), parameters.ToArray()));
}
return(count > 0);
}
catch (Exception ex)
{
throw ex;
}
}