private void ShowInfo(int id)
{
Maticsoft.BLL.cccc.fuk_dan bll = new Maticsoft.BLL.cccc.fuk_dan();
Maticsoft.Model.cccc.fuk_dan model = bll.GetModel(id);
this.lblid.Text = model.id.ToString();
this.lblfkfs.Text = model.fkfs;
this.lblfkjine.Text = model.fkjine.ToString();
this.lbldxjine.Text = model.dxjine;
this.lblbz.Text = model.bz;
this.lblskdw.Text = model.skdw;
this.lbljsr.Text = model.jsr;
this.lbldjbh.Text = model.djbh;
this.lblshijian.Text = model.shijian.ToString();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.cccc.fuk_dan model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update fuk_dan set ");
strSql.Append("fkfs=@fkfs,");
strSql.Append("fkjine=@fkjine,");
strSql.Append("dxjine=@dxjine,");
strSql.Append("bz=@bz,");
strSql.Append("skdw=@skdw,");
strSql.Append("jsr=@jsr,");
strSql.Append("djbh=@djbh,");
strSql.Append("shijian=@shijian");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@fkfs", MySqlDbType.VarChar, 64),
new MySqlParameter("@fkjine", MySqlDbType.Int32, 64),
new MySqlParameter("@dxjine", MySqlDbType.VarChar, 64),
new MySqlParameter("@bz", MySqlDbType.VarChar, 64),
new MySqlParameter("@skdw", MySqlDbType.VarChar, 64),
new MySqlParameter("@jsr", MySqlDbType.VarChar, 64),
new MySqlParameter("@djbh", MySqlDbType.VarChar, 64),
new MySqlParameter("@shijian", MySqlDbType.DateTime),
new MySqlParameter("@id", MySqlDbType.Int32, 64)
};
parameters[0].Value = model.fkfs;
parameters[1].Value = model.fkjine;
parameters[2].Value = model.dxjine;
parameters[3].Value = model.bz;
parameters[4].Value = model.skdw;
parameters[5].Value = model.jsr;
parameters[6].Value = model.djbh;
parameters[7].Value = model.shijian;
parameters[8].Value = model.id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.cccc.fuk_dan DataRowToModel(DataRow row)
{
Maticsoft.Model.cccc.fuk_dan model = new Maticsoft.Model.cccc.fuk_dan();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["fkfs"] != null)
{
model.fkfs = row["fkfs"].ToString();
}
if (row["fkjine"] != null && row["fkjine"].ToString() != "")
{
model.fkjine = int.Parse(row["fkjine"].ToString());
}
if (row["dxjine"] != null)
{
model.dxjine = row["dxjine"].ToString();
}
if (row["bz"] != null)
{
model.bz = row["bz"].ToString();
}
if (row["skdw"] != null)
{
model.skdw = row["skdw"].ToString();
}
if (row["jsr"] != null)
{
model.jsr = row["jsr"].ToString();
}
if (row["djbh"] != null)
{
model.djbh = row["djbh"].ToString();
}
if (row["shijian"] != null && row["shijian"].ToString() != "")
{
model.shijian = DateTime.Parse(row["shijian"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.cccc.fuk_dan model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into fuk_dan(");
strSql.Append("fkfs,fkjine,dxjine,bz,skdw,jsr,djbh,shijian)");
strSql.Append(" values (");
strSql.Append("@fkfs,@fkjine,@dxjine,@bz,@skdw,@jsr,@djbh,@shijian)");
MySqlParameter[] parameters =
{
new MySqlParameter("@fkfs", MySqlDbType.VarChar, 64),
new MySqlParameter("@fkjine", MySqlDbType.Int32, 64),
new MySqlParameter("@dxjine", MySqlDbType.VarChar, 64),
new MySqlParameter("@bz", MySqlDbType.VarChar, 64),
new MySqlParameter("@skdw", MySqlDbType.VarChar, 64),
new MySqlParameter("@jsr", MySqlDbType.VarChar, 64),
new MySqlParameter("@djbh", MySqlDbType.VarChar, 64),
new MySqlParameter("@shijian", MySqlDbType.DateTime)
};
parameters[0].Value = model.fkfs;
parameters[1].Value = model.fkjine;
parameters[2].Value = model.dxjine;
parameters[3].Value = model.bz;
parameters[4].Value = model.skdw;
parameters[5].Value = model.jsr;
parameters[6].Value = model.djbh;
parameters[7].Value = model.shijian;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.cccc.fuk_dan GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,fkfs,fkjine,dxjine,bz,skdw,jsr,djbh,shijian from fuk_dan ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
Maticsoft.Model.cccc.fuk_dan model = new Maticsoft.Model.cccc.fuk_dan();
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.txtfkfs.Text.Trim().Length == 0)
{
strErr += "fkfs不能为空！\\n";
}
if (!PageValidate.IsNumber(txtfkjine.Text))
{
strErr += "fkjine格式错误！\\n";
}
if (this.txtdxjine.Text.Trim().Length == 0)
{
strErr += "dxjine不能为空！\\n";
}
if (this.txtbz.Text.Trim().Length == 0)
{
strErr += "bz不能为空！\\n";
}
if (this.txtskdw.Text.Trim().Length == 0)
{
strErr += "skdw不能为空！\\n";
}
if (this.txtjsr.Text.Trim().Length == 0)
{
strErr += "jsr不能为空！\\n";
}
if (this.txtdjbh.Text.Trim().Length == 0)
{
strErr += "djbh不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtshijian.Text))
{
strErr += "shijian格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string fkfs = this.txtfkfs.Text;
int fkjine = int.Parse(this.txtfkjine.Text);
string dxjine = this.txtdxjine.Text;
string bz = this.txtbz.Text;
string skdw = this.txtskdw.Text;
string jsr = this.txtjsr.Text;
string djbh = this.txtdjbh.Text;
DateTime shijian = DateTime.Parse(this.txtshijian.Text);
Maticsoft.Model.cccc.fuk_dan model = new Maticsoft.Model.cccc.fuk_dan();
model.fkfs = fkfs;
model.fkjine = fkjine;
model.dxjine = dxjine;
model.bz = bz;
model.skdw = skdw;
model.jsr = jsr;
model.djbh = djbh;
model.shijian = shijian;
Maticsoft.BLL.cccc.fuk_dan bll = new Maticsoft.BLL.cccc.fuk_dan();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
