public List <PatientGroupPara> SelectPatientGroupPara(Dictionary <string, object> condition)
{
var list = new List <PatientGroupPara>();
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
if (condition == null || condition.Count == 0)
{
sqlcomm.CommandText =
"select * from PATIENTGROUPPARA order by ID asc;";
list = DatabaseOp.ExecuteQuery <PatientGroupPara>(sqlcomm);
return(list);
}
string sqlcommand = "select * from PATIENTGROUPPARA where ";
DatabaseOp.TransferParameteres(ref sqlcommand, "@", "and", condition, sqlcomm.Parameters);
sqlcommand = sqlcommand.Substring(0, sqlcommand.LastIndexOf("and"));
sqlcommand += " order by ID asc";
sqlcomm.CommandText = sqlcommand;
list = DatabaseOp.ExecuteQuery <PatientGroupPara>(sqlcomm);
return(list);
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("PatientGroupParaDao.cs-SelectPatientGroupPara", e);
return(list);
}
}
public List <TreatMethod> SelectTreatMethod(Dictionary <string, object> condition)
{
var list = new List <TreatMethod>();
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
if (condition == null || condition.Count == 0)
{
sqlcomm.CommandText =
"select * from TREATMETHOD order by ID desc;";
list = DatabaseOp.ExecuteQuery <TreatMethod>(sqlcomm);
return(list);
}
string sqlcommand = "select * from TREATMETHOD where ";
DatabaseOp.TransferParameteres(ref sqlcommand, "@", "and", condition, sqlcomm.Parameters);
sqlcommand = sqlcommand.Substring(0, sqlcommand.LastIndexOf("and"));
sqlcommand += " order by ID desc";
sqlcomm.CommandText = sqlcommand;
list = DatabaseOp.ExecuteQuery <TreatMethod>(sqlcomm);
return(list);
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("TreatMethodDao.cs-SelectTreatMethod", e);
return(list);
}
}
public List <ScheduleTemplate> SelectScheduleTemplate(Dictionary <string, object> condition)
{
var list = new List <ScheduleTemplate>();
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
if (condition == null || condition.Count == 0)
{
sqlcomm.CommandText =
"select * from SCHEDULETEMPLATE order by Date desc;";
list = DatabaseOp.ExecuteQuery <ScheduleTemplate>(sqlcomm);
return(list);
}
string sqlcommand = "select * from SCHEDULETEMPLATE where ";
DatabaseOp.TransferParameteres(ref sqlcommand, "@", "and", condition, sqlcomm.Parameters);
sqlcommand = sqlcommand.Substring(0, sqlcommand.LastIndexOf("and"));
sqlcommand += " order by Date desc";
sqlcomm.CommandText = sqlcommand;
list = DatabaseOp.ExecuteQuery <ScheduleTemplate>(sqlcomm);
return(list);
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("ScheduleTemplateDao.cs-SelectScheduleTemplate", e);
return(list);
}
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="scheduleTemplate">Class instance of PatientArea infomation</param>
/// <param name="scId">Id of the last insert row id</param>
/// <returns></returns>
public bool InsertScheduleTemplate(ScheduleTemplate scheduleTemplate, ref int scId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"INSERT INTO SCHEDULETEMPLATE ([PATIENTID],[DATE],[AMPME],[METHOD],[DESCRIPTION],[RESERVED],[BEDID],[ISTEMP],[ISAUTO]) VALUES
(@PATIENTID,@DATE,@AMPME,@METHOD,@DESCRIPTION,@RESERVED,@BEDID,@ISTEMP,@ISAUTO) SET @ID = SCOPE_IDENTITY() ";
sqlcomm.Parameters.Add("@PATIENTID", DbType.Int32);
sqlcomm.Parameters["@PATIENTID"].Value = scheduleTemplate.PatientId;
sqlcomm.Parameters.Add("@DATE", DbType.String);
if (scheduleTemplate.Date != null)
{
sqlcomm.Parameters["@DATE"].Value = scheduleTemplate.Date;
}
sqlcomm.Parameters.Add("@AMPME", DbType.String);
if (scheduleTemplate.AmPmE != null)
{
sqlcomm.Parameters["@AMPME"].Value = scheduleTemplate.AmPmE;
}
sqlcomm.Parameters.Add("@METHOD", DbType.String);
if (scheduleTemplate.Method != null)
{
sqlcomm.Parameters["@METHOD"].Value = scheduleTemplate.Method;
}
sqlcomm.Parameters.Add("@DESCRIPTION", DbType.String);
if (scheduleTemplate.Description != null)
{
sqlcomm.Parameters["@DESCRIPTION"].Value = scheduleTemplate.Description;
}
sqlcomm.Parameters.Add("@RESERVED", DbType.String);
if (scheduleTemplate.Reserved != null)
{
sqlcomm.Parameters["@RESERVED"].Value = scheduleTemplate.Reserved;
}
sqlcomm.Parameters.Add("@BEDID", DbType.Int32);
sqlcomm.Parameters["@BEDID"].Value = scheduleTemplate.BedId;
sqlcomm.Parameters.Add("@ISTEMP", DbType.Boolean);
sqlcomm.Parameters["@ISTEMP"].Value = scheduleTemplate.IsTemp;
sqlcomm.Parameters.Add("@ISAUTO", DbType.Boolean);
sqlcomm.Parameters["@ISAUTO"].Value = true;
sqlcomm.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
scId = (int)sqlcomm.Parameters["@ID"].Value;
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("ScheduleTemplateDao.cs-InsertScheduleTemplate", e);
return(false);
}
return(true);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="scheduleType">Class instance of PatientArea infomation</param>
/// <param name="scId">Id of the last insert row id</param>
/// <returns></returns>
public bool InsertScheduleType(ScheduleType scheduleType, ref int scId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"INSERT INTO SCHEDULETYPE (NAME,PATIENTID,TIMERANGE,TYPE,COLOR,DESCRIPTION,RESERVED) VALUES
(@NAME,@PATIENTID, @TIMERANGE,@TYPE,@COLOR,@DESCRIPTION,@RESERVED) SET @ID = SCOPE_IDENTITY() ";
sqlcomm.Parameters.Add("@NAME", DbType.String);
if (scheduleType.Name != null)
{
sqlcomm.Parameters["@NAME"].Value = scheduleType.Name;
}
sqlcomm.Parameters.Add("@PATIENTID", DbType.Int32);
sqlcomm.Parameters["@PATIENTID"].Value = scheduleType.PatientId;
sqlcomm.Parameters.Add("@TIMERANGE", DbType.String);
if (scheduleType.TimeRange != null)
{
sqlcomm.Parameters["@TIMERANGE"].Value = scheduleType.TimeRange;
}
sqlcomm.Parameters.Add("@TYPE", DbType.Int32);
sqlcomm.Parameters["@TYPE"].Value = scheduleType.Type;
sqlcomm.Parameters.Add("@COLOR", DbType.String);
if (scheduleType.Color != null)
{
sqlcomm.Parameters["@COLOR"].Value = scheduleType.Color;
}
sqlcomm.Parameters.Add("@DESCRIPTION", DbType.String);
if (scheduleType.Description != null)
{
sqlcomm.Parameters["@DESCRIPTION"].Value = scheduleType.Description;
}
sqlcomm.Parameters.Add("@RESERVED", DbType.String);
if (scheduleType.Reserved != null)
{
sqlcomm.Parameters["@RESERVED"].Value = scheduleType.Reserved;
}
sqlcomm.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
scId = (int)sqlcomm.Parameters["@ID"].Value;
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("ScheduleTypeDao.cs-InsertScheduleType", e);
return(false);
}
return(true);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="patientArea">Class instance of PatientArea infomation</param>
/// <param name="scId">Id of the last insert row id</param>
/// <returns></returns>
public bool InsertPatientArea(PatientArea patientArea, ref int scId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"INSERT INTO PATIENTAREA (NAME,TYPE,DESCRIPTION,INFECTTYPEID,SEQ,POSITION,RESERVED) VALUES
(@NAME,@TYPE,@DESCRIPTION,@INFECTTYPEID,@SEQ,@POSITION,@RESERVED) SET @ID = SCOPE_IDENTITY() ;";
sqlcomm.Parameters.Add("@NAME", DbType.String);
if (patientArea.Name != null)
{
sqlcomm.Parameters["@NAME"].Value = patientArea.Name;
}
sqlcomm.Parameters.Add("@TYPE", DbType.String);
if (patientArea.Type != null)
{
sqlcomm.Parameters["@TYPE"].Value = patientArea.Type;
}
sqlcomm.Parameters.Add("@INFECTTYPEID", DbType.Int32);
sqlcomm.Parameters["@INFECTTYPEID"].Value = patientArea.InfectTypeId;
sqlcomm.Parameters.Add("@SEQ", DbType.Int32);
sqlcomm.Parameters["@SEQ"].Value = patientArea.Seq;
sqlcomm.Parameters.Add("@POSITION", DbType.String);
if (patientArea.Position != null)
{
sqlcomm.Parameters["@POSITION"].Value = patientArea.Position;
}
sqlcomm.Parameters.Add("@DESCRIPTION", DbType.String);
if (patientArea.Description != null)
{
sqlcomm.Parameters["@DESCRIPTION"].Value = patientArea.Description;
}
sqlcomm.Parameters.Add("@RESERVED", DbType.String);
if (patientArea.Reserved != null)
{
sqlcomm.Parameters["@RESERVED"].Value = patientArea.Reserved;
}
sqlcomm.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
scId = (int)sqlcomm.Parameters["@ID"].Value;
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("PatientAreaDao.cs-InsertPatientArea", e);
return(false);
}
return(true);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="treatTime">Class instance of infectType infomation</param>
/// <param name="scId">Id of the last insert row id</param>
/// <returns></returns>
public bool InsertTreatTime(TreatTime treatTime, ref int scId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"INSERT INTO TREATTIME (ACTIVATED,NAME,BEGINTIME,ENDTIME,DESCRIPTION,RESERVED) VALUES
(@ACTIVATED,@NAME,@BEGINTIME,@ENDTIME,@DESCRIPTION,@RESERVED) SET @ID = SCOPE_IDENTITY() ";
sqlcomm.Parameters.Add("@NAME", DbType.String);
if (treatTime.Name != null)
{
sqlcomm.Parameters["@NAME"].Value = treatTime.Name;
}
sqlcomm.Parameters.Add("@ACTIVATED", DbType.Boolean);
sqlcomm.Parameters["@ACTIVATED"].Value = treatTime.Activated;
sqlcomm.Parameters.Add("@BEGINTIME", DbType.String);
if (treatTime.BeginTime != null)
{
sqlcomm.Parameters["@BEGINTIME"].Value = treatTime.BeginTime;
}
sqlcomm.Parameters.Add("@ENDTIME", DbType.String);
if (treatTime.EndTime != null)
{
sqlcomm.Parameters["@ENDTIME"].Value = treatTime.EndTime;
}
sqlcomm.Parameters.Add("@DESCRIPTION", DbType.String);
if (treatTime.Description != null)
{
sqlcomm.Parameters["@DESCRIPTION"].Value = treatTime.Description;
}
sqlcomm.Parameters.Add("@RESERVED", DbType.String);
if (treatTime.Reserved != null)
{
sqlcomm.Parameters["@RESERVED"].Value = treatTime.Reserved;
}
sqlcomm.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
scId = (int)sqlcomm.Parameters["@ID"].Value;
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("TreatTimeDao.cs-InsertTreatTime", e);
return(false);
}
return(true);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="bed">Class instance of bed infomation</param>
/// <param name="scBedId">Id of the last insert row id</param>
/// <returns></returns>
public bool InsertBed(Bed bed, ref int scId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"INSERT INTO BED (PATIENTAREAID,NAME,TREATTYPEID,ISAVAILABLE, ISOCCUPY,DESCRIPTION,RESERVED,ISTEMP, MACHINETYPEID) VALUES
(@PATIENTAREAID,@NAME,@TREATTYPEID,@ISAVAILABLE,@ISOCCUPY,@DESCRIPTION,@RESERVED,@ISTEMP,@MACHINETYPEID) SET @ID = SCOPE_IDENTITY() ";
sqlcomm.Parameters.Add("@NAME", DbType.String);
if (bed.Name != null)
{
sqlcomm.Parameters["@NAME"].Value = bed.Name;
}
sqlcomm.Parameters.Add("@TREATTYPEID", DbType.Int32);
sqlcomm.Parameters["@TREATTYPEID"].Value = bed.TreatTypeId;
sqlcomm.Parameters.Add("@ISAVAILABLE", DbType.Boolean);
sqlcomm.Parameters["@ISAVAILABLE"].Value = bed.IsAvailable;
sqlcomm.Parameters.Add("@ISOCCUPY", DbType.Boolean);
sqlcomm.Parameters["@ISOCCUPY"].Value = bed.IsOccupy;
sqlcomm.Parameters.Add("@DESCRIPTION", DbType.String);
if (bed.Description != null)
{
sqlcomm.Parameters["@DESCRIPTION"].Value = bed.Description;
}
sqlcomm.Parameters.Add("@RESERVED", DbType.String);
if (bed.Reserved != null)
{
sqlcomm.Parameters["@RESERVED"].Value = bed.Reserved;
}
sqlcomm.Parameters.Add("@PATIENTAREAID", DbType.Int32);
sqlcomm.Parameters["@PATIENTAREAID"].Value = bed.PatientAreaId;
sqlcomm.Parameters.Add("@ISTEMP", DbType.Boolean);
sqlcomm.Parameters["@ISTEMP"].Value = bed.IsTemp;
sqlcomm.Parameters.Add("@MACHINETYPEID", DbType.Int32);
sqlcomm.Parameters["@MACHINETYPEID"].Value = bed.MachineTypeId;
sqlcomm.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
scId = (int)sqlcomm.Parameters["@ID"].Value;
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("BedDao.cs-InsertBed", e);
return(false);
}
return(true);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="treatMethod">Class instance of infectType infomation</param>
/// <param name="scId">Id of the last insert row id</param>
/// <returns></returns>
public bool InsertTreatMethod(TreatMethod treatMethod, ref int scId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"INSERT INTO TREATMETHOD (NAME,SINGLEPUMP,DOUBLEPUMP,DESCRIPTION,RESERVED,BGCOLOR,ISAVAILABLE) VALUES
(@NAME,@SINGLEPUMP,@DOUBLEPUMP,@DESCRIPTION,@RESERVED,@BGCOLOR,@ISAVAILABLE) SET @ID = SCOPE_IDENTITY() ";
sqlcomm.Parameters.Add("@NAME", DbType.String);
if (treatMethod.Name != null)
{
sqlcomm.Parameters["@NAME"].Value = treatMethod.Name;
}
sqlcomm.Parameters.Add("@SINGLEPUMP", DbType.Boolean);
sqlcomm.Parameters["@SINGLEPUMP"].Value = treatMethod.SinglePump;
sqlcomm.Parameters.Add("@DOUBLEPUMP", DbType.Boolean);
sqlcomm.Parameters["@DOUBLEPUMP"].Value = treatMethod.DoublePump;
sqlcomm.Parameters.Add("@DESCRIPTION", DbType.String);
if (treatMethod.Description != null)
{
sqlcomm.Parameters["@DESCRIPTION"].Value = treatMethod.Description;
}
sqlcomm.Parameters.Add("@RESERVED", DbType.String);
if (treatMethod.Reserved != null)
{
sqlcomm.Parameters["@RESERVED"].Value = treatMethod.Reserved;
}
sqlcomm.Parameters.Add("@BGCOLOR", DbType.String);
sqlcomm.Parameters["@BGCOLOR"].Value = treatMethod.BgColor;
sqlcomm.Parameters.Add("@ISAVAILABLE", DbType.Boolean);
sqlcomm.Parameters["@ISAVAILABLE"].Value = treatMethod.IsAvailable;
sqlcomm.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
scId = (int)sqlcomm.Parameters["@ID"].Value;
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("TreatMethodDao.cs-InsertTreatMethod", e);
return(false);
}
return(true);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="interval">Class instance of infectType infomation</param>
/// <param name="scintervalId">Id of the last insert row id</param>
/// <returns></returns>
public bool InsertInterval(MedicalOrderPara interval, ref int scId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"INSERT INTO MEDICALORDERPARA ([NAME],[TYPE],[COUNT],[DESCRIPTION],[RESERVED]) VALUES
(@NAME,@TYPE,@COUNT,@DESCRIPTION,@RESERVED) SET @ID = SCOPE_IDENTITY() ";
sqlcomm.Parameters.Add("@NAME", DbType.String);
if (interval.Name != null)
{
sqlcomm.Parameters["@NAME"].Value = interval.Name;
}
sqlcomm.Parameters.Add("@TYPE", DbType.String);
if (interval.Type != null)
{
sqlcomm.Parameters["@TYPE"].Value = interval.Type;
}
sqlcomm.Parameters.Add("@COUNT", DbType.Int32);
sqlcomm.Parameters["@COUNT"].Value = interval.Count;
sqlcomm.Parameters.Add("@DESCRIPTION", DbType.String);
if (interval.Description != null)
{
sqlcomm.Parameters["@DESCRIPTION"].Value = interval.Description;
}
sqlcomm.Parameters.Add("@RESERVED", DbType.String);
if (interval.Reserved != null)
{
sqlcomm.Parameters["@RESERVED"].Value = interval.Reserved;
}
sqlcomm.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
scId = (int)sqlcomm.Parameters["@ID"].Value;
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("MedicalOrderParaDao.cs-Insert", e);
return(false);
}
return(true);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="MachineType">Class instance of MachineType infomation</param>
/// <param name="scMachineTypeId">Id of the last insert row id</param>
/// <returns></returns>
public bool InsertMachineType(MachineType MachineType, ref int scId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"INSERT INTO MACHINETYPE (NAME,BGCOLOR,DESCRIPTION,RESERVED) VALUES
(@NAME,@BGCOLOR,@DESCRIPTION,@RESERVED) SET @ID = SCOPE_IDENTITY() ";
sqlcomm.Parameters.Add("@NAME", DbType.String);
if (MachineType.Name != null)
{
sqlcomm.Parameters["@NAME"].Value = MachineType.Name;
}
sqlcomm.Parameters.Add("@BGCOLOR", DbType.String);
if (MachineType.BgColor != null)
{
sqlcomm.Parameters["@BGCOLOR"].Value = MachineType.BgColor;
}
sqlcomm.Parameters.Add("@DESCRIPTION", DbType.String);
if (MachineType.Description != null)
{
sqlcomm.Parameters["@DESCRIPTION"].Value = MachineType.Description;
}
sqlcomm.Parameters.Add("@RESERVED", DbType.String);
if (MachineType.Reserved != null)
{
sqlcomm.Parameters["@RESERVED"].Value = MachineType.Reserved;
}
sqlcomm.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
scId = (int)sqlcomm.Parameters["@ID"].Value;
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("MachineTypeDao.cs-InsertMachineType", e);
return(false);
}
return(true);
}
public List <BedDetails> SelectPatient(Dictionary <string, object> condition)
{
var list = new List <BedDetails>();
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
//DateTime end = endtemp.AddDays(1);
if (condition == null || condition.Count == 0)
{
/*sqlcomm.CommandText =
* "select * from PATIENT where " + "REGISITDATE between '" +
* begin.ToString("yyyy-MM-dd") +
* "' and '" + end.ToString("yyyy-MM-dd") + "'" + "order by ID desc;";*/
sqlcomm.CommandText =
"SELECT Bed.Id, Bed.Name, PatientArea.Type FROM (Bed INNER JOIN PatientRoom ON Bed.PatientRoomId=PatientRoom.Id) INNER JOIN PatientArea ON PatientRoom.PatientAreaId=PatientArea.Id";
list = DatabaseOp.ExecuteQuery <BedDetails>(sqlcomm);
return(list);
}
string sqlcommand = "select Bed.Id, Bed.Name, PatientArea.Type FROM (Bed INNER JOIN PatientRoom ON Bed.PatientRoomId=PatientRoom.Id) INNER JOIN PatientArea ON PatientRoom.PatientAreaId=PatientArea.Id where ";
//DatabaseOp.TransferParameteres(ref sqlcommand, "@", "and", condition, sqlcomm.Parameters);
//sqlcommand = sqlcommand.Substring(0, sqlcommand.LastIndexOf("and"));
//sqlcommand += " order by Bed.ID desc";
foreach (var v in condition)
{
sqlcommand += v.Key + "=" + v.Value;
}
sqlcomm.CommandText = sqlcommand;
list = DatabaseOp.ExecuteQuery <BedDetails>(sqlcomm);
return(list);
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("ComplexDao.cs-SelectPatient", e);
return(list);
}
}
public bool DeleteTreatType(Int64 scId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"DELETE FROM TREATTYPE WHERE ID = @ID";
sqlcomm.Parameters.Add("@ID", DbType.Int32);
sqlcomm.Parameters["@ID"].Value = scId;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("TreatTypeDao.cs-DeleteTreatType", e);
return(false);
}
return(true);
}
public bool DeleteScheduleTemplate2(int scId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"DELETE FROM SCHEDULETEMPLATE WHERE PatientId = @PatientId";
sqlcomm.Parameters.Add("@PatientId", DbType.Int32);
sqlcomm.Parameters["@PatientId"].Value = scId;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("ScheduleTemplateDao.cs-DeleteScheduleTemplate2", e);
return(false);
}
return(true);
}
public bool DeletePatientGroupPara(Int64 scPatientGroupParaId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"DELETE FROM PATIENTGROUPPARA WHERE ID = @ID";
sqlcomm.Parameters.Add("@ID", DbType.Int32);
sqlcomm.Parameters["@ID"].Value = scPatientGroupParaId;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("PatientGroupParaDao.cs-DeletePatientGroupPara", e);
return(false);
}
return(true);
}
public bool DeleteMedicalOrder2(int patientId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"DELETE FROM MEDICALORDER WHERE PatientId = @PatientId";
sqlcomm.Parameters.Add("@PatientId", DbType.Int32);
sqlcomm.Parameters["@PatientId"].Value = patientId;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("MedicalOrderDao.cs-DeleteMedicalOrder", e);
return(false);
}
return(true);
}
public bool DeleteInterval(Int64 scIntervalId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"DELETE FROM MEDICALORDERPARA WHERE ID = @ID";
sqlcomm.Parameters.Add("@ID", DbType.Int32);
sqlcomm.Parameters["@ID"].Value = scIntervalId;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("MedicalOrderParaDao.cs-Delete", e);
return(false);
}
return(true);
}
public List <Patient> SelectPatient(Dictionary <string, object> condition, DateTime begin,
DateTime endtemp)
{
var list = new List <Patient>();
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
//DateTime end = endtemp.AddDays(1);
DateTime end = endtemp;
if (condition == null || condition.Count == 0)
{
sqlcomm.CommandText =
"select * from PATIENT where " + "REGISITDATE between '" +
begin.ToString("yyyy-MM-dd") +
"' and '" + end.ToString("yyyy-MM-dd") + "'" + "order by ID desc;";
list = DatabaseOp.ExecuteQuery <Patient>(sqlcomm);
return(list);
}
string sqlcommand = "select * from PATIENT where ";
TransferLikeParameteres(ref sqlcommand, "@", "and", condition, sqlcomm.Parameters);
sqlcommand = sqlcommand.Substring(0, sqlcommand.LastIndexOf("and"));
sqlcommand += " and REGISITDATE between '" + begin.ToString("yyyy-MM-dd") +
"' and '" + end.ToString("yyyy-MM-dd") + "'";
sqlcommand += " order by ID desc; ";
sqlcomm.CommandText = sqlcommand;
list = DatabaseOp.ExecuteQuery <Patient>(sqlcomm);
return(list);
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("ComplexDao.cs-SelectPatient", e);
return(list);
}
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="PatientGroup">Class instance of PatientGroup infomation</param>
/// <param name="scPatientGroupId">Id of the last insert row id</param>
/// <returns></returns>
public bool InsertPatientGroup(PatientGroup PatientGroup, ref int scId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"INSERT INTO PATIENTGROUP (NAME,DESCRIPTION,RESERVED) VALUES
(@NAME,@DESCRIPTION,@RESERVED) SET @ID = SCOPE_IDENTITY() ";
sqlcomm.Parameters.Add("@NAME", DbType.String);
if (PatientGroup.Name != null)
{
sqlcomm.Parameters["@NAME"].Value = PatientGroup.Name;
}
sqlcomm.Parameters.Add("@DESCRIPTION", DbType.String);
if (PatientGroup.Description != null)
{
sqlcomm.Parameters["@DESCRIPTION"].Value = PatientGroup.Description;
}
sqlcomm.Parameters.Add("@RESERVED", DbType.String);
if (PatientGroup.Reserved != null)
{
sqlcomm.Parameters["@RESERVED"].Value = PatientGroup.Reserved;
}
sqlcomm.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
scId = (int)sqlcomm.Parameters["@ID"].Value;
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("PatientGroupDao.cs-InsertPatientGroup", e);
return(false);
}
return(true);
}
public bool UpdateScheduleTemplate1(string fields, string condition, DateTime begin)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
string sqlcommand = "update SCHEDULETEMPLATE set BedId =";
sqlcommand += fields;
sqlcommand += " where BedId =";
sqlcommand += condition;
string str = " and Date >= '" + begin.Date.ToString("yyyy-MM-dd") + "' ";
sqlcommand += str;
sqlcomm.CommandText = sqlcommand;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("ScheduleTemplateDao.cs-UpdateScheduleTemplate", e);
return(false);
}
return(true);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="TreatTime">Class instance of infectType infomation</param>
/// <param name="scId">Id of the last insert row id</param>
/// <returns></returns>
public bool InsertTreatTime(TreatTime TreatTime, ref int scId)
{
try
{
using (SQLiteCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"INSERT INTO TREATTIME (NAME,ACTIVATED,BEGINTIME,ENDTIME,DESCRIPTION,RESERVED) VALUES
(@NAME,@ACTIVATED,@BEGINTIME,@ENDTIME,@DESCRIPTION,@RESERVED)";
sqlcomm.Parameters.Add("@NAME", DbType.String);
sqlcomm.Parameters["@NAME"].Value = TreatTime.Name;
sqlcomm.Parameters.Add("@ACTIVATED", DbType.Boolean);
sqlcomm.Parameters["@ACTIVATED"].Value = TreatTime.Activated;
sqlcomm.Parameters.Add("@DESCRIPTION", DbType.String);
sqlcomm.Parameters["@DESCRIPTION"].Value = TreatTime.Description;
sqlcomm.Parameters.Add("@BEGINTIME", DbType.String);
sqlcomm.Parameters["@BEGINTIME"].Value = TreatTime.BeginTime;
sqlcomm.Parameters.Add("@ENDTIME", DbType.String);
sqlcomm.Parameters["@ENDTIME"].Value = TreatTime.EndTime;
sqlcomm.Parameters.Add("@RESERVED", DbType.String);
sqlcomm.Parameters["@RESERVED"].Value = TreatTime.Reserved;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
//set last insert id of this table this connection
SQLiteCommand comm = SqlConn.CreateCommand();
comm.CommandText = "Select last_insert_rowid() as TREATTIME;";
scId = Convert.ToInt32(comm.ExecuteScalar());
comm.Dispose();
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("TreatTimeDao.cs-InsertTreatTime", e);
return(false);
}
return(true);
}
public bool UpdateScheduleTemplate(Dictionary <string, object> fields, Dictionary <string, object> condition)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
string sqlcommand = "update SCHEDULETEMPLATE set ";
var parameters = new Dictionary <string, object>();
DatabaseOp.TransferParameteres(ref sqlcommand, "@", ",", fields, sqlcomm.Parameters);
sqlcommand = sqlcommand.Substring(0, sqlcommand.LastIndexOf(","));
sqlcommand += " where ";
DatabaseOp.TransferParameteres(ref sqlcommand, "@", "and", condition, sqlcomm.Parameters);
sqlcommand = sqlcommand.Substring(0, sqlcommand.LastIndexOf("and"));
sqlcomm.CommandText = sqlcommand;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("ScheduleTemplateDao.cs-UpdateScheduleTemplate", e);
return(false);
}
return(true);
}
public List <Patient> SelectPatientSpecial(List <PatientGroupPara> listinParas)
{
var list = new List <Patient>();
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
string condition = string.Empty;
foreach (var patientGroupPara in listinParas)
{
//Key["感染情况"] = "INFECTTYPEID";
//Key["治疗状态"] = "TREATSTATUSID";
//Key["固定床位"] = "ISFIXEDBED";
//Key["所属分区"] = "AERAID";
if (patientGroupPara.Value.Contains("%"))
{
if (patientGroupPara.Key.Equals("所属分区"))
{
string value = string.Empty;
using (PatientAreaDao patientAreaDao = new PatientAreaDao())
{
Dictionary <string, object> con = new Dictionary <string, object>();
con["NAME"] = patientGroupPara.Value;
var li = patientAreaDao.SelectPatientArea(con);
value = li[0].Id.ToString();
}
condition += patientGroupPara.Left.Trim() + " " + MainWindow.Key[patientGroupPara.Key].Trim() + " " +
MainWindow.Symbol[patientGroupPara.Symbol].Trim() + " " + value.Trim() + " " +
patientGroupPara.Right.Trim() + " " + patientGroupPara.Logic.Trim();
}
else if (patientGroupPara.Key.Equals("治疗状态"))
{
string value = string.Empty;
using (TreatStatusDao treatStatusDao = new TreatStatusDao())
{
Dictionary <string, object> con = new Dictionary <string, object>();
con["NAME"] = patientGroupPara.Value;
var li = treatStatusDao.SelectTreatStatus(con);
value = li[0].Id.ToString();
}
condition += patientGroupPara.Left.Trim() + " " + MainWindow.Key[patientGroupPara.Key].Trim() + " " +
MainWindow.Symbol[patientGroupPara.Symbol].Trim() + " " + value.Trim() + " " +
patientGroupPara.Right.Trim() + " " + patientGroupPara.Logic.Trim();
}
else if (patientGroupPara.Key.Equals("感染情况"))
{
if (patientGroupPara.Value.Equals("阴性"))
{
condition += patientGroupPara.Left.Trim() + " " + MainWindow.Key[patientGroupPara.Key].Trim() + " " +
MainWindow.Symbol[patientGroupPara.Symbol].Trim() + " " + "0" + " " +
patientGroupPara.Right.Trim() + " " + patientGroupPara.Logic.Trim();
}
else
{
string value = string.Empty;
using (InfectTypeDao infectTypeDao = new InfectTypeDao())
{
Dictionary <string, object> con = new Dictionary <string, object>();
con["NAME"] = patientGroupPara.Value;
var li = infectTypeDao.SelectInfectType(con);
value = li[0].Id.ToString();
}
condition += patientGroupPara.Left.Trim() + " " + MainWindow.Key[patientGroupPara.Key].Trim() + " " +
MainWindow.Symbol[patientGroupPara.Symbol].Trim() + " " + value.Trim() + " " +
patientGroupPara.Right.Trim() + " " + patientGroupPara.Logic.Trim();
}
}
else if (patientGroupPara.Key.Equals("固定床位"))
{
condition += patientGroupPara.Left.Trim() + " " + MainWindow.Key[patientGroupPara.Key].Trim() + " " +
MainWindow.Symbol[patientGroupPara.Symbol].Trim() + " " + patientGroupPara.Value.Trim() + " " +
patientGroupPara.Right.Trim() + " " + patientGroupPara.Logic.Trim();
}
else
{
condition += patientGroupPara.Left.Trim() + " " + MainWindow.Key[patientGroupPara.Key].Trim() + " " +
MainWindow.Symbol[patientGroupPara.Symbol].Trim() + " \'" + patientGroupPara.Value.Trim() + "\' " +
patientGroupPara.Right.Trim() + " " + patientGroupPara.Logic.Trim();
}
}
else
{
if (patientGroupPara.Key.Equals("所属分区"))
{
string value = string.Empty;
using (PatientAreaDao patientAreaDao = new PatientAreaDao())
{
Dictionary <string, object> con = new Dictionary <string, object>();
con["NAME"] = patientGroupPara.Value;
var li = patientAreaDao.SelectPatientArea(con);
value = li[0].Id.ToString();
}
condition += patientGroupPara.Left.Trim() + " " +
MainWindow.Key[patientGroupPara.Key].Trim() + " " +
MainWindow.Symbol[patientGroupPara.Symbol].Trim() + " \'" +
value.Trim() + "\' " +
patientGroupPara.Right.Trim() + " " + patientGroupPara.Logic.Trim();
}
else if (patientGroupPara.Key.Equals("治疗状态"))
{
if (patientGroupPara.Value.Equals("在治"))
{
condition += patientGroupPara.Left.Trim() + " " +
MainWindow.Key[patientGroupPara.Key].Trim() + " " +
MainWindow.Symbol[patientGroupPara.Symbol].Trim() + " \'" +
"0" + "\' " +
patientGroupPara.Right.Trim() + " " + patientGroupPara.Logic.Trim();
}
else
{
string value = string.Empty;
using (TreatStatusDao treatStatusDao = new TreatStatusDao())
{
Dictionary <string, object> con = new Dictionary <string, object>();
con["NAME"] = patientGroupPara.Value;
var li = treatStatusDao.SelectTreatStatus(con);
value = li[0].Id.ToString();
}
condition += patientGroupPara.Left.Trim() + " " +
MainWindow.Key[patientGroupPara.Key].Trim() + " " +
MainWindow.Symbol[patientGroupPara.Symbol].Trim() + " \'" +
value.Trim() + "\' " +
patientGroupPara.Right.Trim() + " " + patientGroupPara.Logic.Trim();
}
}
else if (patientGroupPara.Key.Equals("感染情况"))
{
string value = string.Empty;
using (InfectTypeDao infectTypeDao = new InfectTypeDao())
{
Dictionary <string, object> con = new Dictionary <string, object>();
con["NAME"] = patientGroupPara.Value;
var li = infectTypeDao.SelectInfectType(con);
value = li[0].Id.ToString();
}
condition += patientGroupPara.Left.Trim() + " " +
MainWindow.Key[patientGroupPara.Key].Trim() + " " +
MainWindow.Symbol[patientGroupPara.Symbol].Trim() + " \'" +
value.Trim() + "\' " +
patientGroupPara.Right.Trim() + " " + patientGroupPara.Logic.Trim();
}
else if (patientGroupPara.Key.Equals("固定床位"))
{
condition += patientGroupPara.Left.Trim() + " " +
MainWindow.Key[patientGroupPara.Key].Trim() + " " +
MainWindow.Symbol[patientGroupPara.Symbol].Trim() + " \'" +
patientGroupPara.Value.Trim() + "\' " +
patientGroupPara.Right.Trim() + " " + patientGroupPara.Logic.Trim();
}
else
{
condition += patientGroupPara.Left.Trim() + " " +
MainWindow.Key[patientGroupPara.Key].Trim() + " " +
MainWindow.Symbol[patientGroupPara.Symbol].Trim() + " \'" +
patientGroupPara.Value.Trim() + "\' " +
patientGroupPara.Right.Trim() + " " + patientGroupPara.Logic.Trim();
}
}
}
string sqlcommand = "select * from PATIENT where ";
sqlcommand += condition;
sqlcommand += " order by Name asc";
sqlcomm.CommandText = sqlcommand;
list = DatabaseOp.ExecuteQuery <Patient>(sqlcomm);
return(list);
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("PatientDao.cs-SelectPatientSpecial", e);
return(list);
}
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="PatientGroupPara">Class instance of PatientGroupPara infomation</param>
/// <param name="scPatientGroupParaId">Id of the last insert row id</param>
/// <returns></returns>
public bool InsertPatientGroupPara(PatientGroupPara PatientGroupPara, ref int scId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"INSERT INTO PATIENTGROUPPARA (GROUPID,[LEFT],[KEY],SYMBOL,[VALUE],[RIGHT],LOGIC,DESCRIPTION,RESERVED) VALUES
(@GROUPID,@LEFT,@KEY,@SYMBOL,@VALUE,@RIGHT,@LOGIC,@DESCRIPTION,@RESERVED) SET @ID = SCOPE_IDENTITY() ";
sqlcomm.Parameters.Add("@GROUPID", DbType.Int64);
sqlcomm.Parameters["@GROUPID"].Value = PatientGroupPara.GroupId;
sqlcomm.Parameters.Add("@LEFT", DbType.String);
if (PatientGroupPara.Left != null)
{
sqlcomm.Parameters["@LEFT"].Value = PatientGroupPara.Left;
}
sqlcomm.Parameters.Add("@KEY", DbType.String);
if (PatientGroupPara.Key != null)
{
sqlcomm.Parameters["@KEY"].Value = PatientGroupPara.Key;
}
sqlcomm.Parameters.Add("@SYMBOL", DbType.String);
if (PatientGroupPara.Symbol != null)
{
sqlcomm.Parameters["@SYMBOL"].Value = PatientGroupPara.Symbol;
}
sqlcomm.Parameters.Add("@VALUE", DbType.String);
if (PatientGroupPara.Value != null)
{
sqlcomm.Parameters["@VALUE"].Value = PatientGroupPara.Value;
}
sqlcomm.Parameters.Add("@RIGHT", DbType.String);
if (PatientGroupPara.Right != null)
{
sqlcomm.Parameters["@RIGHT"].Value = PatientGroupPara.Right;
}
sqlcomm.Parameters.Add("@LOGIC", DbType.String);
if (PatientGroupPara.Logic != null)
{
sqlcomm.Parameters["@LOGIC"].Value = PatientGroupPara.Logic;
}
sqlcomm.Parameters.Add("@DESCRIPTION", DbType.String);
if (PatientGroupPara.Description != null)
{
sqlcomm.Parameters["@DESCRIPTION"].Value = PatientGroupPara.Description;
}
sqlcomm.Parameters.Add("@RESERVED", DbType.String);
if (PatientGroupPara.Reserved != null)
{
sqlcomm.Parameters["@RESERVED"].Value = PatientGroupPara.Reserved;
}
sqlcomm.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
scId = (int)sqlcomm.Parameters["@ID"].Value;
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("PatientGroupParaDao.cs-InsertPatientGroupPara", e);
return(false);
}
return(true);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="patient">Class instance of patient infomation</param>
/// <param name="scPatientId">Id of the last insert row id</param>
/// <returns></returns>
public bool InsertPatient(Patient patient, ref int scId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"INSERT INTO PATIENT (PATIENTID,NAME,DOB,GENDER,NATIONALITY,MARRIAGE,HEIGHT,BLOODTYPE,IDCODE, MOBILE, ORDERS, TREATSTATUSID,REGISITDATE,
AREAID,ZIPCODE,WEIXINHAO,PAYMENT,INFECTTYPEID,ISFIXEDBED,BEDID,ISASSIGNED,DESCRIPTION,RESERVED1,RESERVED2) VALUES
(@PATIENTID,@NAME,@DOB,@GENDER,@NATIONALITY,@MARRIAGE,@HEIGHT,@BLOODTYPE, @IDCODE, @MOBILE,@ORDERS,@TREATSTATUSID,@REGISITDATE,
@AREAID,@ZIPCODE,@WEIXINHAO,@PAYMENT,@INFECTTYPEID,@ISFIXEDBED,@BEDID,@ISASSIGNED,@DESCRIPTION,@RESERVED1,@RESERVED2) SET @ID = SCOPE_IDENTITY() ";
sqlcomm.Parameters.Add("@PATIENTID", DbType.String);
sqlcomm.Parameters["@PATIENTID"].Value = patient.PatientId;
sqlcomm.Parameters.Add("@NAME", DbType.String);
if (patient.Name != null)
{
sqlcomm.Parameters["@NAME"].Value = patient.Name;
}
sqlcomm.Parameters.Add("@GENDER", DbType.String);
if (patient.Gender != null)
{
sqlcomm.Parameters["@GENDER"].Value = patient.Gender;
}
sqlcomm.Parameters.Add("@DOB", DbType.String);
if (patient.Dob != null)
{
sqlcomm.Parameters["@DOB"].Value = patient.Dob;
}
sqlcomm.Parameters.Add("@NATIONALITY", DbType.String);
if (patient.Nationality != null)
{
sqlcomm.Parameters["@NATIONALITY"].Value = patient.Nationality;
}
sqlcomm.Parameters.Add("@MARRIAGE", DbType.String);
if (patient.Marriage != null)
{
sqlcomm.Parameters["@MARRIAGE"].Value = patient.Marriage;
}
sqlcomm.Parameters.Add("@HEIGHT", DbType.String);
if (patient.Height != null)
{
sqlcomm.Parameters["@HEIGHT"].Value = patient.Height;
}
sqlcomm.Parameters.Add("@BLOODTYPE", DbType.String);
if (patient.BloodType != null)
{
sqlcomm.Parameters["@BLOODTYPE"].Value = patient.BloodType;
}
sqlcomm.Parameters.Add("@IDCODE", DbType.String);
if (patient.IdCode != null)
{
sqlcomm.Parameters["@IDCODE"].Value = patient.IdCode;
}
sqlcomm.Parameters.Add("@MOBILE", DbType.String);
if (patient.Mobile != null)
{
sqlcomm.Parameters["@MOBILE"].Value = patient.Mobile;
}
sqlcomm.Parameters.Add("@ORDERS", DbType.String);
if (patient.Orders != null)
{
sqlcomm.Parameters["@ORDERS"].Value = patient.Orders;
}
sqlcomm.Parameters.Add("@TREATSTATUSID", DbType.Int32);
if (patient.TreatStatusId != null)
{
sqlcomm.Parameters["@TREATSTATUSID"].Value = patient.TreatStatusId;
}
sqlcomm.Parameters.Add("@REGISITDATE", DbType.String);
if (patient.RegisitDate != null)
{
sqlcomm.Parameters["@REGISITDATE"].Value = patient.RegisitDate;
}
sqlcomm.Parameters.Add("@AREAID", DbType.Int32);
if (patient.AreaId != null)
{
sqlcomm.Parameters["@AREAID"].Value = patient.AreaId;
}
sqlcomm.Parameters.Add("@ZIPCODE", DbType.String);
if (patient.ZipCode != null)
{
sqlcomm.Parameters["@ZIPCODE"].Value = patient.ZipCode;
}
sqlcomm.Parameters.Add("@WEIXINHAO", DbType.String);
if (patient.WeiXinHao != null)
{
sqlcomm.Parameters["@WEIXINHAO"].Value = patient.WeiXinHao;
}
sqlcomm.Parameters.Add("@PAYMENT", DbType.String);
if (patient.Payment != null)
{
sqlcomm.Parameters["@PAYMENT"].Value = patient.Payment;
}
sqlcomm.Parameters.Add("@INFECTTYPEID", DbType.Int32);
if (patient.InfectTypeId != null)
{
sqlcomm.Parameters["@INFECTTYPEID"].Value = patient.InfectTypeId;
}
sqlcomm.Parameters.Add("@ISFIXEDBED", DbType.Boolean);
if (patient.IsFixedBed != null)
{
sqlcomm.Parameters["@ISFIXEDBED"].Value = patient.IsFixedBed;
}
sqlcomm.Parameters.Add("@BEDID", DbType.Int32);
if (patient.BedId != null)
{
sqlcomm.Parameters["@BEDID"].Value = patient.BedId;
}
sqlcomm.Parameters.Add("@ISASSIGNED", DbType.Boolean);
if (patient.IsAssigned != null)
{
sqlcomm.Parameters["@ISASSIGNED"].Value = patient.IsAssigned;
}
sqlcomm.Parameters.Add("@DESCRIPTION", DbType.String);
if (patient.Description != null)
{
sqlcomm.Parameters["@DESCRIPTION"].Value = patient.Description;
}
sqlcomm.Parameters.Add("@RESERVED1", DbType.String);
if (patient.Reserved1 != null)
{
sqlcomm.Parameters["@RESERVED1"].Value = patient.Reserved1;
}
sqlcomm.Parameters.Add("@RESERVED2", DbType.String);
if (patient.Reserved2 != null)
{
sqlcomm.Parameters["@RESERVED2"].Value = patient.Reserved2;
}
sqlcomm.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
scId = (int)sqlcomm.Parameters["@ID"].Value;
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("PatientDao.cs-InsertPatient", e);
return(false);
}
return(true);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="medicalOrder">Class instance of Medical Order infomation</param>
/// <param name="scId">Id of the last insert row id</param>
/// <returns></returns>
public bool InsertMedicalOrder(MedicalOrder medicalOrder, ref int scId)
{
try
{
using (SqlCommand sqlcomm = SqlConn.CreateCommand())
{
sqlcomm.CommandText =
@"INSERT INTO MEDICALORDER ([PATIENTID],[ACTIVATED],[SEQ],[PLAN],[METHODID],[INTERVAL],[TIMES],
[DESCRIPTION],[RESERVED1],[RESERVED2]) VALUES
(@PATIENTID,@ACTIVATED,@SEQ,@PLAN,@METHODID,@INTERVAL,@TIMES,
@DESCRIPTION ,@RESERVED1,@RESERVED2) SET @ID = SCOPE_IDENTITY() ";
sqlcomm.Parameters.Add("@PATIENTID", DbType.Int32);
sqlcomm.Parameters["@PATIENTID"].Value = medicalOrder.PatientId;
sqlcomm.Parameters.Add("@ACTIVATED", DbType.Boolean);
sqlcomm.Parameters["@ACTIVATED"].Value = medicalOrder.Activated;
sqlcomm.Parameters.Add("@SEQ", DbType.String);
if (medicalOrder.Seq != null)
{
sqlcomm.Parameters["@SEQ"].Value = medicalOrder.Seq;
}
sqlcomm.Parameters.Add("@PLAN", DbType.String);
if (medicalOrder.Plan != null)
{
sqlcomm.Parameters["@PLAN"].Value = medicalOrder.Plan;
}
sqlcomm.Parameters.Add("@METHODID", DbType.Int32);
sqlcomm.Parameters["@METHODID"].Value = medicalOrder.MethodId;
sqlcomm.Parameters.Add("@INTERVAL", DbType.Int32);
sqlcomm.Parameters["@INTERVAL"].Value = medicalOrder.Interval;
sqlcomm.Parameters.Add("@TIMES", DbType.Int32);
sqlcomm.Parameters["@TIMES"].Value = medicalOrder.Times;
sqlcomm.Parameters.Add("@DESCRIPTION", DbType.String);
if (medicalOrder.Description != null)
{
sqlcomm.Parameters["@DESCRIPTION"].Value = medicalOrder.Description;
}
sqlcomm.Parameters.Add("@RESERVED1", DbType.String);
if (medicalOrder.Reserved1 != null)
{
sqlcomm.Parameters["@RESERVED1"].Value = medicalOrder.Reserved1;
}
sqlcomm.Parameters.Add("@RESERVED2", DbType.String);
if (medicalOrder.Reserved2 != null)
{
sqlcomm.Parameters["@RESERVED2"].Value = medicalOrder.Reserved2;
}
sqlcomm.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output;
DatabaseOp.ExecuteNoneQuery(sqlcomm);
scId = (int)sqlcomm.Parameters["@ID"].Value;
}
}
catch (Exception e)
{
MainWindow.Log.WriteErrorLog("MedicalOrderDao.cs-InsertMedicalOrder", e);
return(false);
}
return(true);
}
