public void RemoveDatabase(string name)
{
OrmLiteConfig.DialectProvider = SqlServerOrmLiteDialectProvider.Instance;
DatabaseParam dBParam = ConfigStringsFactory.NewDatabaseParam();
var connectionString = string.Format(ConnectionString, dBParam.ServerName, dBParam.DatabaseName, dBParam.UserId, dBParam.Password);
using (IDbConnection con = connectionString.OpenDbConnection())
{
int exist = con.Scalar <int>(string.Format(DatabaseSelectSql, name));
IDbCommand cmd = con.CreateCommand();
if (exist > 0)
{
///杀死所有连接
List <SpWho> spWhoes = con.SqlList <SpWho>(" sp_who ;");
foreach (var item in spWhoes)
{
if (item.dbname == name)
{
cmd.CommandText = string.Format(DatabaseKillSql, item.spid);
cmd.ExecuteNonQuery();
}
}
///删除数据库
cmd.CommandText = string.Format(DatabaseDeleteSql, name);
cmd.ExecuteNonQuery();
}
}
}
public static void CreateDatabase(DatabaseParam dbParam)
{
//System.Data.SqlClient.SqlConnection tmpConn;
_sqlCon = new SqlConnection
{
ConnectionString = "SERVER = " + ServerName + "; DATABASE = master; User ID = " + LoginName +
"; Pwd = " + PasswordName
};
var sqlCreateDbQuery = " CREATE DATABASE " + dbParam.DatabaseName + " ON PRIMARY "
+ " (NAME = " + dbParam.DataFileName + ", "
+ " FILENAME = '" + dbParam.DataPathName + "', "
+ " SIZE = 5MB,"
+ " FILEGROWTH ="+ dbParam.DataFileGrowth + ") "
+ " LOG ON (NAME =" + dbParam.LogFileName + ", "
+ " FILENAME = '" + dbParam.LogPathName + "', "
+ " SIZE = 5MB, "
+ " FILEGROWTH ="+ dbParam.LogFileGrowth + ") ";
var myCommand = new SqlCommand(sqlCreateDbQuery, _sqlCon);
try
{
_sqlCon.Open();
myCommand.ExecuteNonQuery();
}
finally
{
_sqlCon.Close();
}
}
/// <summary>
/// 获取住院明细
/// </summary>
/// <param name="user"></param>
/// <param name="businessId"></param>
/// <returns></returns>
public List <InpatientInfoDetailDto> GetInpatientInfoDetail(UserInfoDto user, string businessId)
{
var resultData = new List <InpatientInfoDetailDto>();
var queryParam = new DatabaseParam()
{
Field = "BusinessId",
Value = businessId,
TableName = "Inpatient"
};
var inpatientData = _hisSqlRepository.QueryDatabase(new InpatientEntity(), queryParam);
if (inpatientData == null)
{
throw new Exception("该病人未在中心库中,请检查是否办理医保入院!!!");
}
//获取当前病人
var inpatient = inpatientData.FirstOrDefault();
var transactionId = Guid.NewGuid().ToString("N");
var xmlData = new MedicalInsuranceXmlDto();
xmlData.BusinessId = businessId;
xmlData.HealthInsuranceNo = "31";
xmlData.TransactionId = transactionId;
xmlData.AuthCode = user.AuthCode;
xmlData.UserId = user.UserId;
xmlData.OrganizationCode = user.OrganizationCode;
var data = _webServiceBasic.HIS_Interface("39", JsonConvert.SerializeObject(xmlData));
InpatientDetailListJsonDto dataValue = JsonConvert.DeserializeObject <InpatientDetailListJsonDto>(data.Msg);
if (dataValue != null)
{
resultData = AutoMapper.Mapper.Map <List <InpatientInfoDetailDto> >(dataValue.DetailList);
var saveParam = new SaveInpatientInfoDetailParam()
{
DataList = resultData,
HospitalizationId = inpatient.HospitalizationId,
User = user
};
_hisSqlRepository.SaveInpatientInfoDetail(saveParam);
// // var msg = "获取住院号【" + resultFirst.住院号 + "】，业务ID【" + param.业务ID + "】的时间段内的住院费用成功，共" + result.Count +
// // "条记录";
//}
}
return(resultData);
}
public void CreateDataBase(string name)
{
OrmLiteConfig.DialectProvider = SqlServerOrmLiteDialectProvider.Instance;
DatabaseParam dBParam = ConfigStringsFactory.NewDatabaseParam();
var connectionString = string.Format(ConnectionString, dBParam.ServerName, dBParam.DatabaseName, dBParam.UserId, dBParam.Password);
dBParam.DatabaseName = name;
using (IDbConnection con = connectionString.OpenDbConnection())
{
con.ExecuteNonQuery(string.Format(DatabaseCreateSql,
dBParam.DatabaseName,
dBParam.DataFileSize,
dBParam.DataFileGrowth,
dBParam.LogFileSize,
dBParam.LogFileGrowth,
dBParam.Path));
}
}
private bool CreateDatabase(DatabaseParam DBParam)
{
string sqlCreateDBQuery;
// DBParam.DatabaseName
//sqlCreateDBQuery = " CREATE DATABASE " + DBParam.DatabaseName + " ON PRIMARY "
// + " (NAME = " + DBParam.DataFileName +", "
// + " FILENAME = '" + DBParam.DataPathName +"', "
// + " SIZE = 2MB,"
// + " FILEGROWTH =" + DBParam.DataFileGrowth +") "
// + " LOG ON (NAME =" + DBParam.LogFileName +", "
// + " FILENAME = '" + DBParam.LogPathName + "', "
// + " SIZE = 1MB, "
// + " FILEGROWTH =" + DBParam.LogFileGrowth +") ";
sqlCreateDBQuery = "CREATE DATABASE " + DBParam.DatabaseName +" ON PRIMARY "
+ "(NAME = '" + DBParam.DataFileName+ "', "
+ "FILENAME = '"+ DBParam.DataPathName + "', "
+ "SIZE = " +DBParam.InitialDataFileSize+ "MB,"
+ "MAXSIZE = " + DBParam.DataFileMaxSize + ", FILEGROWTH = " + DBParam.DataFileGrowth + ") " +
"LOG ON (NAME = '"+DBParam.LogFileName+"', " +
"FILENAME = '" + DBParam.LogPathName+ "', "
+ "SIZE = "+DBParam.LogFileSize + "MB, " +
"MAXSIZE = "+DBParam.LogFileMaxSize+ ", " +
"FILEGROWTH = " + DBParam.LogFileGrowth+");";
string csError= null;
string savedDataBaseName = m_con.DataBase;
m_con.DataBase = "";
//m_con.conData.SetConnectionString();
if (this.m_con.ExecuteNonQuerySQL_NoMultiTrans(sqlCreateDBQuery, null, ref csError))
{
// Data Base Created OK
m_con.DataBase = DBParam.DatabaseName;
string msg = "Database \"" + DBParam.DatabaseName + "\" created OK on server:" + this.m_con.DataSource;
MessageBox.Show(this,msg, "OK", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return true;
}
else
{
m_con.DataBase = savedDataBaseName;
//m_con.conData.SetConnectionString();
string msg = "ERROR! Database \"" + DBParam.DatabaseName + "\" not created on server:" + this.m_con.DataSource + "\n ERROR=" + csError;
MessageBox.Show(this,msg, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return false;
}
}
private void btn_CreateDatabase_Click(object sender, EventArgs e)
{
if (m_bPermissionsOK)
{
DatabaseParam DBParam = new DatabaseParam();
DBParam.ServerName = m_con.DataSource;
DBParam.DatabaseName = textBox_DataBaseName.Text;
DBParam.InitialDataFileSize = this.nupdn_InitialFileSizeInMB.Value.ToString();
//Assign Data file parameters
DBParam.DataFileName = GetFileNameWithOutExtensionFromPath(textBox_DataBaseFilePath.Text);
DBParam.DataPathName = textBox_DataBaseFilePath.Text;
if (rdb_FileGrowthInMB.Checked == true)
{
DBParam.DataFileGrowth = this.nupdn_FileGrowthInMB.Value.ToString() + "MB";
}
else
{
DBParam.DataFileGrowth = this.nupdn_LogFileGrowthByPercent.ToString() + "%";
}
if (rdbMaxDataBaseFileSizeUNLIMITED.Checked == true)
{
DBParam.DataFileMaxSize = "UNLIMITED";
}
else
{
DBParam.DataFileMaxSize = this.nupdn_MaxDataBaseFileSizeInGB.Value.ToString() + "GB";
}
//Assign Log file parameters
DBParam.LogFileName = GetFileNameWithOutExtensionFromPath(textBox_DataBaseLogFilePath.Text);
DBParam.LogFileSize = this.nupdn_InitialLogFileSizeInMB.Value.ToString();//1MB at the init state
DBParam.LogPathName = textBox_DataBaseLogFilePath.Text;
if (rdb_LogFileGrowthInMB.Checked == true)
{
DBParam.LogFileGrowth = this.nupdn_LogFileGrowthInMB.Value.ToString() + "MB";
}
else
{
DBParam.LogFileGrowth = this.nupdn_LogFileGrowthByPercent.Value.ToString() + "%";
}
if (rdbMaxLogFileSizeUNLIMITED.Checked == true)
{
DBParam.LogFileMaxSize = "UNLIMITED";
}
else
{
DBParam.LogFileMaxSize = this.nupdn_MaxLogFileSizeInMB + " MB";
}
if (CreateDatabase(DBParam))
{
this.Close();
DialogResult = DialogResult.OK;
}
}
else
{
this.Close();
DialogResult = DialogResult.Cancel;
}
}
