protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtusercode.Text.Trim().Length == 0)
{
strErr += "usercode不能为空！\\n";
}
if (this.txtuseraddr.Text.Trim().Length == 0)
{
strErr += "useraddr不能为空！\\n";
}
if (this.txtopertype.Text.Trim().Length == 0)
{
strErr += "opertype不能为空！\\n";
}
if (this.txtoperobject.Text.Trim().Length == 0)
{
strErr += "operobject不能为空！\\n";
}
if (this.txtopervalue.Text.Trim().Length == 0)
{
strErr += "opervalue不能为空！\\n";
}
if (this.txtoperdesc.Text.Trim().Length == 0)
{
strErr += "operdesc不能为空！\\n";
}
if (this.txtopertime.Text.Trim().Length == 0)
{
strErr += "opertime不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string usercode = this.txtusercode.Text;
string useraddr = this.txtuseraddr.Text;
string opertype = this.txtopertype.Text;
string operobject = this.txtoperobject.Text;
string opervalue = this.txtopervalue.Text;
string operdesc = this.txtoperdesc.Text;
string opertime = this.txtopertime.Text;
Jium.Model.userlog model = new Jium.Model.userlog();
model.usercode = usercode;
model.useraddr = useraddr;
model.opertype = opertype;
model.operobject = operobject;
model.opervalue = opervalue;
model.operdesc = operdesc;
model.opertime = opertime;
Jium.BLL.userlog bll = new Jium.BLL.userlog();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
private void ShowInfo(long id)
{
Jium.BLL.userlog bll = new Jium.BLL.userlog();
Jium.Model.userlog model = bll.GetModel(id);
this.lblid.Text = model.id.ToString();
this.lblusercode.Text = model.usercode;
this.lbluseraddr.Text = model.useraddr;
this.lblopertype.Text = model.opertype;
this.lbloperobject.Text = model.operobject;
this.lblopervalue.Text = model.opervalue;
this.lbloperdesc.Text = model.operdesc;
this.lblopertime.Text = model.opertime;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Jium.Model.userlog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update userlog set ");
strSql.Append("usercode=@usercode,");
strSql.Append("useraddr=@useraddr,");
strSql.Append("opertype=@opertype,");
strSql.Append("operobject=@operobject,");
strSql.Append("opervalue=@opervalue,");
strSql.Append("operdesc=@operdesc,");
strSql.Append("opertime=@opertime");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@usercode", MySqlDbType.VarChar, 40),
new MySqlParameter("@useraddr", MySqlDbType.VarChar, 40),
new MySqlParameter("@opertype", MySqlDbType.VarChar, 20),
new MySqlParameter("@operobject", MySqlDbType.VarChar, 40),
new MySqlParameter("@opervalue", MySqlDbType.VarChar, 40),
new MySqlParameter("@operdesc", MySqlDbType.VarChar, 100),
new MySqlParameter("@opertime", MySqlDbType.VarChar, 20),
new MySqlParameter("@id", MySqlDbType.Int64, 20)
};
parameters[0].Value = model.usercode;
parameters[1].Value = model.useraddr;
parameters[2].Value = model.opertype;
parameters[3].Value = model.operobject;
parameters[4].Value = model.opervalue;
parameters[5].Value = model.operdesc;
parameters[6].Value = model.opertime;
parameters[7].Value = model.id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Jium.Model.userlog DataRowToModel(DataRow row)
{
Jium.Model.userlog model = new Jium.Model.userlog();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = long.Parse(row["id"].ToString());
}
if (row["usercode"] != null)
{
model.usercode = row["usercode"].ToString();
}
if (row["useraddr"] != null)
{
model.useraddr = row["useraddr"].ToString();
}
if (row["opertype"] != null)
{
model.opertype = row["opertype"].ToString();
}
if (row["operobject"] != null)
{
model.operobject = row["operobject"].ToString();
}
if (row["opervalue"] != null)
{
model.opervalue = row["opervalue"].ToString();
}
if (row["operdesc"] != null)
{
model.operdesc = row["operdesc"].ToString();
}
if (row["opertime"] != null)
{
model.opertime = row["opertime"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Jium.Model.userlog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into userlog(");
strSql.Append("usercode,useraddr,opertype,operobject,opervalue,operdesc,opertime)");
strSql.Append(" values (");
strSql.Append("@usercode,@useraddr,@opertype,@operobject,@opervalue,@operdesc,@opertime)");
MySqlParameter[] parameters =
{
new MySqlParameter("@usercode", MySqlDbType.VarChar, 40),
new MySqlParameter("@useraddr", MySqlDbType.VarChar, 40),
new MySqlParameter("@opertype", MySqlDbType.VarChar, 20),
new MySqlParameter("@operobject", MySqlDbType.VarChar, 40),
new MySqlParameter("@opervalue", MySqlDbType.VarChar, 40),
new MySqlParameter("@operdesc", MySqlDbType.VarChar, 100),
new MySqlParameter("@opertime", MySqlDbType.VarChar, 20)
};
parameters[0].Value = model.usercode;
parameters[1].Value = model.useraddr;
parameters[2].Value = model.opertype;
parameters[3].Value = model.operobject;
parameters[4].Value = model.opervalue;
parameters[5].Value = model.operdesc;
parameters[6].Value = model.opertime;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Jium.Model.userlog GetModel(long id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,usercode,useraddr,opertype,operobject,opervalue,operdesc,opertime from userlog ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int64)
};
parameters[0].Value = id;
Jium.Model.userlog model = new Jium.Model.userlog();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
