Esempio n. 1
0
 public static int GetCount(SelectField selectfield)
 {
     SqlParameter[] pars = new SqlParameter[] { new SqlParameter("@TableName", SqlDbType.VarChar, 100), new SqlParameter("@Field", SqlDbType.VarChar, 100), new SqlParameter("@NewField", SqlDbType.VarChar, 100), new SqlParameter("@Condition", SqlDbType.VarChar, 0x1f40) };
     pars[0].Value = selectfield.TableName;
     pars[1].Value = selectfield.Field;
     pars[2].Value = selectfield.NewField;
     pars[3].Value = selectfield.Condition;
     return (int) SqlHelper.GetAllInfo(pars, "SelectField").Tables[0].Rows[0][0];
 }
Esempio n. 2
0
 public static string GetTotalNum(SelectField selectfield)
 {
     SqlParameter[] pars = new SqlParameter[] { new SqlParameter("@TableName", SqlDbType.VarChar, 100), new SqlParameter("@Field", SqlDbType.VarChar, 100), new SqlParameter("@NewField", SqlDbType.VarChar, 100), new SqlParameter("@Condition", SqlDbType.VarChar, 0x1f40) };
     pars[0].Value = selectfield.TableName;
     pars[1].Value = selectfield.Field;
     pars[2].Value = selectfield.NewField;
     pars[3].Value = selectfield.Condition;
     DataSet allInfo = SqlHelper.GetAllInfo(pars, "getTotalNum");
     if ((allInfo != null) && (allInfo.Tables[0].Rows.Count != 0))
     {
         return allInfo.Tables[0].Rows[0][0].ToString();
     }
     return "0";
 }
Esempio n. 3
0
 public static string GetTotalNum(SelectField selectfield)
 {
     return DAL.SelectByPager.GetTotalNum(selectfield);
 }
Esempio n. 4
0
 public static int GetCount(SelectField selectfield)
 {
     return DAL.SelectByPager.GetCount(selectfield);
 }