//
public dynamic GetModel(int Id)
{
try
{
dynamic model = null;
StringBuilder strSql = new StringBuilder();
strSql.Append(" select Id,StandardModeName,Editor,CreateDate from T_StandardMode ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
using (dynamic read = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters))
{
model = new StandardMode();
if (read.Read())
{
try { model.Id = int.Parse(read["Id"].ToString()); }
catch { }
model.StandardModeName = read["StandardModeName"].ToString();
model.Editor = read["Editor"].ToString();
try { model.CreateDate = DateTime.Parse(read["CreateDate"].ToString()); }
catch { }
}
read.Dispose();
}
return(model);
}
catch { throw; }
}
public SqlDataReader GetSurveyTable()
{
string TabelName = " " + prefix + "SurveyTable ";
StringBuilder sql = new StringBuilder("SELECT MAX(SID) FROM" + TabelName, 200);
return(DbHelperSQL.ExecuteReader(ConvertHelper.ConvertString(sql)));
}
public SqlDataReader GetLanTable()
{
string TabelName = " " + prefix + "LanTable ";
StringBuilder sql = new StringBuilder("SELECT ID,JS,CSharp FROM" + TabelName, 50);
return(DbHelperSQL.ExecuteReader(ConvertHelper.ConvertString(sql)));
}
/// <summary>
/// 登入
/// </summary>
/// <param name="kls_uid"></param>
/// <param name="kls_pwd"></param>
/// <param name="kls_num"></param>
/// <returns></returns>
public string Existslongin(string uname, string upwd)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * FROM [OA_User]");
strSql.Append(" where uname=@uname and upwd=@upwd");
SqlParameter[] parameters =
{
new SqlParameter("@uname", SqlDbType.VarChar, 50),
new SqlParameter("@upwd", SqlDbType.VarChar, 250)
};
parameters[0].Value = uname;
parameters[1].Value = upwd;
//return DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters);
string uid = "";
if (dr.Read())
{
uid = dr["Uid"].ToString();
}
return(uid);
}
protected void Button1_Click(object sender, System.EventArgs e)
{
if (Request["UserName"].ToString().Trim() == "" || Request["Pwd"].ToString().Trim() == "")
{
X.Msg.Alert("提示", "用户名或密码不能为空！").Show();
}
else
{
//ArrayList userinfo = new ArrayList();
//userinfo.Add(Request["UserName"].ToString());
//userinfo.Add(Request["Pwd"].ToString());
//User_Contrl Ulogin = new User_Contrl();
//IDataReader Rs=Ulogin.User_Login(userinfo);
string strSQL = "select * from UserInfor where userName='******' and userPass='******'";
IDataReader Rs = DbHelperSQL.ExecuteReader(2, strSQL);
if (Rs.Read())
{
userinfo model = new userinfo();
//DataTable dt = DbHelperSQL.FindByConditions(2, model, "username='******'");
//string sql;
string sql = "SELECT UserID,userName,userPass as password,roleid,Telephone,Adress as address,eMail,logintime,RegisterTime as createtime from UserInfor WHERE userName='******'";
DataTable dt = DbHelperSQL.FindTable(2, sql);
userinfo user = Common <userinfo> .Dt2Model(model, dt);
//======================================================================
HttpCookie mycookie = new HttpCookie("Userinfo");
mycookie["role"] = Rs["roleid"].ToString().Trim();
mycookie["UserID"] = user.userid.ToString();
mycookie["Username"] = user.username;
mycookie["yhzcm"] = Rs["userPass"].ToString();
mycookie["userpwd"] = Rs["userPass"].ToString();
//mycookie["qx"]=Rs["privilege"].ToString();
//mycookie["cg"]=Rs["isAdmin"].ToString();
//mycookie["bmbm"]=Rs["bmbm"].ToString();
//mycookie["bmnr"]=Rs["bmnr"].ToString();
mycookie.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(mycookie);
sql = "UPDATE UserInfor SET logintime=getdate() where userName='******'";
//在数据库CloudMDB的表UserInfor的[logintime]字段中记录当前用户登录时间
DbHelperSQL.ExecuteSql(2, sql);
Rs.Close();
Rs.Dispose();
//Response.Redirect("main.htm");
Response.Redirect("main.aspx");
}
else
{
Rs.Close();
Rs.Dispose();
X.Msg.Alert("提示", "用户名或密码错误！").Show();
//Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language=javascript> window.alert('用户名或密码错误！');</script>");
//Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='text/javascript'>alert('用户名或密码错误！');return false;</script>");
//ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('用户名或密码错误！');</script>");
//RegisterClientScriptBlock("", "<script>alert('提示语')</script>");
//Response.Write("<script>alert('用户名或密码错误！')</script>");
//Response.Redirect("admin/msg.aspx?msg=密码或则用户名出错！请仔细检查！");
}
}
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="adminLogName"></param>
/// <param name="adminLogPass"></param>
/// <returns></returns>
public dynamic UserLogin(string LoginName, string LoginPass)
{
try
{
string strSql = string.Format(" select top 1 Id,LoginName,LoginPass,UserName,UserTel,UserEmail,UserStatus,LoginDate,LoginnNum,OutDate,Veri,MemberTypeId,VeriName,VeriSex,VeriIDCard,VeriIDCardScan,OrgCode,VeriAddress,VeriTel,VeriCorporate,VeriCorporateIDCard,VeriCorporateIDCardScan,VeriCreditCode,VeriCreditCodeScan,VeriStatus,AuditType,VeriCheckName,VeriApplyDate,VeriCheckDate from T_WebUserVeri where LoginName='{0}' and LoginPass='******'", LoginName, LoginPass);
dynamic model = null;
using (dynamic read = DbHelperSQL.ExecuteReader(strSql))
{
if (read.Read())
{
model = new WebUserVeri();
try { model.Id = int.Parse(read["Id"].ToString()); }
catch { }
model.LoginName = read["LoginName"].ToString();
model.LoginPass = read["LoginPass"].ToString();
model.UserName = read["UserName"].ToString();
model.UserTel = read["UserTel"].ToString();
model.UserEmail = read["UserEmail"].ToString();
try { model.UserStatus = int.Parse(read["UserStatus"].ToString()); }
catch { }
try { model.LoginDate = DateTime.Parse(read["LoginDate"].ToString()); }
catch { }
try { model.LoginnNum = int.Parse(read["LoginnNum"].ToString()); }
catch { }
try { model.OutDate = DateTime.Parse(read["OutDate"].ToString()); }
catch { }
try { model.Veri = int.Parse(read["Veri"].ToString()); }
catch { }
try { model.MemberTypeId = int.Parse(read["MemberTypeId"].ToString()); }
catch { }
model.VeriName = read["VeriName"].ToString();
model.VeriSex = read["VeriSex"].ToString();
model.VeriIDCard = read["VeriIDCard"].ToString();
model.VeriIDCardScan = read["VeriIDCardScan"].ToString();
model.OrgCode = read["OrgCode"].ToString();
model.VeriAddress = read["VeriAddress"].ToString();
model.VeriTel = read["VeriTel"].ToString();
model.VeriCorporate = read["VeriCorporate"].ToString();
model.VeriCorporateIDCard = read["VeriCorporateIDCard"].ToString();
model.VeriCorporateIDCardScan = read["VeriCorporateIDCardScan"].ToString();
model.VeriCreditCode = read["VeriCreditCode"].ToString();
model.VeriCreditCodeScan = read["VeriCreditCodeScan"].ToString();
try { model.VeriStatus = int.Parse(read["VeriStatus"].ToString()); }
catch { }
try { model.AuditType = int.Parse(read["AuditType"].ToString()); }
catch { }
model.VeriCheckName = read["VeriCheckName"].ToString();
try { model.VeriApplyDate = DateTime.Parse(read["VeriApplyDate"].ToString()); }
catch { }
try { model.VeriCheckDate = DateTime.Parse(read["VeriCheckDate"].ToString()); }
catch { }
}
read.Dispose();
}
return(model);
}
catch { throw; }
}
//
public dynamic GetModel(int id)
{
try
{
TranProcess model = null;
string strSql = string.Format(" select Id,FK_BidId,AcceptDate,AcceptName,AcceptSay,AcceptSayDate,AuditDate,AuditName,AuditSay,AuditSayDate,TradingDate,TradingName,TradingSay,TradingSayDate,AttestationDate,AttestationName,AttestationSay,AttestationSayDate,HeadDate,HeadName,HeadSay,HeadSayDate,SuperDate,SuperName,SuperSay,SuperSayDate FROM T_TranProcess where FK_BidId ={0}", id);
using (dynamic read = DbHelperSQL.ExecuteReader(strSql))
{
model = new TranProcess();
if (read.Read())
{
try { model.Id = int.Parse(read["Id"].ToString()); }
catch { }
try { model.FK_BidId = int.Parse(read["FK_BidId"].ToString()); }
catch { }
try { model.AcceptDate = DateTime.Parse(read["AcceptDate"].ToString()); }
catch { }
model.AcceptName = read["AcceptName"].ToString();
model.AcceptSay = read["AcceptSay"].ToString();
try { model.AcceptSayDate = DateTime.Parse(read["AcceptSayDate"].ToString()); }
catch { }
try { model.AuditDate = DateTime.Parse(read["AuditDate"].ToString()); }
catch { }
model.AuditName = read["AuditName"].ToString();
model.AuditSay = read["AuditSay"].ToString();
try { model.AuditSayDate = DateTime.Parse(read["AuditSayDate"].ToString()); }
catch { }
try { model.TradingDate = DateTime.Parse(read["TradingDate"].ToString()); }
catch { }
model.TradingName = read["TradingName"].ToString();
model.TradingSay = read["TradingSay"].ToString();
try { model.TradingSayDate = DateTime.Parse(read["TradingSayDate"].ToString()); }
catch { }
try { model.AttestationDate = DateTime.Parse(read["AttestationDate"].ToString()); }
catch { }
model.AttestationName = read["AttestationName"].ToString();
model.AttestationSay = read["AttestationSay"].ToString();
try { model.AttestationSayDate = DateTime.Parse(read["AttestationSayDate"].ToString()); }
catch { }
try { model.HeadDate = DateTime.Parse(read["HeadDate"].ToString()); }
catch { }
model.HeadName = read["HeadName"].ToString();
model.HeadSay = read["HeadSay"].ToString();
try { model.HeadSayDate = DateTime.Parse(read["HeadSayDate"].ToString()); }
catch { }
try { model.SuperDate = DateTime.Parse(read["SuperDate"].ToString()); }
catch { }
model.SuperName = read["SuperName"].ToString();
model.SuperSay = read["SuperSay"].ToString();
try { model.SuperSayDate = DateTime.Parse(read["SuperSayDate"].ToString()); }
catch { }
}
read.Dispose();
}
return(model);
}
catch { throw; }
}
public static String getPartTimeList(String area, String condition, int page, int pageSize)
{
String json = String.Empty;
try
{
List <Job> jobList = new List <Job>();
String sql = String.Empty;
if (String.IsNullOrEmpty(area) && String.IsNullOrEmpty(condition))
{
//sql = "select * from Job a,Dict_Item b where a.Job_Address=b.Dict_Item_Value order by Job_Id offset " + (page - 1) * pageSize + " rows fetch next " + page * pageSize + " rows only";
sql = "select * from Job a,Dict_Item b where a.Job_Address=b.Dict_Item_Value order by job_Id";
}
else if (!String.IsNullOrEmpty(area) && String.IsNullOrEmpty(condition))
{
//sql = "select * from Job a,Dict_Item b where a.Job_Address=b.Dict_Item_Value and a.Job_Address='" + area + "' order by Job_Id offset " + (page - 1) * pageSize + " rows fetch next " + page * pageSize + " rows only";
sql = "select * from Job a,Dict_Item b where a.Job_Address=b.Dict_Item_Value and a.Job_Address='" + area + "' order by Job_Id ";
}
else if (String.IsNullOrEmpty(area) && !String.IsNullOrEmpty(condition))
{
//sql = "select * from Job a,Dict_Item b where a.Job_Address=b.Dict_Item_Value and a.Job_Type='" + condition + "' order by Job_Id offset " + (page - 1) * pageSize + " rows fetch next " + page * pageSize + " rows only";
sql = "select * from Job a,Dict_Item b where a.Job_Address=b.Dict_Item_Value and a.Job_Type='" + condition + "' order by Job_Id";
}
else
{
//sql = "select * from Job a,Dict_Item b where a.Job_Address=b.Dict_Item_Value and a.Job_Address='" + area + "' and a.Job_Type='" + condition + "' order by Job_Id offset " + (page - 1) * pageSize + " rows fetch next " + page * pageSize + " rows only";
sql = "select * from Job a,Dict_Item b where a.Job_Address=b.Dict_Item_Value and a.Job_Address='" + area + "' and a.Job_Type='" + condition + "' order by Job_Id";
}
using (SqlDataReader list = DbHelperSQL.ExecuteReader(sql))
{
while (list.Read())
{
Job job = new Job();
job.JobId = (int)list["Job_Id"];
job.UserId = (int)list["User_Id"];
job.WxId = list["Wx_id"].ToString();
job.JobTitle = list["Job_Title"].ToString();
job.JobMoney = list["Job_Money"].ToString();
job.JobAddress = list["Dict_Item_Name"].ToString();
job.JobTime = list["Job_time"].ToString();
job.JobPeopleNum = (int)list["Job_PeopleNum"];
job.JobBrowseNum = (int)list["Job_BrowseNum"];
job.JobStartDate = list["Job_StartDate"].ToString();
job.JobWorkDate = list["Job_WorkDate"].ToString();
job.JobCondition = list["Job_Condition"].ToString();
job.JobContent = list["Job_Content"].ToString();
jobList.Add(job);
}
}
json = JsonConvert.SerializeObject(jobList);
}
catch (Exception ex)
{
}
return(json);
}
public SqlDataReader GetSurveyExpand(string SID)
{
string TabelName = " " + prefix + "SurveyExpand ";
StringBuilder sql = new StringBuilder("SELECT ExpandContent,ExpandType FROM" + TabelName + "WHERE SID=@SID AND ExpandType IN(0,1,8,9)", 50);
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@SID", SID);
return(DbHelperSQL.ExecuteReader(ConvertHelper.ConvertString(sql), parameters));
}
public SqlDataReader GetItemTable(string SID)
{
string TabelName = " " + prefix + "ItemTable ";
StringBuilder sql = new StringBuilder("select IID, UID, SID, PageNo, ItemName, ItemType, DataFormatCheck, ItemContent, Sort, ItemHTML, OptionAmount, ParentID, StyleMode, OrderModel, OtherProperty, Logic, StatAmount, OptionImgModel, ChildID From" + TabelName + " where ParentID=0 and SID=@SID order by PageNo asc,Sort asc ", 50);
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@SID", SID);
return(DbHelperSQL.ExecuteReader(ConvertHelper.ConvertString(sql), parameters));
}
public SqlDataReader GetIP(string sSubmitIP)
{
string TabelName = " " + prefix + "IP ";
StringBuilder sql = new StringBuilder("SELECT TOP 1 Province,City FROM" + TabelName + " WHERE @sSubmitIP >=StartIP AND @sSubmitIP <=EndIP", 50);
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@sSubmitIP", sSubmitIP);
return(DbHelperSQL.ExecuteReader(ConvertHelper.ConvertString(sql), parameters));
}
public SqlDataReader GetPageStyle(string PageType)
{
string TabelName = " " + prefix + "PageStyle ";
StringBuilder sql = new StringBuilder("SELECT P_ID,PageFileName,StyleName,PageType,PageImage FROM" + TabelName + "WHERE PageType=@PageType ORDER BY ID DESC", 200);
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@PageType", PageType);
return(DbHelperSQL.ExecuteReader(ConvertHelper.ConvertString(sql), parameters));
}
/// <summary>
/// 获取泛型数据列表
/// </summary>
public List<Model.IMG_LAYOUT_RESULT> GetList()
{
StringBuilder strSql = new StringBuilder("SELECT * FROM LHF.IMG_LAYOUT_RESULT");
using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
List<Model.IMG_LAYOUT_RESULT> lst = GetList(dr);
return lst;
}
}
public SqlDataReader GetParBySysBaseInfo(string ParName)
{
string TabelName = " " + prefix + "SysBaseInfo ";
StringBuilder sql = new StringBuilder("SELECT TOP 1 Par FROM " + TabelName + "WHERE ParName=@ParName", 50);
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@ParName", ParName);
return(DbHelperSQL.ExecuteReader(ConvertHelper.ConvertString(sql), parameters));
}
public SqlDataReader GetAllStyleLib(string ID)
{
string TabelName = " " + prefix + "StyleLib ";
StringBuilder sql = new StringBuilder("SELECT * FROM " + TabelName + "WHERE ID=@ID", 50);
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@ID", ID);
return(DbHelperSQL.ExecuteReader(ConvertHelper.ConvertString(sql), parameters));
}
public SqlDataReader GetSurveyTable(string SID)
{
string TabelName = " " + prefix + "SurveyTable ";
StringBuilder sql = new StringBuilder("SELECT TOP 1 Temppage FROM" + TabelName + "WHERE SID=@SID", 50);
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@SID", SID);
return(DbHelperSQL.ExecuteReader(ConvertHelper.ConvertString(sql), parameters));
}
public SqlDataReader GetSurveyExpand(string SID) //防重复答卷
{
string TabelName = " " + prefix + "SurveyExpand ";
StringBuilder sql = new StringBuilder("SELECT ExpandType,ExpandContent FROM " + TabelName + "where SID=@SID AND (ExpandType IN (2,3,4))", 100);
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@SID", SID);
return(DbHelperSQL.ExecuteReader(ConvertHelper.ConvertString(sql), parameters));
}
public SqlDataReader GetItemTable(string SID) //防重复答卷
{
string TabelName = " " + prefix + "ItemTable ";
StringBuilder sql = new StringBuilder("SELECT IID,ItemType,OptionAmount,ParentID,DataFormatCheck FROM " + TabelName + "where SID=@SID ORDER BY PageNo,Sort", 100);
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@SID", SID);
return(DbHelperSQL.ExecuteReader(ConvertHelper.ConvertString(sql), parameters));
}
public SqlDataReader GetOptionTable(string SID) //防重复答卷
{
string TabelName = " " + prefix + "OptionTable ";
StringBuilder sql = new StringBuilder("SELECT OID,IID FROM " + TabelName + "where SID=@SID", 100);
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@SID", SID);
return(DbHelperSQL.ExecuteReader(ConvertHelper.ConvertString(sql), parameters));
}
public SqlDataReader GetAnswerInfo(string SID) //获取答卷总数
{
string TabelName = " " + prefix + "AnswerInfo ";
StringBuilder sql = new StringBuilder("SELECT COUNT(1) FROM " + TabelName + "where SID=@SID", 100);
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@SID", SID);
return(DbHelperSQL.ExecuteReader(ConvertHelper.ConvertString(sql), parameters));
}
public SqlDataReader GetHuiYuan_Point(string HuiYuanGuid) //防重复答卷
{
string TabelName = " " + prefix + "HuiYuan_Point ";
StringBuilder sql = new StringBuilder("SELECT TOP 1 TotalPoint FROM" + TabelName + "WHERE HuiYuanGuid=@HuiYuanGuid", 100);
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@HuiYuanGuid", HuiYuanGuid);
return(DbHelperSQL.ExecuteReader(ConvertHelper.ConvertString(sql), parameters));
}
public T GetById <T>(string idname, int id) where T : class, new()
{
string tablename = typeof(T).Name;
SqlDataReader reader = DbHelperSQL.ExecuteReader(string.Format("select * from [{0}] where {2} = {1}", tablename, id, idname));
List <T> ls = BuildTByDataReader <T>(reader);
T t = ls.Count == 0 ? null : ls[0];
return(t);
}
/// <summary>
/// 获取泛型数据列表
/// </summary>
public List <Model.CompanyUAV> GetList()
{
StringBuilder strSql = new StringBuilder("SELECT * FROM CompanyUAV");
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
List <Model.CompanyUAV> lst = GetList(dr);
return(lst);
}
}
/// <summary>
/// 获取泛型数据列表
/// </summary>
public List <Model.TaskAreas> GetList(int pid)
{
StringBuilder strSql = new StringBuilder("SELECT * FROM TaskAreas where PID=" + pid);
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
List <Model.TaskAreas> lst = GetList(dr);
return(lst);
}
}
/// <summary>
/// 获取无人机已完成的任务列表
/// </summary>
public List <Model.PlanResult> GetFinishedTasks(int uid)
{
StringBuilder strSql = new StringBuilder("SELECT * FROM PlanResult WHERE State=2 AND UAVID=" + uid);
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
List <Model.PlanResult> lst = GetList(dr);
return(lst);
}
}
/// <summary>
/// 根据PID获取泛型数据列表
/// </summary>
public List <Model.PlanResult> GetListByPID(int PID)
{
StringBuilder strSql = new StringBuilder("SELECT * FROM PlanResult WHERE PID=" + PID);
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
List <Model.PlanResult> lst = GetList(dr);
return(lst);
}
}
public SqlDataReader GetAnswerInfoIP(string IP, string SID) //防重复答卷
{
string TabelName = " " + prefix + "AnswerInfo ";
StringBuilder sql = new StringBuilder("SELECT TOP 1 ID FROM " + TabelName + "WHERE IP=@IP AND SID=@SID", 100);
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@IP", IP);
parameters[1] = new SqlParameter("@SID", SID);
return(DbHelperSQL.ExecuteReader(ConvertHelper.ConvertString(sql), parameters));
}
public SqlDataReader GetAnswerInfo1(string SID, string str) //防重复答卷
{
string TabelName = " " + prefix + "AnswerInfo ";
StringBuilder sql = new StringBuilder("SELECT TOP 1 ID FROM " + TabelName + "where SID=@SID and ( @str )", 100);
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@SID", SID);
parameters[1] = new SqlParameter("@str", str);
return(DbHelperSQL.ExecuteReader(ConvertHelper.ConvertString(sql), parameters));
}
/// <summary>
/// 获取泛型数据列表
/// </summary>
public List <CoScheduling.Core.Model.BIGAREA_SATELLITE> GetList()
{
StringBuilder strSql = new StringBuilder("SELECT * FROM BIGAREA_SATELLITE");
using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
List <CoScheduling.Core.Model.BIGAREA_SATELLITE> lst = GetList(dr);
return(lst);
}
}
/// <summary>
/// 获取泛型数据列表
/// </summary>
public List <Model.V_VolDisaInfo> GetList(string whereclause)
{
StringBuilder strSql = new StringBuilder("SELECT * FROM V_VolDisaInfo WHERE Address LIKE '%" + whereclause + "%'");
using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
List <Model.V_VolDisaInfo> lst = GetList(dr);
return(lst);
}
}
