//[LoginPwd]
/// <summary>
/// 编辑店面信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool EditStoreInfo(StoreModel model)
{
string sqlStr = @"Update Stores Set [StoreName]=@StoreName,[Address]=@Address,[BaiduMap]=@BaiduMap {0} WHERE STOREID=@STOREID; ";
if (!string.IsNullOrEmpty(model.LoginPwd))
{
sqlStr = string.Format(sqlStr, ",[LoginPwd]=@LoginPwd ");
model.LoginPwd = Md5.MD5(model.LoginPwd.Trim().ToLower());
}
else { sqlStr = string.Format(sqlStr, ""); }
List<SQLiteParameter> list = GetEntityParas(model);
return ExecuteNonQuery(sqlStr, list.ToArray()) > 0;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!int.TryParse(Request["d"], out StoreID)) Response.Redirect("list.aspx", true);
Model = StoreDAL.GetModel(StoreID);
if (Model == null) Response.Redirect("list.aspx", true);
if (!IsPostBack)
{
txt_shopname.Text = Model.StoreName;
txt_username.Text = Model.LoginName;
hid_address.Value = Model.BaiduMap;
txt_address.Text = Model.Address;
}
}
protected void btn_submit_Click(object sender, EventArgs e)
{
StoreModel model = new StoreModel();
if (!string.IsNullOrEmpty(txt_username.Text)) model.LoginName = txt_username.Text;
if (!string.IsNullOrEmpty(txt_shopname.Text)) model.StoreName = txt_shopname.Text;
if (!string.IsNullOrEmpty(hid_address.Value)) model.BaiduMap = hid_address.Value;
if (!string.IsNullOrEmpty(txt_address.Text)) model.Address = txt_address.Text;
if (!string.IsNullOrEmpty(txt_pwd.Text)) model.LoginPwd = txt_pwd.Text;
model.AddTime = DateTime.Now;
bool result = StoreDAL.RegStoreInfo(model);
if (result)
ShowAlert("店面添加成功！");
else
ShowAlert("店面添加失败！");
}
/// <summary>
/// 注册店面
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool RegStoreInfo(StoreModel model)
{
model.LoginPwd = Md5.MD5(model.LoginPwd.Trim().ToLower());
string sqlStr = @"
Insert Into Stores ([LoginName],[LoginPwd],[StoreName],[Address],[BaiduMap],[AddTime])
select @LoginName,@LoginPwd,@StoreName,@Address,@BaiduMap,datetime('now','localtime') where not exists(select 1 from stores where loginname='kcly')
";
List<SQLiteParameter> list = GetEntityParas(model);
return ExecuteNonQuery(sqlStr, list.ToArray()) > 0;
}
/// <summary>
/// 登录
/// </summary>
/// <param name="email"></param>
/// <param name="pwd"></param>
/// <param name="store"></param>
/// <returns></returns>
public static bool LoginModel(string email, string pwd, out StoreModel store)
{
store = GetModel(email);
if (store == null) return false;
bool isTrue = Md5.CheckPassword(pwd.Trim().ToLower(), store.LoginPwd, 32);
return isTrue;
}
