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