/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.outlet model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "outlet("); strSql.Append("name,provinces,city,area,street,address,mobile,addtime,x_zb,y_zb,img,busintime,Linkman,WeChat,Other,userId)"); strSql.Append(" values ("); strSql.Append("@name,@provinces,@city,@area,@street,@address,@mobile,@addtime,@x_zb,@y_zb,@img,@busintime,@Linkman,@WeChat,@Other,@userId)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.VarChar, 100), new SqlParameter("@provinces", SqlDbType.VarChar, 100), new SqlParameter("@city", SqlDbType.VarChar, 100), new SqlParameter("@area", SqlDbType.VarChar, 100), new SqlParameter("@street", SqlDbType.VarChar, 100), new SqlParameter("@address", SqlDbType.NVarChar, 500), new SqlParameter("@mobile", SqlDbType.VarChar, 20), new SqlParameter("@addtime", SqlDbType.DateTime), new SqlParameter("@x_zb", SqlDbType.VarChar, 50), new SqlParameter("@y_zb", SqlDbType.VarChar, 50), new SqlParameter("@img", SqlDbType.VarChar, 100), new SqlParameter("@busintime", SqlDbType.NVarChar, 50), new SqlParameter("@Linkman", SqlDbType.NVarChar, 100), new SqlParameter("@WeChat", SqlDbType.NVarChar, 100), new SqlParameter("@Other", SqlDbType.NVarChar, 100), new SqlParameter("@userId", SqlDbType.Int), new SqlParameter("@ReturnValue", SqlDbType.Int) }; parameters[0].Value = model.name; parameters[1].Value = model.provinces; parameters[2].Value = model.city; parameters[3].Value = model.area; parameters[4].Value = model.street; parameters[5].Value = model.address; parameters[6].Value = model.mobile; parameters[7].Value = model.addtime; parameters[8].Value = model.x_zb; parameters[9].Value = model.y_zb; parameters[10].Value = model.img; parameters[11].Value = model.busintime; parameters[12].Value = model.Linkman; parameters[13].Value = model.WeChat; parameters[14].Value = model.Other; parameters[15].Value = model.userId; parameters[16].Direction = ParameterDirection.Output; List <CommandInfo> sqllist = new List <CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return((int)parameters[16].Value); }
private bool DoEdit(int _id) { bool result = false; Model.outlet model = new Model.outlet(); BLL.outlet bll = new BLL.outlet(); if (this.provinces1.Value == "所在省份") { JscriptMsg("请选择省份!", "", "Error"); return(result); } model.id = _id; model.provinces = this.provinces1.Value; model.city = this.city1.Value; model.area = this.area1.Value; model.street = txtaddress.Text; model.address = provinces1.Value + city1.Value + area1.Value + txtaddress.Text; //model.provinces = provinces.Items[provinces.SelectedIndex].Text; //model.city = city.Items[city.SelectedIndex].Text; //model.area = area.Items[area.SelectedIndex].Text; //model.address = provinces.Items[provinces.SelectedIndex].Text + city.Items[city.SelectedIndex].Text + area.Items[area.SelectedIndex].Text + txtaddress.Text; model.name = txtTitle.Text; model.img = txtImgUrl.Text; model.busintime = busintime.Text; model.mobile = txtmobile.Text; model.x_zb = txtX.Text.ToString(); model.y_zb = txtY.Text.ToString(); model.Linkman = TextLinkman.Text; model.WeChat = TextWeChat.Text; model.Other = TextOther.Text; model.userId = Convert.ToInt32(DropDownList1.SelectedItem.Value); if (bll.Update(model)) { //开始生成缩略图咯 //AddAdminLog(Vincent._DTcms.DTEnums.ActionEnum.Add.ToString(), "添加" + this.channel_name + "频道内容:" + model.title); //记录日志 result = true; } return(result); }
/*#region 绑定类别================================= * private void TreeBind(int _channel_id) * { * BLL.article_category bll = new BLL.article_category(); * DataTable dt = bll.GetList(0, _channel_id); * * this.ddlCategoryId.Items.Clear(); * this.ddlCategoryId.Items.Add(new ListItem("请选择类别...", "")); * foreach (DataRow dr in dt.Rows) * { * string Id = dr["id"].ToString(); * int ClassLayer = int.Parse(dr["class_layer"].ToString()); * string Title = dr["title"].ToString().Trim(); * * if (ClassLayer == 1) * { * this.ddlCategoryId.Items.Add(new ListItem(Title, Id)); * } * else * { * Title = "├ " + Title; * Title = Vincent._DTcms.Utils.StringOfChar(ClassLayer - 1, " ") + Title; * this.ddlCategoryId.Items.Add(new ListItem(Title, Id)); * } * } * } #endregion*/ #region 赋值操作================================= private void ShowInfo(int _id) { BLL.outlet bll = new BLL.outlet(); Model.outlet model = bll.GetModel(_id); provinces.Value = model.provinces; provinces1.Value = model.provinces; city.Value = model.city; city1.Value = model.city; area.Value = model.area; area1.Value = model.area; txtaddress.Text = model.street;//详细地址 txtTitle.Text = model.name; txtImgUrl.Text = model.img; busintime.Text = model.busintime; txtmobile.Text = model.mobile; txtX.Text = model.x_zb.ToString(); txtY.Text = model.y_zb.ToString(); TextLinkman.Text = model.Linkman; TextWeChat.Text = model.WeChat; TextOther.Text = model.Other; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.outlet model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "outlet set "); strSql.Append("name=@name,"); strSql.Append("provinces=@provinces,"); strSql.Append("city=@city,"); strSql.Append("area=@area,"); strSql.Append("street=@street,"); strSql.Append("address=@address,"); strSql.Append("mobile=@mobile,"); strSql.Append("addtime=@addtime,"); strSql.Append("x_zb=@x_zb,"); strSql.Append("y_zb=@y_zb,"); strSql.Append("img=@img,"); strSql.Append("Linkman=@Linkman,"); strSql.Append("WeChat=@WeChat,"); strSql.Append("Other=@Other,"); strSql.Append("userId=@userId,"); strSql.Append("busintime=@busintime"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@name", SqlDbType.VarChar, 100), new SqlParameter("@provinces", SqlDbType.VarChar, 100), new SqlParameter("@city", SqlDbType.VarChar, 100), new SqlParameter("@area", SqlDbType.VarChar, 100), new SqlParameter("@street", SqlDbType.VarChar, 100), new SqlParameter("@address", SqlDbType.NVarChar, 500), new SqlParameter("@mobile", SqlDbType.VarChar, 20), new SqlParameter("@addtime", SqlDbType.DateTime), new SqlParameter("@x_zb", SqlDbType.VarChar, 50), new SqlParameter("@y_zb", SqlDbType.VarChar, 50), new SqlParameter("@img", SqlDbType.VarChar, 100), new SqlParameter("@Linkman", SqlDbType.NVarChar, 100), new SqlParameter("@WeChat", SqlDbType.NVarChar, 100), new SqlParameter("@Other", SqlDbType.NVarChar, 100), new SqlParameter("@userId", SqlDbType.Int, 4), new SqlParameter("@busintime", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.id; parameters[1].Value = model.name; parameters[2].Value = model.provinces; parameters[3].Value = model.city; parameters[4].Value = model.area; parameters[5].Value = model.street; parameters[6].Value = model.address; parameters[7].Value = model.mobile; parameters[8].Value = model.addtime; parameters[9].Value = model.x_zb; parameters[10].Value = model.y_zb; parameters[11].Value = model.img; parameters[12].Value = model.Linkman; parameters[13].Value = model.WeChat; parameters[14].Value = model.Other; parameters[15].Value = model.userId; parameters[16].Value = model.busintime; try { int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } } catch (Exception ex) { throw; } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.outlet GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,name,provinces,city,area,street,address,mobile,addtime,x_zb,y_zb,img,busintime,Linkman,WeChat,Other,userId from " + databaseprefix + "outlet "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.outlet model = new Model.outlet(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["name"] != null && ds.Tables[0].Rows[0]["name"].ToString() != "") { model.name = ds.Tables[0].Rows[0]["name"].ToString(); } if (ds.Tables[0].Rows[0]["provinces"] != null && ds.Tables[0].Rows[0]["provinces"].ToString() != "") { model.provinces = ds.Tables[0].Rows[0]["provinces"].ToString(); } if (ds.Tables[0].Rows[0]["city"] != null && ds.Tables[0].Rows[0]["city"].ToString() != "") { model.city = ds.Tables[0].Rows[0]["city"].ToString(); } if (ds.Tables[0].Rows[0]["area"] != null && ds.Tables[0].Rows[0]["area"].ToString() != "") { model.area = ds.Tables[0].Rows[0]["area"].ToString(); } if (ds.Tables[0].Rows[0]["street"] != null && ds.Tables[0].Rows[0]["street"].ToString() != "") { model.street = ds.Tables[0].Rows[0]["street"].ToString(); } if (ds.Tables[0].Rows[0]["address"] != null && ds.Tables[0].Rows[0]["address"].ToString() != "") { model.address = ds.Tables[0].Rows[0]["address"].ToString(); } if (ds.Tables[0].Rows[0]["mobile"] != null && ds.Tables[0].Rows[0]["mobile"].ToString() != "") { model.mobile = ds.Tables[0].Rows[0]["mobile"].ToString(); } if (ds.Tables[0].Rows[0]["addtime"] != null && ds.Tables[0].Rows[0]["addtime"].ToString() != "") { model.addtime = DateTime.Parse(ds.Tables[0].Rows[0]["addtime"].ToString()); } if (ds.Tables[0].Rows[0]["x_zb"] != null && ds.Tables[0].Rows[0]["x_zb"].ToString() != "") { model.x_zb = ds.Tables[0].Rows[0]["x_zb"].ToString(); } if (ds.Tables[0].Rows[0]["y_zb"] != null && ds.Tables[0].Rows[0]["y_zb"].ToString() != "") { model.y_zb = ds.Tables[0].Rows[0]["y_zb"].ToString(); } if (ds.Tables[0].Rows[0]["img"] != null && ds.Tables[0].Rows[0]["img"].ToString() != "") { model.img = ds.Tables[0].Rows[0]["img"].ToString(); } if (ds.Tables[0].Rows[0]["busintime"] != null && ds.Tables[0].Rows[0]["busintime"].ToString() != "") { model.busintime = ds.Tables[0].Rows[0]["busintime"].ToString(); } if (ds.Tables[0].Rows[0]["Linkman"] != null && ds.Tables[0].Rows[0]["Linkman"].ToString() != "") { model.Linkman = ds.Tables[0].Rows[0]["Linkman"].ToString(); } if (ds.Tables[0].Rows[0]["WeChat"] != null && ds.Tables[0].Rows[0]["WeChat"].ToString() != "") { model.WeChat = ds.Tables[0].Rows[0]["WeChat"].ToString(); } if (ds.Tables[0].Rows[0]["Other"] != null && ds.Tables[0].Rows[0]["Other"].ToString() != "") { model.Other = ds.Tables[0].Rows[0]["Other"].ToString(); } if (ds.Tables[0].Rows[0]["userId"] != null && ds.Tables[0].Rows[0]["userId"].ToString() != "") { model.Other = ds.Tables[0].Rows[0]["userId"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.outlet model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.outlet model) { return(dal.Add(model)); }