protected void btnadd_Click(object sender, EventArgs e)
{
SysLogBll.Create("检证书修改", "检证书修改", adminUser.AdminName);
NCPEP.Bll.T_Jzs bll = new NCPEP.Bll.T_Jzs();
NCPEP.Model.T_Jzs model = new NCPEP.Model.T_Jzs();
DataTable dt = bll.GetList(" binid='" + Request.QueryString["p"] + "'").Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
bll.Delete(int.Parse(dr["id"].ToString()));
}
}
try { model.beizhu = this.txtbeizhu.Value; }
catch { }
try { model.binid = Request.QueryString["p"].ToString(); }
catch { }
model.cjje = this.txtcjje.Value;
model.htbh = this.txthtbh.Value;
model.zcdate = this.txtStartDatejzs.Value;
model.zcdatez = this.txtEndDatejzs.Value;
model.beiyong = this.txtbeizhu.Value.Trim();
//int id = (int)dal.Create(GetModels(context));
int id = bll.Add(model);
if (id > 0)
{
MessageBox.Show(this, "更新成功！");
}
else
{
MessageBox.Show(this, "更新失败！");
}
}
private string Create(HttpContext context)
{
try
{
SysLogBll.Create("检证书修改", "检证书修改", adminUser.AdminName);
NCPEP.Bll.T_Jzs bll = new NCPEP.Bll.T_Jzs();
NCPEP.Model.T_Jzs model = new NCPEP.Model.T_Jzs();
try { model.beizhu = context.Request.Form["beizhu"].ToString(); }
catch { }
try { model.binid = context.Request.Form["Id"].ToString(); }
catch { }
model.cjje = context.Request.Form["cjje"].ToString();
model.htbh = context.Request.Form["htbh"].ToString();
model.zcdate = context.Request.Form["jzsStartDate"].ToString();
model.zcdatez = context.Request.Form["jzsEndDate"].ToString();
//int id = (int)dal.Create(GetModels(context));
int id = bll.Add(model);
if (id > 0)
{
return("添加成功！");
}
else
{
return("添加失败请重新操作! ");
}
}
catch (Exception ex)
{
SystemErrorPlug.ErrorRecord("时间:[" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "]类名:[" + this.GetType().Name + "],行号:[" + Component.GetLineNum().ToString() + "行],错误信息:[" + ex.Message + "]");
return("添加失败请重新操作，错误代码：500 ");
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(NCPEP.Model.T_Jzs model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Jzs set ");
strSql.Append("zcdate=@zcdate,");
strSql.Append("zcdatez=@zcdatez,");
strSql.Append("cjje=@cjje,");
strSql.Append("htbh=@htbh,");
strSql.Append("binid=@binid,");
strSql.Append("beizhu=@beizhu,");
strSql.Append("beiyong=@beiyong,");
strSql.Append("beiyong2=@beiyong2");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@zcdate", SqlDbType.VarChar, 50),
new SqlParameter("@zcdatez", SqlDbType.VarChar, 50),
new SqlParameter("@cjje", SqlDbType.VarChar, 50),
new SqlParameter("@htbh", SqlDbType.VarChar, 50),
new SqlParameter("@binid", SqlDbType.VarChar, 50),
new SqlParameter("@beizhu", SqlDbType.VarChar, 500),
new SqlParameter("@beiyong", SqlDbType.VarChar, 500),
new SqlParameter("@beiyong2", SqlDbType.VarChar, 500),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.zcdate;
parameters[1].Value = model.zcdatez;
parameters[2].Value = model.cjje;
parameters[3].Value = model.htbh;
parameters[4].Value = model.binid;
parameters[5].Value = model.beizhu;
parameters[6].Value = model.beiyong;
parameters[7].Value = model.beiyong2;
parameters[8].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public NCPEP.Model.T_Jzs DataRowToModel(DataRow row)
{
NCPEP.Model.T_Jzs model = new NCPEP.Model.T_Jzs();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["zcdate"] != null)
{
model.zcdate = row["zcdate"].ToString();
}
if (row["zcdatez"] != null)
{
model.zcdatez = row["zcdatez"].ToString();
}
if (row["cjje"] != null)
{
model.cjje = row["cjje"].ToString();
}
if (row["htbh"] != null)
{
model.htbh = row["htbh"].ToString();
}
if (row["binid"] != null)
{
model.binid = row["binid"].ToString();
}
if (row["beizhu"] != null)
{
model.beizhu = row["beizhu"].ToString();
}
if (row["beiyong"] != null)
{
model.beiyong = row["beiyong"].ToString();
}
if (row["beiyong2"] != null)
{
model.beiyong2 = row["beiyong2"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(NCPEP.Model.T_Jzs model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Jzs(");
strSql.Append("zcdate,zcdatez,cjje,htbh,binid,beizhu,beiyong,beiyong2)");
strSql.Append(" values (");
strSql.Append("@zcdate,@zcdatez,@cjje,@htbh,@binid,@beizhu,@beiyong,@beiyong2)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@zcdate", SqlDbType.VarChar, 50),
new SqlParameter("@zcdatez", SqlDbType.VarChar, 50),
new SqlParameter("@cjje", SqlDbType.VarChar, 50),
new SqlParameter("@htbh", SqlDbType.VarChar, 50),
new SqlParameter("@binid", SqlDbType.VarChar, 50),
new SqlParameter("@beizhu", SqlDbType.VarChar, 500),
new SqlParameter("@beiyong", SqlDbType.VarChar, 500),
new SqlParameter("@beiyong2", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.zcdate;
parameters[1].Value = model.zcdatez;
parameters[2].Value = model.cjje;
parameters[3].Value = model.htbh;
parameters[4].Value = model.binid;
parameters[5].Value = model.beizhu;
parameters[6].Value = model.beiyong;
parameters[7].Value = model.beiyong2;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public NCPEP.Model.T_Jzs GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,zcdate,zcdatez,cjje,htbh,binid,beizhu,beiyong,beiyong2 from T_Jzs ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
NCPEP.Model.T_Jzs model = new NCPEP.Model.T_Jzs();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(NCPEP.Model.T_Jzs model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(NCPEP.Model.T_Jzs model)
{
return(dal.Add(model));
}
