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