public int AddJia_Shop(Jia_Shop jia_shop) { string sql = "insert Jia_Shop values(@ShopId,@IsExpired,@ExpireDate,@AddDate)"; SqlParameter[] param = CreateParameter(jia_shop); return(DBHelper.ExecuteNonQuery(sql, param)); }
public int ModifyJia_Shop(Jia_Shop jia_shop) { string sql = "update Jia_Shop set ShopId=@ShopId,IsExpired=@IsExpired,ExpireDate=@ExpireDate,AddDate=@AddDate where Nick=@Nick"; SqlParameter[] param = CreateParameter(jia_shop); return(DBHelper.ExecuteNonQuery(sql, param)); }
private SqlParameter[] CreateParameter(Jia_Shop jia_shop) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Nick", jia_shop.Nick), new SqlParameter("@ShopId", jia_shop.ShopId), new SqlParameter("@IsExpired", jia_shop.IsExpired), new SqlParameter("@ExpireDate", jia_shop.ExpireDate), new SqlParameter("@AddDate", jia_shop.AddDate) }; return(param); }
private IList <Jia_Shop> Jia_ShopPropertity(string sql, params SqlParameter[] param) { DataTable dt = DBHelper.ExecuteDataTable(sql, param); IList <Jia_Shop> list = new List <Jia_Shop>(); foreach (DataRow dr in dt.Rows) { Jia_Shop jia_shop = new Jia_Shop(); jia_shop.Nick = Convert.ToString(dr["Nick"]); jia_shop.ShopId = Convert.ToString(dr["ShopId"]); jia_shop.IsExpired = Convert.ToInt32(dr["IsExpired"]); jia_shop.ExpireDate = Convert.ToDateTime(dr["ExpireDate"]); jia_shop.AddDate = Convert.ToDateTime(dr["AddDate"]); list.Add(jia_shop); } return(list); }
public string checkexpire(string uId, string dataType) { Jia_Shop shop = ssDal.GetJia_ShopByNick(uId); ResponseMsg pmsg = new ResponseMsg(); msg msg = new msg(); if (shop == null) { pmsg.result = "fail"; msg.content = "该用户尚未订购模版"; } else { pmsg.result = "success"; //if (shop.IsExpired == 1) if (shop.ExpireDate <= DateTime.Now) { msg.content = "0"; } else { msg.content = "1"; } } List <msg> list = new List <msg>(); list.Add(msg); if (dataType == "json") { return(GetJsonStr(list, pmsg)); } ResponseXMLMsg xmlmsg = new ResponseXMLMsg(); xmlmsg.result = pmsg.result; return(GetXMLStr(list, xmlmsg)); }