//保存 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevel("_ybd_company_partner", EnumCollection.ActionEnum.Modify.ToString()); //检查权限 BLL.company_partner bll = new BLL.company_partner(); Model.company_partner model = bll.GetModel(this.id); model.company_id = Convert.ToInt32(txtcompany_id.Text); model.logo = Convert.ToString(txtlogo.Text); model.title = Convert.ToString(txttitle.Text); model.video_url = Convert.ToString(txtvideo_url.Text); model.video_thumb_img = Convert.ToString(txtvideo_thumb_img.Text); model.details = Convert.ToString(txtdetails.Text); model.is_show = Convert.ToInt32(txtis_show.Text); model.sort = Convert.ToInt32(txtsort.Text); model.add_time = Convert.ToDateTime(txtadd_time.Text); if (bll.Update(model)) { AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改合作伙伴信息,主键:" + id); //记录日志 JscriptMsg("修改合作伙伴信息成功!", "Manage.aspx"); } else { JscriptMsg("保存过程中发生错误!", ""); } }
private void SetPartnerIsShow() { int id = RequestHelper.GetFormInt("id"); BLL.company_partner bll = new BLL.company_partner(); Model.company_partner model = bll.GetModel(id); if (model != null) { if (model.is_show == (int)EnumCollection.YesOrNot.是) { model.is_show = (int)EnumCollection.YesOrNot.否; } else { model.is_show = (int)EnumCollection.YesOrNot.是; } bll.Update(model); HttpContext.Current.Response.Write("1"); HttpContext.Current.Response.End(); } else { HttpContext.Current.Response.Write("0"); HttpContext.Current.Response.End(); } }
/// <summary> /// 获得Model /// </summary> /// <param name="Top">大于0取前几行数据,否则取全部</param> /// <param name="whereStr">where条件</param> /// <param name="filedOrder">排序字段Order By + filedOrder (不可为空)</param> /// <returns></returns> public Model.company_partner GetModel(int Top, string whereStr, string filedOrder) { DataTable dt = dal.GetList(Top, whereStr, filedOrder).Tables[0]; Model.company_partner model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null; return(model); }
/// <summary> /// 获得Model /// </summary> /// <param name="whereStr"></param> /// <returns></returns> public Model.company_partner GetModel(string whereStr) { DataTable dt = dal.GetList(whereStr).Tables[0]; Model.company_partner model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null; return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.company_partner model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"Insert Into ybd_company_partner( company_id ,logo ,title ,video_url ,video_thumb_img ,details ,is_show ,sort ,add_time ) Values ( @company_id ,@logo ,@title ,@video_url ,@video_thumb_img ,@details ,@is_show ,@sort ,@add_time ); SELECT @@IDENTITY;"); SqlParameter[] parameters = { new SqlParameter("@company_id", SqlDbType.Int, 4) , new SqlParameter("@logo", SqlDbType.NVarChar, 255) , new SqlParameter("@title", SqlDbType.NVarChar, 50) , new SqlParameter("@video_url", SqlDbType.NVarChar, 255) , new SqlParameter("@video_thumb_img", SqlDbType.NVarChar, 255) , new SqlParameter("@details", SqlDbType.NText) , new SqlParameter("@is_show", SqlDbType.Int, 4) , new SqlParameter("@sort", SqlDbType.Int, 4) , new SqlParameter("@add_time", SqlDbType.DateTime, 8) }; parameters[0].Value = model.company_id; parameters[1].Value = model.logo; parameters[2].Value = model.title; parameters[3].Value = model.video_url; parameters[4].Value = model.video_thumb_img; parameters[5].Value = model.details; parameters[6].Value = model.is_show; parameters[7].Value = model.sort; parameters[8].Value = model.add_time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.company_partner DataRowToModel(DataRow row) { Model.company_partner model = new Model.company_partner(); if (row != null) { if (row["id"] != null) //&& row["id"].ToString() != "" { model.id = Convert.ToInt32(row["id"]); } if (row["company_id"] != null) //&& row["company_id"].ToString() != "" { model.company_id = Convert.ToInt32(row["company_id"]); } if (row["logo"] != null) //&& row["logo"].ToString() != "" { model.logo = Convert.ToString(row["logo"]); } if (row["title"] != null) //&& row["title"].ToString() != "" { model.title = Convert.ToString(row["title"]); } if (row["video_url"] != null) //&& row["video_url"].ToString() != "" { model.video_url = Convert.ToString(row["video_url"]); } if (row["video_thumb_img"] != null) //&& row["video_thumb_img"].ToString() != "" { model.video_thumb_img = Convert.ToString(row["video_thumb_img"]); } if (row["details"] != null) //&& row["details"].ToString() != "" { model.details = Convert.ToString(row["details"]); } if (row["is_show"] != null) //&& row["is_show"].ToString() != "" { model.is_show = Convert.ToInt32(row["is_show"]); } if (row["sort"] != null) //&& row["sort"].ToString() != "" { model.sort = Convert.ToInt32(row["sort"]); } if (row["add_time"] != null && row["add_time"].ToString() != "") { model.add_time = Convert.ToDateTime(row["add_time"]); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.company_partner model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"UPDATE ybd_company_partner SET company_id = @company_id ,logo = @logo ,title = @title ,video_url = @video_url ,video_thumb_img = @video_thumb_img ,details = @details ,is_show = @is_show ,sort = @sort ,add_time = @add_time WHERE id = @id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) , new SqlParameter("@company_id", SqlDbType.Int, 4) , new SqlParameter("@logo", SqlDbType.NVarChar, 255) , new SqlParameter("@title", SqlDbType.NVarChar, 50) , new SqlParameter("@video_url", SqlDbType.NVarChar, 255) , new SqlParameter("@video_thumb_img", SqlDbType.NVarChar, 255) , new SqlParameter("@details", SqlDbType.NText) , new SqlParameter("@is_show", SqlDbType.Int, 4) , new SqlParameter("@sort", SqlDbType.Int, 4) , new SqlParameter("@add_time", SqlDbType.DateTime, 8) }; parameters[0].Value = model.id; parameters[1].Value = model.company_id; parameters[2].Value = model.logo; parameters[3].Value = model.title; parameters[4].Value = model.video_url; parameters[5].Value = model.video_thumb_img; parameters[6].Value = model.details; parameters[7].Value = model.is_show; parameters[8].Value = model.sort; parameters[9].Value = model.add_time; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void BindInfo() { BLL.company_partner bll = new BLL.company_partner(); Model.company_partner model = bll.GetModel(this.id); if (model == null) { JscriptMsg("信息不存在或已被删除!", "back"); return; } txtlogo.Text = model.logo + ""; txttitle.Text = model.title + ""; txtvideo_url.Text = model.video_url + ""; this.rbtnIsShow.SelectedValue = model.is_show + ""; txtsort.Text = model.sort + ""; }
private void BindInfo() { BLL.company_partner bll = new BLL.company_partner(); Model.company_partner model = bll.GetModel(this.id); if (model == null) { JscriptMsg("信息不存在或已被删除!", "back"); return; } txtcompany_id.Text = model.company_id + ""; txtlogo.Text = model.logo + ""; txttitle.Text = model.title + ""; txtvideo_url.Text = model.video_url + ""; txtvideo_thumb_img.Text = model.video_thumb_img + ""; txtdetails.Text = model.details + ""; txtis_show.Text = model.is_show + ""; txtsort.Text = model.sort + ""; txtadd_time.Text = model.add_time + ""; }
private bool DoEdit() { BLL.company_partner bll = new BLL.company_partner(); Model.company_partner model = bll.GetModel(this.id); model.logo = Convert.ToString(txtlogo.Text); model.title = Convert.ToString(txttitle.Text); model.video_url = Convert.ToString(txtvideo_url.Text); model.details = ""; model.is_show = Convert.ToInt32(this.rbtnIsShow.SelectedValue); model.sort = Convert.ToInt32(txtsort.Text); if (bll.Update(model)) { AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改合作伙伴信息,主键:" + id); //记录日志 return(true); } return(false); }
private bool DoAdd() { Model.company_partner model = new Model.company_partner(); BLL.company_partner bll = new BLL.company_partner(); model.company_id = 0; model.logo = Convert.ToString(txtlogo.Text); model.title = Convert.ToString(txttitle.Text); model.video_url = Convert.ToString(txtvideo_url.Text); model.details = ""; model.is_show = Convert.ToInt32(this.rbtnIsShow.SelectedValue); model.sort = Convert.ToInt32(txtsort.Text); model.add_time = System.DateTime.Now; int id = bll.Add(model); if (id > 0) { AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加合作伙伴信息,主键:" + id); //记录日志 return(true); } return(false); }
//保存 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevel("_ybd_company_partner", EnumCollection.ActionEnum.Add.ToString()); //检查权限 #region string strError = string.Empty; if (txtcompany_id.Text.Trim() == "" || txtcompany_id.Text.Trim().Length > 4) { strError += "公司id为空或超出长度![br]"; } if (txtlogo.Text.Trim() == "" || txtlogo.Text.Trim().Length > 255) { strError += "logo为空或超出长度![br]"; } if (txttitle.Text.Trim() == "" || txttitle.Text.Trim().Length > 50) { strError += "标题为空或超出长度![br]"; } if (txtvideo_url.Text.Trim() == "" || txtvideo_url.Text.Trim().Length > 255) { strError += "视频地址为空或超出长度![br]"; } if (txtvideo_thumb_img.Text.Trim() == "" || txtvideo_thumb_img.Text.Trim().Length > 255) { strError += "视频缩略图地址为空或超出长度![br]"; } if (txtdetails.Text.Trim() == "" || txtdetails.Text.Trim().Length > 16) { strError += "案例详情为空或超出长度![br]"; } if (txtis_show.Text.Trim() == "" || txtis_show.Text.Trim().Length > 4) { strError += "是否显示为空或超出长度![br]"; } if (txtsort.Text.Trim() == "" || txtsort.Text.Trim().Length > 4) { strError += "排序为空或超出长度![br]"; } if (txtadd_time.Text.Trim() == "" || txtadd_time.Text.Trim().Length > 8) { strError += "添加时间为空或超出长度![br]"; } if (strError != string.Empty) { JscriptMsg(strError, "", "Error"); return; } #endregion Model.company_partner model = new Model.company_partner(); BLL.company_partner bll = new BLL.company_partner(); model.company_id = Convert.ToInt32(txtcompany_id.Text); model.logo = Convert.ToString(txtlogo.Text); model.title = Convert.ToString(txttitle.Text); model.video_url = Convert.ToString(txtvideo_url.Text); model.video_thumb_img = Convert.ToString(txtvideo_thumb_img.Text); model.details = Convert.ToString(txtdetails.Text); model.is_show = Convert.ToInt32(txtis_show.Text); model.sort = Convert.ToInt32(txtsort.Text); model.add_time = Convert.ToDateTime(txtadd_time.Text); int id = bll.Add(model); if (id > 0) { AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加合作伙伴信息,主键:" + id); //记录日志 JscriptMsg("添加合作伙伴信息成功!", "Manage.aspx", ""); } else { JscriptMsg("保存过程中发生错误!", ""); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.company_partner model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.company_partner model) { return(dal.Add(model)); }