public void gcsjtj_new(string stryear, string strimage, string strremark, string strtime)
{
DateTime dt = System.Convert.ToDateTime(strtime);
string sql = string.Format("insert into tb_gcsjtj(year,image,remark,time)values('{0}','{1}','{2}','{3}')", stryear, strimage, strremark, dt);
DBI.GetDBI_yhxx().ExecuteScalar(sql);
}
public void glqktj_new(string stryear, string strimage, string strremark, string strtime)
{
DateTime dt = System.Convert.ToDateTime(strtime);
string sql = string.Format("insert into tb_glqktj(year,image,remark,time)values('{0}','{1}','{2}','{3}')", stryear, strimage, strremark, dt);
DBI.GetDBI_yhxx().ExecuteScalar(sql);
// sqlhelp.ExecuteNonQuery(conn,CommandType.Text,"insert into tb_glqktj(year,image,time,remark)values('{0}','{1}','{2}','{3}')",stryear,strimage,strremark,strtime);
}
public DataTable gcsjtj_query(string gcsj_id, string year)
{
string str1 = "";
if (!string.IsNullOrEmpty(gcsj_id))
{
str1 = "where tb_gcsjtj.gcsj_id='" + gcsj_id + "'";
}
if (!string.IsNullOrEmpty(year))
{
if (str1.Length > 0)
{
str1 = str1 + " and tb_gcsjtj.year='" + year + "'";
}
else
{
str1 = "where tb_gcsjtj.year='" + year + "'";
}
}
string str = "select * from tb_gcsjtj " + str1;
DataTable ds = DBI.GetDBI_yhxx().ExecuteDataTable(str);
return(ds);
}