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); }