public static List <px_InternetPrinterModel> QueryInternetPrinterListForPart()
{
List <px_InternetPrinterModel> list = null;
string sql2 = @"
SELECT [IID]
,[IName]
,[PrintIP] ,[IAddTime],[IRole],[IRamark]
FROM [px_InternetPrinter]
order by IID asc
";
DataTable dt = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, System.Data.CommandType.Text, sql2, null);
if (DataHelper.HasData(dt))
{
DataTable dt2 = dt;
list = new List <px_InternetPrinterModel>();
foreach (DataRow row in dt2.Rows)
{
px_InternetPrinterModel model = new px_InternetPrinterModel();
model.IID = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "IID"));
model.IName = DataHelper.GetCellDataToStr(row, "IName");
model.PrintIP = DataHelper.GetCellDataToStr(row, "PrintIP");
model.IAddTime = DataHelper.GetCellDataToStr(row, "IAddTime");
model.IRole = DataHelper.GetCellDataToStr(row, "IRole");
model.IRamark = DataHelper.GetCellDataToStr(row, "IRamark");
list.Add(model);
}
}
return(list);
}
public static List <px_InternetPrinterModel> QueryListForPaging(string page, string pagesize, out string total)
{
total = "0";
List <px_InternetPrinterModel> list = null;
string sql1 = @"select count(IID) total from [px_InternetPrinter];";
string sql2 = @"
SELECT top " + pagesize + @" [IID]
,[IName]
,[PrintIP] , [IAddTime], [IRole], [IRamark]
FROM [px_InternetPrinter]
where IID > (
select top 1 IID from
(select top ((" + page + @"-1)*" + pagesize + @") IID from [px_InternetPrinter] where IID is not null order by IID asc )t
order by IID desc)
order by IID 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_InternetPrinterModel>();
foreach (DataRow row in dt2.Rows)
{
px_InternetPrinterModel model = new px_InternetPrinterModel();
model.IID = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "IID"));
model.IName = DataHelper.GetCellDataToStr(row, "IName");
model.PrintIP = DataHelper.GetCellDataToStr(row, "PrintIP");
model.IAddTime = DataHelper.GetCellDataToStr(row, "IAddTime");
model.IRole = DataHelper.GetCellDataToStr(row, "IRole");
model.IRamark = DataHelper.GetCellDataToStr(row, "IRamark");
list.Add(model);
}
}
return(list);
}
private static string AddInternetPrinter(px_InternetPrinterModel model)
{
int count = px_InternetPrinterDAL.AddInternetPrinter(model);
return(count > 0 ? "true" : "false");
}
public static string SaveInternetPrinter(px_InternetPrinterModel model)
{
return(model.IID == 0 ? AddInternetPrinter(model) : UpdateInternetPrinter(model));
}
