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, "服务器错误:更新令牌信息")); } } }