public static DataSet ExecuteSQLServerAdoQuery(string queryString, SqlParameter[] ParaList, string connectionString)
{
DataSet dataset = new DataSet();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(queryString, conn);
using (SqlDataAdapter dadp = new SqlDataAdapter(cmd))
{
if (ParaList != null)
{
foreach (SqlParameter para in ParaList)
{
para.Value = para.Value == null ? DBNull.Value : para.Value;
cmd.Parameters.Add(para);
}
}
conn.Open();
// dadp.SelectCommand = cmd;
dadp.Fill(dataset);
}
}
}
catch (Exception ex)
{
Log4NetLogger.GetLogger().Error(ex.Message);
throw;
}
return(dataset);
}
public static DataSet ExecuteQuery(string queryString, SqlParameter[] ParaList, CommandType commandType)
{
DataSet dataset = new DataSet();
try
{
using (SqlConnection conn = new SqlConnection(ConnectionStringSettings))
{
SqlDataAdapter dadp = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(queryString, conn);
cmd.CommandType = commandType;
if (ParaList != null)
{
foreach (SqlParameter para in ParaList)
{
para.Value = para.Value == null ? DBNull.Value : para.Value;
cmd.Parameters.Add(para);
}
}
dadp.SelectCommand = cmd;
dadp.Fill(dataset);
}
}
catch (Exception ex)
{
Log4NetLogger.GetLogger().Error(ex.Message);
throw;
}
return(dataset);
}
// Basic Method Here
public static int ExecuteNonQuery(string strSql, SqlParameter[] ParaList, CommandType commandType)
{
try
{
using (SqlConnection conn = new SqlConnection(ConnectionStringSettings))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = strSql;
cmd.CommandType = commandType;
cmd.Connection = conn;
conn.Open();
if (ParaList != null)
{
foreach (SqlParameter para in ParaList)
{
para.Value = para.Value == null ? DBNull.Value : para.Value;
cmd.Parameters.Add(para);
}
}
int iret = cmd.ExecuteNonQuery();
conn.Close();
return(iret);
}
}
catch (Exception ex)
{
Log4NetLogger.GetLogger().Error(ex.Message);
throw;
}
}
/// <summary>
/// Remove the old, unnecessary files
/// </summary>
private void TempImgLRU()
{
int nLURInterval = 30; // LUR every ? seconds
int nMaxFilesCount = 100; // Only LRU when files count exceed this threshold
int nMaxExpiredMinutes = 30; // Only delete the files expired with specified minutes
string strTempFolder = Yiyou.Util.ImageUtils.GetTempFolderPath();
while (System.IO.Directory.Exists(strTempFolder))
{
try
{
string[] FileList = System.IO.Directory.GetFiles(strTempFolder, "*.*", System.IO.SearchOption.AllDirectories);
if (FileList.Length > nMaxFilesCount)
{
foreach (string filePath in FileList)
{
System.IO.FileInfo fi = new System.IO.FileInfo(filePath);
if (fi.LastAccessTime.AddMinutes(nMaxExpiredMinutes) < DateTime.Now)
{
fi.Attributes = System.IO.FileAttributes.Normal;
fi.Delete();
}
}
}
}
catch (Exception ex)
{
Log4NetLogger.GetLogger().Info("LRU failed: " + ex.StackTrace);
}
System.Threading.Thread.Sleep(nLURInterval * 1000);
}
}
private bool SaveApplication()
{
try
{
ApplicationAllInOneMdl totalMdl = this.GetMdlFromGUI();
Consult_ApplicationMdl mdl = totalMdl.Consult_ApplicationMdl;
Consult_ApplicationDAL dal = new Consult_ApplicationDAL();
// Save/Update the Patient info first
#region MyRegion
string patient_guid = EMR_PatientMdlDAL.GetPatientGUID(totalMdl.EMR_PatientMdl.name, totalMdl.EMR_PatientMdl.user_guid);
if (string.IsNullOrEmpty(patient_guid))
{
// New
totalMdl.EMR_PatientMdl.patient_guid = Guid.NewGuid().ToString(); // Create new GUID
totalMdl.Consult_ApplicationMdl.patient_guid = totalMdl.EMR_PatientMdl.patient_guid; // Copy GUID
EMR_PatientMdlDAL.Add(totalMdl.EMR_PatientMdl);
}
else
{
// Update
totalMdl.EMR_PatientMdl.patient_guid = patient_guid; // Create new GUID
totalMdl.Consult_ApplicationMdl.patient_guid = totalMdl.EMR_PatientMdl.patient_guid; // Copy GUID
EMR_PatientMdlDAL.Update(totalMdl.EMR_PatientMdl);
}
#endregion
// Continue save the others info
if (!dal.IsExist(mdl.guid))
{
// Add Consult_ApplicationMdl
dal.Add_consult_application(mdl);
// Add consult_application_consultant
dal.Add_consult_application_consultant(totalMdl.Consult_Application_ConsultantMdlCollection);
// Add the Purpose Image
dal.Add_consult_application_accessory(totalMdl.consult_application_accessoryMdl);
return(true);
}
else
{
// Update Consult_ApplicationMdl
dal.Update_consult_application(mdl);
// Update consult_application_consultant
dal.Update_consult_application_consultant(totalMdl.Consult_Application_ConsultantMdlCollection);
// Update the Purpose Image
dal.Update_consult_application_accessory(totalMdl.consult_application_accessoryMdl);
return(true);
}
}
catch (Exception ex)
{
Log4NetLogger.GetLogger().Error(ex.Message);
this.lblErrorMsg.Text = ex.Message;
}
return(false);
}
private ILogger CreateGlobalLoggerForService(string instanceName)
{
Constraint.MustNotBeNull(Configuration, "Configuration");
var logFilePath = Configuration.GetStringValue(GlobalSettings.Keys.LogFilePath);
// ReSharper disable once AssignNullToNotNullAttribute
logFilePath = string.Format(logFilePath, string.Format(".{0}", instanceName));
logFilePath = PathHelp.RootPathIfRelative(logFilePath, AppDomain.CurrentDomain.BaseDirectory);
return(Log4NetLogger.GetLogger(ExeAppSettings.FilePath,
Appenders.Trace(),
Appenders.ColouredConsole(),
Appenders.EventLog(EventLogSource),
Appenders.RollingFile(logFilePath, true)));
}
void Application_Start(object sender, EventArgs e)
{
// 在应用程序启动时运行的代码
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
// Code that runs on application startup
Log4NetLogger.GetLogger().Info("Application_Start....");
SqlHelper.ConnectionStringSettings = ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString;
Log4NetLogger.GetLogger().Info("ConnectionStringSettings: " + SqlHelper.ConnectionStringSettings);
System.Threading.Thread t = new System.Threading.Thread(TempImgLRU);
t.Start();
}
// Basic Method Here
public static int ExecuteNonQuery(List <SqlWrapper> lstSql)
{
try
{
int iret = 0;
using (TransactionScope scope = new TransactionScope())
{
using (SqlConnection conn = new SqlConnection(ConnectionStringSettings))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
conn.Open();
foreach (SqlWrapper sql in lstSql)
{
try
{
cmd.CommandText = sql.SqlString;
cmd.Parameters.Clear();
if (sql.Parameter != null)
{
foreach (SqlParameter para in sql.Parameter)
{
para.Value = para.Value == null ? DBNull.Value : para.Value;
cmd.Parameters.Add(para);
}
}
iret += cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Log4NetLogger.GetLogger().Error(ex.Message);
throw;
}
}
conn.Close();
}
scope.Complete();
return(iret);
}
}
catch
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!Page.IsPostBack)
{
this.InitCtrl();
}
else
{
this.CreateDropdownListGroup();
}
}
catch (Exception ex)
{
Log4NetLogger.GetLogger().Error(ex.Message);
this.lblErrorMsg.Text = ex.Message;
}
}
// Basic Method Here
public static DataSet ExecuteAdapter(string queryString, string tableName)
{
DataSet dataset = new DataSet();
try
{
using (SqlConnection conn = new SqlConnection(ConnectionStringSettings))
{
SqlDataAdapter adapter = new SqlDataAdapter(queryString, conn);
adapter.Fill(dataset, tableName);
}
}
catch (Exception ex)
{
Log4NetLogger.GetLogger().Error(ex.Message);
throw;
}
return(dataset);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public static ILog StaticLogger(System.Type type)
{
return(Log4NetLogger.GetLogger(type));
}
/// <summary>
/// Logger's constructor using the given type as logger name
/// </summary>
/// <param name="type"></param>
public LoggerBase(System.Type type)
{
Logger = Log4NetLogger.GetLogger(type);
}
/// <summary>
/// Construct the Logger, using the log4net.config file as configurator
/// </summary>
public LoggerBase()
{
Logger = Log4NetLogger.GetLogger(GetType());
}