/// <summary> /// 添加店主,先检测是否存在,再在店主表和,所有用户记录表中添加 /// </summary> /// <param name="ast"></param> /// <returns></returns> public int addAssistant(assistant ast) { string sql0 = "select * from assistant where sa_tel='" + ast.sa_tel + "' ";//查询店主表中是否有该用户 if (mysqlDBhelper.doselectsqlReturnNum(sql0) == 0) { DataTable dt = mysqlDBhelper.doselectsqlT("select * from managers where ma_tel='" + ast.sa_tel + "'");//查询管理员表中是否有该用户 string sql1 = ""; if (dt.Rows.Count == 0) { sql1 = "insert into managers(ma_tel,ma_ifassitant,ma_nick) values('" + ast.sa_tel + "',true,'" + ast.sa_nick + "')"; } else { sql1 = "update managers set ma_ifassitant=true where ma_tel='" + ast.sa_tel + "'"; } mysqlDBhelper.dochangesql(sql1); //插入行细信息 string sql = "insert into assistant(sa_tel,s_id,sa_name,sa_pwd,sa_general,sa_birthday,sa_breifinfo,sa_sculpture)" + "values('" + ast.sa_tel + "','" + ast.s_id + "','" + ast.sa_name + "','" + ast.sa_pwd + "','" + ast.sa_general + "'," + "'" + ast.sa_birthday + "','" + ast.sa_breifinfo + "','" + ast.sa_sculpture + "')"; return(mysqlDBhelper.dochangesql(sql)); } else { return(-1); } }
public int editAssistant(assistant ast) { string sql = "update assistant set s_id='" + ast.s_id + "',sa_name='" + ast.sa_name + "',sa_pwd='" + ast.sa_pwd + "',sa_general='" + ast.sa_general + "'," + "sa_nick='" + ast.sa_nick + "',sa_birthday='" + ast.sa_birthday + "',sa_breifinfo='" + ast.sa_breifinfo + "' where sa_tel='" + ast.sa_tel + "' "; return(mysqlDBhelper.dochangesql(sql)); }
public Game1() { Console.WriteLine("started"); graphics = new GraphicsDeviceManager(this); Content.RootDirectory = "Content"; quit = false; ass = new assistant(this); //the game is not capable of handling irregular aspect ratios and resolutions, just don't. //Window.AllowUserResizing = true; }
/// <summary> /// 编辑店主信息 /// </summary> /// <returns></returns> public int editAssistant() { assistant ast = new assistant(); ast.sa_tel = Request["sa_tel"]; //店主电话作为主键,不可修改 ast.s_id = Request["s_id"].ToString(); ast.sa_name = Request["sa_name"].ToString(); ast.sa_pwd = DataHelper.GetSha1("123456");//默认值设置为123456,每次修改后密码自动重置为123456 ast.sa_general = Request["sa_general"].ToString(); ast.sa_nick = Request["sa_nick"].ToString(); ast.sa_birthday = Request["sa_birthday"].ToString(); ast.sa_breifinfo = Request["sa_breifinfo"].ToString(); return(bas.editAssistant(ast)); }
/// <summary> /// 增加店主 /// </summary> /// <returns></returns> public int addAssistant() { assistant ast = new assistant(); ast.sa_tel = Request["sa_tel"]; Session["store_id"] = "6666";//临时 ast.s_id = Session["store_id"].ToString(); ast.sa_name = Request["sa_name"].ToString(); ast.sa_pwd = DataHelper.GetSha1("123456");//默认值设置为123456 ast.sa_general = Request["sa_general"].ToString(); ast.sa_nick = Request["sa_nick"].ToString(); ast.sa_birthday = Request["sa_birthday"].ToString(); ast.sa_breifinfo = Request["sa_breifinfo"].ToString(); ast.sa_sculpture = "~/Content/images/headicon/dianyuan.jpg";//默认图片头像 return(bas.addAssistant(ast)); }
public int editAssistant(assistant ast) { return(das.editAssistant(ast)); }
public int addAssistant(assistant ast) { return(das.addAssistant(ast)); }