/// <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); } }
/// <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 int Add(REL_Famous_KeyWordMod model) { return(dal.Add(model)); }