public static List <px_PanrameterModel> QueryPanrameterListForPart()
{
List <px_PanrameterModel> list = null;
string sql2 = @"
SELECT [SerialID]
,[Name]
,[Number]
FROM [px_Panrameter]
order by SerialID asc
";
DataTable dt = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, System.Data.CommandType.Text, sql2, null);
if (DataHelper.HasData(dt))
{
DataTable dt2 = dt;
list = new List <px_PanrameterModel>();
foreach (DataRow row in dt2.Rows)
{
px_PanrameterModel model = new px_PanrameterModel();
model.SerialID = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "SerialID"));
model.Name = DataHelper.GetCellDataToStr(row, "Name");
model.Number = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "Number"));
list.Add(model);
}
}
return(list);
}
void SavePanrameter()
{
string SerialID = Request.Params["SerialID"];
string Name = Request.Params["Name"];
string Number = Request.Params["Number"];
px_PanrameterModel model = new px_PanrameterModel();
model.SerialID = NumericParse.StringToInt(SerialID);
model.Name = Name;
model.Number = NumericParse.StringToInt(Number);
string json = px_PanrameterBLL.SavePanrameter(model);
Response.Write(json);
Response.End();
}
public static List <px_PanrameterModel> QueryListForPaging(string page, string pagesize, out string total)
{
total = "0";
List <px_PanrameterModel> list = null;
string sql1 = @"select count(SerialID) total from [px_Panrameter];";
string sql2 = @"
SELECT top " + pagesize + @" [SerialID]
,[Name]
,[Number]
FROM [px_Panrameter]
where SerialID > (
select top 1 SerialID from
(select top ((" + page + @"-1)*" + pagesize + @") SerialID from [px_Panrameter] where SerialID is not null order by SerialID asc )t
order by SerialID desc)
order by SerialID asc
";
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 <px_PanrameterModel>();
foreach (DataRow row in dt2.Rows)
{
px_PanrameterModel model = new px_PanrameterModel();
model.SerialID = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "SerialID"));
model.Name = DataHelper.GetCellDataToStr(row, "Name");
model.Number = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "Number"));
list.Add(model);
}
}
return(list);
}
public static List <px_PanrameterModel> QueryListForFirstPage(string pagesize, out string total)
{
total = "0";
List <px_PanrameterModel> list = null;
string sql1 = @"select count(SerialID) total from [px_Panrameter];";
string sql2 = @"
SELECT top " + pagesize + @" [SerialID]
,[Name]
,[Number]
FROM [px_Panrameter]
order by SerialID asc
";
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 <px_PanrameterModel>();
foreach (DataRow row in dt2.Rows)
{
px_PanrameterModel model = new px_PanrameterModel();
model.SerialID = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "SerialID"));
model.Name = DataHelper.GetCellDataToStr(row, "Name");
model.Number = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "Number"));
var sendbtnvalue = "";
var printbtnvalue = "";
var ascdescbtnvalue = "";
if (GetBtnClass.BtnClassList == null)
{
GetBtnClass gbc = new GetBtnClass();
// GetBtnClass.BtnClassList = new List<OrderList>(GetBtnClass.BtnClassList);
}
else
{
GetBtnClass.BtnClassList = new List <OrderList>(GetBtnClass.BtnClassList);
}
foreach (var item in GetBtnClass.BtnClassList)
{
if (item.SortName.Equals(model.Name))
{
sendbtnvalue = item.IsAutoSend ? "开启" : "关闭";
printbtnvalue = item.IsAutoPrint ? "开启" : "关闭";
ascdescbtnvalue = item.Ascordesc ? "开启" : "关闭";
model.IsAutoPrint = item.IsAutoPrint;
model.IsAutoSend = item.IsAutoSend;
model.Ascordesc = item.Ascordesc;
}
}
model.IsAutoPrint1 = printbtnvalue;
model.IsAutoSend1 = sendbtnvalue;
model.Ascordesc1 = ascdescbtnvalue;
list.Add(model);
}
}
return(list);
}
