/// <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());
}