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