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