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