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); }