/// <summary>
/// 得到一个对象实体
/// </summary>
public YJUI.Model.jldl1 GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,fksj,fkr,pj,fssj,fsdq,dls,dlsdh,xlcxx,fknr,fl,jjsfth,zrbm,zrr,ycclrq,plga,dkhcs,wcsj,kcclcs,kcwcrq,gysclcs,gysrq,nblcgygs,nblcwcrq,qtcs,qtcsrq,zrbmsp,dsfjh,hfsjqk,hfwcrq from jldl1 ");
strSql.Append(" where ID=@ID");
strSql.Append(" order by DESC");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
YJUI.Model.jldl1 model = new YJUI.Model.jldl1();
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_dsfjh(YJUI.Model.jldl1 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update jldl1 set ");
strSql.Append("fl=@fl,");
strSql.Append("dsfjh=@dsfjh");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@fl", SqlDbType.VarChar, 50),
new SqlParameter("@dsfjh", SqlDbType.VarChar, 50),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.fl;
parameters[1].Value = model.dsfjh;
parameters[2].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 责任部门审批
/// </summary>
public bool Update_zrbmsh(YJUI.Model.jldl1 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update jldl1 set ");
strSql.Append("zrbmsp=@zrbmsp");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@zrbmsp", SqlDbType.VarChar, 200),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.zrbmsp;
parameters[1].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 回访实际情况
/// </summary>
public bool Update_hfsjqk(YJUI.Model.jldl1 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update jldl1 set ");
strSql.Append("hfsjqk=@hfsjqk,");
strSql.Append("hfwcrq=@hfwcrq");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@hfsjqk", SqlDbType.Text),
new SqlParameter("@hfwcrq", SqlDbType.VarChar, 50),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.hfsjqk;
parameters[1].Value = model.hfwcrq;
parameters[2].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update_ceshi(YJUI.Model.jldl1 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update jldl1 set ");
strSql.Append("fksj=@fksj,");
strSql.Append("pj=@pj,");
strSql.Append("fssj=@fssj,");
strSql.Append("fsdq=@fsdq,");
strSql.Append("dls=@dls,");
strSql.Append("dlsdh=@dlsdh,");
strSql.Append("xlcxx=@xlcxx,");
strSql.Append("fknr=@fknr,");
strSql.Append("fl=@fl,");
strSql.Append("jjsfth=@jjsfth,");
SqlParameter[] parameters =
{
new SqlParameter("@dls", SqlDbType.VarChar, 50),
new SqlParameter("@dlsdh", SqlDbType.VarChar, 50)
};
parameters[4].Value = model.dls;
parameters[5].Value = model.dlsdh;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public YJUI.Model.jldl1 DataRowToModel(DataRow row)
{
YJUI.Model.jldl1 model = new YJUI.Model.jldl1();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["fksj"] != null && row["fksj"].ToString() != "")
{
model.fksj = DateTime.Parse(row["fksj"].ToString());
}
if (row["fkr"] != null)
{
model.fkr = row["fkr"].ToString();
}
if (row["pj"] != null)
{
model.pj = row["pj"].ToString();
}
if (row["fssj"] != null)
{
model.fssj = row["fssj"].ToString();
}
if (row["fsdq"] != null)
{
model.fsdq = row["fsdq"].ToString();
}
if (row["dls"] != null)
{
model.dls = row["dls"].ToString();
}
if (row["dlsdh"] != null)
{
model.dlsdh = row["dlsdh"].ToString();
}
if (row["xlcxx"] != null)
{
model.xlcxx = row["xlcxx"].ToString();
}
if (row["fknr"] != null)
{
model.fknr = row["fknr"].ToString();
}
if (row["fl"] != null)
{
model.fl = row["fl"].ToString();
}
if (row["jjsfth"] != null)
{
model.jjsfth = row["jjsfth"].ToString();
}
if (row["zrbm"] != null)
{
model.zrbm = row["zrbm"].ToString();
}
if (row["zrr"] != null)
{
model.zrr = row["zrr"].ToString();
}
if (row["ycclrq"] != null)
{
model.ycclrq = row["ycclrq"].ToString();
}
if (row["plga"] != null)
{
model.plga = row["plga"].ToString();
}
if (row["dkhcs"] != null)
{
model.dkhcs = row["dkhcs"].ToString();
}
if (row["wcsj"] != null)
{
model.wcsj = row["wcsj"].ToString();
}
if (row["kcclcs"] != null)
{
model.kcclcs = row["kcclcs"].ToString();
}
if (row["kcwcrq"] != null)
{
model.kcwcrq = row["kcwcrq"].ToString();
}
if (row["gysclcs"] != null)
{
model.gysclcs = row["gysclcs"].ToString();
}
if (row["gysrq"] != null)
{
model.gysrq = row["gysrq"].ToString();
}
if (row["nblcgygs"] != null)
{
model.nblcgygs = row["nblcgygs"].ToString();
}
if (row["nblcwcrq"] != null)
{
model.nblcwcrq = row["nblcwcrq"].ToString();
}
if (row["qtcs"] != null)
{
model.qtcs = row["qtcs"].ToString();
}
if (row["qtcsrq"] != null)
{
model.qtcsrq = row["qtcsrq"].ToString();
}
if (row["zrbmsp"] != null)
{
model.zrbmsp = row["zrbmsp"].ToString();
}
if (row["dsfjh"] != null)
{
model.dsfjh = row["dsfjh"].ToString();
}
if (row["hfsjqk"] != null)
{
model.hfsjqk = row["hfsjqk"].ToString();
}
if (row["hfwcrq"] != null)
{
model.hfwcrq = row["hfwcrq"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(YJUI.Model.jldl1 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into jldl1(");
strSql.Append("fksj,fkr,pj,fssj,fsdq,dls,dlsdh,xlcxx,fknr,fl,jjsfth,zrbm,zrr,ycclrq,plga,dkhcs,wcsj,kcclcs,kcwcrq,gysclcs,gysrq,nblcgygs,nblcwcrq,qtcs,qtcsrq,zrbmsp,dsfjh,hfsjqk,hfwcrq)");
strSql.Append(" values (");
strSql.Append("@fksj,@fkr,@pj,@fssj,@fsdq,@dls,@dlsdh,@xlcxx,@fknr,@fl,@jjsfth,@zrbm,@zrr,@ycclrq,@plga,@dkhcs,@wcsj,@kcclcs,@kcwcrq,@gysclcs,@gysrq,@nblcgygs,@nblcwcrq,@qtcs,@qtcsrq,@zrbmsp,@dsfjh,@hfsjqk,@hfwcrq)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@fksj", SqlDbType.DateTime),
new SqlParameter("@fkr", SqlDbType.VarChar, 50),
new SqlParameter("@pj", SqlDbType.VarChar, 50),
new SqlParameter("@fssj", SqlDbType.VarChar, 50),
new SqlParameter("@fsdq", SqlDbType.VarChar, 50),
new SqlParameter("@dls", SqlDbType.VarChar, 50),
new SqlParameter("@dlsdh", SqlDbType.VarChar, 50),
new SqlParameter("@xlcxx", SqlDbType.VarChar, 50),
new SqlParameter("@fknr", SqlDbType.Text),
new SqlParameter("@fl", SqlDbType.Char, 10),
new SqlParameter("@jjsfth", SqlDbType.Char, 40),
new SqlParameter("@zrbm", SqlDbType.Char, 40),
new SqlParameter("@zrr", SqlDbType.Char, 40),
new SqlParameter("@ycclrq", SqlDbType.VarChar, 50),
new SqlParameter("@plga", SqlDbType.Char, 10),
new SqlParameter("@dkhcs", SqlDbType.Text),
new SqlParameter("@wcsj", SqlDbType.VarChar, 100),
new SqlParameter("@kcclcs", SqlDbType.Text),
new SqlParameter("@kcwcrq", SqlDbType.VarChar, 50),
new SqlParameter("@gysclcs", SqlDbType.Text),
new SqlParameter("@gysrq", SqlDbType.VarChar, 50),
new SqlParameter("@nblcgygs", SqlDbType.Text),
new SqlParameter("@nblcwcrq", SqlDbType.VarChar, 50),
new SqlParameter("@qtcs", SqlDbType.Text),
new SqlParameter("@qtcsrq", SqlDbType.VarChar, 50),
new SqlParameter("@zrbmsp", SqlDbType.VarChar, 50),
new SqlParameter("@dsfjh", SqlDbType.VarChar, 50),
new SqlParameter("@hfsjqk", SqlDbType.Text),
new SqlParameter("@hfwcrq", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.fksj;
parameters[1].Value = model.fkr;
parameters[2].Value = model.pj;
parameters[3].Value = model.fssj;
parameters[4].Value = model.fsdq;
parameters[5].Value = model.dls;
parameters[6].Value = model.dlsdh;
parameters[7].Value = model.xlcxx;
parameters[8].Value = model.fknr;
parameters[9].Value = model.fl;
parameters[10].Value = model.jjsfth;
parameters[11].Value = model.zrbm;
parameters[12].Value = model.zrr;
parameters[13].Value = model.ycclrq;
parameters[14].Value = model.plga;
parameters[15].Value = model.dkhcs;
parameters[16].Value = model.wcsj;
parameters[17].Value = model.kcclcs;
parameters[18].Value = model.kcwcrq;
parameters[19].Value = model.gysclcs;
parameters[20].Value = model.gysrq;
parameters[21].Value = model.nblcgygs;
parameters[22].Value = model.nblcwcrq;
parameters[23].Value = model.qtcs;
parameters[24].Value = model.qtcsrq;
parameters[25].Value = model.zrbmsp;
parameters[26].Value = model.dsfjh;
parameters[27].Value = model.hfsjqk;
parameters[28].Value = model.hfwcrq;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 责任部门审批
/// </summary>
public bool Update_zrbm(YJUI.Model.jldl1 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update jldl1 set ");
strSql.Append("jjsfth=@jjsfth,");
strSql.Append("zrbm=@zrbm,");
strSql.Append("zrr=@zrr,");
strSql.Append("ycclrq=@ycclrq,");
strSql.Append("plga=@plga,");
strSql.Append("dkhcs=@dkhcs,");
strSql.Append("wcsj=@wcsj,");
strSql.Append("kcclcs=@kcclcs,");
strSql.Append("kcwcrq=@kcwcrq,");
strSql.Append("gysclcs=@gysclcs,");
strSql.Append("gysrq=@gysrq,");
strSql.Append("nblcgygs=@nblcgygs,");
strSql.Append("nblcwcrq=@nblcwcrq,");
strSql.Append("qtcs=@qtcs,");
strSql.Append("qtcsrq=@qtcsrq");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@jjsfth", SqlDbType.Char, 40),
new SqlParameter("@zrbm", SqlDbType.Char, 40),
new SqlParameter("@zrr", SqlDbType.Char, 40),
new SqlParameter("@ycclrq", SqlDbType.VarChar, 50),
new SqlParameter("@plga", SqlDbType.Char, 10),
new SqlParameter("@dkhcs", SqlDbType.Text),
new SqlParameter("@wcsj", SqlDbType.VarChar, 100),
new SqlParameter("@kcclcs", SqlDbType.Text),
new SqlParameter("@kcwcrq", SqlDbType.VarChar, 50),
new SqlParameter("@gysclcs", SqlDbType.Text),
new SqlParameter("@gysrq", SqlDbType.VarChar, 50),
new SqlParameter("@nblcgygs", SqlDbType.Text),
new SqlParameter("@nblcwcrq", SqlDbType.VarChar, 50),
new SqlParameter("@qtcs", SqlDbType.Text),
new SqlParameter("@qtcsrq", SqlDbType.VarChar, 50),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.jjsfth;
parameters[1].Value = model.zrbm;
parameters[2].Value = model.zrr;
parameters[3].Value = model.ycclrq;
parameters[4].Value = model.plga;
parameters[5].Value = model.dkhcs;
parameters[6].Value = model.wcsj;
parameters[7].Value = model.kcclcs;
parameters[8].Value = model.kcwcrq;
parameters[9].Value = model.gysclcs;
parameters[10].Value = model.gysrq;
parameters[11].Value = model.nblcgygs;
parameters[12].Value = model.nblcwcrq;
parameters[13].Value = model.qtcs;
parameters[14].Value = model.qtcsrq;
parameters[15].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(YJUI.Model.jldl1 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update jldl1 set ");
strSql.Append("fksj=@fksj,");
strSql.Append("pj=@pj,");
strSql.Append("fssj=@fssj,");
strSql.Append("fsdq=@fsdq,");
strSql.Append("dls=@dls,");
strSql.Append("dlsdh=@dlsdh,");
strSql.Append("xlcxx=@xlcxx,");
strSql.Append("fknr=@fknr,");
strSql.Append("fl=@fl,");
strSql.Append("jjsfth=@jjsfth,");
strSql.Append("zrbm=@zrbm,");
strSql.Append("zrr=@zrr,");
strSql.Append("ycclrq=@ycclrq,");
strSql.Append("plga=@plga,");
strSql.Append("dkhcs=@dkhcs,");
strSql.Append("wcsj=@wcsj,");
strSql.Append("kcclcs=@kcclcs,");
strSql.Append("kcwcrq=@kcwcrq,");
strSql.Append("gysclcs=@gysclcs,");
strSql.Append("gysrq=@gysrq,");
strSql.Append("nblcgygs=@nblcgygs,");
strSql.Append("nblcwcrq=@nblcwcrq,");
strSql.Append("qtcs=@qtcs,");
strSql.Append("qtcsrq=@qtcsrq,");
strSql.Append("zrbmsp=@zrbmsp,");
strSql.Append("dsfjh=@dsfjh,");
strSql.Append("hfsjqk=@hfsjqk,");
strSql.Append("hfwcrq=@hfwcrq");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@fksj", SqlDbType.DateTime),
new SqlParameter("@pj", SqlDbType.VarChar, 50),
new SqlParameter("@fssj", SqlDbType.VarChar, 50),
new SqlParameter("@fsdq", SqlDbType.VarChar, 50),
new SqlParameter("@dls", SqlDbType.VarChar, 50),
new SqlParameter("@dlsdh", SqlDbType.VarChar, 50),
new SqlParameter("@xlcxx", SqlDbType.VarChar, 50),
new SqlParameter("@fknr", SqlDbType.Text),
new SqlParameter("@fl", SqlDbType.Char, 10),
new SqlParameter("@jjsfth", SqlDbType.Char, 40),
new SqlParameter("@zrbm", SqlDbType.Char, 40),
new SqlParameter("@zrr", SqlDbType.Char, 40),
new SqlParameter("@ycclrq", SqlDbType.VarChar, 50),
new SqlParameter("@plga", SqlDbType.Char, 10),
new SqlParameter("@dkhcs", SqlDbType.Text),
new SqlParameter("@wcsj", SqlDbType.VarChar, 100),
new SqlParameter("@kcclcs", SqlDbType.Text),
new SqlParameter("@kcwcrq", SqlDbType.VarChar, 50),
new SqlParameter("@gysclcs", SqlDbType.Text),
new SqlParameter("@gysrq", SqlDbType.VarChar, 50),
new SqlParameter("@nblcgygs", SqlDbType.Text),
new SqlParameter("@nblcwcrq", SqlDbType.VarChar, 50),
new SqlParameter("@qtcs", SqlDbType.Text),
new SqlParameter("@qtcsrq", SqlDbType.VarChar, 50),
new SqlParameter("@zrbmsp", SqlDbType.VarChar, 50),
new SqlParameter("@dsfjh", SqlDbType.VarChar, 50),
new SqlParameter("@hfsjqk", SqlDbType.Text),
new SqlParameter("@hfwcrq", SqlDbType.VarChar, 50),
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@fkr", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.fksj;
parameters[1].Value = model.pj;
parameters[2].Value = model.fssj;
parameters[3].Value = model.fsdq;
parameters[4].Value = model.dls;
parameters[5].Value = model.dlsdh;
parameters[6].Value = model.xlcxx;
parameters[7].Value = model.fknr;
parameters[8].Value = model.fl;
parameters[9].Value = model.jjsfth;
parameters[10].Value = model.zrbm;
parameters[11].Value = model.zrr;
parameters[12].Value = model.ycclrq;
parameters[13].Value = model.plga;
parameters[14].Value = model.dkhcs;
parameters[15].Value = model.wcsj;
parameters[16].Value = model.kcclcs;
parameters[17].Value = model.kcwcrq;
parameters[18].Value = model.gysclcs;
parameters[19].Value = model.gysrq;
parameters[20].Value = model.nblcgygs;
parameters[21].Value = model.nblcwcrq;
parameters[22].Value = model.qtcs;
parameters[23].Value = model.qtcsrq;
parameters[24].Value = model.zrbmsp;
parameters[25].Value = model.dsfjh;
parameters[26].Value = model.hfsjqk;
parameters[27].Value = model.hfwcrq;
parameters[28].Value = model.ID;
parameters[29].Value = model.fkr;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
