public static List <mg_PoInspectItemModel> QueryListForPaging(string page, string pagesize, out string total)
{
total = "0";
List <mg_PoInspectItemModel> list = null;
string sql1 = @"select count(ID) total from [mg_PointInspection_Item];";
string sql2 = @" SELECT top " + pagesize + @" ID pid
,PI_Item
,PI_ItemDescribe
FROM [mg_PointInspection_Item]
where ID not in (
select top ((" + page + @"-1)*" + pagesize + @") ID from [mg_PointInspection_Item]
order by ID)
order by ID
";
DataSet ds = SqlHelper.GetDataSetTableMapping(SqlHelper.SqlConnString, System.Data.CommandType.Text, sql1 + sql2, new string[] { "count", "data" }, null);
if (DataHelper.HasData(ds))
{
DataTable dt1 = ds.Tables["count"];
total = DataHelper.GetCellDataToStr(dt1.Rows[0], "total");
DataTable dt2 = ds.Tables["data"];
list = new List <mg_PoInspectItemModel>();
foreach (DataRow row in dt2.Rows)
{
mg_PoInspectItemModel model = new mg_PoInspectItemModel();
model.pi_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "pid"));
model.piitem = DataHelper.GetCellDataToStr(row, "PI_Item");
model.piitemdescribe = DataHelper.GetCellDataToStr(row, "PI_ItemDescribe");
list.Add(model);
}
}
return(list);
}
void savePoInstpectItem()
{
string pi_id = Request.Params["pi_id"];
string piitem = Request.Params["piitem"];
string piitemdescribe = Request.Params["piitemdescribe"];
mg_PoInspectItemModel model = new mg_PoInspectItemModel();
model.pi_id = NumericParse.StringToInt(pi_id);
model.piitem = piitem;
model.piitemdescribe = piitemdescribe;
string json = mg_PoInspectItemBLL.savePoInstpectItem(model);
Response.Write(json);
Response.End();
}
public static int AddPoInstpectItem(mg_PoInspectItemModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into mg_PointInspection_Item(");
strSql.Append("PI_Item,PI_ItemDescribe)");
strSql.Append(" values (");
strSql.Append("@PI_Item,@PI_ItemDescribe)");
SqlParameter[] parameters =
{
new SqlParameter("@PI_Item", SqlDbType.NVarChar),
new SqlParameter("@PI_ItemDescribe", SqlDbType.NVarChar),
};
parameters[0].Value = model.piitem;
parameters[1].Value = model.piitemdescribe;
int rows = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, strSql.ToString(), parameters);
return(rows);
}
public static int UpdatePoInstpectItem(mg_PoInspectItemModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update mg_PointInspection_Item set ");
strSql.Append("PI_Item=@PI_Item,");
strSql.Append("PI_ItemDescribe=@PI_ItemDescribe");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int),
new SqlParameter("@PI_Item", SqlDbType.NVarChar),
new SqlParameter("@PI_ItemDescribe", SqlDbType.NVarChar),
};
parameters[0].Value = model.pi_id;
parameters[1].Value = model.piitem;
parameters[2].Value = model.piitemdescribe;
int rows = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, strSql.ToString(), parameters);
return(rows);
}
private static string UpdatePoInstpectItem(mg_PoInspectItemModel model)
{
int count = mg_PoInspectItemDAL.UpdatePoInstpectItem(model);
return(count > 0 ? "true" : "false");
}
public static string savePoInstpectItem(mg_PoInspectItemModel model)
{
return(model.pi_id == 0 ? AddPoInstpectItem(model) : UpdatePoInstpectItem(model));
}
