62,047
社区成员
发帖
与我相关
我的任务
分享
string date = DateTime.Now.AddDays(-3 * System.DateTime.Now.Day).ToShortDateString();
string strConn = ConfigurationManager.ConnectionStrings["ManufacturingExecutionConnectionString"].ConnectionString;
string sql = " select *from stockout where OutDate < '" + date + "'";
SqlDataAdapter da = new SqlDataAdapter(sql, strConn);
DataSet ds = new DataSet("dt");
da.Fill(ds);
DataTable dt = ds.Tables[0];