/// <summary> /// 组合成对象实体 /// </summary> /// <param name="row">一行数据</param> /// <returns>Model.plugin_qqonline</returns> private Model.plugin_qqonline DataRowToModel(DataRow row) { Model.plugin_qqonline model = new Model.plugin_qqonline(); if (row != null) { if (null != row["id"] && "" != row["id"].ToString()) { model.id = int.Parse(row["id"].ToString()); } if (null != row["qq"]) { model.qq = row["qq"].ToString(); } if (null != row["username"]) { model.username = row["username"].ToString(); } if (null != row["img_url"]) { model.img_url = row["img_url"].ToString(); } if (null != row["link_url"]) { model.link_url = row["link_url"].ToString(); } if (null != row["is_lock"] && "" != row["is_lock"].ToString()) { model.is_lock = int.Parse(row["is_lock"].ToString()); } if (null != row["sort_id"] && "" != row["sort_id"].ToString()) { model.sort_id = int.Parse(row["sort_id"].ToString()); } if (null != row["color"]) { model.color = row["color"].ToString(); } if (null != row["add_time"] && "" != row["add_time"].ToString()) { model.add_time = DateTime.Parse(row["add_time"].ToString()); } } return(model); }
//赋值操作 private void ShowInfo(int _id) { BLL.plugin_qqonline bll = new BLL.plugin_qqonline(); Model.plugin_qqonline model = bll.GetModel(_id); txtUserName.Text = model.username; txtQQ.Text = model.qq; txtColor.Text = model.color; if (model.is_lock == 0) { cbStatus.Checked = true; } else { cbStatus.Checked = false; } txtSort.Text = model.sort_id.ToString(); txtUrl.Text = model.link_url; rblPicList.SelectedValue = model.img_url; }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">Model.plugin_qqonline</param> /// <returns>True or False</returns> public bool Update(Model.plugin_qqonline model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [" + databaseprefix + "plugin_qqonline] set "); strSql.Append("qq=@qq,"); strSql.Append("username=@username,"); strSql.Append("img_url=@img_url,"); strSql.Append("link_url=@link_url,"); strSql.Append("is_lock=@is_lock,"); strSql.Append("sort_id=@sort_id,"); strSql.Append("color=@color,"); strSql.Append("add_time=@add_time"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@qq", SqlDbType.VarChar, 20), new SqlParameter("@username", SqlDbType.NVarChar, 30), new SqlParameter("@img_url", SqlDbType.NVarChar, 100), new SqlParameter("@link_url", SqlDbType.NVarChar, 200), new SqlParameter("@is_lock", SqlDbType.TinyInt, 1), new SqlParameter("@sort_id", SqlDbType.Int, 4), new SqlParameter("@color", SqlDbType.NVarChar, 20), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.qq; parameters[1].Value = model.username; parameters[2].Value = model.img_url; parameters[3].Value = model.link_url; parameters[4].Value = model.is_lock; parameters[5].Value = model.sort_id; parameters[6].Value = model.color; parameters[7].Value = model.add_time; parameters[8].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } return(false); }
//增加操作 private bool DoAdd() { BLL.plugin_qqonline bll = new BLL.plugin_qqonline(); Model.plugin_qqonline model = new Model.plugin_qqonline(); model.username = txtUserName.Text.Trim(); model.qq = txtQQ.Text.Trim(); model.color = txtColor.Text; if (cbStatus.Checked == false) { model.is_lock = 1; } model.sort_id = Utils.StrToInt(txtSort.Text.Trim(), 99); model.link_url = txtUrl.Text.Trim(); model.img_url = rblPicList.SelectedValue; if (bll.Add(model) > 0) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "添加QQ在线客服:" + model.username); return(true); } return(false); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">Model.plugin_qqonline</param> /// <returns>ID</returns> public int Add(Model.plugin_qqonline model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [" + databaseprefix + "plugin_qqonline]("); strSql.Append("qq,username,img_url,link_url,is_lock,sort_id,color,add_time"); strSql.Append(") values("); strSql.Append("@qq,@username,@img_url,@link_url,@is_lock,@sort_id,@color,@add_time)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@qq", SqlDbType.VarChar, 20), new SqlParameter("@username", SqlDbType.NVarChar, 30), new SqlParameter("@img_url", SqlDbType.NVarChar, 100), new SqlParameter("@link_url", SqlDbType.NVarChar, 200), new SqlParameter("@is_lock", SqlDbType.TinyInt, 1), new SqlParameter("@sort_id", SqlDbType.Int, 4), new SqlParameter("@color", SqlDbType.NVarChar, 20), new SqlParameter("@add_time", SqlDbType.DateTime) }; parameters[0].Value = model.qq; parameters[1].Value = model.username; parameters[2].Value = model.img_url; parameters[3].Value = model.link_url; parameters[4].Value = model.is_lock; parameters[5].Value = model.sort_id; parameters[6].Value = model.color; parameters[7].Value = model.add_time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (null != obj) { return(Convert.ToInt32(obj)); } else { return(0); } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">Model.plugin_qqonline</param> /// <returns>True Or False</returns> public bool Update(Model.plugin_qqonline model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">Model.plugin_qqonline</param> /// <returns>ID</returns> public int Add(Model.plugin_qqonline model) { return(dal.Add(model)); }