/// <summary> /// 管理员获取项目留言列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-04-28</remarks> public DataTable AdminGetList(E_ItemMessage data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseName", SqlDbType.VarChar, 128), new SqlParameter("@ItemName", SqlDbType.VarChar, 64), new SqlParameter("@UserName", SqlDbType.VarChar, 128), new SqlParameter("@Mobile", SqlDbType.VarChar, 11), new SqlParameter("@Email", SqlDbType.VarChar, 128), new SqlParameter("@DelFlag", SqlDbType.Int), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@TotalCount", SqlDbType.Int) }; parms[0].Value = data.EnterpriseName; parms[1].Value = data.ItemName; parms[2].Value = data.UserName; parms[3].Value = data.Mobile; parms[4].Value = data.Email; parms[5].Value = data.DelFlag; parms[6].Value = data.Page.PageSize; parms[7].Value = data.Page.PageIndex; parms[8].Direction = ParameterDirection.Output; DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_ItemMessage_AdminSelectList", parms); data.Page.TotalCount = parms[8].Value == DBNull.Value ? 0 : Convert.ToInt32(parms[8].Value); return(dt); }
/// <summary> /// 添加留言信息 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-04-27</remarks> public bool Add(E_ItemMessage data) { SqlParameter[] parms = { new SqlParameter("@ItemID", SqlDbType.Int), new SqlParameter("@UserID", SqlDbType.Int), new SqlParameter("@UserName", SqlDbType.VarChar, 128), new SqlParameter("@Mobile", SqlDbType.VarChar, 11), new SqlParameter("@Tel", SqlDbType.VarChar, 64), new SqlParameter("@Email", SqlDbType.VarChar, 128), new SqlParameter("@Address", SqlDbType.VarChar, 128), new SqlParameter("@Message", SqlDbType.VarChar, 1024) }; parms[0].Value = data.ItemID; parms[1].Value = data.UserID; parms[2].Value = data.UserName; parms[3].Value = data.Mobile; parms[4].Value = data.Tel; parms[5].Value = data.Email; parms[6].Value = data.Address; parms[7].Value = data.Message; int ReturnValue; DbHelperSQL.RunProcedures("ProcEP_B_ItemMessage_Insert", parms, out ReturnValue); return(ReturnValue > 0); }
/// <summary> /// 后台管理员真正删除 /// </summary> /// <param name="data"></param> /// <returns></returns> public bool AdminDelete(E_ItemMessage data) { SqlParameter[] parms = { new SqlParameter("@ID", SqlDbType.Int) }; parms[0].Value = data.ID; int ReturnValue; DbHelperSQL.RunProcedures("ProcEP_B_ItemMessage_AdminDelete", parms, out ReturnValue); return(ReturnValue > 0); }
/// <summary> /// 删除个人用户留言信息 /// </summary> private void DeleteMessage() { int mid; if (!int.TryParse(nv["mid"], out mid)) { HttpContext.Current.Response.Write("0"); return; } E_ItemMessage data = new E_ItemMessage(); data.ID = mid; bool flag = new T_ItemMessage().AdminDelete(data); HttpContext.Current.Response.Write(flag ? "1" : "0"); }
/// <summary> /// 加载留言信息 /// </summary> protected void loadMessage() { E_ItemMessage data = new E_ItemMessage(); data.EnterpriseID = eid; data.Page = new MLMGC.DataEntity.E_Page(); data.Page.PageIndex = pageIndex; data.Page.PageSize = pageSize; rpList.DataSource = new T_ItemMessage().GetList(data); rpList.DataBind(); //设置分页样式 pageList1.PageSize = pageSize; pageList1.CurrentPageIndex = pageIndex; pageList1.RecordCount = data.Page.TotalCount; pageList1.CustomInfoHTML = string.Format("共有记录 <span class='red_font'>{0}</span> 条", pageList1.RecordCount); pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " "; }
/// <summary> /// 查看留言列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-04-27</remarks> public DataTable GetList(E_ItemMessage data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@TotalCount", SqlDbType.Int) }; parms[0].Value = data.EnterpriseID; parms[1].Value = data.Page.PageSize; parms[2].Value = data.Page.PageIndex; parms[3].Direction = ParameterDirection.Output; DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_ItemMessage_SelectList", parms); data.Page.TotalCount = parms[3].Value == DBNull.Value ? 0 : Convert.ToInt32(parms[3].Value); return(dt); }
/// <summary> /// 数据绑定 /// </summary> protected void databind() { string epname = Requests.GetQueryString("epname"); string itemname = Requests.GetQueryString("itemname"); string username = Requests.GetQueryString("username"); string mobile = Requests.GetQueryString("mobile"); string email = Requests.GetQueryString("email"); int delflag = Requests.GetQueryInt("delflag", -1); txtEPName.Text = epname; txtItemName.Text = itemname; txtUserName.Text = username; txtMobile.Text = mobile; txtEmail.Text = email; cbDelFlag.Checked = delflag == 0; E_ItemMessage data = new E_ItemMessage(); data.EnterpriseName = epname; data.ItemName = itemname; data.UserName = username; data.Mobile = mobile; data.Email = email; data.DelFlag = delflag; data.Page = new MLMGC.DataEntity.E_Page(); data.Page.PageIndex = pageIndex; data.Page.PageSize = pageSize; rpList.DataSource = new T_ItemMessage().AdminGetList(data); rpList.DataBind(); //设置分页样式 pageList1.PageSize = pageSize; pageList1.CurrentPageIndex = pageIndex; pageList1.RecordCount = data.Page.TotalCount; pageList1.CustomInfoHTML = string.Format("共有记录 <span class='red_font'>{0}</span> 条", pageList1.RecordCount); pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " "; }
/// <summary> /// 提交留言处理事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { //获取界面数据 string username = txtUserName.Text.Trim(); string mobile = txtMobile.Text.Trim(); string tel = txtTel.Text.Trim(); string address = txtAddress.Text.Trim(); string email = txtEmail.Text.Trim(); string message = txtMessage.Text.Trim(); if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(mobile) || string.IsNullOrEmpty(message)) { Jscript.ShowMsg("请请认真填写以上内容!", this); return; } E_ItemMessage data = new E_ItemMessage(); data.ItemID = iid; data.UserID = UserID; data.UserName = username; data.Mobile = mobile; data.Tel = tel; data.Address = address; data.Email = email; data.Message = message; bool flag = new T_ItemMessage().Add(data); if (flag) { loadMessage(); txtMessage.Text = ""; } else { Jscript.ShowMsg("留言失败!", this); } }
/// <summary> /// 后台管理员真正删除 /// </summary> /// <param name="data"></param> /// <returns></returns> public bool AdminDelete(E_ItemMessage data) { return(dal.AdminDelete(data)); }
/// <summary> /// 总监删除留言 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-04-27</remarks> public bool Delete(E_ItemMessage data) { return(dal.Delete(data)); }
/// <summary> /// 管理员获取项目留言列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-04-28</remarks> public DataTable AdminGetList(E_ItemMessage data) { return(dal.AdminGetList(data)); }
/// <summary> /// 添加留言信息 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-04-27</remarks> public bool Add(E_ItemMessage data) { return(dal.Add(data)); }