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();
}
}
/// <summary>
/// 获得最新的省略词
/// </summary>
/// <returns></returns>
public List <string> GetShenglueci(string dbfile, string str_sql, string field)
{
List <string> list_result = new List <string>();
mysqliter = new SqliteHelper(dbfile);
mysqliter.Open();
List <object> list_o = mysqliter.ExecuteRow(str_sql, null, null);
foreach (object o in list_o)
{
Dictionary <string, object> dic = o as Dictionary <string, object>;
list_result.Add(dic[field].ToString());
}
mysqliter.Close();
return(list_result);
}
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();
}
}
private RequestResult LocalSQL(DBTransfer transfer)
{
RequestResult result = new RequestResult();
result.Error = ErrorCode.Sucess;
DBAcessPool dBAcess = new DBAcessPool();
dBAcess.DBName = transfer.DBCfg;
if (transfer.IsQuery)
{
try
{
DataSet ds = sqliteHelper.GetSelect(transfer.SQL);
sqliteHelper.Close();
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
result.Result = dt;
if (transfer.IsModel && !string.IsNullOrEmpty(transfer.ModelCls))
{
object value = null;
if (!dicModels.TryGetValue(transfer.ModelCls, out value))
{
string path = null;
path = transfer.ModelDLL;
if (string.IsNullOrEmpty(path))
{
path = transfer.ModelCls.Substring(0, transfer.ModelCls.LastIndexOf("."));
}
Assembly assembly = Assembly.LoadFrom(Path.Combine("Models", path, ".dll"));
value = assembly.CreateInstance(transfer.ModelCls, true);
}
//
try
{
result.Result = DataConvert <object> .ToList(dt);
}
catch (Exception ex)
{
result.Error = ErrorCode.Exception;
result.ReslutMsg = "转换Model错误，" + ex.Message;
}
}
}
}
catch (Exception ex)
{
result.Error = ErrorCode.Exception;
result.ReslutMsg = "查询错误，" + ex.Message;
}
}
else
{
try
{
int r = sqliteHelper.ExecuteUpdate(transfer.SQL, transfer.IsScala);
result.Result = r;
sqliteHelper.Close();
}
catch (Exception ex)
{
result.Error = ErrorCode.Exception;
result.ReslutMsg = "执行错误，" + ex.Message;
}
}
result.ErrorMsg = result.Error.ToDescriptionString();
return(result);
}
