public static List <mg_allpartModel> QueryListForPaging(string page, string pagesize, out string total)
{
total = "0";
List <mg_allpartModel> list = null;
string sql1 = @"select count(all_id) total from [mg_allpart];";
string sql2 = @"
SELECT top " + pagesize + @" [all_id]
,[all_no]
,[all_rateid]
,r.prop_name [all_ratename]
,[all_colorid]
,c.prop_name [all_colorname]
,[all_metaid]
,m.prop_name [all_metaname]
,[all_desc]
FROM [mg_allpart] a
left join mg_Property r on a.all_rateid=r.prop_id
left join mg_Property c on a.all_colorid=c.prop_id
left join mg_Property m on a.all_metaid=m.prop_id
where a.all_id < (
select top 1 all_id from
(select top ((" + page + @"-1)*" + pagesize + @") all_id from [mg_allpart] where all_id is not null order by all_id desc )t
order by all_id )
order by a.all_id desc
";
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_allpartModel>();
foreach (DataRow row in dt2.Rows)
{
mg_allpartModel model = new mg_allpartModel();
model.all_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "all_id"));
model.all_no = DataHelper.GetCellDataToStr(row, "all_no");
model.all_rateid = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "all_rateid"));
model.all_ratename = DataHelper.GetCellDataToStr(row, "all_ratename");
model.all_colorid = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "all_colorid"));
model.all_colorname = DataHelper.GetCellDataToStr(row, "all_colorname");
model.all_metaid = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "all_metaid"));
model.all_metaname = DataHelper.GetCellDataToStr(row, "all_metaname");
model.all_desc = DataHelper.GetCellDataToStr(row, "all_desc");
list.Add(model);
}
}
return(list);
}
public static List <mg_allpartModel> QueryAllPartListForPart()
{
List <mg_allpartModel> list = null;
string sql2 = @"
SELECT [all_id]
,[all_no]
,[all_rateid]
,r.prop_name [all_ratename]
,[all_colorid]
,c.prop_name [all_colorname]
,[all_metaid]
,m.prop_name [all_metaname]
,[all_desc]
FROM [mg_allpart] a
left join mg_Property r on a.all_rateid=r.prop_id
left join mg_Property c on a.all_colorid=c.prop_id
left join mg_Property m on a.all_metaid=m.prop_id
order by a.all_no
";
DataTable dt = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, System.Data.CommandType.Text, sql2, null);
if (DataHelper.HasData(dt))
{
DataTable dt2 = dt;
list = new List <mg_allpartModel>();
foreach (DataRow row in dt2.Rows)
{
mg_allpartModel model = new mg_allpartModel();
model.all_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "all_id"));
model.all_no = DataHelper.GetCellDataToStr(row, "all_no");
model.all_rateid = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "all_rateid"));
model.all_ratename = DataHelper.GetCellDataToStr(row, "all_ratename");
model.all_colorid = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "all_colorid"));
model.all_colorname = DataHelper.GetCellDataToStr(row, "all_colorname");
model.all_metaid = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "all_metaid"));
model.all_metaname = DataHelper.GetCellDataToStr(row, "all_metaname");
model.all_desc = DataHelper.GetCellDataToStr(row, "all_desc");
list.Add(model);
}
}
return(list);
}
void SaveAllPart()
{
string all_id = Request.Params["all_id"];
string all_rateid = Request.Params["all_rateid"];
string all_colorid = Request.Params["all_colorid"];
string all_metaid = Request.Params["all_metaid"];
string all_no = Request.Params["all_no"];
string all_desc = Request.Params["all_desc"];
mg_allpartModel model = new mg_allpartModel();
model.all_id = NumericParse.StringToInt(all_id);
model.all_rateid = NumericParse.StringToInt(all_rateid);
model.all_colorid = NumericParse.StringToInt(all_colorid);
model.all_metaid = NumericParse.StringToInt(all_metaid);
model.all_no = all_no;
model.all_desc = all_desc;
string json = mg_allpartBLL.SaveAllPart(model);
Response.Write(json);
Response.End();
}
private static string AddAllPart(mg_allpartModel model)
{
int count = mg_allpartDAL.AddAllPart(model);
return(count > 0 ? "true" : "false");
}
/*
*
* 姜任鹏
*
*/
public static string SaveAllPart(mg_allpartModel model)
{
return(model.all_id == 0 ? AddAllPart(model) : UpdateAllPart(model));
}
