/// <summary>
/// 获取数据列表
/// </summary>
/// <returns></returns>
public List <SitePointInfo> GetList()
{
string cmdText = @"select * from [SitePoint] ";
List <SitePointInfo> list = new List <SitePointInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
SitePointInfo model = new SitePointInfo();
model.Id = reader["Id"];
model.PointName = reader["PointName"].ToString();
model.PointNum = decimal.Parse(reader["PointNum"].ToString());
model.Remark = reader["Remark"].ToString();
list.Add(model);
}
}
}
return(list);
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(SitePointInfo model)
{
if (model == null)
{
return(-1);
}
if (IsExist(model.PointName, model.Id))
{
return(110);
}
//定义查询命令
string cmdText = @"update [SitePoint] set PointName = @PointName,PointNum = @PointNum,Remark = @Remark where Id = @Id";
//创建查询命令参数集
SqlParameter[] parms =
{
new SqlParameter("@Id", SqlDbType.UniqueIdentifier),
new SqlParameter("@PointName", SqlDbType.NVarChar, 256),
new SqlParameter("@PointNum", SqlDbType.Decimal),
new SqlParameter("@Remark", SqlDbType.NVarChar, 300)
};
parms[0].Value = Guid.Parse(model.Id.ToString());
parms[1].Value = model.PointName;
parms[2].Value = model.PointNum;
parms[3].Value = model.Remark;
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms));
}
/// <summary>
/// 获取满足当前条件的数据列表
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="sqlWhere"></param>
/// <param name="cmdParms"></param>
/// <returns></returns>
public List <SitePointInfo> GetList(int pageIndex, int pageSize, string sqlWhere, params SqlParameter[] cmdParms)
{
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
string cmdText = @"select * from(select row_number() over(order by t1.Sort) as RowNumber,t1.Id,t1.PointName,t1.PointNum,t1.Remark from [SitePoint] t1 ";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += "where 1=1 " + sqlWhere;
}
cmdText += ")as objTable where RowNumber between " + startIndex + " and " + endIndex + " ";
List <SitePointInfo> list = new List <SitePointInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
SitePointInfo model = new SitePointInfo();
model.Id = reader["Id"];
model.PointName = reader["PointName"].ToString();
model.PointNum = decimal.Parse(reader["PointNum"].ToString());
model.Remark = reader["Remark"].ToString();
list.Add(model);
}
}
}
return(list);
}
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(SitePointInfo model)
{
if (model == null)
{
return(-1);
}
//判断当前记录是否存在，如果存在则返回;
if (IsExist(model.PointName, Guid.Empty))
{
return(110);
}
string cmdText = "insert into [SitePoint] (PointName,PointNum,Remark) values (@PointName,@PointNum,@Remark)";
//创建查询命令参数集
SqlParameter[] parms =
{
new SqlParameter("@PointName", SqlDbType.NVarChar, 50),
new SqlParameter("@PointNum", SqlDbType.Decimal),
new SqlParameter("@Remark", SqlDbType.NVarChar, 300)
};
parms[0].Value = model.PointName;
parms[1].Value = model.PointNum;
parms[2].Value = model.Remark;
//执行数据库操作
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms));
}
/// <summary>
/// 获取对应的数据
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public SitePointInfo GetModel(object Id)
{
SitePointInfo model = null;
string cmdText = @"select top 1 Id,PointName,PointNum,Remark from [SitePoint] where Id = @Id ";
SqlParameter parm = new SqlParameter("@Id", SqlDbType.UniqueIdentifier);
parm.Value = Guid.Parse(Id.ToString());
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parm))
{
if (reader != null)
{
while (reader.Read())
{
model = new SitePointInfo();
model.Id = reader["Id"];
model.PointName = reader["PointName"].ToString();
model.PointNum = decimal.Parse(reader["PointNum"].ToString());
model.Remark = reader["Remark"].ToString();
}
}
}
return(model);
}
private void OnSave()
{
string sName = txtName.Value.Trim();
if (string.IsNullOrWhiteSpace(sName))
{
MessageBox.Messager(this.Page, Page.Controls[0], "有“*”标识的为必填项，请检查");
return;
}
string sPointNum = txtPointNum.Value.Trim();
decimal pointNum = 0;
if (!decimal.TryParse(sPointNum, out pointNum))
{
MessageBox.Messager(this.Page, Page.Controls[0], "积分数输入值格式不正确，请检查");
return;
}
string sRemark = txtRemark.Value.Trim();
SitePointInfo model = new SitePointInfo();
model.PointName = sName;
model.PointNum = pointNum;
model.Remark = sRemark;
int effect = -1;
SitePoint bll = new SitePoint();
if (!gId.Equals(Guid.Empty))
{
model.Id = gId;
effect = bll.Update(model);
}
else
{
effect = bll.Insert(model);
}
if (effect == 110)
{
MessageBox.Messager(this.Page, Page.Controls[0], "已存在相同记录", "系统提示", "error");
return;
}
if (effect > 0)
{
MessageBox.MessagerShow(this.Page, Page.Controls[0], "操作成功");
}
else
{
MessageBox.Messager(this.Page, Page.Controls[0], "操作失败，请检查", "系统提示", "error");
}
}
private void Bind()
{
if (!gId.Equals(Guid.Empty))
{
SitePoint bll = new SitePoint();
SitePointInfo model = bll.GetModel(gId);
if (model != null)
{
txtName.Value = model.PointName;
txtPointNum.Value = model.PointNum.ToString();
txtRemark.Value = model.Remark;
}
}
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(SitePointInfo model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(SitePointInfo model)
{
return(dal.Insert(model));
}
