/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Jium.Model.userinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update userinfo set ");
strSql.Append("tagname=@tagname,");
strSql.Append("email=@email,");
strSql.Append("level=@level,");
strSql.Append("pwd=@pwd,");
strSql.Append("remark=@remark,");
strSql.Append("createtime=@createtime,");
strSql.Append("token=@token,");
strSql.Append("tokentime=@tokentime,");
strSql.Append("status=@status");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@tagname", MySqlDbType.VarChar, 40),
new MySqlParameter("@email", MySqlDbType.VarChar, 40),
new MySqlParameter("@level", MySqlDbType.smallint, 8),
new MySqlParameter("@pwd", MySqlDbType.VarChar, 40),
new MySqlParameter("@remark", MySqlDbType.VarChar, 256),
new MySqlParameter("@createtime", MySqlDbType.VarChar, 20),
new MySqlParameter("@token", MySqlDbType.VarChar, 128),
new MySqlParameter("@tokentime", MySqlDbType.VarChar, 20),
new MySqlParameter("@status", MySqlDbType.Int32, 11),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.tagname;
parameters[1].Value = model.email;
parameters[2].Value = model.level;
parameters[3].Value = model.pwd;
parameters[4].Value = model.remark;
parameters[5].Value = model.createtime;
parameters[6].Value = model.token;
parameters[7].Value = model.tokentime;
parameters[8].Value = model.status;
parameters[9].Value = model.id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ShowInfo(int id)
{
Jium.BLL.userinfo bll = new Jium.BLL.userinfo();
Jium.Model.userinfo model = bll.GetModel(id);
this.lblid.Text = model.id.ToString();
this.lbltagname.Text = model.tagname;
this.lblemail.Text = model.email;
this.lbllevel.Text = model.level.ToString();
this.lblpwd.Text = model.pwd;
this.lblremark.Text = model.remark;
this.lblcreatetime.Text = model.createtime;
this.lbltoken.Text = model.token;
this.lbltokentime.Text = model.tokentime;
this.lblstatus.Text = model.status.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Jium.Model.userinfo DataRowToModel(DataRow row)
{
Jium.Model.userinfo model = new Jium.Model.userinfo();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["tagname"] != null)
{
model.tagname = row["tagname"].ToString();
}
if (row["email"] != null)
{
model.email = row["email"].ToString();
}
if (row["level"] != null && row["level"].ToString() != "")
{
model.level = int.Parse(row["level"].ToString());
}
if (row["pwd"] != null)
{
model.pwd = row["pwd"].ToString();
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["createtime"] != null)
{
model.createtime = row["createtime"].ToString();
}
if (row["token"] != null)
{
model.token = row["token"].ToString();
}
if (row["tokentime"] != null)
{
model.tokentime = row["tokentime"].ToString();
}
if (row["status"] != null && row["status"].ToString() != "")
{
model.status = int.Parse(row["status"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Jium.Model.userinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into userinfo(");
strSql.Append("tagname,email,level,pwd,remark,createtime,token,tokentime,status)");
strSql.Append(" values (");
strSql.Append("@tagname,@email,@level,@pwd,@remark,@createtime,@token,@tokentime,@status)");
MySqlParameter[] parameters =
{
new MySqlParameter("@tagname", MySqlDbType.VarChar, 40),
new MySqlParameter("@email", MySqlDbType.VarChar, 40),
new MySqlParameter("@level", MySqlDbType.smallint, 8),
new MySqlParameter("@pwd", MySqlDbType.VarChar, 40),
new MySqlParameter("@remark", MySqlDbType.VarChar, 256),
new MySqlParameter("@createtime", MySqlDbType.VarChar, 20),
new MySqlParameter("@token", MySqlDbType.VarChar, 128),
new MySqlParameter("@tokentime", MySqlDbType.VarChar, 20),
new MySqlParameter("@status", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.tagname;
parameters[1].Value = model.email;
parameters[2].Value = model.level;
parameters[3].Value = model.pwd;
parameters[4].Value = model.remark;
parameters[5].Value = model.createtime;
parameters[6].Value = model.token;
parameters[7].Value = model.tokentime;
parameters[8].Value = model.status;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Jium.Model.userinfo GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,tagname,email,level,pwd,remark,createtime,token,tokentime,status from userinfo ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
Jium.Model.userinfo model = new Jium.Model.userinfo();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txttagname.Text.Trim().Length == 0)
{
strErr += "tagname不能为空！\\n";
}
if (this.txtemail.Text.Trim().Length == 0)
{
strErr += "email不能为空！\\n";
}
if (!PageValidate.IsNumber(txtlevel.Text))
{
strErr += "level格式错误！\\n";
}
if (this.txtpwd.Text.Trim().Length == 0)
{
strErr += "pwd不能为空！\\n";
}
if (this.txtremark.Text.Trim().Length == 0)
{
strErr += "remark不能为空！\\n";
}
//if(this.txtcreatetime.Text.Trim().Length==0)
//{
// strErr+="createtime不能为空！\\n";
//}
//if(this.txttoken.Text.Trim().Length==0)
//{
// strErr+="token不能为空！\\n";
//}
//if(this.txttokentime.Text.Trim().Length==0)
//{
// strErr+="tokentime不能为空！\\n";
//}
//if(!PageValidate.IsNumber(txtstatus.Text))
//{
// strErr+="status格式错误！\\n";
//}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string tagname = this.txttagname.Text;
string email = this.txtemail.Text;
int level = int.Parse(this.txtlevel.Text);
string pwd = this.txtpwd.Text;
string remark = this.txtremark.Text;
string createtime = DateTime.Now.ToString("yyyyMMddHHmmss");// this.txtcreatetime.Text;
//string token=this.txttoken.Text;
//string tokentime=this.txttokentime.Text;
//int status=int.Parse(this.txtstatus.Text);
Jium.Model.userinfo model = new Jium.Model.userinfo();
model.tagname = tagname;
model.email = email;
model.level = level;
model.pwd = pwd;
model.remark = remark;
model.createtime = createtime;
//model.token=token;
//model.tokentime=tokentime;
//model.status=status;
Jium.BLL.userinfo bll = new Jium.BLL.userinfo();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
