public int Save(IList<Model.DataBean> list)
{
int i = 0;
object result;
AccessHelper db = new AccessHelper();
foreach (var item in list)
{
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO SalesRecord ( ScZydBh, ScBh, ScDj, ScZl, JyTime, State,JyJlID ) ");
sb.Append("values( '" + item.ZydBh + "','" + item.ShcBh + "','" + item.ShcDj + "','" + item.XSSL + "','" +
item.XSTime + "','0','" + item.JyJlID + "')");
OleDbCommand cmd = db.GetSqlStringCommand(sb.ToString());
result = db.ExecuteNonQuery(cmd); //.ExecuteNonQuery(cmd);
i += result == null ? -1 : Convert.ToInt16(result);
}
return i;
}
public IList<Model.DataBean> GetDataList(string path = "")
{
IList<DataBean> list = new List<DataBean>();
string sql = "select * from SalesRecord where State in(0,1)";
AccessHelper db = new AccessHelper();
OleDbCommand cmd = db.GetSqlStringCommand(sql);
DataTable dt = db.ExecuteDataTable(cmd);
foreach (DataRow VARIABLE in dt.Rows)
{
DataBean bena = new DataBean();
bena.ID = UtiData.DBObjectToInt(VARIABLE["ID"]);
bena.ShcBh = UtiData.DBObjectToString(VARIABLE["ScBh"]);
bena.ShcDj = UtiData.DBObjectToString(VARIABLE["ScDj"]);
bena.XSSL = UtiData.DBObjectToString(VARIABLE["ScZl"]);
bena.XSTime = UtiData.DBObjectToDateTime(VARIABLE["JyTime"]);
bena.ZydBh = UtiData.DBObjectToString(VARIABLE["ScZydBh"]);
bena.JyJlID = UtiData.DBObjectToString(VARIABLE["JyJlID"]);
list.Add(bena);
}
return list;
}
public int UpdateState(IList<DataBean> list )
{
object result;
AccessHelper db = new AccessHelper();
StringBuilder sb=new StringBuilder();
foreach (var item in list)
{
sb.Append("," + item.ID + "");
}
StringBuilder sbs = new StringBuilder();
sbs.Append("update SalesRecord set State=2 where ID in("+sb.ToString().Substring(1)+") ");
OleDbCommand cmd = db.GetSqlStringCommand(sbs.ToString());
result = db.ExecuteNonQuery(cmd);
return result == null ? -1 : Convert.ToInt16(result);
}