/// <summary> /// 更新一条数据 /// </summary> public bool Update(Dong.Model.ShopInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ShopInfo set "); strSql.Append("Name=@Name,"); strSql.Append("Addr=@Addr,"); strSql.Append("Phone=@Phone"); strSql.Append(" where Id=@Id"); OleDbParameter[] parameters = { new OleDbParameter("@Name", OleDbType.VarChar, 50), new OleDbParameter("@Addr", OleDbType.VarChar, 100), new OleDbParameter("@Phone", OleDbType.VarChar, 50), new OleDbParameter("@Id", OleDbType.Integer, 4) }; parameters[0].Value = model.Name; parameters[1].Value = model.Addr; parameters[2].Value = model.Phone; parameters[3].Value = model.Id; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Dong.Model.ShopInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ShopInfo("); strSql.Append("Name,Addr,Phone)"); strSql.Append(" values ("); strSql.Append("@Name,@Addr,@Phone)"); OleDbParameter[] parameters = { new OleDbParameter("@Name", OleDbType.VarChar, 50), new OleDbParameter("@Addr", OleDbType.VarChar, 100), new OleDbParameter("@Phone", OleDbType.VarChar, 50) }; parameters[0].Value = model.Name; parameters[1].Value = model.Addr; parameters[2].Value = model.Phone; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void frmShop_Load(object sender, EventArgs e) { Dong.BLL.ShopInfo bShop = new Dong.BLL.ShopInfo(); Dong.Model.ShopInfo mShop = new Dong.Model.ShopInfo(); mShop = bShop.GetModel(1); tbShopName.Text = mShop.Name; tbPhone.Text = mShop.Phone; tbAddr.Text = mShop.Addr; }
private void frmLogin_Load(object sender, EventArgs e) { //初始化界面信息 //提取配置信息 Dong.BLL.ShopInfo bShop = new Dong.BLL.ShopInfo(); Dong.Model.ShopInfo mShop = new Dong.Model.ShopInfo(); mShop = bShop.GetModel(1); Dong.Model.GlobalsInfo.shopName = mShop.Name; this.Text = this.Text + " --【" + mShop.Name + "】"; Dong.Model.GlobalsInfo.shopAddr = mShop.Addr; }
private void btnSave_Click(object sender, EventArgs e) { Dong.BLL.ShopInfo bShop = new Dong.BLL.ShopInfo(); Dong.Model.ShopInfo mShop = new Dong.Model.ShopInfo(); mShop.Id = 1; mShop.Name = tbShopName.Text; mShop.Addr = tbAddr.Text; mShop.Phone = tbPhone.Text; if (bShop.Update(mShop)) { DevComponents.DotNetBar.MessageBoxEx.Show("修改成功!"); } else { DevComponents.DotNetBar.MessageBoxEx.Show("操作失败!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void frmLogin_Load(object sender, EventArgs e) { //初始化界面信息 //提取用户列表 DataSet ds = new DataSet(); Dong.BLL.OperInfo mOper = new Dong.BLL.OperInfo(); ds = mOper.GetAllList(); cbUserid.ValueMember = "Code"; cbUserid.DisplayMember = "Code"; cbUserid.DataSource = ds.Tables[0]; //提取配置信息 Dong.BLL.ShopInfo bShop = new Dong.BLL.ShopInfo(); Dong.Model.ShopInfo mShop = new Dong.Model.ShopInfo(); mShop = bShop.GetModel(1); Dong.Model.GlobalsInfo.shopName = mShop.Name; this.Text = this.Text + " --【" + mShop.Name + "】"; tbPwd.Text = "1001"; Dong.Model.GlobalsInfo.shopAddr = mShop.Addr; }
/// <summary> /// 得到一个对象实体 /// </summary> public Dong.Model.ShopInfo DataRowToModel(DataRow row) { Dong.Model.ShopInfo model = new Dong.Model.ShopInfo(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["Addr"] != null) { model.Addr = row["Addr"].ToString(); } if (row["Phone"] != null) { model.Phone = row["Phone"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Dong.Model.ShopInfo GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,Name,Addr,Phone from ShopInfo "); strSql.Append(" where Id=@Id"); OleDbParameter[] parameters = { new OleDbParameter("@Id", OleDbType.Integer, 4) }; parameters[0].Value = Id; Dong.Model.ShopInfo model = new Dong.Model.ShopInfo(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }