/// <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); }