/// <summary>
/// 增加一条数据
/// </summary>
public int Add(zhangte.Model.zt_yonghubiao model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into zt_yonghubiao(");
strSql.Append("用户名,密码,联系方式,收货地址) values (");
strSql.Append("@用户名,@密码,@联系方式,@收货地址)");
strSql.Append(";");
MySqlParameter[] parameters =
{
new MySqlParameter("@用户名", MySqlDbType.VarChar, 255),
new MySqlParameter("@密码", MySqlDbType.VarChar, 255),
new MySqlParameter("@联系方式", MySqlDbType.VarChar, 255),
new MySqlParameter("@收货地址", MySqlDbType.VarChar, 255)
};
parameters[0].Value = model.用户名;
parameters[1].Value = model.密码;
parameters[2].Value = model.联系方式;
parameters[3].Value = model.收货地址;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(rows);
}
else
{
return(0);
}
}
private string savezl(string yonghuming, HttpContext context)
{
string mima = context.Request.QueryString["mima"].ToString();
string lianxifangshi1 = context.Request.QueryString["lianxifangshi1"].ToString();
string shouhuodizhi1 = context.Request.QueryString["shouhuodizhi1"].ToString();
zhangte.BLL.zt_yonghubiao bll1 = new zhangte.BLL.zt_yonghubiao();
DataTable dt1 = bll1.GetList("用户名='" + yonghuming + "'").Tables[0];
zhangte.Model.zt_yonghubiao md1 = new zhangte.Model.zt_yonghubiao();
md1.Id = int.Parse(dt1.Rows[0]["id"].ToString());
md1.用户名 = yonghuming;
md1.密码 = mima;
md1.联系方式 = lianxifangshi1;
md1.收货地址 = shouhuodizhi1;
bll1.Update1(md1);
string strret = "OK";
return(strret);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public zhangte.Model.zt_yonghubiao DataRowToModel(DataRow row)
{
zhangte.Model.zt_yonghubiao model = new zhangte.Model.zt_yonghubiao();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["用户名"] != null)
{
model.用户名 = row["用户名"].ToString();
}
if (row["密码"] != null)
{
model.密码 = row["密码"].ToString();
}
if (row["联系方式"] != null)
{
model.联系方式 = row["联系方式"].ToString();
}
if (row["收货地址"] != null)
{
model.收货地址 = row["收货地址"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public zhangte.Model.zt_yonghubiao GetModel(int Id)
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from zt_yonghubiao ");
strSql.Append(" where Id=@Id LIMIT 1");
MySqlParameter[] parameters =
{
new MySqlParameter("@Id", MySql.Data.MySqlClient.MySqlDbType.Int16, 11)
};
parameters[0].Value = Id;
zhangte.Model.zt_yonghubiao model = new zhangte.Model.zt_yonghubiao();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public void ProcessRequest(HttpContext context)
{
string yonghuming = context.Request.Form["yonghuming"].ToString().Trim();
string mima = context.Request.Form["mima"].ToString();
string chongfumima = context.Request.Form["chongfumima"].ToString();
string lianxifangshi = context.Request.Form["lianxifangshi"].ToString();
string shouhuodizhi = context.Request.Form["shouhuodizhi"].ToString();
if (mima.Equals(chongfumima) == false)
{
context.Response.Write("两次密码不一致");
return;
}
if (yonghuming == "" || mima == "" || chongfumima == "" || lianxifangshi == "" || shouhuodizhi == "")
{
context.Response.Write("还有信息未填写");
return;
}
zhangte.BLL.zt_yonghubiao bll1 = new zhangte.BLL.zt_yonghubiao();
DataTable dt1 = bll1.GetList("用户名='" + yonghuming + "'").Tables[0];
if (dt1.Rows.Count > 0)
{
context.Response.Write("用户名已存在");
return;
}
zhangte.Model.zt_yonghubiao md1 = new zhangte.Model.zt_yonghubiao();
md1.用户名 = yonghuming;
md1.密码 = mima;
md1.联系方式 = lianxifangshi;
md1.收货地址 = shouhuodizhi;
bll1.Add1(md1);
context.Response.Write("注册成功");
}
private string readzl(string yonghuming, HttpContext context)
{
zhangte.BLL.zt_yonghubiao bll1 = new zhangte.BLL.zt_yonghubiao(context);
zhangte.Model.zt_yonghubiao model1 = new zhangte.Model.zt_yonghubiao();
yonghuming = context.Session["用户名"].ToString();
DataSet ds1 = bll1.GetList(" 用户名 = '" + yonghuming + "'");
string strif = " order by id desc";
if (yonghuming != "")
{
strif = " where 用户名 = " + yonghuming + " order by id desc";
}
string strret = "";
if (ds1.Tables[0].Rows.Count > 0)
{
strret = ds1.Tables[0].Rows[0]["用户名"].ToString() + "|" + ds1.Tables[0].Rows[0]["密码"].ToString() + "|" + ds1.Tables[0].Rows[0]["联系方式"].ToString() + "|" + ds1.Tables[0].Rows[0]["收货地址"].ToString() + "|";
}
return(strret);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(zhangte.Model.zt_yonghubiao model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update zt_yonghubiao set ");
strSql.Append("用户名=@用户名,");
strSql.Append("密码=@密码,");
strSql.Append("联系方式=@联系方式,");
strSql.Append("收货地址=@收货地址");
strSql.Append(" where Id=@Id");
MySqlParameter[] parameters =
{
new MySqlParameter("@用户名", MySqlDbType.VarChar, 255),
new MySqlParameter("@密码", MySqlDbType.VarChar, 255),
new MySqlParameter("@联系方式", MySqlDbType.VarChar, 255),
new MySqlParameter("@收货地址", MySqlDbType.VarChar, 255),
new MySqlParameter("@Id", MySqlDbType.Int16, 6)
};
parameters[0].Value = model.用户名;
parameters[1].Value = model.密码;
parameters[2].Value = model.联系方式;
parameters[3].Value = model.收货地址;
parameters[4].Value = model.Id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}