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