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];
}
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";
}
public static string GetTotalNum(SelectField selectfield)
{
return DAL.SelectByPager.GetTotalNum(selectfield);
}
public static int GetCount(SelectField selectfield)
{
return DAL.SelectByPager.GetCount(selectfield);
}