protected void init() { try { string id = Request.QueryString["ServiceID"].ToString(); VServiceInfo n = Leyp.SQLServerDAL.Factory.getServiceInfoDAL().getByID(int.Parse(id)); if (n == null) { Response.Write("没有数据!"); Response.End(); return; } IDS.Text = id; ServiceTitle.Text = n.ServiceTitle; CreateDate.Text = n.CreateDate; Content.Text = n.Content; ServiceName.Text = n.ServiceName; ReplyInfo.Text = n.ReplyInfo; AuditingUser.Text = n.AuditingUser; UserName.Text = n.UserName; State.Text = changString(n.State.ToString()); RealName.Text = n.RealName; } catch { Response.Write("参数有误!"); } }
public VServiceInfo getByID(int ID) { bool flag = false; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; VServiceInfo info = new VServiceInfo(); SqlDataReader reader = SQLHelper.RunProcedure("p_ServiceInfo_getByID", parameters); if (reader.Read()) { info.TypeID = reader.GetInt32(reader.GetOrdinal("TypeID")); info.ID = reader.GetInt32(reader.GetOrdinal("ID")); info.State = reader.GetInt32(reader.GetOrdinal("State")); info.AuditingUser = reader.GetString(reader.GetOrdinal("AuditingUser")); info.ServiceTitle = reader.GetString(reader.GetOrdinal("ServiceTitle")); info.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate")); info.ServiceName = reader.GetString(reader.GetOrdinal("ServiceName")); info.UserName = reader.GetString(reader.GetOrdinal("UserName")); info.RealName = reader.GetString(reader.GetOrdinal("RealName")); info.Content = reader.GetString(reader.GetOrdinal("Content")); info.ReplyInfo = reader.GetString(reader.GetOrdinal("ReplyInfo")); flag = true; } reader.Close(); return(flag ? info : null); }
public List <VServiceInfo> getSearchListByDate(string beginDate, string endDate, int sideState) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@beginDate", SqlDbType.NVarChar), new SqlParameter("@endDate", SqlDbType.NVarChar), new SqlParameter("@sideState", SqlDbType.Int) }; parameters[0].Value = beginDate; parameters[1].Value = endDate; parameters[2].Value = sideState; List <VServiceInfo> list = new List <VServiceInfo>(); SqlDataReader reader = SQLHelper.RunProcedure("p_ServiceInfo_getSearchListByDate", parameters); while (reader.Read()) { VServiceInfo item = new VServiceInfo(); item.TypeID = reader.GetInt32(reader.GetOrdinal("TypeID")); item.ID = reader.GetInt32(reader.GetOrdinal("ID")); item.AuditingUser = reader.GetString(reader.GetOrdinal("AuditingUser")); item.ServiceTitle = reader.GetString(reader.GetOrdinal("ServiceTitle")); item.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate")); item.ServiceName = reader.GetString(reader.GetOrdinal("ServiceName")); item.UserName = reader.GetString(reader.GetOrdinal("UserName")); item.RealName = reader.GetString(reader.GetOrdinal("RealName")); item.State = reader.GetInt32(reader.GetOrdinal("State")); list.Add(item); } reader.Close(); return(list); }
protected void init() { List <Notice> list0 = new List <Notice>(); List <Notice> list1 = new List <Notice>(); List <Notice> list2 = new List <Notice>(); Leyp.SQLServerDAL.NoticeDAL dl = Leyp.SQLServerDAL.Factory.getNoticeDAL(); List <VServiceInfo> list3 = null; List <VServiceInfo> list30 = new List <VServiceInfo>(); list3 = Leyp.SQLServerDAL.Factory.getServiceInfoDAL().getMyTopic(getUserName()); for (int i = 0; i < list3.Count; i++) { VServiceInfo s = list3[i]; list30.Add(s); if (i == 4) { break; } } list0 = dl.getNewsByType(0); //通知 list1 = dl.getNewsByType(1); //热销活动 list2 = dl.getNewsByType(2); //会议 Noticelist.DataSource = list0; Noticelist.DataBind(); NewsSales.DataSource = list1; NewsSales.DataBind(); MeetingRepeater.DataSource = list2; MeetingRepeater.DataBind(); VServiceInfoList.DataSource = list30; VServiceInfoList.DataBind(); }
public List <VServiceInfo> getAll() { List <VServiceInfo> list = new List <VServiceInfo>(); SqlDataReader reader = SQLHelper.RunProcedure("p_ServiceInfo_getAll", null); while (reader.Read()) { VServiceInfo item = new VServiceInfo(); item.TypeID = reader.GetInt32(reader.GetOrdinal("TypeID")); item.ID = reader.GetInt32(reader.GetOrdinal("ID")); item.AuditingUser = reader.GetString(reader.GetOrdinal("AuditingUser")); item.ServiceTitle = reader.GetString(reader.GetOrdinal("ServiceTitle")); item.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate")); item.ServiceName = reader.GetString(reader.GetOrdinal("ServiceName")); item.UserName = reader.GetString(reader.GetOrdinal("UserName")); item.RealName = reader.GetString(reader.GetOrdinal("RealName")); item.State = reader.GetInt32(reader.GetOrdinal("State")); list.Add(item); } reader.Close(); return(list); }
public List <VServiceInfo> getMyAuditingUserTopic(string UserName) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@UserName", SqlDbType.NVarChar) }; parameters[0].Value = UserName; List <VServiceInfo> list = new List <VServiceInfo>(); SqlDataReader reader = SQLHelper.RunProcedure("p_ServiceInfo_getMyAuditingUserTopic", parameters); while (reader.Read()) { VServiceInfo item = new VServiceInfo(); item.TypeID = reader.GetInt32(reader.GetOrdinal("TypeID")); item.ID = reader.GetInt32(reader.GetOrdinal("ID")); item.AuditingUser = reader.GetString(reader.GetOrdinal("AuditingUser")); item.ServiceTitle = reader.GetString(reader.GetOrdinal("ServiceTitle")); item.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate")); item.ServiceName = reader.GetString(reader.GetOrdinal("ServiceName")); item.UserName = reader.GetString(reader.GetOrdinal("UserName")); item.RealName = reader.GetString(reader.GetOrdinal("RealName")); item.State = reader.GetInt32(reader.GetOrdinal("State")); list.Add(item); } reader.Close(); return(list); }