private IList <LeavewordInfo> DrRead(SqlDataReader dr) { IList <LeavewordInfo> LInfoList = new List <LeavewordInfo>(); while (dr.Read()) { LeavewordInfo LInfo = new LeavewordInfo(); LInfo.ID = Convert.ToInt32(dr["ID"]); LInfo.Name = Convert.ToString(dr["Name"]); LInfo.Email = Convert.ToString(dr["Email"]); LInfo.Phone = Convert.ToString(dr["Phone"]); LInfo.Content = Convert.ToString(dr["Content"]); LInfo.View = Convert.ToBoolean(dr["View"]); LInfo.Revert = Convert.ToBoolean(dr["Revert"]); if (dr["RevertContent"] == DBNull.Value) { LInfo.RevertContent = ""; } else { LInfo.RevertContent = Convert.ToString(dr["RevertContent"]); } LInfo.CreateDate = Convert.ToDateTime(dr["CreateDate"]); LInfoList.Add(LInfo); } dr.Close(); return(LInfoList); }
public int Add(LeavewordInfo LInfo) { SqlParameter[] MyPar = new SqlParameter[4]; MyPar[0] = new SqlParameter("@Name", SqlDbType.NVarChar, 10); MyPar[0].Value = LInfo.Name; MyPar[1] = new SqlParameter("@Email", SqlDbType.NVarChar, 30); MyPar[1].Value = LInfo.Email; MyPar[2] = new SqlParameter("@Phone", SqlDbType.NVarChar, 20); MyPar[2].Value = LInfo.Phone; MyPar[3] = new SqlParameter("@Content", SqlDbType.NVarChar); MyPar[3].Value = LInfo.Content; string sql = "insert into [" + Pre + "_Leaveword]([Name],[Email],[Phone],[Content]) values(@Name,@Email,@Phone,@Content)"; return(SqlHelper.ExecuteNonQuery(ConnStr, CommandType.Text, sql, MyPar)); }
protected void Page_Load(object sender, EventArgs e) { try { ID = Convert.ToInt32(Tools.GetQueryString("id")); } catch { ShowWindow(4, "系统提示", "参数类型不正确", null, true); } LInfo = new BLL.Leaveword.Leaveword().GetByID(ID); if (LInfo != null && !LInfo.View) { new BLL.Leaveword.Leaveword().UpdateView(LInfo.ID); } if (Tools.GetQueryString("action").ToLower() == "save" && LInfo != null) { string RevertContent = Tools.GetForm("RevertContent"); if (RevertContent == string.Empty) { ShowWindow(1, "系统提示", "请填写回复内容", null, true); } else { if (new BLL.Leaveword.Leaveword().Revert(LInfo.ID, RevertContent) != 0) { ShowWindow(3, "系统提示", "回复成功,点击 \\\"确定\\\" 按钮返回", "leaveword.aspx?p=" + Tools.GetQueryString("p"), false); } else { ShowWindow(4, "系统提示", "回复失败", null, true); } } } }
public int Add(LeavewordInfo LInfo) { return(dal.Add(LInfo)); }