/// <summary>根据userid得到管理员工信息</summary>
public DbModels.manage getManage(XXF.Db.DbConn PubConn, string userid)
{
string sql = "select ygbh,ygmc,ygmm,ygzt,sfsc from tb_userinfo where ygbh=@userid";
DataSet ds = new DataSet();
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@userid", userid);
PubConn.SqlToDataSet(ds, sql, para.ToParameters());
if (ds.Tables[0].Rows.Count != 1)
{
return(null);
}
DbModels.manage model = new DbModels.manage();
model.userid = ds.Tables[0].Rows[0]["ygbh"].ToString();
model.id = model.userid;
model.username = ds.Tables[0].Rows[0]["ygmc"].ToString();
model.pwd = privateToDeDES(ds.Tables[0].Rows[0]["ygmm"].ToString());
model.freeze = Convert.ToInt32(ds.Tables[0].Rows[0]["sfsc"]);
if (model.freeze == 0)
{
model.freeze = 1;
}
else
{
model.freeze = 0;
}
return(model);
}
public List <Models.DbModels.app> GetList(XXF.Db.DbConn PubConn, int pno, int pagesize, string keywords, out int totalcount)
{
totalcount = 0;
List <Models.DbModels.app> listapp = new List <DbModels.app>();
string sql = string.Format(basesql, " ROW_NUMBER() over (order by appid) as rownum, appid,appname,appsecret,app.apptype,appgrade.appgradeno,appgrade.appgradename,appdesc,freeze ");;
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
string con = "";
if (!string.IsNullOrEmpty(keywords))
{
con = " and app.appid like '%' + @keywords + '%' or app.appname like '%' + @keywords + '%' or appname like '%' + @keywords + '%' ";
para.Add("@keywords", keywords);
sql = sql + con;
}
string querysql = string.Concat("select A.* from (", sql, ") A ", " where A.rownum between ", (pno - 1) * pagesize + 1, " and ", pno * pagesize);
DataSet ds = new DataSet();
PubConn.SqlToDataSet(ds, querysql, para.ToParameters());
foreach (DataRow dr in ds.Tables[0].Rows)
{
listapp.Add(FillModel(dr));
}
totalcount = (int)PubConn.ExecuteScalar(string.Format(basesql, " count(*) ") + con, para.ToParameters());
return(listapp);
}
//get
public Models.DbModels.app GetAppInfo(XXF.Db.DbConn PubConn, string appid)
{
string sql = string.Format(basesql, " appid,appname,appsecret,app.apptype,appgrade.appgradeno,appgrade.appgradename,appdesc,freeze ");
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@appid", appid);
sql += " and appid=@appid";
DataSet ds = new DataSet();
PubConn.SqlToDataSet(ds, sql, para.ToParameters());
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
return(FillModel(ds.Tables[0].Rows[0]));
}
/// <summary></summary>
public DbModels.manage getUser(XXF.Db.DbConn PubConn, string userid)
{
string sql = "select f_id, f_yhzh,f_yhxm,f_dlmm,f_sfdj from tb_customer where f_yhzh=@userid";
DataSet ds = new DataSet();
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@userid", userid);
PubConn.SqlToDataSet(ds, sql, para.ToParameters());
if (ds.Tables[0].Rows.Count != 1)
{
return(null);
}
DbModels.manage model = new DbModels.manage();
model.userid = ds.Tables[0].Rows[0]["f_yhzh"].ToString();
model.id = ds.Tables[0].Rows[0]["f_id"].ToString();
model.username = ds.Tables[0].Rows[0]["f_yhxm"].ToString();
model.pwd = privateToDeDES(ds.Tables[0].Rows[0]["f_dlmm"].ToString());
model.freeze = Convert.ToInt32(ds.Tables[0].Rows[0]["f_sfdj"]);
return(model);
}
/// <summary>根据userid得到管理员工信息</summary>
public DbModels.manage getShop(XXF.Db.DbConn PubConn, string userid)
{
string sql = "SELECT f_shzh,f_shsj,f_shmc,f_dlmm,f_sfdj FROM [tb_shop] where f_shzh=@userid or f_shsj=@userid";
DataSet ds = new DataSet();
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@userid", userid);
PubConn.SqlToDataSet(ds, sql, para.ToParameters());
if (ds.Tables[0].Rows.Count != 1)
{
return(null);
}
DbModels.manage model = new DbModels.manage();
model.userid = ds.Tables[0].Rows[0]["f_shzh"].ToString();
model.id = model.userid;
model.username = ds.Tables[0].Rows[0]["f_shmc"].ToString();
model.pwd = privateToDeDES(ds.Tables[0].Rows[0]["f_dlmm"].ToString());
model.freeze = Convert.ToInt32(ds.Tables[0].Rows[0]["f_sfdj"]);
return(model);
}
public List <Models.DbModels.appcategory> GetAppTypeCategorys(XXF.Db.DbConn PubConn, int typeid)
{
List <DbModels.appcategory> listmodel = new List <DbModels.appcategory>();
string sql = "select apptype,categoryid,categorytitle, categorydesc from appcategory where apptype=@apptype order by categoryid asc";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@apptype", typeid);
DataSet ds = new DataSet();
PubConn.SqlToDataSet(ds, sql, para.ToParameters());
foreach (DataRow dr in ds.Tables[0].Rows)
{
DbModels.appcategory item = new DbModels.appcategory();
item.apptype = Convert.ToInt32(dr["apptype"]);
item.categoryid = Convert.ToInt32(dr["categoryid"]);
item.categorytitle = dr["categorytitle"].ToString();
item.categorydesc = dr["categorydesc"].ToString();
listmodel.Add(item);
}
return(listmodel);
}
public List <DbModels.appgrade> GetGrades(XXF.Db.DbConn PubConn, int typ)
{
List <DbModels.appgrade> listmodel = new List <DbModels.appgrade>();
string sql = "select apptype,appgradeno,appgradename,appgradedesc from appgrade where apptype=@apptype order by appgradeno asc";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@apptype", typ);
DataSet ds = new DataSet();
PubConn.SqlToDataSet(ds, sql, para.ToParameters());
foreach (DataRow dr in ds.Tables[0].Rows)
{
DbModels.appgrade item = new DbModels.appgrade();
item.apptype = Convert.ToInt32(dr["apptype"]);
item.appgradeno = Convert.ToInt32(dr["appgradeno"]);
item.appgradename = dr["appgradename"].ToString();
item.appgradedesc = dr["appgradedesc"].ToString();
listmodel.Add(item);
}
return(listmodel);
}
public Models.DbModels.appcategory GetCategoryInfo(XXF.Db.DbConn PubConn, int typeid, int categoryid)
{
string sql = "select apptype,categoryid,categorytitle, categorydesc from appcategory where apptype=@apptype and categoryid=@categoryid";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@apptype", typeid);
para.Add("@categoryid", categoryid);
DataSet ds = new DataSet();
PubConn.SqlToDataSet(ds, sql, para.ToParameters());
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
DataRow dr = ds.Tables[0].Rows[0];
DbModels.appcategory item = new DbModels.appcategory();
item.apptype = Convert.ToInt32(dr["apptype"]);
item.categoryid = Convert.ToInt32(dr["categoryid"]);
item.categorytitle = dr["categorytitle"].ToString();
item.categorydesc = dr["categorydesc"].ToString();
return(item);
}
public DbModels.appgrade GetGradeInfo(XXF.Db.DbConn PubConn, int apptype, int appgradeno)
{
string sql = "select apptype,appgradeno,appgradename,appgradedesc from appgrade where apptype=@apptype and appgradeno=@appgradeno ";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@apptype", apptype);
para.Add("@appgradeno", appgradeno);
DataSet ds = new DataSet();
PubConn.SqlToDataSet(ds, sql, para.ToParameters());
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
DataRow dr = ds.Tables[0].Rows[0];
DbModels.appgrade item = new DbModels.appgrade();
item.apptype = Convert.ToInt32(dr["apptype"]);
item.appgradeno = Convert.ToInt32(dr["appgradeno"]);
item.appgradename = dr["appgradename"].ToString();
item.appgradedesc = dr["appgradedesc"].ToString();
return(item);
}
