public bool SaveRequestLog(int i,string type,string zydbh)
{
DBHelper db=new DBHelper();
Guid id = Guid.NewGuid();
string sql = "";
if (i > 0)
{
sql="insert into RequestLog select '"+id+"','"+zydbh+"','"+type+"','"+DateTime.Now+
"','1'";
}
else
{
sql = "insert into RequestLog select '" + id + "','" + zydbh + "','" + type + "','" + DateTime.Now +
"','0'";
}
DbCommand cmd = db.GetSqlStringCommand(sql);
if (db.ExecuteNonQuery(cmd) > 0)
{
return true;
}
else
{
return false;
}
}
public int Save(IList<Model.DataBean> list)
{
int i = list.Count;
int b = 0;
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO SalesRecords ");
DBHelper db = new DBHelper();
foreach (var item in list)
{
b++;
if (b != i)
{
sb.Append("select '" + item.guid + "','" + item.ZydBh + "','" + item.ShcBh + "','" + item.ShcDj +
"','" + item.XSSL + "','" + item.XSTime + "','" + item.JyJlID + "' union ");
}
else
{
sb.Append("select '" + item.guid + "','" + item.ZydBh + "','" + item.ShcBh + "','" + item.ShcDj +
"','" + item.XSSL + "','" + item.XSTime + "','" + item.JyJlID + "'");
}
}
DbCommand cmd = db.GetSqlStringCommand(sb.ToString());
object result = db.ExecuteNonQuery(cmd);
int m = result == null ? -1 : Convert.ToInt16(result);
SaveRequestLog(m, "提交数据", list[0].ZydBh);
return m;
}