/// <summary>
/// 查询列表（带分页）。返回List
/// </summary>
/// <param name="m">s_系列</param>
/// <param name="p">Model.Pages</param>
/// <param name="Rc">返回记录总条数</param>
public static List <Model.Uploadfile> Select_List(Model.Uploadfile m, ref Model.Pages p, ref long Rc)
{
#region ==返回参数处理==
string[] return_value = Common.Functions.Parameters_Filter(m.s_Total_parameter, m.s_Main_parameter, m.s_Extended_parameter, demand);
m.s_Main_parameter = return_value[0];
m.s_Extended_parameter = return_value[1];
#endregion
DataTable dt = Dal.Uploadfile.Select_List(ref p, ref Rc, m.s_Main_parameter, m.s_Extended_parameter, m.s_Uid, m.s_Uid_not, m.s_Order);
DataRow dr;
List <Model.Uploadfile> l = new List <Model.Uploadfile>();
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
m = new Model.Uploadfile();
#region ==主参数==
if (Common.Functions.checkHave(return_value[0], "Uid"))
{
m.Uid = Common.Functions.ConvertInt16(dr["Uid"], 0);
}
if (Common.Functions.checkHave(return_value[0], "Url"))
{
m.Url = dr["Url"].ToString();
}
#endregion
l.Add(m);
}
dt.Dispose();
return(l);
}
public ActionResult GetJQGridJson(int rows, int page, string sidx, string sord, string queryJson = "")
{
Model.Article query = new Model.Article();
if (!string.IsNullOrEmpty(queryJson))
{
query = Newtonsoft.Json.JsonConvert.DeserializeObject <Model.Article>(queryJson);
}
#region ==获得记录==
l_article = new List <Model.Article>();
p = new Model.Pages();
p.Page = page;
p.Ps = rows;
m = new Model.Article();
m.s_Alive = query.s_Alive;
m.s_Hot = s_hot;
m.s_Recommend = s_recommend;
m.s_d1 = d1;
m.s_d2 = d2;
m.s_Keywords = query.s_Keywords;
m.s_Kind = Kind.ToString();
m.s_Asid = Asid;
m.s_Order = sidx + " " + sord;
m.s_Main_parameter = "Aid,Atitle,Url,Source,Author,Alive,Kind,Layer,Ainfo,Atime,Pic1,Pic2,Summary,Hot,Recommend,Asid,ieTitle,seoKeywords,seoDescription";
m.s_Extended_parameter = "Stitle";
l_article = Bll.Article.Select_List(m, ref p, ref Rc);
#endregion
return(Json(new { page = p.Page.ToString(), total = p.Pc, records = Rc.ToString(), rows = l_article }));
}
/// <summary>
/// Осуществляет переход на указанную страницу
/// </summary>
/// <param name="uri"></param>
private void Navigate(Model.Pages page)
{
if (page.Equals(Pages.Exit))
{
this.Close();
}
frDisplay.Navigate(new Uri(page.GetUri(), UriKind.RelativeOrAbsolute));
}
/// <summary>
/// 查询列表（带分页）。返回List
/// </summary>
/// <param name="m">s_系列</param>
/// <param name="p">Model.Pages</param>
/// <param name="Rc">返回记录总条数</param>
public static List <Model.ArticleSort> Select_List(ref Model.Pages p, Model.ArticleSort m, ref long Rc)
{
#region ==返回参数处理==
string[] return_value = Common.Functions.Parameters_Filter(m.s_Total_parameter, m.s_Main_parameter, m.s_Extended_parameter, demand);
m.s_Main_parameter = return_value[0];
m.s_Extended_parameter = return_value[1];
#endregion
DataTable dt = Dal.ArticleSort.Select_List(ref p, ref Rc, m.s_Main_parameter, m.s_Extended_parameter, m.s_Keywords, m.s_Asid, m.s_Kind, m.s_Alive, m.s_Order);
DataRow dr;
List <Model.ArticleSort> l = new List <Model.ArticleSort>();
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
m = new Model.ArticleSort();
#region ==主参数==
if (Common.Functions.checkHave(return_value[0], "Asid"))
{
m.Asid = Common.Functions.ConvertInt64(dr["Asid"], 0);
}
if (Common.Functions.checkHave(return_value[0], "Stitle"))
{
m.Stitle = dr["Stitle"].ToString();
}
if (Common.Functions.checkHave(return_value[0], "Layer"))
{
m.Layer = Common.Functions.ConvertInt64(dr["Layer"], 0);
}
if (Common.Functions.checkHave(return_value[0], "Alive"))
{
m.Alive = Convert.ToBoolean(dr["Alive"]);
}
if (Common.Functions.checkHave(return_value[0], "Kind"))
{
m.Kind = Common.Functions.ConvertInt32(dr["Kind"], 0);
}
#endregion
l.Add(m);
}
dt.Dispose();
return(l);
}
/// <summary>
/// 查询列表（带分页）。返回List
/// </summary>
/// <param name="m">s_系列</param>
/// <param name="p">Model.Pages</param>
/// <param name="Rc">返回表记录总数量</param>
public static List <Model.LawyerFirst> Select_List(Model.LawyerFirst m, ref Model.Pages p, ref long Rc)
{
#region ==返回参数处理==
string[] return_value = Common.Functions.Parameters_Filter(m.s_Total_parameter, m.s_Main_parameter, m.s_Extended_parameter, demand);
m.s_Main_parameter = return_value[0];
m.s_Extended_parameter = return_value[1];
#endregion
DataTable dt = Dal.LawyerFirst.Select_List(ref p, m.s_Main_parameter, m.s_Extended_parameter, m.s_Keywords, m.s_Lid, m.s_Order, ref Rc);
DataRow dr;
List <Model.LawyerFirst> l = new List <Model.LawyerFirst>();
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
m = new Model.LawyerFirst();
#region 主参数
if (Common.Functions.checkHave(return_value[0], "Lid"))
{
m.Lid = Common.Functions.ConvertInt64(dr["Lid"]);
}
if (Common.Functions.checkHave(return_value[0], "Pic1"))
{
m.Pic1 = Common.Functions.ConvertString(dr["Pic1"]);
}
if (Common.Functions.checkHave(return_value[0], "Lname"))
{
m.Lname = dr["Lname"].ToString();
}
if (Common.Functions.checkHave(return_value[0], "Summary"))
{
m.Summary = Common.Functions.ConvertString(dr["Summary"]);
}
if (Common.Functions.checkHave(return_value[0], "Linfo"))
{
m.Linfo = Common.Functions.ConvertString(dr["Linfo"]);
}
#endregion
l.Add(m);
}
dt.Dispose();
return(l);
}
public static DataTable Select_List(ref Model.Pages p, ref long Rc, string Main_parameter, string Extended_parameter, string Keywords, string Asid, string Kind, int Alive, string Order)
{
#region ==null判断==
if (p.Page < 1)
{
p.Page = 1;
}
if (p.Pname == null)
{
p.Pname = "p";
}
if (p.Tp == null)
{
p.Tp = p.Pname;
}
if (p.Previous == null)
{
p.Previous = "上一页";
}
if (p.Next == null)
{
p.Next = "下一页";
}
if (p.pageName == null)
{
p.pageName = "页";
}
if (p.sk == null)
{
p.sk = "";
}
if (p.method == null)
{
p.method = "get";
}
if (Main_parameter == null)
{
Main_parameter = "";
}
if (Extended_parameter == null)
{
Extended_parameter = "";
}
if (Keywords == null)
{
Keywords = "";
}
if (Asid == null)
{
Asid = "";
}
if (Kind == null)
{
Kind = "";
}
if (Order == null)
{
Order = "";
}
#endregion
Common.Config cfg = new Common.Config();
cfg.connDb();
SqlCommand sc = new SqlCommand("zzlh2017_ArticleSort_Select", cfg.Conn);
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@Page", SqlDbType.Int).Value = p.Page;
sc.Parameters.Add("@Ps", SqlDbType.SmallInt).Value = p.Ps;
sc.Parameters.Add("@Main_parameter", SqlDbType.VarChar, 8000).Value = Main_parameter;
sc.Parameters.Add("@Extended_parameter", SqlDbType.VarChar, 8000).Value = Extended_parameter;
sc.Parameters.Add("@Keywords", SqlDbType.VarChar, 8000).Value = Keywords;
sc.Parameters.Add("@Asid", SqlDbType.VarChar, 8000).Value = Asid;
sc.Parameters.Add("@Kind", SqlDbType.VarChar, 8000).Value = Kind;
sc.Parameters.Add("@Alive", SqlDbType.SmallInt).Value = Alive;
sc.Parameters.Add("@Order", SqlDbType.VarChar, 200).Value = Order;
IDataParameter parameters_Rc = new SqlParameter("@Rc", SqlDbType.BigInt, 8);
parameters_Rc.Direction = ParameterDirection.Output;
sc.Parameters.Add(parameters_Rc);
SqlDataAdapter da = new SqlDataAdapter(sc);
DataTable dt = new DataTable();
da.Fill(dt);
Rc = Common.Functions.ConvertInt64(parameters_Rc.Value, 0);
da.Dispose();
sc.Dispose();
cfg.closeDb();
#region 分页
if (p.Ps == 0)
{
p.page_str = " ";
}
else
{
int Pc = Common.Functions.ConvertInt16(Rc / p.Ps, 0);
if (Rc % p.Ps != 0)
{
Pc++;
}
p.page_str = Common.Functions.Pagination(Pc, p.Page, p.Tp, p.Pname, p.Previous, p.Next, p.pageName, p.inputHeight, p.sk, p.method);
}
#endregion
return(dt);
dt.Dispose();
}
public static DataTable Select_List(ref Model.Pages p, string Keywords, string Auid, int Alive, string Aulid, string Order, string Main_parameter, string Extended_parameter, ref long Rc)
{
if (p.Page < 1)
{
p.Page = 1;
}
if (p.Pname == null)
{
p.Pname = "p";
}
if (p.Tp == null)
{
p.Tp = p.Pname;
}
if (p.Previous == null)
{
p.Previous = "ÉÏÒ»Ò³";
}
if (p.Next == null)
{
p.Next = "ÏÂÒ»Ò³";
}
if (p.pageName == null)
{
p.pageName = "Ò³";
}
if (p.sk == null)
{
p.sk = "";
}
if (p.method == null)
{
p.method = "get";
}
if (Keywords == null)
{
Keywords = "";
}
if (Auid == null)
{
Auid = "";
}
if (Aulid == null)
{
Aulid = "";
}
if (Order == null)
{
Order = "";
}
if (Extended_parameter == null)
{
Extended_parameter = "";
}
if (Main_parameter == null)
{
Main_parameter = "";
}
Common.Config cfg = new Common.Config();
cfg.connDb();
SqlCommand sc = new SqlCommand("zzlh2017_adminUsers_Select", cfg.Conn);
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@Page", SqlDbType.Int).Value = p.Page;
sc.Parameters.Add("@Ps", SqlDbType.SmallInt).Value = p.Ps;
sc.Parameters.Add("@Keywords", SqlDbType.VarChar, 8000).Value = Keywords;
sc.Parameters.Add("@Auid", SqlDbType.VarChar, 8000).Value = Auid;
sc.Parameters.Add("@Aulid", SqlDbType.VarChar, 8000).Value = Aulid;
sc.Parameters.Add("@Alive", SqlDbType.SmallInt).Value = Alive;
sc.Parameters.Add("@Auid_not", SqlDbType.VarChar, 8000).Value = "";
sc.Parameters.Add("@Auser", SqlDbType.VarChar, 20).Value = "";
sc.Parameters.Add("@Passwd", SqlDbType.VarChar, 32).Value = "";
sc.Parameters.Add("@Order", SqlDbType.VarChar, 200).Value = Order;
sc.Parameters.Add("@Token", SqlDbType.VarChar, 8000).Value = "";
sc.Parameters.Add("@New_Token", SqlDbType.VarChar, 8000).Value = "";
sc.Parameters.Add("@New_Token_expiry", SqlDbType.VarChar, 100).Value = "";
sc.Parameters.Add("@New_Token_IP", SqlDbType.VarChar, 8000).Value = "";
sc.Parameters.Add("@Main_parameter", SqlDbType.VarChar, 8000).Value = Main_parameter;
sc.Parameters.Add("@Extended_parameter", SqlDbType.VarChar, 8000).Value = Extended_parameter;
IDataParameter parameters_Rc = new SqlParameter("@Rc", SqlDbType.BigInt, 8);
parameters_Rc.Direction = ParameterDirection.Output;
sc.Parameters.Add(parameters_Rc);
SqlDataAdapter da = new SqlDataAdapter(sc);
DataTable dt = new DataTable();
da.Fill(dt);
Rc = Common.Functions.ConvertInt64(parameters_Rc.Value, 0);
da.Dispose();
sc.Dispose();
cfg.closeDb();
#region ==·ÖÒ³==
if (p.Ps == 0)
{
p.page_str = " ";
}
else
{
p.Pc = Common.Functions.ConvertInt16(Rc / p.Ps, 0);
if (Rc % p.Ps != 0)
{
p.Pc++;
}
if (p.PageStyle == 0)
{
p.page_str = Common.Functions.Pagination(p.Pc, p.Page, p.Tp, p.Pname, p.Previous, p.Next, p.pageName, p.inputHeight, p.sk, p.method);
}
else if (p.PageStyle == 1)
{
p.page_str = Common.Functions.Pagination1(p.Pc, p.Page, p.Tp, p.Pname, p.First, p.Last, p.Previous, p.Next, p.pageName, p.sk, p.c);
}
}
#endregion
return(dt);
dt.Dispose();
}
public static DataTable Select_List(ref Model.Pages p, string Main_parameter, string Extended_parameter, string Keywords, string Kind, int Alive, string d1, string d2, string Aid, string Asid, string Order, int Hot, int Recommend, ref long Rc)
{
if (p.Page < 1)
{
p.Page = 1;
}
if (p.Pname == null)
{
p.Pname = "p";
}
if (p.Tp == null)
{
p.Tp = p.Pname;
}
if (p.Previous == null)
{
p.Previous = "上一页";
}
if (p.Next == null)
{
p.Next = "下一页";
}
if (p.pageName == null)
{
p.pageName = "页";
}
if (p.sk == null)
{
p.sk = "";
}
if (p.method == null)
{
p.method = "get";
}
if (Keywords == null)
{
Keywords = "";
}
if (Kind == null)
{
Kind = "";
}
if (d1 == null)
{
d1 = "";
}
if (d2 == null)
{
d2 = "";
}
if (Aid == null)
{
Aid = "";
}
if (Asid == null)
{
Asid = "";
}
if (Order == null)
{
Order = "";
}
Common.Config cfg = new Common.Config();
cfg.connDb();
SqlCommand sc = new SqlCommand("zzlh2017_Article_Select", cfg.Conn);
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@Page", SqlDbType.Int).Value = p.Page;
sc.Parameters.Add("@Ps", SqlDbType.SmallInt).Value = p.Ps;
sc.Parameters.Add("@Main_parameter", SqlDbType.VarChar, 8000).Value = Main_parameter;
sc.Parameters.Add("@Extended_parameter", SqlDbType.VarChar, 8000).Value = Extended_parameter;
sc.Parameters.Add("@Order", SqlDbType.VarChar, 200).Value = Order;
sc.Parameters.Add("@Aid", SqlDbType.VarChar, 8000).Value = Aid;
sc.Parameters.Add("@Asid", SqlDbType.VarChar, 8000).Value = Asid;
sc.Parameters.Add("@Keywords", SqlDbType.VarChar, 8000).Value = Keywords;
sc.Parameters.Add("@Alive", SqlDbType.SmallInt).Value = Alive;
sc.Parameters.Add("@Hot", SqlDbType.SmallInt).Value = Hot;
sc.Parameters.Add("@Recommend", SqlDbType.SmallInt).Value = Recommend;
sc.Parameters.Add("@Kind", SqlDbType.VarChar, 8000).Value = Kind;
sc.Parameters.Add("@d1", SqlDbType.VarChar, 20).Value = d1;
sc.Parameters.Add("@d2", SqlDbType.VarChar, 20).Value = d2;
sc.Parameters.Add("@rc", SqlDbType.BigInt).Direction = ParameterDirection.Output;
sc.ExecuteNonQuery();
Rc = Common.Functions.ConvertInt64(sc.Parameters["@rc"].Value, 0);
SqlDataAdapter da = new SqlDataAdapter(sc);
DataTable dt = new DataTable();
da.Fill(dt);
da.Dispose();
sc.Dispose();
cfg.closeDb();
if (p.Ps == 0)
{
p.page_str = " ";
}
else
{
p.Pc = Common.Functions.ConvertInt16(Rc / p.Ps, 0);
if (Rc % p.Ps != 0)
{
p.Pc++;
}
if (p.PageStyle == 0)
{
p.page_str = Common.Functions.Pagination(p.Pc, p.Page, p.Tp, p.Pname, p.Previous, p.Next, p.pageName, p.inputHeight, p.sk, p.method);
}
else if (p.PageStyle == 1)
{
p.page_str = Common.Functions.Pagination1(p.Pc, p.Page, p.Tp, p.Pname, p.First, p.Last, p.Previous, p.Next, p.pageName, p.sk, p.c);
}
}
return(dt);
dt.Dispose();
}
/// <summary>
/// 查询列表（带分页）。返回List
/// </summary>
/// <param name="m">s_系列</param>
/// <param name="p">Model.Pages</param>
/// <param name="Rc">返回表记录总数量</param>
public static List <Model.Article> Select_List(Model.Article m, ref Model.Pages p, ref long Rc)
{
#region ==返回参数处理==
string[] return_value = Common.Functions.Parameters_Filter(m.s_Total_parameter, m.s_Main_parameter, m.s_Extended_parameter, demand);
m.s_Main_parameter = return_value[0];
m.s_Extended_parameter = return_value[1];
#endregion
DataTable dt = Dal.Article.Select_List(ref p, m.s_Main_parameter, m.s_Extended_parameter, m.s_Keywords, m.s_Kind, m.s_Alive, m.s_d1, m.s_d2, m.s_Aid, m.s_Asid, m.s_Order, m.s_Hot, m.s_Recommend, ref Rc);
DataRow dr;
List <Model.Article> l = new List <Model.Article>();
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
m = new Model.Article();
#region 主参数
if (Common.Functions.checkHave(return_value[0], "Aid"))
{
m.Aid = Common.Functions.ConvertInt64(dr["Aid"]);
}
if (Common.Functions.checkHave(return_value[0], "Atitle"))
{
m.Atitle = Common.Functions.ConvertString(dr["Atitle"]);
}
if (Common.Functions.checkHave(return_value[0], "Url"))
{
m.Url = dr["Url"].ToString();
}
if (Common.Functions.checkHave(return_value[0], "Source"))
{
m.Source = Common.Functions.ConvertString(dr["Source"]);
}
if (Common.Functions.checkHave(return_value[0], "Author"))
{
m.Author = Common.Functions.ConvertString(dr["Author"]);
}
if (Common.Functions.checkHave(return_value[0], "Alive"))
{
m.Alive = Convert.ToBoolean(dr["Alive"]);
}
if (Common.Functions.checkHave(return_value[0], "Hot"))
{
m.Hot = Convert.ToBoolean(dr["Hot"]);
}
if (Common.Functions.checkHave(return_value[0], "Recommend"))
{
m.Recommend = Convert.ToBoolean(dr["Recommend"]);
}
if (Common.Functions.checkHave(return_value[0], "Kind"))
{
m.Kind = Common.Functions.ConvertInt16(dr["Kind"], 0);
}
if (Common.Functions.checkHave(return_value[0], "Layer"))
{
m.Layer = Common.Functions.ConvertInt64(dr["Layer"], 0);
}
if (Common.Functions.checkHave(return_value[0], "Ainfo"))
{
m.Ainfo = dr["Ainfo"].ToString();
}
if (Common.Functions.checkHave(return_value[0], "Atime"))
{
m.Atime = Common.Functions.ConvertDateTime(dr["Atime"], Convert.ToDateTime(Common.Para.dt_def));
}
if (Common.Functions.checkHave(return_value[0], "Pic1"))
{
m.Pic1 = dr["Pic1"].ToString();
}
if (Common.Functions.checkHave(return_value[0], "Pic2"))
{
m.Pic2 = dr["Pic2"].ToString();
}
if (Common.Functions.checkHave(return_value[0], "Summary"))
{
m.Summary = dr["Summary"].ToString();
}
if (Common.Functions.checkHave(return_value[0], "Asid"))
{
m.Asid = Common.Functions.ConvertInt64(dr["Asid"]);
}
if (Common.Functions.checkHave(return_value[0], "ieTitle"))
{
m.ieTitle = dr["ieTitle"].ToString();
}
if (Common.Functions.checkHave(return_value[0], "seoKeywords"))
{
m.seoKeywords = dr["seoKeywords"].ToString();
}
if (Common.Functions.checkHave(return_value[0], "seoDescription"))
{
m.seoDescription = dr["seoDescription"].ToString();
}
#endregion
#region 扩展参数
if (Common.Functions.checkHave(return_value[1], "Stitle"))
{
m.Stitle = dr["Stitle"].ToString();
}
#endregion
l.Add(m);
}
dt.Dispose();
return(l);
}
/// <summary>
/// 查询列表（带分页）。返回List
/// </summary>
/// <param name="m">s_系列</param>
/// <param name="p">Model.Pages</param>
/// <param name="Rc">返回记录总条数</param>
public static List <Model.adminUsers> Select_List(ref Model.Pages p, Model.adminUsers m, ref long Rc)
{
#region ==返回参数处理==
string[] return_value = Common.Functions.Parameters_Filter(m.s_Total_parameter, m.s_Main_parameter, m.s_Extended_parameter, demand);
m.s_Main_parameter = return_value[0];
m.s_Extended_parameter = return_value[1];
#endregion
DataTable dt = Dal.adminUsers.Select_List(ref p, m.s_Keywords, m.s_Auid, m.s_Alive, m.s_Aulid, m.s_Order, m.s_Main_parameter, m.s_Extended_parameter, ref Rc);
DataRow dr;
List <Model.adminUsers> l = new List <Model.adminUsers>();
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
m = new Model.adminUsers();
#region ==主参数==
if (Common.Functions.checkHave(return_value[0], "Auid"))
{
m.Auid = Common.Functions.ConvertInt64(dr["Auid"], 0);
}
if (Common.Functions.checkHave(return_value[0], "Auser"))
{
m.Auser = dr["Auser"].ToString();
}
if (Common.Functions.checkHave(return_value[0], "Passwd"))
{
m.Passwd = dr["Passwd"].ToString();
}
if (Common.Functions.checkHave(return_value[0], "Aulid"))
{
m.Aulid = Common.Functions.ConvertInt32(dr["Aulid"], 0);
}
if (Common.Functions.checkHave(return_value[0], "Alive"))
{
m.Alive = Convert.ToBoolean(dr["Alive"]);
}
if (Common.Functions.checkHave(return_value[0], "Token"))
{
m.Token = dr["Token"].ToString();
}
if (Common.Functions.checkHave(return_value[0], "Token_expiry"))
{
m.Token_expiry = Common.Functions.ConvertDateTime(dr["Token_expiry"], Convert.ToDateTime(Common.Para.dt_def));
}
if (Common.Functions.checkHave(return_value[0], "Token_IP"))
{
m.Token_IP = dr["Token_IP"].ToString();
}
#endregion
#region ==扩展参数==
if (Common.Functions.checkHave(return_value[1], "Area"))
{
m.Areas = dr["Area"].ToString().Split(',');
}
if (Common.Functions.checkHave(return_value[1], "Ltitle"))
{
m.Ltitle = dr["Ltitle"].ToString();
}
#endregion
l.Add(m);
}
dt.Dispose();
return(l);
}
/// <summary>
/// 查询列表（带分页）。返回List
/// </summary>
/// <param name="m">s_系列</param>
/// <param name="p">Model.Pages</param>
/// <param name="Rc">返回记录总条数</param>
public static List <Model.adminUsersLevel> Select_List(Model.adminUsersLevel m, ref Model.Pages p, ref long Rc)
{
#region ==返回参数处理==
string[] return_value = Common.Functions.Parameters_Filter(m.s_Total_parameter, m.s_Main_parameter, m.s_Extended_parameter, demand);
m.s_Main_parameter = return_value[0];
m.s_Extended_parameter = return_value[1];
#endregion
DataTable dt = Dal.adminUsersLevel.Select_List(ref p, ref Rc, m.s_Main_parameter, m.s_Extended_parameter, m.s_Keywords, m.s_Aulid, m.s_Alive, m.s_Order);
DataRow dr;
List <Model.adminUsersLevel> l = new List <Model.adminUsersLevel>();
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
m = new Model.adminUsersLevel();
#region ==主参数==
if (Common.Functions.checkHave(return_value[0], "Aulid"))
{
m.Aulid = Common.Functions.ConvertInt16(dr["Aulid"], 0);
}
if (Common.Functions.checkHave(return_value[0], "Alive"))
{
m.Alive = Convert.ToBoolean(dr["Alive"]);
}
if (Common.Functions.checkHave(return_value[0], "Ltitle"))
{
m.Ltitle = dr["Ltitle"].ToString();
}
if (Common.Functions.checkHave(return_value[0], "Area"))
{
m.Area = dr["Area"].ToString();
}
#endregion
#region ==扩展参数==
if (Common.Functions.checkHave(return_value[1], "c"))
{
m.c = Common.Functions.ConvertInt64(dr["c"], 0);
}
#endregion
l.Add(m);
}
dt.Dispose();
return(l);
}
/// <summary>
/// 查询列表（带分页）。返回List
/// </summary>
/// <param name="m">s_系列</param>
/// <param name="p">Model.Pages</param>
/// <param name="Rc">返回表记录总数量</param>
public static List <Model.LegalAdvice> Select_List(Model.LegalAdvice m, ref Model.Pages p, ref long Rc)
{
#region ==返回参数处理==
string[] return_value = Common.Functions.Parameters_Filter(m.s_Total_parameter, m.s_Main_parameter, m.s_Extended_parameter, demand);
m.s_Main_parameter = return_value[0];
m.s_Extended_parameter = return_value[1];
#endregion
DataTable dt = Dal.LegalAdvice.Select_List(ref p, m.s_Main_parameter, m.s_Extended_parameter, m.s_Keywords, m.s_Lid, m.s_Order, m.s_Ostatus, m.s_d1, m.s_d2, ref Rc);
DataRow dr;
List <Model.LegalAdvice> l = new List <Model.LegalAdvice>();
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
m = new Model.LegalAdvice();
#region 主参数
if (Common.Functions.checkHave(return_value[0], "Lid"))
{
m.Lid = Common.Functions.ConvertInt64(dr["Lid"]);
}
if (Common.Functions.checkHave(return_value[0], "Ltitle"))
{
m.Ltitle = Common.Functions.ConvertString(dr["Ltitle"]);
}
if (Common.Functions.checkHave(return_value[0], "Linfo"))
{
m.Linfo = dr["Linfo"].ToString();
}
if (Common.Functions.checkHave(return_value[0], "Lname"))
{
m.Lname = Common.Functions.ConvertString(dr["Lname"]);
}
if (Common.Functions.checkHave(return_value[0], "Tel"))
{
m.Tel = Common.Functions.ConvertString(dr["Tel"]);
}
if (Common.Functions.checkHave(return_value[0], "QQ"))
{
m.QQ = dr["QQ"].ToString();
}
if (Common.Functions.checkHave(return_value[0], "Email"))
{
m.Email = dr["Email"].ToString();
}
if (Common.Functions.checkHave(return_value[0], "Ldate"))
{
m.Ldate = Common.Functions.ConvertDateTime(dr["Ldate"], Convert.ToDateTime(Common.Para.dt_def));
}
if (Common.Functions.checkHave(return_value[0], "Ostatus"))
{
m.Ostatus = Common.Functions.ConvertInt16(dr["Ostatus"], 0);
}
if (Common.Functions.checkHave(return_value[0], "Reply"))
{
m.Reply = dr["Reply"].ToString();
}
#endregion
l.Add(m);
}
dt.Dispose();
return(l);
}
public static DataTable Select_List(ref Model.Pages p, ref long Rc, string Main_parameter, string Extended_parameter, string Uid, string Uid_not, string Order)
{
#region ==null判断==
if (p.Page < 1)
{
p.Page = 1;
}
if (p.Pname == null)
{
p.Pname = "p";
}
if (p.Tp == null)
{
p.Tp = p.Pname;
}
if (p.Previous == null)
{
p.Previous = "上一页";
}
if (p.Next == null)
{
p.Next = "下一页";
}
if (p.pageName == null)
{
p.pageName = "页";
}
if (p.sk == null)
{
p.sk = "";
}
if (p.method == null)
{
p.method = "get";
}
if (Main_parameter == null)
{
Main_parameter = "";
}
if (Extended_parameter == null)
{
Extended_parameter = "";
}
if (Uid == null)
{
Uid = "";
}
if (Uid_not == null)
{
Uid_not = "";
}
if (Order == null)
{
Order = "";
}
#endregion
Common.Config cfg = new Common.Config();
cfg.connDb();
SqlCommand sc = new SqlCommand("zzlh2017_Uploadfile_Select", cfg.Conn);
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@Page", SqlDbType.Int).Value = p.Page;
sc.Parameters.Add("@Ps", SqlDbType.SmallInt).Value = p.Ps;
sc.Parameters.Add("@Main_parameter", SqlDbType.VarChar, 8000).Value = Main_parameter;
sc.Parameters.Add("@Extended_parameter", SqlDbType.VarChar, 8000).Value = Extended_parameter;
sc.Parameters.Add("@Uid", SqlDbType.VarChar, 8000).Value = Uid;
sc.Parameters.Add("@Uid_not", SqlDbType.VarChar, 8000).Value = Uid_not;
sc.Parameters.Add("@Order", SqlDbType.VarChar, 200).Value = Order;
sc.Parameters.Add("@rc", SqlDbType.BigInt).Direction = ParameterDirection.Output;
sc.ExecuteNonQuery();
Rc = Common.Functions.ConvertInt64(sc.Parameters["@rc"].Value, 0);
SqlDataAdapter da = new SqlDataAdapter(sc);
DataTable dt = new DataTable();
da.Fill(dt);
da.Dispose();
sc.Dispose();
cfg.closeDb();
if (p.Ps == 0)
{
p.page_str = " ";
}
else
{
int Pc = Common.Functions.ConvertInt16(Rc / p.Ps, 0);
if (Rc % p.Ps != 0)
{
Pc++;
}
p.page_str = Common.Functions.Pagination(Pc, p.Page, p.Tp, p.Pname, p.Previous, p.Next, p.pageName, p.inputHeight, p.sk, p.method);
}
return(dt);
}
