protected int AddStoreSite(DataTable dt) { SqliteHelper sqliteDb = new SqliteHelper(); try { sqliteDb.Open(); sqliteDb.BeginTransaction(); sqliteDb.ExecuteNonQuery(@"DELETE FROM StoreSite"); int ret = 0; foreach (DataRow dr in dt.Rows) { string sql = string.Format(@"insert into StoreSite(storeSiteId,storeSiteNo,storeSiteName) values ('{0}','{1}','{2}')", DataConvert.ToString(dr["storeSiteId"]), SafeSql.SafeSqlStr(DataConvert.ToString(dr["storeSiteNo"])), SafeSql.SafeSqlStr(DataConvert.ToString(dr["storeSiteName"])) ); ret += sqliteDb.ExecuteNonQuery(sql); } sqliteDb.Commit(); return(ret); } catch (Exception ex) { sqliteDb.RollBack(); throw ex; } finally { sqliteDb.Close(); } }
protected int AddAssetsCheckDetail(DataTable dt) { SqliteHelper sqliteDb = new SqliteHelper(); string sql; try { sqliteDb.Open(); sqliteDb.BeginTransaction(); sqliteDb.ExecuteNonQuery(@"DELETE FROM AssetsCheckDetail"); int ret = 0; foreach (DataRow dr in dt.Rows) { sql = string.Format(@"insert into AssetsCheckDetail(assetsCheckId,assetsCheckNo,assetsCheckName, assetsId,assetsNo,assetsName,remark,storeSiteId,checkDate,assetsUser) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')", DataConvert.ToString(dr["assetsCheckId"]), SafeSql.SafeSqlStr(DataConvert.ToString(dr["assetsCheckNo"])), SafeSql.SafeSqlStr(DataConvert.ToString(dr["assetsCheckName"])), DataConvert.ToString(dr["assetsId"]), SafeSql.SafeSqlStr(DataConvert.ToString(dr["assetsNo"])), SafeSql.SafeSqlStr(DataConvert.ToString(dr["assetsName"])), SafeSql.SafeSqlStr(DataConvert.ToString(dr["remark"])), DataConvert.ToString(dr["storeSiteId"]), DataConvert.ToDateTime(dr["checkDate"]).ToString("yyyy-MM-dd"), DataConvert.ToString(dr["assetsUser"]) ); ret += sqliteDb.ExecuteNonQuery(sql); } sqliteDb.Commit(); return(ret); } catch (Exception ex) { sqliteDb.RollBack(); throw ex; } finally { sqliteDb.Close(); } }