/// <summary> /// 添加店主,先检测是否存在,再在店主表和,所有用户记录表中添加 /// </summary> /// <param name="skeeper"></param> /// <returns></returns> public int addStoreKeeper(storekepper skeeper) { string sql0 = "select * from storekeeper where sk_tel='" + skeeper.sk_tel + "' or sk_idcard='" + skeeper.sk_idcard + "'";//查询店主表中是否有该用户 if (mysqlDBhelper.doselectsqlReturnNum(sql0) == 0) { DataTable dt = mysqlDBhelper.doselectsqlT("select * from managers where ma_tel='" + skeeper.sk_tel + "'");//查询管理员表中是否有该用户 string sql1 = ""; if (dt.Rows.Count == 0) { sql1 = "insert into managers(ma_tel,ma_role) values('" + skeeper.sk_tel + "','3')"; } else { string role = dt.Rows[0][2].ToString() + "-3"; sql1 = "update managers) set ma_role='" + role + "' where ma_tel='" + skeeper.sk_tel + "'"; } mysqlDBhelper.dochangesql(sql1); //插入行细信息 string sql = "insert into storekeeper(sk_tel,sk_idcard,sk_name,sk_pwd,sk_general,sk_birthloacation,sk_birthday,sk_breifinfo,sk_sculpture)" + "values('" + skeeper.sk_tel + "','" + skeeper.sk_idcard + "','" + skeeper.sk_name + "','" + skeeper.sk_pwd + "','" + skeeper.sk_general + "'," + "'" + skeeper.sk_birthloacation + "','" + skeeper.sk_birthday + "','" + skeeper.sk_breifinfo + "','" + skeeper.sk_sculpture + "')"; return(mysqlDBhelper.dochangesql(sql)); } else { return(-1); } }
public int editkeeper(storekepper skeeper) { string sql = "update storekeeper set sk_idcard='" + skeeper.sk_idcard + "',sk_name='" + skeeper.sk_name + "',sk_pwd='" + skeeper.sk_pwd + "',sk_general='" + skeeper.sk_general + "'," + "sk_birthloacation='" + skeeper.sk_birthloacation + "',sk_birthday='" + skeeper.sk_birthday + "',sk_breifinfo='" + skeeper.sk_breifinfo + "' where sk_tel='" + skeeper.sk_tel + "' "; return(mysqlDBhelper.dochangesql(sql)); }
/// <summary> /// 添加店主,先检测是否存在,再在店主表和,所有用户记录表中添加 /// </summary> /// <param name="skeeper"></param> /// <returns></returns> public int addStoreKeeper(storekepper skeeper) { string sql0 = "select * from storekeeper where sk_tel='" + skeeper.sk_tel + "' or sk_idcard='" + skeeper.sk_idcard + "'";//查询店主表中是否有该用户 if (mysqlDBhelper.doselectsqlReturnNum(sql0) == 0) { DataTable dt = mysqlDBhelper.doselectsqlT("select * from managers where ma_tel='" + skeeper.sk_tel + "'");//查询管理员表中是否有该用户 string sql1 = ""; if (dt.Rows.Count == 0) { sql1 = "insert into managers(ma_tel,ma_pwd,ma_ifstorekeeper) values('" + skeeper.sk_tel + "','" + mysqlDBhelper.GetSha1("123456") + "',true)";//添加ma_pwd } else { sql1 = "update managers set ma_ifstorekeeper=true where ma_tel='" + skeeper.sk_tel + "'"; } mysqlDBhelper.dochangesql(sql1); //插入行细信息 string sql = "insert into storekeeper(sk_tel,sk_idcard,sk_name,sk_general,sk_birthloacation,sk_birthday,sk_breifinfo,sk_sculpture)" + "values('" + skeeper.sk_tel + "','" + skeeper.sk_idcard + "','" + skeeper.sk_name + "','" + skeeper.sk_general + "'," + "'" + skeeper.sk_birthloacation + "','" + skeeper.sk_birthday + "','" + skeeper.sk_breifinfo + "','" + skeeper.sk_sculpture + "')";//店主表 return(mysqlDBhelper.dochangesql(sql)); } else { return(-1); } }
/// <summary> /// 编辑店主信息 /// </summary> /// <returns></returns> public int editkeeper() { storekepper skeeper = new storekepper(); skeeper.sk_tel = Request["sk_tel"]; //店主电话作为主键,不可修改 skeeper.sk_idcard = Request["sk_idcard"].ToString(); skeeper.sk_name = Request["sk_name"].ToString(); skeeper.sk_general = Request["sk_general"].ToString(); skeeper.sk_birthloacation = Request["sk_birthloacation"].ToString(); skeeper.sk_birthday = Request["sk_birthday"].ToString(); skeeper.sk_breifinfo = Request["sk_breifinfo"].ToString(); return(bsk.editkeeper(skeeper)); }
/// <summary> /// 增加店主 /// </summary> /// <returns></returns> public int addStoreKeeper() { storekepper skeeper = new storekepper(); skeeper.sk_tel = Request["sk_tel"]; skeeper.sk_idcard = Request["sk_idcard"].ToString(); skeeper.sk_name = Request["sk_name"].ToString(); skeeper.sk_general = Request["sk_general"].ToString(); skeeper.sk_birthloacation = Request["sk_birthloacation"].ToString(); skeeper.sk_birthday = Request["sk_birthday"].ToString(); skeeper.sk_breifinfo = Request["sk_breifinfo"].ToString(); skeeper.sk_sculpture = "auto.jpg";//默认图片头像 return(bsk.addStoreKeeper(skeeper)); }
/// <summary> /// 编辑店主信息 /// </summary> /// <returns></returns> public int editkeeper() { storekepper skeeper = new storekepper(); skeeper.sk_tel = Request["sk_tel"]; //店主电话作为主键,不可修改 skeeper.sk_idcard = Request["sk_idcard"].ToString(); skeeper.sk_name = Request["sk_name"].ToString(); skeeper.sk_pwd = DataHelper.GetSha1("123456");//默认值设置为123456,每次修改后密码自动重置为123456 skeeper.sk_general = Request["sk_general"].ToString(); skeeper.sk_birthloacation = Request["sk_birthloacation"].ToString(); skeeper.sk_birthday = Request["sk_birthday"].ToString(); skeeper.sk_breifinfo = Request["sk_breifinfo"].ToString(); return(bsk.editkeeper(skeeper)); }
/// <summary> /// 增加店主 /// </summary> /// <returns></returns> public int addStoreKeeper() { storekepper skeeper = new storekepper(); skeeper.sk_tel = Request["sk_tel"]; skeeper.sk_idcard = Request["sk_idcard"].ToString(); skeeper.sk_name = Request["sk_name"].ToString(); skeeper.sk_pwd = DataHelper.GetSha1("123456");//默认值设置为123456 skeeper.sk_general = Request["sk_general"].ToString(); skeeper.sk_birthloacation = Request["sk_birthloacation"].ToString(); skeeper.sk_birthday = Request["sk_birthday"].ToString(); skeeper.sk_breifinfo = Request["sk_breifinfo"].ToString(); skeeper.sk_sculpture = "~/Content/images/headicon/sweet.jpg";//默认图片头像 return(bsk.addStoreKeeper(skeeper)); }
public int editkeeper(storekepper skeeper) { return(dsk.editkeeper(skeeper)); }
public int addStoreKeeper(storekepper skeeper) { return(dsk.addStoreKeeper(skeeper)); }