/// <summary> /// 读取系统管理员信息 /// </summary> /// <param name="adminid"></param> /// <returns></returns> public static admininfo getAdminInfo(int adminid) { SqlParameter[] parms = new SqlParameter[1]; parms[0] = new SqlParameter("@adminid", SqlDbType.Int); parms[0].Value = adminid; admininfo data = new admininfo(); string sql = "SELECT adminid,adminname,roleid,adddate,updatedate FROM SysAdmin WHERE adminid=@adminid"; try { SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.connectionstring, CommandType.Text, sql, parms); if (reader.Read()) { data.adminid = TypeParse.DbObjToInt(reader["adminid"], 0); data.adminname = TypeParse.DbObjToString(reader["adminname"], ""); data.adddate = TypeParse.DbObjToDateTime(reader["adddate"], DateTime.Now); data.updatedate = TypeParse.DbObjToDateTime(reader["updatedate"], DateTime.Now); reader.Close(); reader.Dispose(); } return(data); } catch (Exception E) { throw new Exception(E.Message); } finally { } }
/// <summary> /// 得到管理员信息列表 /// </summary> /// <param name="pdata"></param> /// <returns></returns> public static List <admininfo> getAdminList() { List <admininfo> adminlist = new List <admininfo>(); string sql = "SELECT adminid,adminname,roleid,adddate,updatedate FROM SysAdmin"; try { DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.connectionstring, CommandType.Text, sql).Tables[0]; if (dt != null) { foreach (DataRow reader in dt.Rows) { admininfo data = new admininfo(); data.adminid = TypeParse.DbObjToInt(reader["adminid"], 0); data.adminname = TypeParse.DbObjToString(reader["adminname"], ""); data.adddate = TypeParse.DbObjToDateTime(reader["adddate"], DateTime.Now); data.updatedate = TypeParse.DbObjToDateTime(reader["updatedate"], DateTime.Now); adminlist.Add(data); } } return(adminlist); } catch (Exception E) { throw new Exception(E.Message); } finally { } }
public static List <admininfo> getAdminListPage(pageinfo item) { List <admininfo> adminlist = new List <admininfo>(); try { DataTable dt = pagehelper.getpagedt(item); if (dt != null) { foreach (DataRow reader in dt.Rows) { admininfo data = new admininfo(); data.adminid = TypeParse.DbObjToInt(reader["adminid"], 0); data.adminname = TypeParse.DbObjToString(reader["adminname"], ""); data.adddate = TypeParse.DbObjToDateTime(reader["adddate"], DateTime.Now); data.updatedate = TypeParse.DbObjToDateTime(reader["updatedate"], DateTime.Now); adminlist.Add(data); } } return(adminlist); } catch (Exception E) { throw new Exception(E.Message); } finally { } }
/// <summary> /// 根据ID读取资讯信息 /// </summary> /// <param name="newsid"></param> /// <returns></returns> public static newsinfo getnewsinfo(string newsid) { string sql = "select news.newsid,news.newstitle,news.newswriter,news.newsfrom,news.newsnote,news.adddate,news.ntid,newstype.newstype,news.ninfo,news.istop,news.newsimg,news.userid from news,newstype where news.ntid=newstype.ntid and news.newsid=" + newsid + ""; newsinfo item = new newsinfo(); try { SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.connectionstring, CommandType.Text, sql); if (dr.Read()) { item.newsid = TypeParse.DbObjToInt(dr["newsid"].ToString(), 0); item.newstitle = TypeParse.DbObjToString(dr["newstitle"].ToString(), ""); item.newswriter = TypeParse.DbObjToString(dr["newswriter"].ToString(), ""); item.ntid = TypeParse.DbObjToInt(dr["ntid"].ToString(), 1); item.istop = TypeParse.DbObjToInt(dr["istop"].ToString(), 0); item.newsfrom = TypeParse.DbObjToString(dr["newsfrom"].ToString(), ""); item.newsnote = TypeParse.DbObjToString(dr["newsnote"].ToString(), ""); item.ninfo = TypeParse.DbObjToString(dr["ninfo"].ToString(), ""); item.newstype = TypeParse.DbObjToString(dr["newstype"].ToString(), ""); item.adddate = TypeParse.DbObjToDateTime(dr["adddate"].ToString(), DateTime.Now); item.newsimg = TypeParse.DbObjToString(dr["newsimg"].ToString(), "noimg.jpg"); item.userid = TypeParse.DbObjToString(dr["userid"].ToString(), ""); dr.Close(); dr.Dispose(); } } catch (Exception ex) { throw new Exception(ex.Message); } finally { } return(item); }
/// <summary> /// 得到订单列表 /// </summary> /// <param name="pdata"></param> /// <returns></returns> public static List <orderinfo> getorderlist(pageinfo pdata) { List <orderinfo> list = new List <orderinfo>(); try { DataTable dt = pagehelper.getpagedt(pdata); if (dt != null) { foreach (DataRow dr in dt.Rows) { orderinfo item = new orderinfo(); item.orderid = TypeParse.DbObjToString(dr["orderid"].ToString(), "0"); item.tel = TypeParse.DbObjToString(dr["tel"].ToString(), ""); item.mobile = TypeParse.DbObjToString(dr["mobile"].ToString(), ""); item.address = TypeParse.DbObjToString(dr["address"].ToString(), ""); item.contact = TypeParse.DbObjToString(dr["contact"].ToString(), ""); item.allmoney = Decimal.Parse(TypeParse.DbObjToString(dr["allmoney"].ToString(), "0.00")); item.paymoney = Decimal.Parse(TypeParse.DbObjToString(dr["paymoney"].ToString(), "0.00")); item.orderstate = TypeParse.DbObjToInt(dr["orderstate"].ToString(), 0); item.orderdate = TypeParse.DbObjToDateTime(dr["orderdate"].ToString(), DateTime.Now); item.deliverydate = TypeParse.DbObjToDateTime(dr["deliverydate"].ToString(), DateTime.Now); item.ordernumber = TypeParse.DbObjToString(dr["ordernumber"].ToString(), ""); item.deliveryI = TypeParse.DbObjToString(dr["deliveryI"].ToString(), ""); item.deliveryII = TypeParse.DbObjToString(dr["deliveryII"].ToString(), ""); switch (item.orderstate) { case 0: item.orderstatestr = "进行中"; break; case 10: item.orderstatestr = "已完成"; break; case 44: item.orderstatestr = "待处理"; break; default: item.orderstatestr = "进行中"; break; } list.Add(item); } } } catch (Exception ex) { throw new Exception(ex.Message); } finally { } return(list); }
//绑定浏览记录 public static List <productinfo> bindproductlistvh(int n, string pidstr) { SqlParameter[] parms = new SqlParameter[1]; parms[0] = new SqlParameter("@pidstr", SqlDbType.NVarChar, 500); parms[0].Value = pidstr; List <productinfo> list = new List <productinfo>(); string sql = "SELECT TOP " + n + " a.productid,a.productname,a.productprice,a.productcode,a.productbrief,a.productintroduce,a.vipprice,a.productimg,a.smallcategoryid,a.bigcategoryid,a.brand,a.punit,a.placeid,a.adddate,a.editdate,a.salestate,a.tjtypeid,b.bigcategory,c.smallcategory,d.place from product a ,bigcategory b ,smallcategory c ,place d where a.smallcategoryid=c.smallcategoryid and b.bigcategoryid=c.bigcategoryid and a.placeid=d.placeid and a.productid in (" + pidstr + ")"; try { DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.connectionstring, CommandType.Text, sql, parms).Tables[0]; if (dt != null) { foreach (DataRow dr in dt.Rows) { productinfo item = new productinfo(); item.productid = TypeParse.DbObjToInt(dr["productid"].ToString(), 0); item.productname = TypeParse.DbObjToString(dr["productname"].ToString(), ""); item.vipprice = Convert.ToDecimal(TypeParse.DbObjToString(dr["vipprice"].ToString(), "100.00")); item.productprice = Convert.ToDecimal(TypeParse.DbObjToString(dr["productprice"].ToString(), "100.00")); item.productcode = TypeParse.DbObjToString(dr["productcode"].ToString(), ""); item.productbrief = TypeParse.DbObjToString(dr["productbrief"].ToString(), ""); item.productintroduce = TypeParse.DbObjToString(dr["productintroduce"].ToString(), ""); item.productimg = TypeParse.DbObjToString(dr["productimg"].ToString(), ""); item.smallcategoryid = TypeParse.DbObjToInt(dr["smallcategoryid"].ToString(), 0); item.smallcategory = TypeParse.DbObjToString(dr["smallcategory"].ToString(), ""); item.bigcategoryid = TypeParse.DbObjToInt(dr["bigcategoryid"].ToString(), 0); item.brand = TypeParse.DbObjToString(dr["brand"].ToString(), ""); item.punit = TypeParse.DbObjToString(dr["punit"].ToString(), ""); item.adddate = TypeParse.DbObjToDateTime(dr["adddate"], DateTime.Now); item.editdate = TypeParse.DbObjToDateTime(dr["editdate"], DateTime.Now); item.salestate = TypeParse.DbObjToInt(dr["salestate"].ToString(), 0); item.placeid = TypeParse.DbObjToInt(dr["placeid"].ToString(), 0); item.place = TypeParse.DbObjToString(dr["place"].ToString(), ""); item.tjtypeid = TypeParse.DbObjToInt(dr["tjtypeid"].ToString(), 0); list.Add(item); } } } catch (Exception ex) { throw new Exception(ex.Message); } finally { } return(list); }
/// <summary> /// 得到单个产品信息 /// </summary> /// <param name="wiid"></param> /// <returns></returns> public static productinfo getproductinfo(int productid) { SqlParameter[] parms = new SqlParameter[1]; parms[0] = new SqlParameter("@productid", SqlDbType.Int); parms[0].Value = productid; productinfo item = new productinfo(); string sql = "select a.productid,a.productname,a.productprice,a.productcode,a.productbrief,a.productintroduce,a.vipprice,a.productimg,a.smallcategoryid,a.bigcategoryid,a.brand,a.punit,a.placeid,a.adddate,a.editdate,a.salestate,a.tjtypeid,b.bigcategory,c.smallcategory,d.place from product a ,bigcategory b ,smallcategory c ,place d where a.smallcategoryid=c.smallcategoryid and b.bigcategoryid=c.bigcategoryid and a.placeid=d.placeid and productid=@productid"; try { SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.connectionstring, CommandType.Text, sql, parms); if (dr.Read()) { item.productid = TypeParse.DbObjToInt(dr["productid"].ToString(), 0); item.productname = TypeParse.DbObjToString(dr["productname"].ToString(), ""); item.vipprice = Convert.ToDecimal(TypeParse.DbObjToString(dr["vipprice"].ToString(), "100.00")); item.productprice = Convert.ToDecimal(TypeParse.DbObjToString(dr["productprice"].ToString(), "100.00")); item.productcode = TypeParse.DbObjToString(dr["productcode"].ToString(), ""); item.productbrief = TypeParse.DbObjToString(dr["productbrief"].ToString(), ""); item.productintroduce = TypeParse.DbObjToString(dr["productintroduce"].ToString(), ""); item.productimg = TypeParse.DbObjToString(dr["productimg"].ToString(), ""); item.smallcategoryid = TypeParse.DbObjToInt(dr["smallcategoryid"].ToString(), 0); item.bigcategoryid = TypeParse.DbObjToInt(dr["bigcategoryid"].ToString(), 0); item.bigcategory = TypeParse.DbObjToString(dr["bigcategory"].ToString(), ""); item.smallcategory = TypeParse.DbObjToString(dr["smallcategory"].ToString(), ""); item.brand = TypeParse.DbObjToString(dr["brand"].ToString(), ""); item.punit = TypeParse.DbObjToString(dr["punit"].ToString(), ""); item.adddate = TypeParse.DbObjToDateTime(dr["adddate"], DateTime.Now); item.editdate = TypeParse.DbObjToDateTime(dr["editdate"], DateTime.Now); item.salestate = TypeParse.DbObjToInt(dr["salestate"].ToString(), 0); item.placeid = TypeParse.DbObjToInt(dr["placeid"].ToString(), 0); item.place = TypeParse.DbObjToString(dr["place"].ToString(), ""); item.tjtypeid = TypeParse.DbObjToInt(dr["tjtypeid"].ToString(), 0); dr.Close(); dr.Dispose(); } } catch (Exception ex) { throw new Exception(ex.Message); } finally { } return(item); }
/// <summary> /// 得到产品 /// </summary> /// <param name="pdata"></param> /// <returns></returns> public static List <productinfo> getproduct(pageinfo pdata) { List <productinfo> list = new List <productinfo>(); try { DataTable dt = pagehelper.getpagedt(pdata); if (dt != null) { foreach (DataRow dr in dt.Rows) { productinfo item = new productinfo(); item.productid = TypeParse.DbObjToInt(dr["productid"].ToString(), 0); item.productname = TypeParse.DbObjToString(dr["productname"].ToString(), ""); item.vipprice = Convert.ToDecimal(TypeParse.DbObjToString(dr["vipprice"].ToString(), "100.00")); item.productprice = Convert.ToDecimal(TypeParse.DbObjToString(dr["productprice"].ToString(), "100.00")); item.productcode = TypeParse.DbObjToString(dr["productcode"].ToString(), ""); item.productbrief = TypeParse.DbObjToString(dr["productbrief"].ToString(), ""); item.productintroduce = TypeParse.DbObjToString(dr["productintroduce"].ToString(), ""); item.productimg = TypeParse.DbObjToString(dr["productimg"].ToString(), ""); item.smallcategoryid = TypeParse.DbObjToInt(dr["smallcategoryid"].ToString(), 0); item.bigcategoryid = TypeParse.DbObjToInt(dr["bigcategoryid"].ToString(), 0); item.smallcategory = TypeParse.DbObjToString(dr["smallcategory"].ToString(), ""); item.bigcategory = TypeParse.DbObjToString(dr["bigcategory"].ToString(), ""); item.brand = TypeParse.DbObjToString(dr["brand"].ToString(), ""); item.punit = TypeParse.DbObjToString(dr["punit"].ToString(), ""); item.adddate = TypeParse.DbObjToDateTime(dr["adddate"], DateTime.Now); item.editdate = TypeParse.DbObjToDateTime(dr["editdate"], DateTime.Now); item.salestate = TypeParse.DbObjToInt(dr["salestate"].ToString(), 0); item.placeid = TypeParse.DbObjToInt(dr["placeid"].ToString(), 0); item.place = TypeParse.DbObjToString(dr["place"].ToString(), ""); list.Add(item); } } } catch (Exception ex) { throw new Exception(ex.Message); } finally { } return(list); }
/// <summary> /// 根据AID读取用户信息 /// </summary> /// <param name="aid"></param> /// <returns></returns> public static userinfo getuserinfo(string userid) { SqlParameter[] parms = new SqlParameter[1]; parms[0] = new SqlParameter("@userid", SqlDbType.NVarChar, 50); parms[0].Value = userid; string sql = "SELECT userinfo.userid,userinfo.email,userinfo.accounts,userinfo.pwd,userinfo.tel,userinfo.mobile,userinfo.headerimg,userinfo.qq,userinfo.company,userinfo.address,userinfo.truename,userinfo.adddate,userinfo.atid,accountstype.atdiscount,accountstype.accountstype FROM userinfo,accountstype WHERE accountstype.atid=userinfo.atid and userinfo.[userid]=@userid"; SqlDataReader reader = null; try { userinfo data = new userinfo(); reader = SqlHelper.ExecuteReader(SqlHelper.connectionstring, CommandType.Text, sql, parms); if (reader.Read()) { data.userid = TypeParse.DbObjToString(reader["userid"], ""); data.email = TypeParse.DbObjToString(reader["email"], ""); data.adddate = TypeParse.DbObjToDateTime(reader["adddate"], DateTime.Now); data.tel = TypeParse.DbObjToString(reader["tel"], ""); data.mobile = TypeParse.DbObjToString(reader["mobile"], ""); data.headerimg = TypeParse.DbObjToString(reader["headerimg"], "noimg.jpg"); data.truename = TypeParse.DbObjToString(reader["truename"], ""); data.qq = TypeParse.DbObjToString(reader["qq"], ""); data.company = TypeParse.DbObjToString(reader["company"], ""); data.accounts = TypeParse.DbObjToString(reader["accounts"], ""); data.address = TypeParse.DbObjToString(reader["address"], ""); data.atid = TypeParse.DbObjToInt(reader["atid"], 1); data.accountstype = TypeParse.DbObjToString(reader["accountstype"], ""); data.atdiscount = Decimal.Parse(TypeParse.DbObjToString(reader["atdiscount"], "1.00")); reader.Close(); reader.Dispose(); } return(data); } catch (Exception E) { throw new Exception(E.Message); } finally { } }
/// <summary> /// 绑定页面资讯列表 /// </summary> /// <param name="n"></param> /// <param name="newstype"></param> /// <returns></returns> public static List <newsinfo> bindnewslist(int n, string newstype) { SqlParameter[] parms = new SqlParameter[1]; parms[0] = new SqlParameter("@newstype", SqlDbType.VarChar, 50); parms[0].Value = newstype; List <newsinfo> newslist = new List <newsinfo>(); string sql = "SELECT TOP " + n + " news.newsid,news.newstitle,news.newswriter,news.newsfrom,news.newsnote,news.adddate,news.ntid,newstype.newstype,news.ninfo,news.istop,news.newsimg FROM news,newstype WHERE news.ntid=newstype.ntid AND newstype.newstype=@newstype ORDER BY news.istop desc,news.adddate desc"; try { DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.connectionstring, CommandType.Text, sql, parms).Tables[0]; if (dt != null) { foreach (DataRow dr in dt.Rows) { newsinfo item = new newsinfo(); item.newsid = TypeParse.DbObjToInt(dr["newsid"].ToString(), 0); item.newstitle = TypeParse.DbObjToString(dr["newstitle"].ToString(), ""); item.newswriter = TypeParse.DbObjToString(dr["newswriter"].ToString(), ""); item.ntid = TypeParse.DbObjToInt(dr["ntid"].ToString(), 1); item.istop = TypeParse.DbObjToInt(dr["istop"].ToString(), 0); item.newsfrom = TypeParse.DbObjToString(dr["newsfrom"].ToString(), ""); item.newsnote = TypeParse.DbObjToString(dr["newsnote"].ToString(), ""); item.ninfo = TypeParse.DbObjToString(dr["ninfo"].ToString(), ""); item.newstype = TypeParse.DbObjToString(dr["newstype"].ToString(), ""); item.adddate = TypeParse.DbObjToDateTime(dr["adddate"].ToString(), DateTime.Now); item.newsimg = TypeParse.DbObjToString(dr["newsimg"].ToString(), "noimg.jpg"); newslist.Add(item); } } } catch (Exception ex) { throw new Exception(ex.Message); } finally { } return(newslist); }
/// <summary> /// 得到用户信息列表 /// </summary> /// <param name="pdata"></param> /// <returns></returns> public static List <userinfo> getUserList(pageinfo pdata) { List <userinfo> userlist = new List <userinfo>(); try { DataTable dt = pagehelper.getpagedt(pdata); if (dt != null) { foreach (DataRow reader in dt.Rows) { userinfo data = new userinfo(); data.userid = TypeParse.DbObjToString(reader["userid"], ""); data.email = TypeParse.DbObjToString(reader["email"], ""); data.accounts = TypeParse.DbObjToString(reader["accounts"], ""); data.tel = TypeParse.DbObjToString(reader["tel"], ""); data.mobile = TypeParse.DbObjToString(reader["mobile"], ""); data.headerimg = TypeParse.DbObjToString(reader["headerimg"], "noimg.jpg"); data.atid = TypeParse.DbObjToInt(reader["atid"], 1); data.accountstype = TypeParse.DbObjToString(reader["accountstype"], ""); data.truename = TypeParse.DbObjToString(reader["truename"], ""); data.qq = TypeParse.DbObjToString(reader["qq"], ""); data.company = TypeParse.DbObjToString(reader["company"], ""); data.address = TypeParse.DbObjToString(reader["address"], ""); data.adddate = TypeParse.DbObjToDateTime(reader["adddate"], DateTime.Now); userlist.Add(data); } } return(userlist); } catch (Exception E) { throw new Exception(E.Message); } finally { } }
/// <summary> /// 得到资讯列表 /// </summary> /// <param name="pdata"></param> /// <returns></returns> public static List <newsinfo> getnews(pageinfo pdata) { List <newsinfo> newslist = new List <newsinfo>(); try { DataTable dt = pagehelper.getpagedt(pdata); if (dt != null) { foreach (DataRow dr in dt.Rows) { newsinfo item = new newsinfo(); item.newsid = TypeParse.DbObjToInt(dr["newsid"].ToString(), 0); item.newstitle = TypeParse.DbObjToString(dr["newstitle"].ToString(), ""); item.newswriter = TypeParse.DbObjToString(dr["newswriter"].ToString(), ""); item.ntid = TypeParse.DbObjToInt(dr["ntid"].ToString(), 1); item.istop = TypeParse.DbObjToInt(dr["istop"].ToString(), 0); item.newsfrom = TypeParse.DbObjToString(dr["newsfrom"].ToString(), ""); item.newsnote = TypeParse.DbObjToString(dr["newsnote"].ToString(), ""); item.ninfo = TypeParse.DbObjToString(dr["ninfo"].ToString(), ""); item.newstype = TypeParse.DbObjToString(dr["newstype"].ToString(), ""); item.adddate = TypeParse.DbObjToDateTime(dr["adddate"].ToString(), DateTime.Now); item.newsimg = TypeParse.DbObjToString(dr["newsimg"].ToString(), "noimg.jpg"); item.userid = TypeParse.DbObjToString(dr["userid"].ToString(), ""); newslist.Add(item); } } } catch (Exception ex) { throw new Exception(ex.Message); } finally { } return(newslist); }
/// <summary> /// 得到单个订单信息 /// </summary> /// <param name="orderid"></param> /// <returns></returns> public static orderinfo getorderinfo(string orderid) { SqlParameter[] parms = new SqlParameter[1]; parms[0] = new SqlParameter("@orderid", SqlDbType.NVarChar, 50); parms[0].Value = orderid; orderinfo item = new orderinfo(); string sql = "select a.orderid,a.ordernumber,a.allmoney,a.paymoney,a.deliveryIid,a.deliveryIIid,a.orderdate,a.deliverydate,a.orderstate,a.contact,a.tel,a.mobile,a.address,c.deliveryI,d.deliveryII from [userorder] a,deliveryI c,deliveryII d where a.deliveryIid=c.deliveryIid and a.deliveryIIid=d.deliveryIIid and orderid=@orderid"; try { SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.connectionstring, CommandType.Text, sql, parms); if (dr.Read()) { item.orderid = TypeParse.DbObjToString(dr["orderid"].ToString(), "0"); item.tel = TypeParse.DbObjToString(dr["tel"].ToString(), ""); item.ordernumber = TypeParse.DbObjToString(dr["ordernumber"].ToString(), ""); item.mobile = TypeParse.DbObjToString(dr["mobile"].ToString(), ""); item.address = TypeParse.DbObjToString(dr["address"].ToString(), ""); item.contact = TypeParse.DbObjToString(dr["contact"].ToString(), ""); item.allmoney = Decimal.Parse(TypeParse.DbObjToString(dr["allmoney"].ToString(), "0.00")); item.paymoney = Decimal.Parse(TypeParse.DbObjToString(dr["paymoney"].ToString(), "0.00")); item.orderstate = TypeParse.DbObjToInt(dr["orderstate"].ToString(), 0); item.orderdate = TypeParse.DbObjToDateTime(dr["orderdate"].ToString(), DateTime.Now); item.deliverydate = TypeParse.DbObjToDateTime(dr["deliverydate"].ToString(), DateTime.Now); item.ordernumber = TypeParse.DbObjToString(dr["ordernumber"].ToString(), ""); item.deliveryI = TypeParse.DbObjToString(dr["deliveryI"].ToString(), ""); item.deliveryII = TypeParse.DbObjToString(dr["deliveryII"].ToString(), ""); item.deliveryIid = TypeParse.DbObjToInt(dr["deliveryIid"].ToString(), 0); item.deliveryIIid = TypeParse.DbObjToInt(dr["deliveryIIid"].ToString(), 0); switch (item.orderstate) { case 0: item.orderstatestr = "进行中"; break; case 10: item.orderstatestr = "已完成"; break; case 44: item.orderstatestr = "待处理"; break; default: item.orderstatestr = "进行中"; break; } dr.Close(); dr.Dispose(); } } catch (Exception ex) { throw new Exception(ex.Message); } finally { } return(item); }