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