/// <summary>
/// 创建数据库连接会话
/// </summary>
/// <param name="dbContext"></param>
private static DBSession Create(DBContext dbContext)
{
DBSession session = null;
switch (dbContext.DataType)
{
case DataBaseType.SQLServer:
session = new SQLServer();
break;
case DataBaseType.Oracle:
session = new Oracle();
break;
case DataBaseType.MySQL:
session = new MySQL();
break;
case DataBaseType.SQLite:
session = new SQLite();
break;
}
if (session == null)
{
throw new MyDBException("未知的数据库连接！");
}
//设置session的数据库连接对象
session._dbContext = dbContext;
//创建该Session的数据库连接
session.CreateConnection();
return(session);
}
//获取表中装配线
internal List<EapDepartment> GetASSEMBLY_LINE()
{
StringBuilder sql = new StringBuilder(200);
sql.Append("select distinct ASSEMBLY_LINE from t_eap_department");
return Oracle.GetOracle().QueryToList<EapDepartment>(sql);
}
/// <summary>
/// 根据程序集名称和数据访问对象类型创建一个新的数据访问对象实例。
/// </summary>
/// <param name="HelperAssembly">程序集名称</param>
/// <param name="HelperType">数据访问对象类型</param>
/// <param name="ConnectionString">连接字符串</param>
/// <returns>数据访问对象</returns>
public static AdoHelper GetDBHelper(string HelperAssembly, string HelperType, string ConnectionString)
{
AdoHelper helper = null;// CommonDB.CreateInstance(HelperAssembly, HelperType);
if (HelperAssembly == "PWMIS.Core")
{
switch (HelperType)
{
case "PWMIS.DataProvider.Data.SqlServer": helper = new SqlServer(); break;
case "PWMIS.DataProvider.Data.Oracle": helper = new Oracle(); break;
case "PWMIS.DataProvider.Data.OleDb": helper = new OleDb(); break;
case "PWMIS.DataProvider.Data.Odbc": helper = new Odbc(); break;
case "PWMIS.DataProvider.Data.Access": helper = new Access(); break;
//case "PWMIS.DataProvider.Data.SqlServerCe": helper = new SqlServerCe(); break;
default: helper = new SqlServer(); break;
}
}
else
{
helper = CommonDB.CreateInstance(HelperAssembly, HelperType);
}
helper.ConnectionString = ConnectionString;
return(helper);
}
/// <summary>
/// 查询日志数据
/// </summary>
/// <param name="query_entity">查询条件实体</param>
/// <param name="pageno">要查询的页</param>
/// <param name="pagesize">页大小</param>
/// <param name="icnt">结果记录条数</param>
/// <returns>值列表数据清单</returns>
internal List<EapLog> QueryEapLog(EapLog query_entity, int pno, int psize, out int icnt)
{
int para_count = 2;
StringBuilder sql = new StringBuilder();
sql.Append("select t.LOG_ID,t.LOG_TYPE,t1.VLIST_DETAIL_NAME as LOG_TYPE_NAME,t.OPERATE_NOTE,t2.USER_NAME as OPERATE_USER,t.OPERATE_TIME from T_EAP_LOG t");
sql.Append(" left join T_EAP_VALUE_LIST_DETAIL t1 on t1.VLIST_DETAIL_VALUE=t.LOG_TYPE");
sql.Append(" left join T_EAP_USER t2 on t.OPERATE_USER=t2.USER_ID");
sql.Append(" where t1.VLIST_ID='log_type'");
sql.Append(" and to_char(t.OPERATE_TIME,'YYYYMMDD')>=to_char(:BEGIN_TIME,'YYYYMMDD')");
sql.Append(" and to_char(t.OPERATE_TIME,'YYYYMMDD')<=to_char(:END_TIME,'YYYYMMDD')");
if (query_entity.LOG_TYPE != -1)
{
sql.Append(" and t.LOG_TYPE=:LOG_TYPE");
para_count++;
}
if (query_entity.OPERATE_NOTE !=string.Empty)
{
sql.Append(" and t.OPERATE_NOTE like '%'||:OPERATE_NOTE||'%'");
para_count++;
}
if (query_entity.OPERATE_USER != string.Empty)
{
sql.Append(" and t.OPERATE_USER like '%'||:OPERATE_USER||'%'");
para_count++;
}
sql.Append(" order by t.LOG_ID desc");
OracleParameter[] para = new OracleParameter[para_count];
para[0] = new OracleParameter(":BEGIN_TIME", OracleType.DateTime);
para[0].Value = query_entity.BEGIN_TIME;
para[1] = new OracleParameter(":END_TIME", OracleType.DateTime);
para[1].Value = query_entity.END_TIME;
for (int i = 2; i < para_count; i++)
{
if (query_entity.LOG_TYPE != -1)
{
para[i] = new OracleParameter(":LOG_TYPE", OracleType.Number);
para[i].Value = query_entity.LOG_TYPE;
query_entity.LOG_TYPE = -1;
continue;
}
if (query_entity.OPERATE_NOTE != string.Empty)
{
para[i] = new OracleParameter(":OPERATE_NOTE", OracleType.VarChar);
para[i].Value = query_entity.OPERATE_NOTE;
query_entity.OPERATE_NOTE = string.Empty;
continue;
}
if (query_entity.OPERATE_USER != string.Empty)
{
para[i] = new OracleParameter(":OPERATE_USER", OracleType.VarChar);
para[i].Value = query_entity.OPERATE_USER;
query_entity.OPERATE_USER = string.Empty;
continue;
}
}
return Oracle.GetOracle().QueryToPage<EapLog>(sql, para, pno, psize, out icnt);
}
public List <TipoVivienda> ReadAll4()
{
try
{
Cone = Oracle.abrirConexion();
OracleCommand cmd = new OracleCommand("FN_LTIPO_VIVIENDA", Cone);
cmd.CommandType = CommandType.StoredProcedure;
List <TipoVivienda> tipo = new List <TipoVivienda>();
OracleParameter copia_cursor = cmd.Parameters.Add("L_TV", OracleDbType.RefCursor); // es igual a %rowtype
copia_cursor.Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
OracleDataReader info_leida = ((OracleRefCursor)copia_cursor.Value).GetDataReader(); //lo parseamos a cursor, por los distintos tipo de datos que contiene
while (info_leida.Read())
{
//rescatamos
TipoVivienda pos = new TipoVivienda();
pos.Id_tipo_vivienda = info_leida.GetInt32(0);
pos.Descripcion = info_leida.GetString(1);
//agregamos a la lista
tipo.Add(pos);
}
return(tipo);
}
catch (Exception ex)
{
return(null);
}
}
public List <PuebloOriginario> ReadAll6()
{
try
{
Cone = Oracle.abrirConexion();
OracleCommand cmd = new OracleCommand("FN_LPUEBLO", Cone);
cmd.CommandType = CommandType.StoredProcedure;
List <PuebloOriginario> pueblos = new List <PuebloOriginario>();
OracleParameter copia_cursor = cmd.Parameters.Add("L_PUEBLO", OracleDbType.RefCursor); // es igual a %rowtype
copia_cursor.Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
OracleDataReader info_leida = ((OracleRefCursor)copia_cursor.Value).GetDataReader(); //lo parseamos a cursor, por los distintos tipo de datos que contiene
while (info_leida.Read())
{
//rescatamos
PuebloOriginario pos = new PuebloOriginario();
pos.Id_pueblo = info_leida.GetInt32(0);
pos.Descripcion = info_leida.GetString(1);
//agregamos a la lista
pueblos.Add(pos);
}
return(pueblos);
}
catch (Exception ex)
{
return(null);
}
}
public string GetId(string divid, string itype)
{
//在配置表中插入一条记录 返回 主键
Oracle db = new Oracle();
try
{
string sql = "Select to_char(Systimestamp, 'ff') as c From dual ";
DataTable dt_id = new DataTable();
db.ExcuteDataTable(dt_id, sql, CommandType.Text);
//执行insert into 把数据写入表中
return(dt_id.Rows[0][0].ToString());
}
catch (Exception ex)
{
return("-1");
}
finally
{
db.GetDBConnection().Dispose();
}
}
private static void CheckChampSmite(string name, string type, float range, SpellSlot slot, int stage = 0)
{
if (Oracle.ChampionName != name)
{
return;
}
ddmg = 0f;
var spell = new Spell(slot, range);
if (spell.IsReady() && _mainmenu.Item("smitespell").GetValue <bool>())
{
var inst = Me.Spellbook.GetSpell(slot);
foreach (var minion in ObjectManager.Get <Obj_AI_Minion>())
{
if (minion.Distance(Me.ServerPosition, true) > 1200 * 1200)
{
continue;
}
if (EpicMinions.Any(xe => minion.Name.StartsWith(xe) && !minion.Name.Contains("Mini")) &&
_mainmenu.Item("smitesuper").GetValue <bool>() ||
LargeMinions.Any(xe => minion.Name.StartsWith(xe) && !minion.Name.Contains("Mini")) &&
_mainmenu.Item("smitelarge").GetValue <bool>())
{
var champdamage = (float)Me.GetSpellDamage(minion, slot, stage);
var smitedamage = (float)Me.GetSummonerSpellDamage(minion, Damage.SummonerSpell.Smite);
ddmg = champdamage;
if (minion.Health <= smitedamage + champdamage)
{
if (name == "LeeSin" && inst.Name == "blindmonkqtwo" &&
!minion.HasBuff("BlindMonkSonicWave"))
{
return;
}
switch (type)
{
case "self":
spell.Cast();
Oracle.Logger(Oracle.LogType.Action, "Casting (Self) " + inst.Name + " near: " + minion.Name);
break;
case "vector":
spell.Cast(minion.ServerPosition);
Oracle.Logger(Oracle.LogType.Action, "Casting (Vector) " + inst.Name + " on: " + minion.Name);
break;
case "target":
spell.CastOnUnit(minion);
Oracle.Logger(Oracle.LogType.Action, "Casting (Target) " + inst.Name + " on: " + minion.Name);
break;
}
}
}
}
}
}
public static void Main(string[] args)
{
ContractLog.Init();
IList <Thread> threads = new List <Thread>();
ConcurrentQueue <ContractTask> tasks = new ConcurrentQueue <ContractTask>();
var web3 = InitWeb3();
if (web3 != null)
{
var oracle = new Oracle(web3);
threads.Add(new Thread(() => CreateHostBuilder(args).Build().Run()));
for (int i = 0; i < 3; ++i)
{
threads.Add(new Thread(() => DemoOfContractExecute(oracle, tasks)));
}
foreach (var thread in threads)
{
thread.Start();
}
// generate contracts
for (int i = 0; i < 9; ++i)
{
tasks.Enqueue(new ContractTask(oracle));
}
}
ContractLog.Close();
}
public void ctor(Oracle oracle)
{
this.oracle = oracle;
//if (oracle.ID == Oracle.OracleID.SS)
//{
baseMoveSoundLoop = new StaticSoundLoop(SoundID.SS_AI_Base_Move_LOOP, oracle.firstChunk.pos, oracle.room, 1f, 1f);
//}
cornerPositions = new Vector2[4];
cornerPositions[0] = oracle.room.MiddleOfTile(10, 31);
cornerPositions[1] = oracle.room.MiddleOfTile(38, 31);
cornerPositions[2] = oracle.room.MiddleOfTile(38, 3);
cornerPositions[3] = oracle.room.MiddleOfTile(10, 3);
if (oracle.ID == Oracle.OracleID.SL)
{
for (int i = 0; i < cornerPositions.Length; i++)
{
cornerPositions[i] += new Vector2(1040f, -20f);
}
}
joints = new patch_Oracle.OracleArm.Joint[4];
for (int j = 0; j < joints.Length; j++)
{
joints[j] = new patch_Oracle.OracleArm.Joint(this, j);
if (j > 0)
{
joints[j].previous = joints[j - 1];
joints[j - 1].next = joints[j];
}
}
framePos = 10002.5f;
lastFramePos = framePos;
}
/// <summary>
/// 获取所有权限
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
internal List<EapMenu> GetUserAuthority()
{
StringBuilder sql = new StringBuilder(100);
sql.Append("select t.menu_id,t.menu_name,t.parent_menu_id,t.form_name,t.assembly_name from t_eap_menu t");
return Oracle.GetOracle().QueryToList<EapMenu>(sql);
}
/// <summary>
/// 保存用户生产线权限
/// </summary>
/// <param name="userid"></param>
/// <param name="list_right"></param>
/// <returns></returns>
internal string SaveUserTrimLine(List <EapUserTrimLine> list_line)
{
//打开事务
string ret = Oracle.GetOracle().BeginTran();
if (ret != string.Empty)
{
return(ret);
}
//删除已经拥有的权限
ret = DalOracle.GetDalOracle().DelUserLine(list_line[0].USER_ID);
if (ret != string.Empty)
{
Oracle.GetOracle().Rollback();
return(ret);
}
//创建用户权限
foreach (EapUserTrimLine sub in list_line)
{
ret = DalOracle.GetDalOracle().CreateUserLine(sub);
if (ret != string.Empty)
{
Oracle.GetOracle().Rollback();
return(ret);
}
}
Oracle.GetOracle().Commit();
return(string.Empty);
}
public void InicializarPFE(Oracle ora)
{
Oracle = ora;
Emr = new ExecuteMultipleRequest()
{
Settings = new ExecuteMultipleSettings()
{
ContinueOnError = true,
ReturnResponses = true
},
Requests = new OrganizationRequestCollection()
};
var url = XrmServiceUriFactory.CreateOrganizationServiceUri(Comun.ConnStringCrm.Split(';')[0].Split('=')[1]);
var usr = Comun.ConnStringCrm.Split(';')[1].Split('=')[1];
var pwd = Comun.ConnStringCrm.Split(';')[2].Split('=')[1];
OSManager = new OrganizationServiceManager(url, usr, pwd);
OSOptions = new OrganizationServiceProxyOptions
{
Timeout = new TimeSpan(0, Comun.TimeOutEnMinutos, 0)
};
PFERequests = new Dictionary <string, ExecuteMultipleRequest>();
RequestKey = 0;
}
/// <summary>
/// 保存用户权限
/// </summary>
/// <param name="userid"></param>
/// <param name="list_right"></param>
/// <returns></returns>
internal string SaveUserMenuRight(string user_id, List<EapUserMenuRight> list_right)
{
//打开事务
string ret = Oracle.GetOracle().BeginTran();
if (ret != string.Empty)
{
return ret;
}
//删除已经拥有的权限
ret = DelUserMenu(user_id);
if (ret != string.Empty)
{
Oracle.GetOracle().Rollback();
return ret;
}
//创建用户权限
foreach (EapUserMenuRight sub in list_right)
{
ret = CreateUserMenu(sub);
if (ret != string.Empty)
{
Oracle.GetOracle().Rollback();
return ret;
}
}
Oracle.GetOracle().Commit();
return string.Empty;
}
public string saveLogin(string inorout)
{
try
{
string logintype = System.Web.HttpContext.Current.Session["logintype"].ToString();
string clientip = getClientIp();
string user_id = System.Web.HttpContext.Current.Session["user_id"].ToString();
string m002_key = "-";
try
{
m002_key = System.Web.HttpContext.Current.Session["m002_key"].ToString();
}
catch
{
m002_key = "-";
}
string log_sql = "Proc_login_log('" + logintype + "','" + m002_key + "','" + user_id + "','" + clientip + "','" + inorout + "')";
Oracle db = new Oracle();
db.BeginTransaction();
int li_db = db.ExecuteNonQuery(log_sql, CommandType.Text);
if (li_db < 0)
{
db.Rollback();
}
else
{
db.Commit();
}
return(li_db.ToString());
}
catch
{
return("-1");
}
}
static void Main(string[] args)
{
//BankAccount bankAccount ;
//bankAccount = new SavingAccount();
//bankAccount = new CurrentAccount();
Shape sh;
sh = new Circle();
sh.Area();
sh.FillColor();
sh = new Square();
sh.Area();
sh.FillColor();
IDatabase idb;
idb = new Oracle();
idb = new SqlServer();
}
void FixedUpdate()
{
if (!hasBeenInitialized)
{
for (int i = 0; i < Oracle.FutureSteps; i++)
{
Oracle.Step();
}
Oracle.ReturnToPresent();
hasBeenInitialized = true;
}
Oracle.CalculateFuture();
foreach (PlanetBody p in planets)
{
p.future.RemoveAt(0);
}
Oracle.ReturnToPresent();
foreach (PlanetBody p in planets)
{
p.Attract(dynamics);
}
foreach (FixedBody f in statics)
{
f.Attract(dynamics);
}
foreach (FallingBody f in dynamics)
{
f.PhysicsStep();
}
}
private void Awake()
{
this.lineRenderer = this.GetComponent <LineRenderer>();
this.lineRenderer.startWidth = 0.1f;
this.lineRenderer.endWidth = 0.1f;
this.parentOracle = this.GetComponentInParent <Oracle>();
}
/// <summary>
/// 倒箱更新配载指令
/// </summary>
/// <param name="tallyE">TallyE数据对象</param>
/// <returns>结果</returns>
public string Moved_UpdateInstruction(TallyE tallyE)
{
//错误提示
string strErr = string.Empty;
string strSql = string.Empty;
if (tallyE.StrInOutType.Equals("I"))
{
strSql =
string.Format(@"update TB_CON_INSTRUCTION
set complete_mark='1', bayno='{5}',truck_no='{2}',tally_mark='{3}',updatetime='{6}'
where ship_id='{0}' and ctn_no='{1}' and loadUnload_Mark='{4}' and reLoad_mark='1' ",
tallyE.StrShip_Id, tallyE.StrContainer_No, tallyE.StrTruck_No, tallyE.StrWork_No, "0", tallyE.StrBay_No, tallyE.StrTime);
}
else {
strSql =
string.Format(@"update TB_CON_INSTRUCTION
set complete_mark = '1', bayno = '{2}', tally_mark = '{3}', updatetime = '{5}'
where ship_id = '{0}' and ctn_no = '{1}' and loadUnload_mark = '{4}' and reLoad_mark = '1' ",
tallyE.StrShip_Id, tallyE.StrContainer_No, tallyE.StrBay_No, tallyE.StrWork_No, "1", tallyE.StrTime);
}
Oracle.DataAccess(RegistryKey.KeyPath_Oracle_Tally).ExecuteNonQuery(strSql, out strErr);
if (!string.IsNullOrWhiteSpace(strErr))
{
log.LogCatalogFailure("倒箱更新配载指令：" + strErr);
return Rollback(tallyE);
//return Result.Failure("倒箱更新配载指令：" + strErr);
}
return null;
}
/// <summary>
/// 同步舱单
/// </summary>
/// <param name="tallyE">TallyE数据对象</param>
/// <returns>结果</returns>
public string UpdateHatch(TallyE tallyE)
{
//错误提示
string strErr = string.Empty;
string strSql = string.Empty;
if (tallyE.StrInOutType.Equals("E"))
{
strSql = string.Format(@"update CON_HATCH_RECORD
set unload_mark = '1',bayno='{0}',user_code='{1}'
where ship_id='{2}' and container_no='{3}'",
tallyE.StrBay_No, tallyE.StrWork_No, tallyE.StrNewShip_Id, tallyE.StrContainer_No);
}
else {
strSql = string.Format(@"update CON_HATCH_RECORD
set unload_mark = '1',user_code='{0}'
where ship_id='{1}' and container_no='{2}'",
tallyE.StrWork_No, tallyE.StrNewShip_Id, tallyE.StrContainer_No);
}
Oracle.DataAccess(RegistryKey.KeyPath_Oracle_Tally).ExecuteNonQuery(strSql, out strErr);
if (!string.IsNullOrWhiteSpace(strErr))
{
log.LogCatalogFailure("同步舱单异常：" + strErr);
return Rollback(tallyE);
//return Result.Failure("同步舱单异常：" + strErr);
}
return null;
}
//
internal List<EapDepartment> GetDEPARTMENT_TYPE()
{
StringBuilder sql = new StringBuilder(200);
sql.Append("select distinct department_type from t_eap_department");
return Oracle.GetOracle().QueryToList<EapDepartment>(sql);
}
static void Main(string[] args)
{
privateKey = GetOrCreateKey();
byte[] pubKey = Oracle.PublicKeyFromPrivateKey(privateKey);
Console.WriteLine("Oracle Public Key: {0}", BitConverter.ToString(pubKey).Replace("-", ""));
while (true)
{
byte[] oneTimeSigningKey = Oracle.GenerateOneTimeSigningKey();
byte[] rPoint = Oracle.PublicKeyFromPrivateKey(oneTimeSigningKey);
Console.WriteLine("R-Point for next publication: {0}", BitConverter.ToString(rPoint).Replace("-", ""));
Thread.Sleep(600);
// Value is a random number between 10000 and 20000
long value = rand.Next(10000, 20000);
// Generate message to sign. Uses the same encoding as expected by LIT when settling the contract
byte[] message = Oracle.GenerateNumericMessage(value);
// Sign the message
byte[] signature = Oracle.ComputeSignature(privateKey, oneTimeSigningKey, message);
Console.WriteLine("Value: {0}\r\nSignature: {1}", value,
BitConverter.ToString(signature).Replace("-", ""));
}
}
static void Main(string[] args)
{
if (args.Length != 3)
{
Console.WriteLine("Usage: ConsoleTest.exe sql.txt output.xlsx sheetname");
return;
}
Console.WriteLine("Querying DB");
string ExtractSql = Oracle.ReadSql(args[0]);
string OutputPath = args[1];
string SheetName = args[2];
Stopwatch stopwatch = new Stopwatch();
stopwatch.Start();
Field[][] rows = Oracle.Read(ExtractSql).ToArray();
stopwatch.Stop();
Console.WriteLine("DB extraction: count = " + rows.Length + " in " + stopwatch.ElapsedMilliseconds + "ms.");
stopwatch.Reset();
stopwatch.Start();
Oracle.Write2Xlsx(rows, OutputPath, SheetName);
stopwatch.Stop();
Console.WriteLine("Excel written in " + stopwatch.ElapsedMilliseconds + "ms.");
Console.WriteLine("Test concluded");
Console.ReadKey();
}
/// <summary>
/// 查找匹配箱号列表
/// </summary>
/// <param name="strShip_Id">航次ID</param>
/// <param name="strContainer_No">查询箱号</param>
/// <returns>结果</returns>
public string FindMatchedContainerNoList(string strShip_Id, string strContainer_No)
{
//错误提示
string strErr = string.Empty;
string strSql =
string.Format(@"select distinct container_no
from CON_IMAGE
where ship_id='{0}' and container_no like '%{1}'",
strShip_Id, strContainer_No);
var dt = Oracle.DataAccess(RegistryKey.KeyPath_Oracle_Tally).ExecuteQuery_DataTable(strSql, out strErr);
if (!string.IsNullOrWhiteSpace(strErr))
{
log.LogCatalogFailure("异常：" + strErr);
return(Result.Failure("异常：" + strErr));
}
if (dt.Rows.Count <= 0)
{
log.LogCatalogSuccess("无匹配箱号数据");
return(Result.Success(null, null));
}
string[] strArray = new string[dt.Rows.Count];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
strArray[iRow] = Convert.ToString(dt.Rows[iRow]["container_no"]);
}
log.LogCatalogSuccess();
return(Result.Success(strArray, null));
}
public List <EstadoCivil> ReadAll3()
{
try
{
Cone = Oracle.abrirConexion();
OracleCommand cmd = new OracleCommand("FN_LESTADO_CIVIL", Cone);
cmd.CommandType = CommandType.StoredProcedure;
List <EstadoCivil> estCivil = new List <EstadoCivil>();
OracleParameter copia_cursor = cmd.Parameters.Add("L_EC", OracleDbType.RefCursor); // es igual a %rowtype
copia_cursor.Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
OracleDataReader info_leida = ((OracleRefCursor)copia_cursor.Value).GetDataReader(); //lo parseamos a cursor, por los distintos tipo de datos que contiene
while (info_leida.Read())
{
//rescatamos
EstadoCivil pos = new EstadoCivil();
pos.Id_estado_civil = info_leida.GetInt32(0);
pos.Descripcion = info_leida.GetString(1);
//agregamos a la lista
estCivil.Add(pos);
}
return(estCivil);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 绑定部门数据
/// </summary>
/// <param name="entity">数据源</param>
/// <param name="pageno">页数</param>
/// <param name="pagesize">页大小</param>
/// <param name="icnt">条数</param>
/// <returns></returns>
internal List<EapDepartment> GetDEPARTMENTList(EapDepartment entity, int pageno, int pagesize, out int icnt)
{
StringBuilder sql = new StringBuilder(200);
string DEPARTMENT_TYPE = "";
if (entity.DEPARTMENT_TYPE != "全部")
{
DEPARTMENT_TYPE = entity.DEPARTMENT_TYPE;
}
OracleParameter[] para = new OracleParameter[]
{
new OracleParameter(":DEPARTMENT_CODE",entity.DEPARTMENT_CODE),
new OracleParameter(":DEPARTMENT_NAME",entity.DEPARTMENT_NAME),
new OracleParameter(":DEPARTMENT_TYPE",DEPARTMENT_TYPE),
new OracleParameter(":ASSEMBLY_LINE",entity.ASSEMBLY_LINE),
new OracleParameter(":STATUS",entity.STATUS)
};
sql.Append("select DEPARTMENT_ID,DEPARTMENT_CODE,DEPARTMENT_NAME,DEPARTMENT_TYPE,ASSEMBLY_LINE,STATUS,STATUS as STATUS_FALSE ");
sql.Append(" from t_eap_department ");
sql.Append(" where DEPARTMENT_CODE like '%'||:DEPARTMENT_CODE||'%' ");
sql.Append(" and DEPARTMENT_NAME like '%'||:DEPARTMENT_NAME||'%' ");
sql.Append(" and DEPARTMENT_TYPE like '%'||:DEPARTMENT_TYPE||'%' ");
sql.Append(" and STATUS=:STATUS ");
sql.Append(" order by DEPARTMENT_ID ");
return Oracle.GetOracle().QueryToPage<EapDepartment>(sql, para, pageno, pagesize, out icnt);
}
/// <summary>
/// 倒箱作业校验
/// </summary>
/// <param name="tallyE">TallyE数据对象</param>
/// <returns>结果</returns>
public string Moved_CheckWork(TallyE tallyE)
{
//错误提示
string strErr = string.Empty;
string strSql = string.Empty;
//出口装箱，判断前后贝
string pos1 = Convert.ToString((Convert.ToInt16(tallyE.StrBay_No.Substring(0, 2)) - 1)).PadLeft(2, '0') + tallyE.StrBay_No.Substring(2).PadLeft(4, '0');
string pos2 = Convert.ToString((Convert.ToInt16(tallyE.StrBay_No.Substring(0, 2)) + 1)).PadLeft(2, '0') + tallyE.StrBay_No.Substring(2).PadLeft(4, '0');
strSql = string.Format(@"select container_no, bayno
from VCON_IMAGE_PDA
where old_id='{0}' and bayno in ('{1}','{2}','{3}') and unload_mark='1' ",
tallyE.StrShip_Id, tallyE.StrBay_No, pos1, pos2);
var dt = Oracle.DataAccess(RegistryKey.KeyPath_Oracle_Tally).ExecuteQuery_DataTable(strSql, out strErr);
if (!string.IsNullOrWhiteSpace(strErr))
{
log.LogCatalogFailure("作业校验异常：" + strErr);
return Result.Failure("作业校验异常：" + strErr);
}
if (dt.Rows.Count > 0)
{
string strMsg = Convert.ToString(dt.Rows[0]["container_no"]) + "已装船！" + Convert.ToString(dt.Rows[0]["bayno"]);
strMsg += "，请注意调整";
log.LogCatalogSuccess(strMsg);
return Result.Success(null, strMsg);
}
return null;
}
public List <Nacionalidad> ReadAll7()
{
try
{
Cone = Oracle.abrirConexion();
OracleCommand cmd = new OracleCommand("FN_LNACIONALIDAD", Cone);
cmd.CommandType = CommandType.StoredProcedure;
List <Nacionalidad> nacion = new List <Nacionalidad>();
OracleParameter copia_cursor = cmd.Parameters.Add("L_NAC", OracleDbType.RefCursor); // es igual a %rowtype
copia_cursor.Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
OracleDataReader info_leida = ((OracleRefCursor)copia_cursor.Value).GetDataReader(); //lo parseamos a cursor, por los distintos tipo de datos que contiene
while (info_leida.Read())
{
//rescatamos
Nacionalidad pos = new Nacionalidad();
pos.Id_nacionalidad = info_leida.GetInt32(0);
pos.Descripcion = info_leida.GetString(1);
//agregamos a la lista
nacion.Add(pos);
}
return(nacion);
}
catch (Exception ex)
{
return(null);
}
}
public DataTable getDt(string sql)
{
Oracle db = new Oracle();
DataTable dt = new DataTable();
db.ExcuteDataTable(dt, sql, CommandType.Text);
return(dt);
}
/// <summary>
/// 从数据库获取应用文件清单
/// </summary>
/// <returns>应用文件清单</returns>
internal List <EapFile> GetAppFiles()
{
StringBuilder sql = new StringBuilder(100);
sql.Append("select t.FILE_ID,t.FILE_VERSION,t.FILE_EDIT_TIME from T_EAP_FILE t");
return(Oracle.GetOracle().QueryToList <EapFile>(sql));
}
public void PopulateData()
{
Oracle oracle = new Oracle();
string queryOracle = "SELECT * FROM " + SourceName;
oracle.PopulateData(ref SourceData, queryOracle);
Azure azure = new Azure();
azure.DeleteTempTable(DestinationTableName);
}
public void PopulateData()
{
Oracle oracle = new Oracle();
string queryOracle = "SELECT * FROM " + SourceName + " WHERE CREATEDDATE >= SYSDATE OR MODIFIEDDATE >= SYSDATE";
oracle.PopulateData(ref SourceData, queryOracle);
//Delete temp tables in destination
Azure azure = new Azure();
azure.DeleteTempTable(DestinationTableName);
}
public void PopulateData()
{
//Get all details, process in azure
Oracle oracle = new Oracle();
string query = "SELECT * FROM " + SourceName;
oracle.PopulateData(ref SourceData, query);
//Delete temp table in destination
Azure azure = new Azure();
azure.DeleteTempTable(DestinationTableName);
}
public void PopulateData()
{
//Get last field pk
Azure azure = new Azure();
string queryAzure = "SELECT MAX(PK) FROM " + RealTableName;
string maxID = azure.GetSingleValue(queryAzure);
//Get source data
Oracle oracle = new Oracle();
string queryOracle = String.Format("SELECT * FROM {0} WHERE {1} > {2}", SourceName, UpdateIdentifier, maxID);
oracle.PopulateData(ref SourceData, queryOracle);
//DELETE temp tables in destination
azure.DeleteTempTable(DestinationTableName);
}
public void PopulateData()
{
//Get last field PK
Azure azure = new Azure();
//string queryAzure = "SELECT MAX(CONVERT(varchar, GamingDate, 6)) FROM " + RealTableName;
string queryAzure = "SELECT MAX(GamingDate) FROM " + RealTableName;
string maxID = azure.GetSingleValue(queryAzure);
DateTime dateMax = Convert.ToDateTime(maxID);
//Get source data
Oracle oracle = new Oracle();
string queryOracle = String.Format("SELECT * FROM {0} WHERE {1} > '{2}'", SourceName, UpdateIdentifier, dateMax.ToString("dd/MMM/yy"));
oracle.PopulateData(ref SourceData, queryOracle);
//Delete temp tables in destination
azure.DeleteTempTable(DestinationTableName);
}
private void SetTimeOut(Oracle.DataAccess.Client.OracleCommand pSqlCommand)
{
var cmdTimeout = ConfigurationReader.GetStringValue("CmdTimeout");
if (cmdTimeout != null)
{
int commandTimeout = int.Parse(cmdTimeout);
pSqlCommand.CommandTimeout = commandTimeout;
}
}
internal string buildParametersString(Oracle.DataAccess.Client.OracleParameterCollection oracleParams)
{
StringBuilder sb = new StringBuilder();
foreach (Oracle.DataAccess.Client.OracleParameter param in oracleParams)
{
if (param.DbType == System.Data.DbType.Binary || param.DbType == System.Data.DbType.Object)
{
sb.Append("BINARY DATA");
continue;
}
sb.Append(param.Value.ToString());
}
return sb.ToString();
}
