private M_KeyWord GetKeyWordInfoFromReader(SqlDataReader reader)
{
M_KeyWord info = new M_KeyWord();
info.KeywordText = reader["KeywordText"].ToString();
info.KeywordType = DataConverter.CLng(reader["KeywordType"].ToString());
info.Priority = DataConverter.CLng(reader["Priority"].ToString());
info.Hits = DataConverter.CLng(reader["Hits"].ToString());
info.LastUseTime = DataConverter.CDate(reader["LastUseTime"]);
info.ArrGeneralID = reader["ArrGeneralID"].ToString();
info.QuoteTimes = DataConverter.CLng(reader["QuoteTimes"]);
reader.Close();
return info;
}
public M_KeyWord GetModelFromReader(DbDataReader rdr)
{
M_KeyWord model = new M_KeyWord();
model.KeyWordID = Convert.ToInt32(rdr["KeyWordID"]);
model.KeywordText = ConverToStr(rdr["KeywordText"]);
model.KeywordType = ConvertToInt(rdr["KeywordType"]);
model.Priority = ConvertToInt(rdr["Priority"]);
model.Hits = ConvertToInt(rdr["Hits"]);
model.LastUseTime = ConvertToDate(rdr["LastUseTime"]);
model.ArrGeneralID = ConverToStr(rdr["ArrGeneralID"]);
model.QuoteTimes = ConvertToInt(rdr["QuoteTimes"]);
rdr.Dispose();
return(model);
}
protected void EBtnSubmit_Click(object sender, EventArgs e)
{
B_KeyWord bkeyword = new B_KeyWord();
M_KeyWord mkeyword=new M_KeyWord();
mkeyword.KeywordText = TxtKeywordText.Text.ToString();
mkeyword.KeywordType = DataConverter.CLng(RadlKeywordType.SelectedValue);
mkeyword.Priority = DataConverter.CLng(TxtPriority.Text.ToString());
mkeyword.LastUseTime = DateTime.Now;
mkeyword.ArrGeneralID = "";
if (bkeyword.Add(mkeyword))
{
Response.Write("<script language=javascript> alert('添加成功！');window.document.location.href='KeyWordManage.aspx';</script>");
//Page.Response.Redirect("KeyWordManage.aspx");
}
}
protected void EBtnModify_Click(object sender, EventArgs e)
{
B_KeyWord bkeyword = new B_KeyWord();
M_KeyWord mkeyword = new M_KeyWord();
mkeyword.KeyWordID = Convert.ToInt32(Request.QueryString["KWId"].Trim());
mkeyword.KeywordText = TxtKeywordText.Text.ToString();
mkeyword.KeywordType = DataConverter.CLng(RadlKeywordType.SelectedValue);
mkeyword.Priority = DataConverter.CLng(TxtPriority.Text.ToString());
mkeyword.LastUseTime = DateTime.Now;
mkeyword.ArrGeneralID = "";
if (bkeyword.Update(mkeyword))
{
Response.Write("<script language=javascript> alert('修改成功！');window.document.location.href='KeyWordManage.aspx';</script>");
}
}
public override SqlParameter[] GetParameters()
{
M_KeyWord model = this;
SqlParameter[] sp = GetSP();
if (model.LastUseTime <= DateTime.MinValue)
{
model.LastUseTime = DateTime.Now;
}
sp[0].Value = model.KeyWordID;
sp[1].Value = model.KeywordText;
sp[2].Value = model.KeywordType;
sp[3].Value = model.Priority;
sp[4].Value = model.Hits;
sp[5].Value = model.LastUseTime;
sp[6].Value = model.ArrGeneralID;
sp[7].Value = model.QuoteTimes;
return(sp);
}
private SqlParameter[] GetParameters(M_KeyWord sourceInfo)
{
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("@KeywordText", SqlDbType.NVarChar,200),
new SqlParameter("@KeywordType", SqlDbType.Int),
new SqlParameter("@Priority", SqlDbType.Int),
new SqlParameter("@Hits", SqlDbType.Int),
new SqlParameter("@LastUseTime", SqlDbType.DateTime,8),
new SqlParameter("@ArrayGeneralId",SqlDbType.NText),
new SqlParameter("@QuoteTimes", SqlDbType.Int),
new SqlParameter("@KeywordID", SqlDbType.Int)
};
parameter[0].Value = sourceInfo.KeywordText;
parameter[1].Value = sourceInfo.KeywordType;
parameter[2].Value = sourceInfo.Priority;
parameter[3].Value = sourceInfo.Hits;
parameter[4].Value = sourceInfo.LastUseTime;
parameter[5].Value = sourceInfo.ArrGeneralID;
parameter[6].Value = sourceInfo.QuoteTimes;
parameter[7].Value = sourceInfo.KeyWordID;
return parameter;
}
public bool Update(M_KeyWord keywordInfo)
{
SqlParameter[] cmdParams = GetParameters(keywordInfo); ;
return SqlHelper.ExecuteProc("PR_Keywords_Update", cmdParams);
}
public bool Add(M_KeyWord KeyWordInfo)
{
string strSql = "PR_Keywords_Add";
SqlParameter[] parameter = GetParameters(KeyWordInfo);
return SqlHelper.ExecuteProc(strSql, parameter);
}
public bool Update(M_KeyWord KeyWordInfo)
{
return KeyWordMethod.Update(KeyWordInfo);
}
public bool Add(M_KeyWord keywordInfo)
{
return KeyWordMethod.Add(keywordInfo);
}
