/// <summary> /// 获取电话号码 add by tangcy /// </summary> /// <param name="usename"> 用户姓名</param> /// <returns></returns> public DataSet GetAllUserMobileNo(string usename) { dal = new Tcs.Libary.DataAccess(); dal.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString2"].ToString(); dal.CreateConnection(); StringBuilder sb = new StringBuilder(); sb.AppendFormat("select MobileNo from Sys_Operator where UserName = '******'", usename); return dal.GetDataSet(sb.ToString()); }
/// <summary> /// 获取平台中所有接收人员名称和编号 /// </summary> /// <returns></returns> public DataSet GetAllUserName() { dal = new Tcs.Libary.DataAccess(); dal.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString2"].ToString(); dal.CreateConnection(); StringBuilder sb = new StringBuilder(); sb.Append("select UserName,UserCode from Sys_Operator"); return dal.GetDataSet(sb.ToString()); }