public static void CreateStoredProcedures(Database db)
{
DbCommand command;
string sql;
try
{
DeleteStoredProcedures(db);
}
catch { }
sql = "CREATE OR REPLACE PACKAGE PKGENTLIB AS " +
"TYPE T_CURSOR IS REF CURSOR; " +
"PROCEDURE RegionSelect (CUR_OUT OUT T_CURSOR); " +
"END PKGENTLIB;";
command = db.GetSqlStringCommand(sql);
db.ExecuteNonQuery(command);
sql = "CREATE OR REPLACE PACKAGE BODY PKGENTLIB AS " +
"PROCEDURE RegionSelect(CUR_OUT OUT T_CURSOR) IS " +
"V_CURSOR T_CURSOR; " +
"BEGIN " +
"OPEN V_CURSOR FOR " +
"SELECT * FROM Region ORDER BY RegionID; " +
"CUR_OUT := V_CURSOR; " +
"END RegionSelect; " +
"END PKGENTLIB;";
command = db.GetSqlStringCommand(sql);
db.ExecuteNonQuery(command);
sql = "create procedure RegionInsert (pRegionID IN Region.RegionID%TYPE, pRegionDescription IN Region.RegionDescription%TYPE) as " +
"BEGIN " +
" insert into Region values(pRegionID, pRegionDescription); " +
"END;";
command = db.GetSqlStringCommand(sql);
db.ExecuteNonQuery(command);
sql = "create procedure RegionUpdate (pRegionID IN Region.RegionID%TYPE, pRegionDescription IN Region.RegionDescription%TYPE) as " +
"BEGIN " +
" update Region set RegionDescription = pRegionDescription where RegionID = pRegionID; " +
"END;";
command = db.GetSqlStringCommand(sql);
db.ExecuteNonQuery(command);
sql = "create procedure RegionDelete (pRegionID IN Region.RegionID%TYPE) as " +
"BEGIN " +
" delete from Region where RegionID = pRegionID; " +
"END;";
command = db.GetSqlStringCommand(sql);
db.ExecuteNonQuery(command);
}
public void btnDelete_Click(System.Object sender, System.EventArgs e)
{
//ExecuteNonQuery
//db.ExecuteNonQuery(CommandType.Text, "DELETE FROM SampleData where [Name] = 'Insert'")
//GetSqlStringCommand and ExecuteNonQuery
DbCommand cmd = db.GetSqlStringCommand("DELETE FROM SampleData where [Name] = \'Insert\'");
db.ExecuteNonQuery(cmd);
}
public void SetUp()
{
testConnection = new TestConnectionString();
testConnection.CopyFile();
db = new SqlCeDatabase(testConnection.ConnectionString);
DbCommand insertionCommand = db.GetSqlStringCommand(insertString);
DbCommand countCommand = db.GetSqlStringCommand(countQuery);
baseFixture = new ExecuteNonQueryFixture(db, insertString, countQuery, insertionCommand, countCommand);
}
public void TestInitialize()
{
testConnection = new TestConnectionString();
testConnection.CopyFile();
db = new SqlCeDatabase(testConnection.ConnectionString);
DbCommand insertCommand = db.GetSqlStringCommand(insertString);
queryCommand = db.GetSqlStringCommand(queryString);
baseFixture = new ExecuteReaderFixture(db, insertString, insertCommand, queryString, queryCommand);
}
public void SetUp()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
DbCommand insertionCommand = db.GetSqlStringCommand(insertString);
DbCommand countCommand = db.GetSqlStringCommand(countQuery);
baseFixture = new ExecuteNonQueryFixture(db, insertString, countQuery, insertionCommand, countCommand);
}
/// <summary>
/// 获取指定的表(适用含虚体表的T)
/// 示例（指定表获取）：DAOHelp.UniversalizationGetAll<DSSLMSEntering>(CommonApp.DBFactory.CreateDefault(), new List<string>() { "[SLMSDB_I].[dbo].[SampleInfo]", "[SLMSDB_I].[dbo].[SampleResult]" });
/// </summary>
/// <typeparam name="T">数据集</typeparam>
/// <param name="_db"></param>
/// <param name="_tablenames">注意表名要用数据库全称</param>
/// <returns></returns>
public static T UniversalizationGetAll <T>(Microsoft.Practices.EnterpriseLibrary.Data.Database _db, List <string> _tablenames)
{
try
{
var model = Activator.CreateInstance <T>();
var sql = _tablenames.Aggregate("", (current, _tb) => current + ("select * from " + _tb + ";"));
var cmd = _db.GetSqlStringCommand(sql);
//注意：如果需要使返回的table名不含有数据库表的限定名，则如下：
var list = new List <string>();
foreach (var tbn in _tablenames)
{
var ele = "";
if (tbn.Contains("."))
{
ele = (tbn.Split('.'))[(tbn.Split('.')).Length - 1];
}
if (ele.StartsWith("["))
{
ele = ele.Substring(1, ele.Length - 2);
}
list.Add(ele);
}
_db.LoadDataSet(cmd, model as DataSet, list.ToArray());//return回来的dataset表名
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// GetItem SAS_ExportData Data...
/// <summary>
/// <param name=sender></param>
/// <param name= e></param>
public ExportDataEN GetItem(ExportDataEN argEn)
{
ExportDataEN loItem = new ExportDataEN();
string sqlCmd = "Select * FROM SAS_ExportData WHERE InterfaceID = @InterfaceID";
Microsoft.Practices.EnterpriseLibrary.Data.Database coDb = DatabaseFactory.CreateDatabase(csConnectionStr);
try
{
using (DbCommand cmd = coDb.GetSqlStringCommand(sqlCmd))
{
coDb.AddInParameter(cmd, "@InterfaceID", DbType.String, argEn.InterfaceID);
using (IDataReader loReader = coDb.ExecuteReader(cmd))
{
if (loReader != null)
{
loReader.Read();
loItem = LoadObject(loReader);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loItem);
}
/// <summary>
/// Getlist SAS_ExportData Data...
/// <summary>
/// <param name=sender></param>
/// <param name= e></param>
public List <ExportDataEN> GetList(ExportDataEN argEn)
{
List <ExportDataEN> loEnList = new List <ExportDataEN>();
argEn.InterfaceID = argEn.InterfaceID.Replace("*", "%");
string sqlCmd = "select * from SAS_ExportData where Interfaceid <> '0'";
if (argEn.InterfaceID.Length != 0)
{
sqlCmd = sqlCmd + " and Interfaceid like '" + argEn.InterfaceID + "'";
}
Microsoft.Practices.EnterpriseLibrary.Data.Database coDb = DatabaseFactory.CreateDatabase(csConnectionStr);
try
{
using (DbCommand cmd = coDb.GetSqlStringCommand(sqlCmd))
{
using (IDataReader loReader = coDb.ExecuteReader(cmd))
{
while (loReader.Read())
{
ExportDataEN loItem = LoadObject(loReader);
loEnList.Add(loItem);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
/// <summary>
/// Delete SAS_ExportData Data...
/// <summary>
/// <param name=sender></param>
/// <param name= e></param>
public bool Delete(ExportDataEN argEn)
{
bool lbRes = false;
string sqlCmd = "DELETE FROM SAS_ExportData WHERE InterfaceID = @InterfaceID";
Microsoft.Practices.EnterpriseLibrary.Data.Database coDb = DatabaseFactory.CreateDatabase(csConnectionStr);
try
{
using (DbCommand cmd = coDb.GetSqlStringCommand(sqlCmd))
{
coDb.AddInParameter(cmd, "@InterfaceID", DbType.String, argEn.InterfaceID);
int liRowAffected = coDb.ExecuteNonQuery(cmd);
if (liRowAffected > -1)
{
lbRes = true;
}
else
{
throw new Exception("Deletion Failed! No Row has been deleted...");
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lbRes);
}
/// <summary>
/// 限定数据库表前缀查询（要求T所有表均有对应的实体表）
/// 示例（所有表获取）：DAOHelp.UniversalizationGetAll<DSSLMSEntering>(CommonApp.DBFactory.CreateDefault(), "[SLMSDB_I].[dbo].");
/// </summary>
/// <typeparam name="T">数据集</typeparam>
/// <param name="_db"></param>
/// <param name="_tablenameprefix">前缀为空时，则指数据集表名与数据库表名一致</param>
/// <returns></returns>
public static T UniversalizationGetAll <T>(Microsoft.Practices.EnterpriseLibrary.Data.Database _db, string _tablenameprefix)
{
try
{
var type = typeof(T);
var ppt = type.GetProperties();
var model = Activator.CreateInstance <T>();
var sql = "";
//获取表集合
var tbs = new List <string>();
foreach (var t in ppt)
{
var eltype = t.ToString().Split(' ')[0];
if (!eltype.Contains("DataTable"))
{
continue;
}
if (eltype.Substring(eltype.Length - 9) != "DataTable")
{
continue;
}
sql += "select * from " + _tablenameprefix + t.Name + ";"; //注意：xsd中表名应当跟数据库表名一致
tbs.Add(t.Name);
}
var cmd = _db.GetSqlStringCommand(sql);
_db.LoadDataSet(cmd, model as DataSet, tbs.ToArray());//return回来的dataset表名
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
//Get XML From Database2
public static string GetOldXml(int id)
{
string RetrivedXML2 = null;
try
{
//Instance for the database
DatabaseProviderFactory factory2 = new DatabaseProviderFactory();
Microsoft.Practices.EnterpriseLibrary.Data.Database db2 = factory2.Create("DB2");
DbCommand dbCommand2 = db2.GetSqlStringCommand("SELECT xmldata FROM data WHERE id='" + id + "'");
object getOldXml = db2.ExecuteScalar(dbCommand2);
if (getOldXml != null)
{
RetrivedXML2 = (string)getOldXml;
}
else
{
throw new Exception(String.Format("Could not find the historyId.", id));
}
return(RetrivedXML2);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取待办事项调转地址
/// </summary>
/// <param name="moduleID"></param>
/// <param name="moduleName"></param>
/// <param name="instanceID"></param>
/// <param name="workflowTasksSetp"></param>
/// <returns></returns>
//private string GetAuditUrl(string moduleID, string moduleName, string instanceID, string workflowTasksSetp, string applyBasisType, string taskStatus)
//{
// string sRtn = string.Empty;
// string showType = basepage.CurrUserInfo().RoleShowType;
// if (moduleName == Constant.TaskCYGYWSP)//车易购业务审批
// {
// switch (workflowTasksSetp)
// {
// case "0":
// if (applyBasisType == "1")
// {
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Business/ApplyAddPersonage.aspx?Desktop=true&id=" + moduleID + "&showType=" + showType + "');>办理</a>";
// }
// if (applyBasisType == "2")
// {
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Business/ApplyAddCompany.aspx?Desktop=true&id=" + moduleID + "&showType=" + showType + "');>办理</a>";
// }
// break;
// case "1":
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Business/InstructionsAuditOption1.aspx?Desktop=true&id=" + moduleID + "&ApplyBasis_Type=" + applyBasisType + "&step=" + workflowTasksSetp + "&showType=" + showType + "');>办理</a>";
// break;
// case "2":
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Business/InstructionsAuditOption2.aspx?Desktop=true&id=" + moduleID + "&ApplyBasis_Type=" + applyBasisType + "&step=" + workflowTasksSetp + "&showType=" + showType + "');>办理</a>";
// break;
// case "3":
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Business/InstructionsAuditOption3.aspx?Desktop=true&id=" + moduleID + "&ApplyBasis_Type=" + applyBasisType + "&step=" + workflowTasksSetp + "&showType=" + showType + "');>办理</a>";
// break;
// case "4":
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Business/InstructionsAuditOption4.aspx?Desktop=true&id=" + moduleID + "&ApplyBasis_Type=" + applyBasisType + "&step=" + workflowTasksSetp + "&showType=" + showType + "');>办理</a>";
// break;
// case "5":
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Business/InstructionsAuditOption5.aspx?Desktop=true&id=" + moduleID + "&ApplyBasis_Type=" + applyBasisType + "&step=" + workflowTasksSetp + "&showType=" + showType + "');>办理</a>";
// break;
// case "6":
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Business/InstructionsAuditOption6.aspx?Desktop=true&id=" + moduleID + "&ApplyBasis_Type=" + applyBasisType + "&step=" + workflowTasksSetp + "&showType=" + showType + "');>办理</a>";
// break;
// }
// }
// if (moduleName == Constant.TaskCYGTQHK)//车易购业务提前还款
// {
// switch (workflowTasksSetp)
// {
// case "0":
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Repayment/AdvancePayAdd.aspx?Desktop=true&id=" + moduleID + "&step=" + workflowTasksSetp + "');>办理</a>";
// break;
// case "1":
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Repayment/AdvancePayApproveAudit.aspx?Desktop=true&id=" + moduleID + "&step=" + workflowTasksSetp + "');>办理</a>";
// break;
// }
// }
// string ExpressInfo_Status = string.Empty;
// string ApplyBasis_Code = string.Empty;
// string ApplyBasis_Name = string.Empty;
// string Department_Name = string.Empty;
// string ApplyBasis_VehicleType = string.Empty;
// string ApplyBasisID = string.Empty;
// if (moduleName == Constant.TaskCYGTQHK || moduleName == Constant.TaskCLIENTFILE || moduleName == Constant.TaskCLIENTFILESHPI)
// {
// Business_ExpressInfo ExpressInfo = new Business_ExpressInfoBLL().Find(p => p.ExpressInfoID == moduleID);
// if (ExpressInfo != null)
// {
// ExpressInfo_Status = ExpressInfo.ExpressInfo_Status;
// ApplyBasisID = ExpressInfo.ExpressInfo_ApplyBasisId;
// View_Business_ApplyBasis ApplyBasis = new View_Business_ApplyBasisBLL().Find(p => p.ApplyBasisId == ExpressInfo.ExpressInfo_ApplyBasisId);
// if (ApplyBasis != null)
// {
// ApplyBasis_Code = ApplyBasis.ApplyBasis_Code;
// ApplyBasis_Name = ApplyBasis.ApplyBasis_Name;
// Department_Name = ApplyBasis.Department_Name;
// ApplyBasis_VehicleType = ApplyBasis.ApplyBasis_VehicleType;
// }
// }
// }
// if (moduleName == Constant.TaskCLIENTFILE)//客户资料管理
// {
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Archives/ExpressInfoAudit.aspx?Desktop=true&id=" + ApplyBasisID + "&ExpressInfoID=" + moduleID + "&ExpressInfo_Status=" + ExpressInfo_Status + "&ApplyBasis_Code=" + ApplyBasis_Code + "&ApplyBasis_Name=" + ApplyBasis_Name + "&Department_Name=" + Department_Name + "&ApplyBasis_VehicleType=" + ApplyBasis_VehicleType + "');>办理</a>";
// }
// if (moduleName == Constant.TaskCLIENTFILESHPI)//快递资料审批
// {
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Archives/ExpressInfoEdit.aspx?Desktop=true&id=" + ApplyBasisID + "&ExpressInfoID=" + moduleID + "&ExpressInfo_Status=" + ExpressInfo_Status + "&ApplyBasis_Code=" + ApplyBasis_Code + "&ApplyBasis_Name=" + ApplyBasis_Name + "&Department_Name=" + Department_Name + "&ApplyBasis_VehicleType=" + ApplyBasis_VehicleType + "');>办理</a>";
// }
// if (moduleName == Constant.TaskCYGYWKHXXBG)//车易购业务客户信息变更
// {
// string ApplyBasis_Type = string.Empty;
// string CustomerInfoChange_ApplyBasisId = string.Empty;
// string CustomerInfoChange_StateCode = string.Empty;
// Business_CustomerInfoChange CustomerInfoChange = new Business_CustomerInfoChangeBLL().Find(p => p.CustomerInfoChange_ID == moduleID);
// CustomerInfoChange_ApplyBasisId = CustomerInfoChange.CustomerInfoChange_ApplyBasisId;
// CustomerInfoChange_StateCode = CustomerInfoChange.CustomerInfoChange_State;
// if (CustomerInfoChange != null)
// {
// View_Business_ApplyBasis ApplyBasis = new View_Business_ApplyBasisBLL().Find(p => p.ApplyBasisId == CustomerInfoChange_ApplyBasisId);
// if (ApplyBasis != null)
// {
// ApplyBasis_Type = ApplyBasis.ApplyBasis_Type.ToString();
// }
// }
// switch (workflowTasksSetp)
// {
// case "0":
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Business/CustomerInfoChangeAdd.aspx?Desktop=true&id=" + moduleID + "&step=" + workflowTasksSetp + "&ApplyBasis_Type=" + ApplyBasis_Type + "&CustomerInfoChange_StateCode=" + CustomerInfoChange_StateCode + "');>办理</a>";
// break;
// case "1":
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Business/CustomerInfoApprove.aspx?Desktop=true&id=" + moduleID + "&step=" + workflowTasksSetp + "&ApplyBasis_Type=" + ApplyBasis_Type + "&CustomerInfoChange_ApplyBasisId=" + CustomerInfoChange_ApplyBasisId + "');>办理</a>";
// break;
// }
// }
// if (moduleName == Constant.TaskCYGYWBDXB)//车易购业务保单续保
// {
// switch (workflowTasksSetp)
// {
// case "0":
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Warranty/WarrantyRenewalApply.aspx?Desktop=true&BusinessID=RenewalApplyList,Modify&id=" + moduleID + "&step=" + workflowTasksSetp + "');>办理</a>";
// break;
// case "1":
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Warranty/WarrantyRenewalApprove.aspx?Desktop=true&id=" + moduleID + "&step=" + workflowTasksSetp + "');>办理</a>";
// break;
// }
// }
// if (moduleName == Constant.TaskCYGYWBDLP)//车易购业务保单理赔
// {
// switch (workflowTasksSetp)
// {
// case "0":
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Warranty/ClaimsApply.aspx?Desktop=true&BusinessID=CustomerClaimsList&id=" + moduleID + "&step=" + workflowTasksSetp + "');>办理</a>";
// break;
// case "1":
// sRtn = "<a href=javascript:TaskShowClick('" + taskStatus + "','/Manage/Warranty/ClaimsApprove.aspx?Desktop=true&id=" + moduleID + "&step=" + workflowTasksSetp + "');>办理</a>";
// break;
// }
// }
// return sRtn;
//}
/// <summary>
/// 其他待办事项(PendingMatter_ToRoleName:多角色 userInfo.RoleName:多角色)
/// </summary>
public List <string> LoadPendingMatterInfo()
{
List <string> PendingMatterList = new List <string>();//待办事项集合
string sqlString = "exec GetPendingMatterRecord '" + basepage.CurrUserInfo().RoleID + "','" + basepage.CurrUserInfo().UserID + "'";
Microsoft.Practices.EnterpriseLibrary.Data.Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(sqlString);
DataSet ds = db.ExecuteDataSet(dbCommand);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string title = ds.Tables[0].Rows[i]["PendingMatter_Title"].ToString();
string url = ds.Tables[0].Rows[i]["PendingMatter_URL"].ToString();
string iCount = ds.Tables[0].Rows[i]["iCount"].ToString();
title = string.Format(Constant.TesksAuditTitle, title, iCount);
PendingMatterList.Add("<li>·<a href=javascript:showTabs('待办事项','" + url + "');>" + title + "</a></li>");
}
}
}
}
return(PendingMatterList);
}
public bool ExisteUsuario(string Usuario)
{
stringBuilder = new StringBuilder();
stringBuilder.Append("SELECT COUNT(1) FROM DbSistemas.dbo.TBLSECUSUARIOS WHERE USUARIO = @USUARIO");
DbCommand commad = Database.GetSqlStringCommand(stringBuilder.ToString());
Database.AddInParameter(commad, "USUARIO", System.Data.DbType.String, Usuario);
if ((int)Database.ExecuteScalar(commad) > 0)
{
return(true);
}
else
{
return(false);
}
}
public DataSet GetAll(string OrderBy, Database db)
{
orderBy = "";
if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy;
sqlText="Select KATILIMCI_ID,UZMANLIK_ALANI_ID from KATILIMCI_UZMANLIK_ARATABLO "+orderBy;
dbComm = db.GetSqlStringCommand(sqlText);
return db.ExecuteDataSet(dbComm);
}
public IDataReader GetAllReader(string OrderBy, Database db)
{
orderBy = "";
if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy;
sqlText="Select ID,ACIKLAMA from SECENEK_TIP "+orderBy;
dbComm = db.GetSqlStringCommand(sqlText);
return db.ExecuteReader(dbComm);
}
public DataSet GetAll(string OrderBy, Database db)
{
orderBy = "";
if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy;
sqlText="Select ID,AD,SOYAD,TELEFON,EMAIL,UNVAN_ID from KATILIMCI "+orderBy;
dbComm = db.GetSqlStringCommand(sqlText);
return db.ExecuteDataSet(dbComm);
}
public DataSet GetAll(string OrderBy, Database db)
{
orderBy = "";
if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy;
sqlText="Select ORGANIZASYON_ID,KATILIMCI_ID,KAYIT_NO from KATILIMCI_ORGANIZASYON_ARATABLO "+orderBy;
dbComm = db.GetSqlStringCommand(sqlText);
return db.ExecuteDataSet(dbComm);
}
public DataSet GetAll(string OrderBy, Database db)
{
orderBy = "";
if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy;
sqlText="Select SORU_ID,SECENEK_ID from SORU_SECENEK_ARATABLO "+orderBy;
dbComm = db.GetSqlStringCommand(sqlText);
return db.ExecuteDataSet(dbComm);
}
public DataSet GetAll(string OrderBy, Database db)
{
orderBy = "";
if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy;
sqlText="Select ID,DUYURU_TIP_ID,ORGANIZASYON_ID,BASLIK,BITIS_TARIHI from DUYURU "+orderBy;
dbComm = db.GetSqlStringCommand(sqlText);
return db.ExecuteDataSet(dbComm);
}
public bool IsInitialized()
{
bool isInitialized = false;
DataSet ds = new DataSet();
string sql = "SELECT COUNT(*) FROM sysobjects WHERE type = 'U' AND name = 'chpt09_SchemaVersions'";
using (DbCommand dbCmd = db.GetSqlStringCommand(sql))
{
ds = db.ExecuteDataSet(dbCmd);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
int count = (int)ds.Tables[0].Rows[0][0];
isInitialized = (count == 1);
}
}
return(isInitialized);
}
public DataSet GetAll(string OrderBy, Database db)
{
orderBy = "";
if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy;
sqlText="Select ID,ORGANIZASYON_TIP_ID,KULUP_ID,AD,TARIH from ORGANIZASYON "+orderBy;
dbComm = db.GetSqlStringCommand(sqlText);
return db.ExecuteDataSet(dbComm);
}
public DataSet GetAll(string OrderBy, Database db)
{
orderBy = "";
if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy;
sqlText="Select ID,ACIKLAMA from DUYURU_TIP "+orderBy;
dbComm = db.GetSqlStringCommand(sqlText);
return db.ExecuteDataSet(dbComm);
}
public IDataReader GetAllReader(string OrderBy, Database db)
{
orderBy = "";
if (OrderBy.Length > 0) orderBy = " Order By " + OrderBy;
sqlText="Select ID,UZMANLIK_ADI from UZMANLIK_ALANLARI "+orderBy;
dbComm = db.GetSqlStringCommand(sqlText);
return db.ExecuteReader(dbComm);
}
public bool DeleteTrServicedetailsInfoById(object param, Database db, DbTransaction transaction)
{
string sql = "DELETE FROM TR_ServiceDetails WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, param);
db.ExecuteNonQuery(dbCommand, transaction);
return true;
}
protected virtual System.Data.Common.DbCommand CreateCommand(string commandText)
{
if (string.IsNullOrWhiteSpace(commandText))
throw new ArgumentNullException();
dbConnection = CreateDB();
System.Data.Common.DbCommand cmd = dbConnection.GetSqlStringCommand(commandText);
return cmd;
}
/// <summary>
/// Method to Get AutoNumber
/// </summary>
/// <param name="Description">Description as Input</param>
/// <returns>Returns AutoNumber</returns>
public string GetAutoNumber(string Description)
{
string AutoNo = "";
int CurNo = 0;
int NoDigit = 0;
int AutoCode = 0;
int i = 0;
string SqlStr;
SqlStr = "select * from SAS_AutoNumber where SAAN_Des='" + Description + "'";
try
{
Microsoft.Practices.EnterpriseLibrary.Data.Database loDbAut = DatabaseFactory.CreateDatabase(csConnectionStr);
DbCommand cmd = loDbAut.GetSqlStringCommand(SqlStr);
IDataReader loReader = loDbAut.ExecuteReader(cmd);
if (loReader.Read())
{
AutoCode = Convert.ToInt32(loReader["SAAN_Code"]);
CurNo = Convert.ToInt32(loReader["SAAN_CurNo"]) + 1;
NoDigit = Convert.ToInt32(loReader["SAAN_NoDigit"]);
AutoNo = Convert.ToString(loReader["SAAN_Prefix"]);
if (CurNo.ToString().Length < NoDigit)
{
while (i < NoDigit - CurNo.ToString().Length)
{
AutoNo = AutoNo + "0";
i = i + 1;
}
AutoNo = AutoNo + CurNo;
}
loReader.Close();
}
AutoNumberEn loItem = new AutoNumberEn();
loItem.SAAN_Code = AutoCode;
AutoNumberDAL cods = new AutoNumberDAL();
cods.GetItem(loItem);
loItem.SAAN_Code = Convert.ToInt32(AutoCode);
loItem.SAAN_CurNo = CurNo;
loItem.SAAN_AutoNo = AutoNo;
cods.Update(loItem);
return(AutoNo);
}
catch (Exception ex)
{
Console.Write("Error in connection : " + ex.Message);
return(ex.ToString());
}
}
public void SetUp()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
DbCommand command = db.GetSqlStringCommand("Select count(*) from region");
baseFixture = new ExecuteScalarFixture(db, command);
}
public int Delete(int katilimciId,DbTransaction dbTransaction,Database db)
{
sqlText="DELETE KATILIMCI_ANKET_CEVAP_ARATABLO where KATILIMCI_ID=@katilimciId ";
dbComm = db.GetSqlStringCommand(sqlText);
db.AddInParameter(dbComm, "@katilimciId", DbType.Int32, katilimciId);
KatilimciAnketCevapAratablo nesne = new KatilimciAnketCevapAratablo();
nesne.KatilimciId = katilimciId;
return base.Delete(nesne, dbComm, dbTransaction, db);
}
public int Delete(int anketId,DbTransaction dbTransaction,Database db)
{
sqlText="DELETE ANKET_SORU_ARATABLO where ANKET_ID=@anketId ";
dbComm = db.GetSqlStringCommand(sqlText);
db.AddInParameter(dbComm, "@anketId", DbType.Int32, anketId);
AnketSoruAratablo nesne = new AnketSoruAratablo();
nesne.AnketId = anketId;
return base.Delete(nesne, dbComm, dbTransaction, db);
}
public int Delete(int id,DbTransaction dbTransaction,Database db)
{
sqlText="DELETE UZMANLIK_ALANLARI where ID=@id ";
dbComm = db.GetSqlStringCommand(sqlText);
db.AddInParameter(dbComm, "@id", DbType.Int32, id);
UzmanlikAlanlari nesne = new UzmanlikAlanlari();
nesne.Id = id;
return base.Delete(nesne, dbComm, dbTransaction, db);
}
public int Delete(int id,DbTransaction dbTransaction,Database db)
{
sqlText="DELETE ORGANIZASYON where ID=@id ";
dbComm = db.GetSqlStringCommand(sqlText);
db.AddInParameter(dbComm, "@id", DbType.Int32, id);
Organizasyon nesne = new Organizasyon();
nesne.Id = id;
return base.Delete(nesne, dbComm, dbTransaction, db);
}
public int Delete(int secenekId,DbTransaction dbTransaction,Database db)
{
sqlText="DELETE SORU_SECENEK_ARATABLO where SECENEK_ID=@secenekId ";
dbComm = db.GetSqlStringCommand(sqlText);
db.AddInParameter(dbComm, "@secenekId", DbType.Int32, secenekId);
SoruSecenekAratablo nesne = new SoruSecenekAratablo();
nesne.SecenekId = secenekId;
return base.Delete(nesne, dbComm, dbTransaction, db);
}
public int Delete(int id,DbTransaction dbTransaction,Database db)
{
sqlText="DELETE SECENEK_TIP where ID=@id ";
dbComm = db.GetSqlStringCommand(sqlText);
db.AddInParameter(dbComm, "@id", DbType.Int32, id);
SecenekTip nesne = new SecenekTip();
nesne.Id = id;
return base.Delete(nesne, dbComm, dbTransaction, db);
}
public int Delete(int id,DbTransaction dbTransaction,Database db)
{
sqlText="DELETE ANKET where ID=@id ";
dbComm = db.GetSqlStringCommand(sqlText);
db.AddInParameter(dbComm, "@id", DbType.Int32, id);
Anket nesne = new Anket();
nesne.Id = id;
return base.Delete(nesne, dbComm, dbTransaction, db);
}
public int DeleteByKulupId(Int32 kulupId,DbTransaction dbTransaction,Database db)
{
sqlText="DELETE ORGANIZASYON where KULUP_ID=@kulupId ";
dbComm = db.GetSqlStringCommand(sqlText);
db.AddInParameter(dbComm, "@kulupId", DbType.Int32, kulupId);
Organizasyon nesne=new Organizasyon();
nesne.Id=-1;
nesne.KulupId=kulupId;
return base.Delete(nesne, dbComm, dbTransaction, db);
}
public int DeleteByUzmanlikAlaniId(Int32 uzmanlikAlaniId,DbTransaction dbTransaction,Database db)
{
sqlText="DELETE KATILIMCI_UZMANLIK_ARATABLO where UZMANLIK_ALANI_ID=@uzmanlikAlaniId ";
dbComm = db.GetSqlStringCommand(sqlText);
db.AddInParameter(dbComm, "@uzmanlikAlaniId", DbType.Int32, uzmanlikAlaniId);
KatilimciUzmanlikAratablo nesne=new KatilimciUzmanlikAratablo();
nesne.KatilimciId=-1;
nesne.UzmanlikAlaniId=uzmanlikAlaniId;
return base.Delete(nesne, dbComm, dbTransaction, db);
}
public int DeleteByOrganizasyonId(Int32 organizasyonId,DbTransaction dbTransaction,Database db)
{
sqlText="DELETE KATILIMCI_ORGANIZASYON_ARATABLO where ORGANIZASYON_ID=@organizasyonId ";
dbComm = db.GetSqlStringCommand(sqlText);
db.AddInParameter(dbComm, "@organizasyonId", DbType.Int32, organizasyonId);
KatilimciOrganizasyonAratablo nesne=new KatilimciOrganizasyonAratablo();
nesne.KatilimciId=-1;
nesne.OrganizasyonId=organizasyonId;
return base.Delete(nesne, dbComm, dbTransaction, db);
}
public int DeleteBySecenekTip(Int32 secenekTip,DbTransaction dbTransaction,Database db)
{
sqlText="DELETE SORU where SECENEK_TIP=@secenekTip ";
dbComm = db.GetSqlStringCommand(sqlText);
db.AddInParameter(dbComm, "@secenekTip", DbType.Int32, secenekTip);
Soru nesne=new Soru();
nesne.Id=-1;
nesne.SecenekTip=secenekTip;
return base.Delete(nesne, dbComm, dbTransaction, db);
}
public int DeleteByOrganizasyonId(Int32 organizasyonId,DbTransaction dbTransaction,Database db)
{
sqlText="DELETE ANKET where ORGANIZASYON_ID=@organizasyonId ";
dbComm = db.GetSqlStringCommand(sqlText);
db.AddInParameter(dbComm, "@organizasyonId", DbType.Int32, organizasyonId);
Anket nesne=new Anket();
nesne.Id=-1;
nesne.OrganizasyonId=organizasyonId;
return base.Delete(nesne, dbComm, dbTransaction, db);
}
public int DeleteByDuyuruTipId(Int32 duyuruTipId,DbTransaction dbTransaction,Database db)
{
sqlText="DELETE DUYURU where DUYURU_TIP_ID=@duyuruTipId ";
dbComm = db.GetSqlStringCommand(sqlText);
db.AddInParameter(dbComm, "@duyuruTipId", DbType.Int32, duyuruTipId);
Duyuru nesne=new Duyuru();
nesne.Id=-1;
nesne.DuyuruTipId=duyuruTipId;
return base.Delete(nesne, dbComm, dbTransaction, db);
}
/// <summary>
/// 获取指定表名的架构信息
/// </summary>
/// <param name="db"></param>
/// <param name="tableName"></param>
/// <returns></returns>
public static DataTable GetSchema(Database db, string tableName)
{
DbDataAdapter ap = db.GetDataAdapter();
DbCommand cmd = db.GetSqlStringCommand(string.Format("SELECT * FROM {0}", tableName));
cmd.Connection = db.CreateConnection();
ap.SelectCommand = cmd;
DataTable t = new DataTable();
ap.FillSchema(t, SchemaType.Mapped);
return t;
}
public bool ActualizarPersonalTiemposDeAlimentacion(PersonalTiemposDeAlimentacion personalTiemposDeAlimentacion)
{
stringBuilder = new StringBuilder();
stringBuilder.AppendLine("UPDATE TblPersonalTiemposDeAlimentacion SET NumeroDeEmpleado=@NumeroDeEmpleado,Fecha=@Fecha,TiemposDeAlimentacionID=@TiemposDeAlimentacionID,ModuloHabitacional=@ModuloHabitacional");
stringBuilder.AppendLine(" WHERE PersonalTiemposDeAlimentacionID=@PersonalTiemposDeAlimentacionID");
DbCommand cmd = Database.GetSqlStringCommand(stringBuilder.ToString());
Database.AddInParameter(cmd, "NumeroDeEmpleado", DbType.String, personalTiemposDeAlimentacion.NumeroDeEmpleado);
Database.AddInParameter(cmd, "Fecha", DbType.DateTime, personalTiemposDeAlimentacion.Fecha);
Database.AddInParameter(cmd, "TiemposDeAlimentacionID", DbType.Int16, personalTiemposDeAlimentacion.TiemposDeAlimentacionID);
Database.AddInParameter(cmd, "ModuloHabitacional", DbType.Int16, personalTiemposDeAlimentacion.ModuloHabitacional);
Database.AddInParameter(cmd, "PersonalTiemposDeAlimentacionID", DbType.Int32, personalTiemposDeAlimentacion.PersonalTiemposDeAlimentacionID);
if (Database.ExecuteNonQuery(cmd) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// ExecuteNonQuery 数据添加、修改、删除
/// </summary>
/// <param name="cmdType">SqlCommand命令类型 (存储过程， T-SQL语句， 等等。)</param>
/// <param name="cmdText">存储过程的名字或者 T-SQL 语句</param>
/// <param name="commandParameters">以数组形式提供SqlCommand命令中用到的参数列表</param>
/// <returns>受影响的行数</returns>
public int ExecuteNonQuery(CommandType cmdType, string cmdText, params IDbDataParameter[] commandParameters)
{
try
{
this.Open();
if (cmdType == CommandType.StoredProcedure)
{
mDbCommand = mDatabase.GetStoredProcCommand(cmdText);
}
else
{
mDbCommand = mDatabase.GetSqlStringCommand(cmdText);
}
mDbCommand.Connection = Connection;
if (Transaction != null)
{
mDbCommand.Transaction = Transaction;
}
if ((commandParameters != null) && (commandParameters.Length > 0))
{
foreach (IDbDataParameter mParameter in commandParameters)
{
mDatabase.AddParameter(mDbCommand, mParameter.ParameterName, mParameter.DbType, mParameter.Direction, mParameter.SourceColumn, mParameter.SourceVersion, mParameter.Value);
}
}
return(mDbCommand.ExecuteNonQuery());
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
if (Transaction == null)
{
this.Close();
}
}
}
public void GetTiemposDeAlimentacion(int TiemposDeAlimentacionID)
{
DatabaseProviderFactory databaseProviderFactory = new DatabaseProviderFactory();
Microsoft.Practices.EnterpriseLibrary.Data.Database database = databaseProviderFactory.Create("DefaultConnection");
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendLine("SELECT Nombre FROM TblTiemposDeAlimentacion WHERE TiemposDeAlimentacionID=@PTiemposDeAlimentacionID");
DbCommand command = database.GetSqlStringCommand(stringBuilder.ToString());
database.AddInParameter(command, "PTiemposDeAlimentacionID", System.Data.DbType.String, TiemposDeAlimentacionID);
Nombre = database.ExecuteScalar(command).ToString();
}
public void GetModuloHabitacional(string ModuloHabitacionalID)
{
DatabaseProviderFactory databaseProviderFactory = new DatabaseProviderFactory();
Microsoft.Practices.EnterpriseLibrary.Data.Database database = databaseProviderFactory.Create("DefaultConnection");
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendLine("SELECT Nombre FROM TblModulosHabitacionales WHERE ModuloHabitacional=@PModuloHabitacional");
DbCommand command = database.GetSqlStringCommand(stringBuilder.ToString());
database.AddInParameter(command, "PModuloHabitacional", System.Data.DbType.String, ModuloHabitacionalID);
Nombre = database.ExecuteScalar(command).ToString();
}
/// <summary>
/// 查询数据库是否有对应记录（是否唯一）
/// </summary>
/// <param name="_db"></param>
/// <param name="_tablename">>注意表名要用数据库全称</param>
/// <param name="_sqlwhere">限定语句，必须and开头，可留空</param>
/// <returns></returns>
public static bool UniversalizationGetUnique(Microsoft.Practices.EnterpriseLibrary.Data.Database _db, string _tablename, string _sqlwhere)
{
try
{
var ds = new DataSet();
var sql = "select * from " + _tablename + " where 1=1 " + _sqlwhere;
var cmd = _db.GetSqlStringCommand(sql);
_db.LoadDataSet(cmd, ds, _tablename);
return(ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据条件where获取单表
/// </summary>
/// <param name="_db"></param>
/// <param name="_tablename">注意表名要用数据库全称</param>
/// <param name="_sqlwhere">限定语句，必须and开头，可留空</param>
/// <returns></returns>
public static T UniversalizationGetwhere <T>(Microsoft.Practices.EnterpriseLibrary.Data.Database _db, string _tablename, string _sqlwhere)
{
try
{
var sql = "select * from " + _tablename + " where 1=1 " + _sqlwhere;
var model = Activator.CreateInstance <T>();
var cmd = _db.GetSqlStringCommand(sql);
//注意：如果需要使返回的table名不含有数据库表的限定名，则如下：
if (_tablename.Contains("."))
{
_tablename = (_tablename.Split('.'))[(_tablename.Split('.')).Length - 1];
}
if (_tablename.StartsWith("["))
{
_tablename = _tablename.Substring(1, _tablename.Length - 2);
}
_db.LoadDataSet(cmd, model as DataSet, _tablename);//return回来的dataset表名
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
public object ExecuteScalar(string query, CommandType commandType, List <IDbDataParameter> parameters)
{
DbConnection _connection;
_connection = _database.CreateConnection();
_connection.Open();
var cmd = commandType == CommandType.StoredProcedure ? _database.GetStoredProcCommand(query) : _database.GetSqlStringCommand(query);
cmd.CommandTimeout = 300;
cmd.Connection = _connection;
using (cmd)
{
if (parameters != null && parameters.Count > 0)
{
cmd.Parameters.AddRange(parameters.ToArray());
}
return(_database.ExecuteScalar(cmd));
}
}
/// <summary>
/// 获取待办事项明细信息
/// </summary>
public List <string> LoadPendingMatterDetailInfo()
{
string SQLApplyBasis = string.Empty;
//if (basepage.CurrUserInfo().RoleName.Contains("运营专员"))
//{
// SQLApplyBasis = SQLWhere("ApplyList.aspx");
//}
SQLApplyBasis = SQLWhere("/ApplyList.aspx");
//else if (basepage.CurrUserInfo().RoleName.Contains("初审专员"))
//{ SQLApplyBasis = SQLWhere("AuditInstructionsList.aspx?step=1"); }
//else if (basepage.CurrUserInfo().RoleName.Contains("信贷专员"))
//{ SQLApplyBasis = SQLWhere("AuditInstructionsList.aspx?step=2"); }
//else if (basepage.CurrUserInfo().RoleName.Contains("信贷主管"))
//{ SQLApplyBasis = SQLWhere("AuditInstructionsList.aspx?step=3"); }
//else if (basepage.CurrUserInfo().RoleName.Contains("贷前审核"))
//{ SQLApplyBasis = SQLWhere("AuditInstructionsList.aspx?step=5"); }
//else if (basepage.CurrUserInfo().RoleName.Contains("财务放款"))
//{ SQLApplyBasis = SQLWhere("AuditInstructionsList.aspx?step=6"); }
//string SQLApplyBasis = SQLWhere("ApplyList.aspx");
//SQLApplyBasis += SQLWhere("AuditInstructionsList.aspx?step=1");
//SQLApplyBasis += SQLWhere("AuditInstructionsList.aspx?step=2");
//SQLApplyBasis += SQLWhere("AuditInstructionsList.aspx?step=3");
//SQLApplyBasis += SQLWhere("AuditInstructionsList.aspx?step=4");
//SQLApplyBasis += SQLWhere("AuditInstructionsList.aspx?step=5");
//SQLApplyBasis += SQLWhere("AuditInstructionsList.aspx?step=6");
SQLApplyBasis = SQLApplyBasis.Replace("'", "''");
List <string> PendingMatterList = new List <string>();//待办事项集合
string sqlString = "exec GetPendingMatterRecordDetail '" + basepage.CurrUserInfo().RoleID + "','" + basepage.CurrUserInfo().UserID + "','" + SQLApplyBasis + "'";
Microsoft.Practices.EnterpriseLibrary.Data.Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(sqlString);
DataSet ds = db.ExecuteDataSet(dbCommand);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
string trStr = "";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
trStr = "";
trStr += "<tr>";
trStr += "<td align=center style=\"border-bottom:1pt dotted\"><img src=\"/Images/Desktop/audit.png\" /></td>";
trStr += "<td align=center style=\"border-bottom:1pt dotted\">" + ds.Tables[0].Rows[i]["Stauts"].ToString() + "</td>";
trStr += "<td align=center style=\"border-bottom:1pt dotted\">" + ds.Tables[0].Rows[i]["ApplyBasis_Code"].ToString() + "</td>";
trStr += "<td align=center style=\"border-bottom:1pt dotted\">" + ds.Tables[0].Rows[i]["ApplyBasis_Name"].ToString() + "</td>";
trStr += "<td align=center style=\"border-bottom:1pt dotted\">" + ds.Tables[0].Rows[i]["VehicleTypeName"].ToString() + "</td>";
//trStr += "<td align=center style=\"border-bottom:1pt dotted\">" + ds.Tables[0].Rows[i]["CustomProduct_Loan"].ToString() + "</td>";
trStr += "<td align=center style=\"border-bottom:1pt dotted\">" + ds.Tables[0].Rows[i]["ApplyBasis_Date"].ToString() + "</td>";
//trStr += "<td align=center style=\"border-bottom:1pt dotted\">" + GetAuditUrl(ds.Tables[0].Rows[i]["PendingMatter_ModuleID"].ToString(), ds.Tables[0].Rows[i]["PendingMatter_ModuleName"].ToString(), ds.Tables[0].Rows[i]["WorkflowTasksInstanceID"].ToString(), ds.Tables[0].Rows[i]["WorkflowTasksSetp"].ToString(), ds.Tables[0].Rows[i]["ApplyBasis_Type"].ToString(), ds.Tables[0].Rows[i]["Stauts"].ToString()) + "</td>";
trStr += "</tr>";
PendingMatterList.Add(trStr);
}
}
}
}
return(PendingMatterList);
}
/// <summary>
/// Update SAS_ExportData Data...
/// <summary>
/// <param name=sender></param>
/// <param name= e></param>
public bool Update(ExportDataEN argEn)
{
bool lbRes = false;
int iOut = 0;
string sqlCmd = "Select count(*) as cnt From SAS_ExportData WHERE InterfaceID = '" + argEn.InterfaceID + "'";
try
{
Microsoft.Practices.EnterpriseLibrary.Data.Database loDbSel = DatabaseFactory.CreateDatabase(csConnectionStr);
using (DbCommand cmdSel = loDbSel.GetSqlStringCommand(sqlCmd))
{
using (IDataReader dr = loDbSel.ExecuteReader(cmdSel))
{
if (dr.Read())
{
iOut = GetValue <int>(dr, "cnt");
}
if (iOut < 0)
{
throw new Exception("Update Failed! No Record Exist!");
}
}
if (iOut != 0)
{
sqlCmd = "UPDATE SAS_ExportData SET InterfaceID = @InterfaceID, FileFormat = @FileFormat, Interface = @Interface, Frequency = @Frequency, TimeofExport = @TimeofExport, Filepath = @Filepath, PreviousData = @PreviousData,DateRange = @DateRange, DateFrom = @DateFrom, DateTo = @DateTo, LastUpdatedBy = @LastUpdatedBy, LastUpdatedDateTime = @LastUpdatedDateTime WHERE InterfaceID = @InterfaceID";
Microsoft.Practices.EnterpriseLibrary.Data.Database loDbUpd = DatabaseFactory.CreateDatabase(csConnectionStr);
using (DbCommand cmd = loDbUpd.GetSqlStringCommand(sqlCmd))
{
loDbUpd.AddInParameter(cmd, "@InterfaceID", DbType.String, argEn.InterfaceID);
loDbUpd.AddInParameter(cmd, "@FileFormat", DbType.String, argEn.FileFormat);
loDbUpd.AddInParameter(cmd, "@Interface", DbType.String, argEn.Interface);
loDbUpd.AddInParameter(cmd, "@Frequency", DbType.String, argEn.Frequency);
loDbUpd.AddInParameter(cmd, "@TimeofExport", DbType.String, argEn.TimeofExport);
loDbUpd.AddInParameter(cmd, "@Filepath", DbType.String, argEn.Filepath);
loDbUpd.AddInParameter(cmd, "@PreviousData", DbType.Boolean, argEn.PreviousData);
loDbUpd.AddInParameter(cmd, "@DateRange", DbType.Boolean, argEn.DateRange);
loDbUpd.AddInParameter(cmd, "@DateFrom", DbType.DateTime, argEn.DateFrom);
loDbUpd.AddInParameter(cmd, "@DateTo", DbType.DateTime, argEn.DateTo);
loDbUpd.AddInParameter(cmd, "@LastUpdatedBy", DbType.String, argEn.LastUpdatedBy);
loDbUpd.AddInParameter(cmd, "@LastUpdatedDateTime", DbType.DateTime, argEn.LastUpdatedDateTime);
int liRowAffected = loDbUpd.ExecuteNonQuery(cmd);
if (liRowAffected > -1)
{
System.Messaging.Message mm = new System.Messaging.Message(argEn, new System.Messaging.XmlMessageFormatter(new Type[] { typeof(ExportDataEN), typeof(string) }));
mm.Label = argEn.InterfaceID;
MessageQueueTransaction Transaction = new MessageQueueTransaction();
Transaction.Begin();
mq.Send(mm, Transaction);
Transaction.Commit();
lbRes = true;
}
else
{
throw new Exception("Update Failed! No Row has been updated...");
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lbRes);
}
