/// <summary>
/// 增加一条数据
/// </summary>
public int Add(REL_Famous_KeyWordMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into REL_Famous_KeyWord(");
strSql.Append("Famous_SysNo,KeyWord_SysNo,Value)");
strSql.Append(" values (");
strSql.Append("@Famous_SysNo,@KeyWord_SysNo,@Value)");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters = {
new SqlParameter("@Famous_SysNo",SqlDbType.Int,4),
new SqlParameter("@KeyWord_SysNo",SqlDbType.Int,4),
new SqlParameter("@Value",SqlDbType.Int,4)
};
if (model.Famous_SysNo != AppConst.IntNull)
parameters[0].Value = model.Famous_SysNo;
else
parameters[0].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[0]);
if (model.KeyWord_SysNo != AppConst.IntNull)
parameters[1].Value = model.KeyWord_SysNo;
else
parameters[1].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[1]);
if (model.Value != AppConst.IntNull)
parameters[2].Value = model.Value;
else
parameters[2].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[2]);
return SqlHelper.ExecuteNonQuery(cmd,parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(REL_Famous_KeyWordMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update REL_Famous_KeyWord set ");
strSql.Append("Famous_SysNo=@Famous_SysNo,");
strSql.Append("KeyWord_SysNo=@KeyWord_SysNo,");
strSql.Append("Value=@Value");
strSql.Append(" where SysNo=@SysNo ");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters =
{
new SqlParameter("@SysNo", SqlDbType.Int, 4),
new SqlParameter("@Famous_SysNo", SqlDbType.Int, 4),
new SqlParameter("@KeyWord_SysNo", SqlDbType.Int, 4),
new SqlParameter("@Value", SqlDbType.Int, 4)
};
if (model.SysNo != AppConst.IntNull)
{
parameters[0].Value = model.SysNo;
}
else
{
parameters[0].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[0]);
if (model.Famous_SysNo != AppConst.IntNull)
{
parameters[1].Value = model.Famous_SysNo;
}
else
{
parameters[1].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[1]);
if (model.KeyWord_SysNo != AppConst.IntNull)
{
parameters[2].Value = model.KeyWord_SysNo;
}
else
{
parameters[2].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[2]);
if (model.Value != AppConst.IntNull)
{
parameters[3].Value = model.Value;
}
else
{
parameters[3].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[3]);
return(SqlHelper.ExecuteNonQuery(cmd, parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(REL_Famous_KeyWordMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into REL_Famous_KeyWord(");
strSql.Append("Famous_SysNo,KeyWord_SysNo,Value)");
strSql.Append(" values (");
strSql.Append("@Famous_SysNo,@KeyWord_SysNo,@Value)");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters =
{
new SqlParameter("@Famous_SysNo", SqlDbType.Int, 4),
new SqlParameter("@KeyWord_SysNo", SqlDbType.Int, 4),
new SqlParameter("@Value", SqlDbType.Int, 4)
};
if (model.Famous_SysNo != AppConst.IntNull)
{
parameters[0].Value = model.Famous_SysNo;
}
else
{
parameters[0].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[0]);
if (model.KeyWord_SysNo != AppConst.IntNull)
{
parameters[1].Value = model.KeyWord_SysNo;
}
else
{
parameters[1].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[1]);
if (model.Value != AppConst.IntNull)
{
parameters[2].Value = model.Value;
}
else
{
parameters[2].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[2]);
return(SqlHelper.ExecuteNonQuery(cmd, parameters));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public REL_Famous_KeyWordMod GetModel(int SysNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SysNo, Famous_SysNo, KeyWord_SysNo, Value from REL_Famous_KeyWord");
strSql.Append(" where SysNo=@SysNo");
SqlParameter[] parameters =
{
new SqlParameter("@SysNo", SqlDbType.Int, 4)
};
parameters[0].Value = SysNo;
REL_Famous_KeyWordMod model = new REL_Famous_KeyWordMod();
DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "")
{
model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString());
}
if (ds.Tables[0].Rows[0]["Famous_SysNo"].ToString() != "")
{
model.Famous_SysNo = int.Parse(ds.Tables[0].Rows[0]["Famous_SysNo"].ToString());
}
if (ds.Tables[0].Rows[0]["KeyWord_SysNo"].ToString() != "")
{
model.KeyWord_SysNo = int.Parse(ds.Tables[0].Rows[0]["KeyWord_SysNo"].ToString());
}
if (ds.Tables[0].Rows[0]["Value"].ToString() != "")
{
model.Value = int.Parse(ds.Tables[0].Rows[0]["Value"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public REL_Famous_KeyWordMod GetModel(int SysNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SysNo, Famous_SysNo, KeyWord_SysNo, Value from REL_Famous_KeyWord");
strSql.Append(" where SysNo=@SysNo");
SqlParameter[] parameters = {
new SqlParameter("@SysNo", SqlDbType.Int,4 )
};
parameters[0].Value = SysNo;
REL_Famous_KeyWordMod model = new REL_Famous_KeyWordMod();
DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "")
{
model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString());
}
if (ds.Tables[0].Rows[0]["Famous_SysNo"].ToString() != "")
{
model.Famous_SysNo = int.Parse(ds.Tables[0].Rows[0]["Famous_SysNo"].ToString());
}
if (ds.Tables[0].Rows[0]["KeyWord_SysNo"].ToString() != "")
{
model.KeyWord_SysNo = int.Parse(ds.Tables[0].Rows[0]["KeyWord_SysNo"].ToString());
}
if (ds.Tables[0].Rows[0]["Value"].ToString() != "")
{
model.Value = int.Parse(ds.Tables[0].Rows[0]["Value"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(REL_Famous_KeyWordMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update REL_Famous_KeyWord set ");
strSql.Append("Famous_SysNo=@Famous_SysNo,");
strSql.Append("KeyWord_SysNo=@KeyWord_SysNo,");
strSql.Append("Value=@Value");
strSql.Append(" where SysNo=@SysNo ");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters = {
new SqlParameter("@SysNo",SqlDbType.Int,4),
new SqlParameter("@Famous_SysNo",SqlDbType.Int,4),
new SqlParameter("@KeyWord_SysNo",SqlDbType.Int,4),
new SqlParameter("@Value",SqlDbType.Int,4)
};
if (model.SysNo != AppConst.IntNull)
parameters[0].Value = model.SysNo;
else
parameters[0].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[0]);
if (model.Famous_SysNo != AppConst.IntNull)
parameters[1].Value = model.Famous_SysNo;
else
parameters[1].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[1]);
if (model.KeyWord_SysNo != AppConst.IntNull)
parameters[2].Value = model.KeyWord_SysNo;
else
parameters[2].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[2]);
if (model.Value != AppConst.IntNull)
parameters[3].Value = model.Value;
else
parameters[3].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[3]);
return SqlHelper.ExecuteNonQuery(cmd,parameters);
}
protected void Unnamed3_Click(object sender, EventArgs e)
{
string[] keys = this.txtKey.Text.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
DataTable m_keys = new DataTable();
SYS_FamousMod m_famous = new SYS_FamousMod();
if (type == "EDIT")
{
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
SysNo = int.Parse(Request.QueryString["id"]);
}
m_famous = SYS_FamousBll.GetInstance().GetModel(SysNo);
m_keys = REL_Famous_KeyWordBll.GetInstance().GetFamousList(SysNo);
}
try
{
m_famous.BirthYear = int.Parse(txtYear.Text);
m_famous.BirthTime = new DateTime(AppConst.DateTimeNull.Year, int.Parse(txtMonth.Text), int.Parse(txtDay.Text),
int.Parse(txtHour.Text), int.Parse(txtMinute.Text), 0);
m_famous.CateSysNo = int.Parse(drpCate.SelectedValue);
m_famous.CustomerSysNo = GetSession().AdminEntity.CustomerSysNo;
m_famous.Description = txtDesc.Text;
m_famous.FullName = txtFullName.Text;
m_famous.Gender = int.Parse(drpGender.SelectedValue);
if (txtHeight.Text != AppConst.StringNull)
{
m_famous.Height = int.Parse(txtHeight.Text);
}
if (drpDistrict3.SelectedValue == "0")
{
ltrError.Text = "请选择第三级地区！";
this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true);
}
m_famous.HomeTown = int.Parse(drpDistrict3.SelectedValue);
m_famous.Name = txtName.Text;
if (type == "INPUT")
{
m_famous.Source = "AstroTheme";
}
else
{
m_famous.Source = "手动添加";
}
m_famous.TimeUnknown = int.Parse(chkTime.SelectedValue);
}
catch
{
ltrError.Text = "输入资料格式有误，请检查！";
this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true);
return;
}
try
{
if (type == "ADD")
{
m_famous.SysNo = SYS_FamousBll.GetInstance().Add(m_famous);
for (int i = 0; i < keys.Length; i++)
{
SYS_Famous_KeyWordsMod tmp_key = new SYS_Famous_KeyWordsMod();
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().GetSysNoByName(keys[i]);
if (tmp_key.SysNo == AppConst.IntNull)
{
tmp_key.KeyWords = keys[i];
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().Add(tmp_key);
}
REL_Famous_KeyWordMod tmp_rel = new REL_Famous_KeyWordMod();
tmp_rel.Famous_SysNo = m_famous.SysNo;
tmp_rel.KeyWord_SysNo = tmp_key.SysNo;
REL_Famous_KeyWordBll.GetInstance().Add(tmp_rel);
}
LogManagement.getInstance().WriteTrace(m_famous.SysNo, "Celebrity.Add", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
}
else if (type == "EDIT")
{
SYS_FamousBll.GetInstance().Update(m_famous);
REL_Famous_KeyWordBll.GetInstance().RemoveAllKeyByFamous(m_famous.SysNo);
for (int i = 0; i < keys.Length; i++)
{
SYS_Famous_KeyWordsMod tmp_key = new SYS_Famous_KeyWordsMod();
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().GetSysNoByName(keys[i]);
if (tmp_key.SysNo == AppConst.IntNull)
{
tmp_key.KeyWords = keys[i];
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().Add(tmp_key);
}
REL_Famous_KeyWordMod tmp_rel = new REL_Famous_KeyWordMod();
tmp_rel.Famous_SysNo = m_famous.SysNo;
tmp_rel.KeyWord_SysNo = tmp_key.SysNo;
REL_Famous_KeyWordBll.GetInstance().Add(tmp_rel);
}
LogManagement.getInstance().WriteTrace(m_famous.SysNo, "Celebrity.Edit", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
}
else if (type == "INPUT")
{
m_famous.SysNo = SYS_FamousBll.GetInstance().Add(m_famous);
int spider = int.Parse(Request.QueryString["id"]);
SPD_FamousMod m_spider = SPD_FamousBll.GetInstance().GetModel(spider);
m_spider.FamousSysNo = m_famous.SysNo;
SPD_FamousBll.GetInstance().Update(m_spider);
for (int i = 0; i < keys.Length; i++)
{
SYS_Famous_KeyWordsMod tmp_key = new SYS_Famous_KeyWordsMod();
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().GetSysNoByName(keys[i]);
if (tmp_key.SysNo == AppConst.IntNull)
{
tmp_key.KeyWords = keys[i];
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().Add(tmp_key);
}
REL_Famous_KeyWordMod tmp_rel = new REL_Famous_KeyWordMod();
tmp_rel.Famous_SysNo = m_famous.SysNo;
tmp_rel.KeyWord_SysNo = tmp_key.SysNo;
REL_Famous_KeyWordBll.GetInstance().Add(tmp_rel);
}
LogManagement.getInstance().WriteTrace(m_famous.SysNo, "Celebrity.Input", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
}
ltrNotice.Text = "该记录已保存成功！";
this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('noticediv').style.display='';", true);
}
catch (Exception ex)
{
ltrError.Text = "系统错误，保存失败！";
this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true);
LogManagement.getInstance().WriteException(ex, "Celebrity.Save", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
}
}
protected void Unnamed3_Click(object sender, EventArgs e)
{
string[] keys = this.txtKey.Text.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
DataTable m_keys = new DataTable();
SYS_FamousMod m_famous = new SYS_FamousMod();
if (type == "EDIT")
{
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
SysNo = int.Parse(Request.QueryString["id"]);
}
m_famous = SYS_FamousBll.GetInstance().GetModel(SysNo);
m_keys = REL_Famous_KeyWordBll.GetInstance().GetFamousList(SysNo);
}
try
{
m_famous.BirthYear = int.Parse(txtYear.Text);
m_famous.BirthTime = new DateTime(AppConst.DateTimeNull.Year, int.Parse(txtMonth.Text), int.Parse(txtDay.Text),
int.Parse(txtHour.Text), int.Parse(txtMinute.Text), 0);
m_famous.CateSysNo = int.Parse(drpCate.SelectedValue);
m_famous.CustomerSysNo = GetSession().AdminEntity.CustomerSysNo;
m_famous.Description = txtDesc.Text;
m_famous.FullName = txtFullName.Text;
m_famous.Gender = int.Parse(drpGender.SelectedValue);
if (txtHeight.Text != AppConst.StringNull)
{
m_famous.Height = int.Parse(txtHeight.Text);
}
if (drpDistrict3.SelectedValue == "0")
{
ltrError.Text = "请选择第三级地区！";
this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true);
}
m_famous.HomeTown = int.Parse(drpDistrict3.SelectedValue);
m_famous.Name = txtName.Text;
if (type == "INPUT")
{
m_famous.Source = "AstroTheme";
}
else
{
m_famous.Source = "手动添加";
}
m_famous.TimeUnknown = int.Parse(chkTime.SelectedValue);
}
catch
{
ltrError.Text = "输入资料格式有误，请检查！";
this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true);
return;
}
try
{
if (type == "ADD")
{
m_famous.SysNo = SYS_FamousBll.GetInstance().Add(m_famous);
for (int i = 0; i < keys.Length; i++)
{
SYS_Famous_KeyWordsMod tmp_key = new SYS_Famous_KeyWordsMod();
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().GetSysNoByName(keys[i]);
if (tmp_key.SysNo == AppConst.IntNull)
{
tmp_key.KeyWords = keys[i];
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().Add(tmp_key);
}
REL_Famous_KeyWordMod tmp_rel = new REL_Famous_KeyWordMod();
tmp_rel.Famous_SysNo = m_famous.SysNo;
tmp_rel.KeyWord_SysNo = tmp_key.SysNo;
REL_Famous_KeyWordBll.GetInstance().Add(tmp_rel);
}
LogManagement.getInstance().WriteTrace(m_famous.SysNo, "Celebrity.Add", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
}
else if (type == "EDIT")
{
SYS_FamousBll.GetInstance().Update(m_famous);
REL_Famous_KeyWordBll.GetInstance().RemoveAllKeyByFamous(m_famous.SysNo);
for (int i = 0; i < keys.Length; i++)
{
SYS_Famous_KeyWordsMod tmp_key = new SYS_Famous_KeyWordsMod();
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().GetSysNoByName(keys[i]);
if (tmp_key.SysNo == AppConst.IntNull)
{
tmp_key.KeyWords = keys[i];
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().Add(tmp_key);
}
REL_Famous_KeyWordMod tmp_rel = new REL_Famous_KeyWordMod();
tmp_rel.Famous_SysNo = m_famous.SysNo;
tmp_rel.KeyWord_SysNo = tmp_key.SysNo;
REL_Famous_KeyWordBll.GetInstance().Add(tmp_rel);
}
LogManagement.getInstance().WriteTrace(m_famous.SysNo, "Celebrity.Edit", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
}
else if (type == "INPUT")
{
m_famous.SysNo = SYS_FamousBll.GetInstance().Add(m_famous);
int spider = int.Parse(Request.QueryString["id"]);
SPD_FamousMod m_spider = SPD_FamousBll.GetInstance().GetModel(spider);
m_spider.FamousSysNo = m_famous.SysNo;
SPD_FamousBll.GetInstance().Update(m_spider);
for (int i = 0; i < keys.Length; i++)
{
SYS_Famous_KeyWordsMod tmp_key = new SYS_Famous_KeyWordsMod();
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().GetSysNoByName(keys[i]);
if (tmp_key.SysNo == AppConst.IntNull)
{
tmp_key.KeyWords = keys[i];
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().Add(tmp_key);
}
REL_Famous_KeyWordMod tmp_rel = new REL_Famous_KeyWordMod();
tmp_rel.Famous_SysNo = m_famous.SysNo;
tmp_rel.KeyWord_SysNo = tmp_key.SysNo;
REL_Famous_KeyWordBll.GetInstance().Add(tmp_rel);
}
LogManagement.getInstance().WriteTrace(m_famous.SysNo, "Celebrity.Input", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
}
ltrNotice.Text = "该记录已保存成功！";
this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('noticediv').style.display='';", true);
}
catch (Exception ex)
{
ltrError.Text = "系统错误，保存失败！";
this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true);
LogManagement.getInstance().WriteException(ex, "Celebrity.Save", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(REL_Famous_KeyWordMod model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(REL_Famous_KeyWordMod model)
{
dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(REL_Famous_KeyWordMod model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(REL_Famous_KeyWordMod model)
{
return(dal.Add(model));
}
