internal CauseInvalidRequest(string msg)
{
@params = new ParamMap()
{
msg = msg
};
}
public List <T> FindBySql <T>(string strSql, int pageIndex, int pageSize, string order, bool desc) where T : new()
{
List <T> list = new List <T>();
IDataReader sdr = null;
try
{
strSql = strSql.ToLower();
String columns = SQLBuilderHelper.fetchColumns(strSql);
PropertyInfo[] properties = ReflectionHelper.GetProperties(new T().GetType());
TableInfo tableInfo = EntityHelper.GetTableInfo(new T(), DbOperateType.SELECT, properties);
strSql = SQLBuilderHelper.builderPageSQL(strSql, order, desc);
ParamMap param = ParamMap.newMap();
param.setPageIndex(pageIndex);
param.setPageSize(pageSize);
sdr = AdoHelper.ExecuteReader(AdoHelper.ConnectionString, CommandType.Text, strSql, param.toDbParameters());
list = EntityHelper.toList <T>(sdr, tableInfo, properties);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sdr != null)
{
sdr.Close();
}
}
return(list);
}
internal ActionRunCmd(string cmd, string id, object con)
{
@params = new ParamMap()
{
cmd = cmd, id = id, con = con
};
}
internal CauseRuncmdFeedback(string id, string cmd, string result, object con)
{
@params = new ParamMap()
{
id = id, cmd = cmd, result = result, con = con
};
}
internal CauseDecodeFailed(string msg)
{
@params = new ParamMap()
{
msg = msg
};
}
internal CauseLeft(string sender, string xuid, string uuid, string ip)
{
@params = new ParamMap()
{
sender = sender, xuid = xuid, uuid = uuid, ip = ip
};
}
internal CauseCmd(string sender, string text)
{
@params = new ParamMap()
{
sender = sender, text = text
};
}
public List <T> FindBySql <T>(string strSql, ParamMap param) where T : new()
{
List <T> list = new List <T>();
IDataReader sdr = null;
try
{
strSql = strSql.ToLower();
String columns = SQLBuilderHelper.fetchColumns(strSql);
PropertyInfo[] properties = ReflectionHelper.GetProperties(new T().GetType());
TableInfo tableInfo = EntityHelper.GetTableInfo(new T(), DbOperateType.SELECT, properties);
if (param.IsPage && !SQLBuilderHelper.isPage(strSql))
{
strSql = SQLBuilderHelper.builderPageSQL(strSql, param.OrderFields, param.IsDesc);
}
sdr = AdoHelper.ExecuteReader(AdoHelper.ConnectionString, CommandType.Text, strSql, param.toDbParameters());
list = EntityHelper.toList <T>(sdr, tableInfo, properties);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sdr != null)
{
sdr.Close();
}
}
return(list);
}
public int executeNonQuery(string sql, Hashtable param)
{
if (sql == null || sql == "")
{
return(-1);
}
ParamMap pm = null;
if (param != null && param.Count > 0)
{
pm = ParamMap.newMap();
foreach (DictionaryEntry v in param)
{
pm.Add(v.Key, v.Value);
}
}
Session ses = _poolSession;
if (pm == null)
{
ses.ExcuteSQL(sql);
}
else
{
ses.ExcuteSQL(sql, pm);
}
return(0);
}
public int ExcuteSQL(string strSQL, ParamMap param)
{
object val = 0;
IDbTransaction transaction = null;
IDbConnection connection = null;
try
{
//获取数据库连接，如果开启了事务，从事务中获取
connection = GetConnection();
{
connection = GetConnection();
IDbDataParameter[] parms = param.toDbParameters();
if (AdoHelper.DbType == DatabaseType.ACCESS)
{
strSQL = SQLBuilderHelper.builderAccessSQL(strSQL, parms);
val = AdoHelper.ExecuteNonQuery(connection, transaction, CommandType.Text, strSQL);
}
else
{
val = AdoHelper.ExecuteNonQuery(connection, transaction, CommandType.Text, strSQL, parms);
}
}
}
catch (Exception e)
{
DBLOG.error(strSQL, e);
}
return(Convert.ToInt32(val));
}
internal IInstruction Instruction(int opcode)
{
// Get instruction with params via opcode (etc: LD n, n)
// using maps in InstructionMap
Type type = InstructionMap.GetInstruction(opcode);
if (type != null)
{
// If instruction is found, create instruction instance as Instruction
var instruction = Activator.CreateInstance(type) as IInstruction;
// Assign opcode
instruction.Opcode = opcode;
// Fetch params using maps in ParamOneMap and ParamTwoMap
instruction.Params = ParamMap.GetParams(this, opcode);
// Fetch initial Ticks information
instruction.Ticks = TicksMap.Ticks[opcode];
// Return Instruction object
return(instruction);
}
// If no instruction is found, throw missing opcode exception
// TODO: Create Missing Opcode Exception, for now return null
return(null);
}
/// <summary>
/// 根据病历ID获取病历信息
/// </summary>
/// <param name="strDoctorGid"></param>
/// <param name="strPatientGid"></param>
/// <param name="strSickness"></param>
/// <returns></returns>
public TMedicHisDetailInfo GetMedicalHisDetail(String strDetailGid)
{
TMedicHisDetailInfo info = new TMedicHisDetailInfo();
String strSql = "SELECT * FROM T_Medical_HisDetail WHERE DETAIL_GID = @DETAIL_GID AND STATUS =1 ";
ParamMap param = ParamMap.newMap();
param.setParameter("DETAIL_GID", strDetailGid);
TMedicalHisDetail detail = DataBaseHelper.FindOne <TMedicalHisDetail>(strSql, param);
if (detail != null)
{
info.DetailGid = detail.DetailGid;
info.HisID = detail.HisID;
info.DetailTitle = detail.DetailTitle;
info.DetailDescribe = detail.DetailDescribe;
info.CreateUser = detail.CreateUser;
info.CreateTime = detail.CreateTime;
info.UpdateTime = detail.UpdateTime;
info.Status = detail.Status;
strSql = "select * from T_Medical_HisDetailPic where Detail_Gid=@Detail_Gid and status =1";
ParamMap paramDetail = ParamMap.newMap();
param.setParameter("Detail_Gid", strDetailGid);
info.PicList = DataBaseHelper.FindBySql <TMedicalHisDetailPic>(strSql, paramDetail);
return(info);
}
else
{
return(null);
}
}
/// <summary>
/// Проверка что параметр не пустой.
/// </summary>
/// <param name="p">объект параметра</param>
/// <returns>true если пустой</returns>
protected bool ParamIsEmpty(ParamMap p)
{
if (!p.Value.To <string>().EqIgnoreCase(ParamMap.NullValue))
{
return(false);
}
return(true);
}
/// <summary>
/// 手机号是否已经被医生注册
/// </summary>
/// <param name="phoneNumber"></param>
/// <returns></returns>
public Boolean IsPhoneExist(String phoneNumber)
{
String strSql = "select count(*) from T_Patient where phone=@myPhone ";
ParamMap param = ParamMap.newMap();
param.setParameter("myPhone", phoneNumber);
return(DataBaseHelper.IsExist(strSql, param));
}
/// <summary>
/// 通过医生的MID来查询医生信息
/// </summary>
/// <param name="doctorMID"></param>
/// <returns></returns>
public TDoctor GetDoctorByMID(String doctorMID)
{
String strSql = "select * from T_Doctor where DocotorMID=@DoctorMID";
ParamMap param = ParamMap.newMap();
param.setParameter("DoctorMID", doctorMID);
return(DataBaseHelper.FindOne <TDoctor>(strSql, param));
}
public bool UpdateUserAvatar(string userGID, string avatarAddr)
{
String strSql = @"update T_Patient set avatar=@avatar where patientGID=@patientGID";
ParamMap param = ParamMap.newMap();
param.setParameter("avatar", avatarAddr);
param.setParameter("PatientGID", userGID);
return(DataBaseHelper.ExcuteSQL(strSql, param) > 0 ? true : false);
}
public bool UpdateUserAvatar(string userGID, string avatarAddr)
{
String strSql = @"update T_Doctor SET Avatar=@Avatar where DoctorGID=@DoctorGID";
ParamMap param = ParamMap.newMap();
param.setParameter("Avatar", avatarAddr);
param.setParameter("DoctorGID", userGID);
return(DataBaseHelper.ExcuteSQL(strSql, param) > 0 ? true : false);
}
/// <summary>
/// 短信注册验证信息是否存在
/// </summary>
/// <param name="smsValidType"></param>
/// <param name="phone"></param>
/// <returns></returns>
private TSmsValid GetSmsValidInfo(SmsValidType smsValidType, String phone)
{
String strSql = @" select * from t_smsvalid where validtype=@validType and phone=@phone ";
ParamMap param = ParamMap.newMap();
param.setParameter("validType", (int)smsValidType);
param.setParameter("phone", phone);
return(DataBaseHelper.FindOne <TSmsValid>(strSql, param));
}
public Boolean UpdatePassword(String gid, String newPassword)
{
String strSql = @"update T_Patient set password=@Password where PatientGID=@PatientGID";
ParamMap param = ParamMap.newMap();
param.setParameter("Password", SecurityService.PasswordEncrypt(newPassword));
param.setParameter("PatientGID", gid);
return(DataBaseHelper.ExcuteSQL(strSql, param) > 0 ? true : false);
}
/// <summary>
/// 通过GID来获取患者信息
/// </summary>
/// <param name="gid"></param>
/// <returns></returns>
public TPatient GetPatientByGID(String gid)
{
String passwordEncrypt = SecurityService.PasswordEncrypt(gid);
String strSql = "select * from T_Patient where patientgid=@patientgid";
ParamMap param = ParamMap.newMap();
param.setParameter("patientgid", gid);
return(DataBaseHelper.FindOne <TPatient>(strSql, param));
}
/// <summary>
/// 病历夹是否存在
/// </summary>
/// <param name="strDoctorGid"></param>
/// <param name="strPatientGid"></param>
/// <param name="strSickness"></param>
/// <returns></returns>
public Boolean IsHisExist(String strDoctorGid, String strPatientGid, String strSickness)
{
String strSql = "select count(*) from T_MEDICAL_HIS where where Doctor_ID = @Doctor_ID AND Patient_ID = @Patient_ID AND Sickness =@Sickness ";
ParamMap param = ParamMap.newMap();
param.setParameter("Doctor_ID", strDoctorGid);
param.setParameter("Patient_ID", strPatientGid);
param.setParameter("Sickness", strSickness);
return(DataBaseHelper.IsExist(strSql, param));
}
/// <summary>
/// 通过手机号和密码查找病人
/// </summary>
/// <param name="phoneNumber"></param>
/// <param name="password"></param>
/// <returns></returns>
public TPatient GetPatientByPhone(String phoneNumber, String password)
{
String passwordEncrypt = SecurityService.PasswordEncrypt(password);
String strSql = "select * from T_Patient where phone=@myPhone and password=@password ";
ParamMap param = ParamMap.newMap();
param.setParameter("myPhone", phoneNumber);
param.setParameter("password", passwordEncrypt);
return(DataBaseHelper.FindOne <TPatient>(strSql, param));
}
public object GetSingleParam(string key)
{
if (ParamMap != null)
{
ParamMap.TryGetValue(key, out var val);
return(val);
}
return(null);
}
/// <summary>
/// 根据医生ID（和病人ID）获取病历夹记录
/// </summary>
/// <param name="strDoctorGid"></param>
/// <param name="strPatientGid"></param>
/// <param name="strSickness"></param>
/// <returns></returns>
public List <TMedicalHisExtend> GetMedicalHis(String strDoctorGid)
{
String strSql = "SELECT A.*, B.PatientName, b.sex AS PatientSex, B.Age AS PatientAge " +
"FROM T_MEDICAL_HIS A LEFT JOIN T_PATIENT B ON A.PATIENT_ID = B.PatientGID " +
" where A.STATUS = 1 AND A.Doctor_ID = @Doctor_ID ";
ParamMap param = ParamMap.newMap();
param.setParameter("Doctor_ID", strDoctorGid);
return(DataBaseHelper.FindBySql <TMedicalHisExtend>(strSql, param));
}
/// <summary>
/// 短信注册验证信息是否存在
/// </summary>
/// <param name="smsValidType"></param>
/// <param name="validStatus"></param>
/// <param name="phone"></param>
/// <returns></returns>
private Boolean IsSmsValidExist(SmsValidType smsValidType, ValidStatus validStatus, String phone)
{
String strSql = @" select * from t_smsvalid where validtype=@validType and ValidStatus=@ValidStatus and phone=@phone ";
ParamMap param = ParamMap.newMap();
param.setParameter("validType", (int)smsValidType);
param.setParameter("ValidStatus", (int)validStatus);
param.setParameter("phone", phone);
return(DataBaseHelper.IsExist(strSql, param));
}
/// <summary>
/// 根据医生ID（和病人ID）获取病历夹记录
/// </summary>
/// <param name="strDoctorGid"></param>
/// <param name="strPatientGid"></param>
/// <param name="strSickness"></param>
/// <returns></returns>
public TMedicalHis GetMedicalHisInfo(String strMedicalHisGid)
{
String strSql = "SELECT * " +
"FROM T_MEDICAL_HIS " +
" where STATUS = 1 AND His_Gid = @His_Gid ";
ParamMap param = ParamMap.newMap();
param.setParameter("His_Gid", strMedicalHisGid);
return(DataBaseHelper.FindOne <TMedicalHis>(strSql, param));
}
public PageResult <T> FindPage <T>(string strSQL, ParamMap param) where T : new()
{
PageResult <T> pageResult = new PageResult <T>();
List <T> list = new List <T>();
IDataReader sdr = null;
IDbConnection connection = null;
try
{
connection = GetConnection();
bool closeConnection = GetWillConnectionState();
strSQL = strSQL.ToLower();
String countSQL = SQLBuilderHelper.builderCountSQL(strSQL);
String columns = SQLBuilderHelper.fetchColumns(strSQL);
T entity = new T();
PropertyInfo[] properties = ReflectionHelper.GetProperties(entity.GetType());
TableInfo tableInfo = EntityHelper.GetTableInfo(entity, DbOperateType.SELECT, properties);
if (param.IsPage && !SQLBuilderHelper.isPage(strSQL))
{
strSQL = SQLBuilderHelper.builderPageSQL(strSQL, param.OrderFields, param.IsDesc);
}
if (AdoHelper.DbType == DatabaseType.ACCESS)
{
strSQL = SQLBuilderHelper.builderAccessSQL(strSQL, param.toDbParameters());
sdr = AdoHelper.ExecuteReader(closeConnection, connection, CommandType.Text, strSQL);
}
else
{
sdr = AdoHelper.ExecuteReader(closeConnection, connection, CommandType.Text, strSQL, param.toDbParameters());
}
int count = this.Count(countSQL, param);
list = EntityHelper.toList <T>(sdr, tableInfo, properties);
pageResult.Total = count;
pageResult.DataList = list;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sdr != null)
{
sdr.Close();
}
}
return(pageResult);
}
/// <summary>
/// 获取更新升级
/// </summary>
/// <param name="type"></param>
/// <param name="versionCode"></param>
/// <returns></returns>
public TAppUpgradeInfo GetUpgradeInfo(AppOSType type, float versionCode)
{
String strSql = "select * from t_appupgradeinfo where ostype=@ostype and ispublish=@ispublish and status=@status and versioncode>@versioncode order by versioncode desc";
ParamMap param = ParamMap.newMap();
param.setParameter("ostype", (int)type);
param.setParameter("ispublish", (int)Status.Enable);
param.setParameter("status", (int)Status.Enable);
param.setParameter("versioncode", versionCode);
return(DataBaseHelper.FindOne <TAppUpgradeInfo>(strSql, param));
}
/// <summary>
/// 删除病历
/// </summary>
/// <param name="templateId"></param>
/// <returns></returns>
public Boolean DeleteDetailByGId(String strDetailGid)
{
//开启事务
DataBaseHelper.BeginTransaction();
try
{
//查询模版动作信息
String strSql1 = "select * from T_Medical_HisDetail where Detail_Gid=@Detail_Gid and status = 1";
ParamMap param = ParamMap.newMap();
param.setParameter("Detail_Gid", strDetailGid);
List <TMedicalHisDetail> ttem = DataBaseHelper.FindBySql <TMedicalHisDetail>(strSql1, param);
strSql1 = "select * from T_Medical_HisDetailPic where Detail_Gid=@Detail_Gid and status =1";
ParamMap paramDetail = ParamMap.newMap();
paramDetail.setParameter("Detail_Gid", strDetailGid);
List <TMedicalHisDetailPic> lstDetailPic = DataBaseHelper.FindBySql <TMedicalHisDetailPic>(strSql1, paramDetail);
if (lstDetailPic != null && lstDetailPic.Count > 0)
{
List <String> lstDeletePic = new List <string>();
String strPicUrl = "";
foreach (TMedicalHisDetailPic mhp in lstDetailPic)
{
strPicUrl = "";
strPicUrl = mhp.PicUrl;
if (strPicUrl.Trim() != "")
{
lstDeletePic.Add(strPicUrl.Trim());
}
}
Zelo.Common.Common.ImageSave.DeletePic(lstDeletePic);
}
//Update(ttem);
DataBaseHelper.Remove(lstDetailPic);
//Update(ttem);
DataBaseHelper.Remove(ttem);
//提交事务
DataBaseHelper.CommitTransaction();
return(true);
}
catch
{
//事务回滚
DataBaseHelper.RollbackTransaction();
return(false);
}
}
/// <summary>
/// 插入或者更新token信息
/// </summary>
/// <param name="tokenType"></param>
/// <param name="ownerGID"></param>
/// <param name="tokenContent"></param>
/// <returns>成功，则返回token信息</returns>
public ServiceResult InsertOrUpdateToken(TokenType tokenType, String ownerGID)
{
//是否存在token
//不存在，插入
//存在，更新
String strSql = @"select * from dbo.T_usertoken where tokenType=@tokenType and tokenownergid=@ownerGID ";
ParamMap param = ParamMap.newMap();
param.setParameter("tokenType", (int)tokenType);
param.setParameter("ownerGID", ownerGID);
TUserToken token = DataBaseHelper.FindOne <TUserToken>(strSql, param);
if (token == null)
{
String guid = Guid.NewGuid().ToString();
//插入token
if (InsertToken(tokenType, ownerGID, guid))
{
return(ServiceResult.CreateInstance(true, guid));
}
else
{
return(ServiceResult.CreateInstance(false, "服务器错误：插入登录令牌错误"));
}
}
else
{
if (token.Status != (int)Status.Enable)
{
return(ServiceResult.CreateInstance(false, "登录令牌已禁用"));
}
//更新
token.StartTime = DateTime.Now;
token.EndTime = DateTime.Now.AddDays(7);
token.TokenContent = Guid.NewGuid().ToString();
if (DataBaseHelper.Update <TUserToken>(token) > 0)
{
return(ServiceResult.CreateInstance(true, token.TokenContent));
}
else
{
return(ServiceResult.CreateInstance(false, "服务器错误：更新令牌信息"));
}
}
}
