public int ExecRowDataInterface(string iYmd, int itxr_user)
{
Biz_Bsc_Interface_Datasource objDS = new Biz_Bsc_Interface_Datasource();
DataSet rDs = null;
DataSet dsDicode = base.GetAllList("", "", "PULL", itxr_user);
string sRtnMsg = "";
bool bisSucc = false;
int iAffRow = 0;
int iGetRow = 0;
if (dsDicode.Tables.Count > 0)
{
int iRow = dsDicode.Tables[0].Rows.Count;
for (int i = 0; i < iRow; i++)
{
base.ISource_Id = int.Parse(dsDicode.Tables[0].Rows[i]["SOURCE_ID"].ToString());
Object objCon = objDS.GetConnection(base.ISource_Id, out bisSucc, out sRtnMsg);
base.IDicode = dsDicode.Tables[0].Rows[i]["DICODE"].ToString();
string sQry = dsDicode.Tables[0].Rows[i]["QUERY"].ToString();
sQry = sQry.Replace(QueryOperator.ParamCurrYmd, "'" + iYmd + "'");
sQry = sQry.Replace(QueryOperator.ParamPrevYmd, "'" + iYmd + "'");
rDs = new DataSet();
if (bisSucc)
{
if (objCon.GetType() == typeof(SqlConnection))
{
SqlConnection conn = (SqlConnection)objCon;
SqlCommand cmmd = new SqlCommand(sQry, conn);
SqlDataAdapter dadt = new SqlDataAdapter(cmmd);
iAffRow = dadt.Fill(rDs);
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
else if (objCon.GetType() == typeof(OracleConnection))
{
OracleConnection conn = (OracleConnection)objCon;
OracleCommand cmmd = new OracleCommand(sQry, conn);
OracleDataAdapter dadt = new OracleDataAdapter(cmmd);
iAffRow = dadt.Fill(rDs);
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
else if (objCon.GetType() == typeof(OleDbConnection))
{
OleDbConnection conn = (OleDbConnection)objCon;
OleDbCommand cmmd = new OleDbCommand(sQry, conn);
OleDbDataAdapter dadt = new OleDbDataAdapter(cmmd);
iAffRow = dadt.Fill(rDs);
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
}
else
{
return(0);
}
sQry = this.GetRowDataQuery(base.IDicode, iYmd, rDs, itxr_user);
//iGetRow += base.DbAgentObj.ExecuteNonQuery(sQry);
string[] arrQuery = sQry.Split(';');
IDbConnection dbcon = DbAgentHelper.CreateDbConnection();
dbcon.Open();
IDbTransaction trx = dbcon.BeginTransaction();
try
{
for (int k = 0; k < arrQuery.Length; k++)
{
if (arrQuery[k].Length > 0)
{
iGetRow += DbAgentObj.ExecuteNonQuery(arrQuery[k]);
}
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
iGetRow = 0;
}
finally
{
dbcon.Close();
}
}
}
return(iGetRow);
}
public DataTable GetOrginalInterfaceData(object dicode, object diname, int itxr_user, string iYmd)
{
Biz_Bsc_Interface_Datasource objDS = new Biz_Bsc_Interface_Datasource();
DataSet rDs = new DataSet();
DataSet dsDicode = base.GetAllList(dicode.ToString(), "", "PULL", itxr_user);
string sRtnMsg = "";
bool bisSucc = false;
int iAffRow = 0;
if (dsDicode.Tables.Count > 0)
{
Object objCon = objDS.GetConnection(int.Parse(dsDicode.Tables[0].Rows[0]["SOURCE_ID"].ToString()), out bisSucc, out sRtnMsg);
string sQry = dsDicode.Tables[0].Rows[0]["QUERY"].ToString();
sQry = sQry.Replace(QueryOperator.ParamCurrYmd, "'" + iYmd + "'");
sQry = sQry.Replace(QueryOperator.ParamPrevYmd, "'" + iYmd + "'");
if (bisSucc)
{
if (objCon.GetType() == typeof(SqlConnection))
{
SqlConnection conn = (SqlConnection)objCon;
SqlCommand cmmd = new SqlCommand(sQry, conn);
SqlDataAdapter dadt = new SqlDataAdapter(cmmd);
iAffRow = dadt.Fill(rDs);
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
else if (objCon.GetType() == typeof(OracleConnection))
{
OracleConnection conn = (OracleConnection)objCon;
OracleCommand cmmd = new OracleCommand(sQry, conn);
OracleDataAdapter dadt = new OracleDataAdapter(cmmd);
iAffRow = dadt.Fill(rDs);
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
else if (objCon.GetType() == typeof(OleDbConnection))
{
OleDbConnection conn = (OleDbConnection)objCon;
OleDbCommand cmmd = new OleDbCommand(sQry, conn);
OleDbDataAdapter dadt = new OleDbDataAdapter(cmmd);
iAffRow = dadt.Fill(rDs);
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
}
}
return(rDs.Tables[0]);
}
public DataTable GetDataResult(string idicode, string sPreYMD, string sCurYMD, int itxr_user)
{
Biz_Bsc_Interface_Dicode objBSC = new Biz_Bsc_Interface_Dicode(idicode, itxr_user);
string sQry = objBSC.IQuery;
int isource_id = objBSC.ISource_Id;
bool bisSucc = false;
string sRtnMsg = "";
int iAffRow = 0;
sQry = sQry.Replace(QueryOperator.ParamCurrYmd, "'" + sCurYMD + "'");
sQry = sQry.Replace(QueryOperator.ParamPrevYmd, "'" + sPreYMD + "'");
DataSet rDs = new DataSet();
Biz_Bsc_Interface_Datasource objDS = new Biz_Bsc_Interface_Datasource();
Object objCon = objDS.GetConnection(isource_id, out bisSucc, out sRtnMsg);
if (bisSucc && sQry.Trim().Length > 0)
{
if (objCon.GetType() == typeof(SqlConnection))
{
SqlConnection conn = (SqlConnection)objCon;
SqlCommand cmmd = new SqlCommand(sQry, conn);
SqlDataAdapter dadt = new SqlDataAdapter(cmmd);
iAffRow = dadt.Fill(rDs);
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
else if (objCon.GetType() == typeof(OracleConnection))
{
OracleConnection conn = (OracleConnection)objCon;
OracleCommand cmmd = new OracleCommand(sQry, conn);
OracleDataAdapter dadt = new OracleDataAdapter(cmmd);
iAffRow = dadt.Fill(rDs);
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
else if (objCon.GetType() == typeof(OleDbConnection))
{
OleDbConnection conn = (OleDbConnection)objCon;
OleDbCommand cmmd = new OleDbCommand(sQry, conn);
OleDbDataAdapter dadt = new OleDbDataAdapter(cmmd);
iAffRow = dadt.Fill(rDs);
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
if (rDs.Tables.Count > 0)
{
return(rDs.Tables[0]);
}
else
{
return(null);
}
}
else
{
return(null);
}
}