/// <summary> /// 增加一条数据 /// </summary> public int Add(FishEntity.QuoteProductEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_quoteproduct("); strSql.Append("no,name,brand,nature,remark,companyid)"); strSql.Append(" values ("); strSql.Append("@no,@name,@brand,@nature,@remark,@companyid);"); strSql.Append("select LAST_INSERT_ID();"); MySqlParameter[] parameters = { new MySqlParameter("@no", MySqlDbType.Int32, 11), new MySqlParameter("@name", MySqlDbType.VarChar, 255), new MySqlParameter("@brand", MySqlDbType.VarChar, 255), new MySqlParameter("@nature", MySqlDbType.VarChar, 255), new MySqlParameter("@remark", MySqlDbType.VarChar, 255), new MySqlParameter("@companyid", MySqlDbType.Int32, 11) }; parameters[0].Value = model.no; parameters[1].Value = model.name; parameters[2].Value = model.brand; parameters[3].Value = model.nature; parameters[4].Value = model.remark; parameters[5].Value = model.companyid; int rows = MySqlHelper.ExecuteSqlReturnId(strSql.ToString(), parameters); return(rows); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FishEntity.QuoteProductEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_quoteproduct set "); strSql.Append("no=@no,"); strSql.Append("name=@name,"); strSql.Append("brand=@brand,"); strSql.Append("nature=@nature,"); strSql.Append("remark=@remark,"); strSql.Append("companyid=@companyid"); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@no", MySqlDbType.Int32, 11), new MySqlParameter("@name", MySqlDbType.VarChar, 255), new MySqlParameter("@brand", MySqlDbType.VarChar, 255), new MySqlParameter("@nature", MySqlDbType.VarChar, 255), new MySqlParameter("@remark", MySqlDbType.VarChar, 255), new MySqlParameter("@companyid", MySqlDbType.Int32, 11), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.no; parameters[1].Value = model.name; parameters[2].Value = model.brand; parameters[3].Value = model.nature; parameters[4].Value = model.remark; parameters[5].Value = model.companyid; parameters[6].Value = model.id; int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public FishEntity.QuoteProductEntity DataRowToModel(DataRow row) // { FishEntity.QuoteProductEntity model = new FishEntity.QuoteProductEntity(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["no"] != null && row["no"].ToString() != "") { model.no = int.Parse(row["no"].ToString()); } if (row["name"] != null) { model.name = row["name"].ToString(); } if (row["brand"] != null) { model.brand = row["brand"].ToString(); } if (row["nature"] != null) { model.nature = row["nature"].ToString(); } if (row["remark"] != null) { model.remark = row["remark"].ToString(); } if (row["companyid"] != null && row["companyid"].ToString() != "") { model.companyid = int.Parse(row["companyid"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public FishEntity.QuoteProductEntity GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,no,name,brand,nature,remark,companyid from t_quoteproduct "); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32) }; parameters[0].Value = id; FishEntity.QuoteProductEntity model = new FishEntity.QuoteProductEntity(); DataSet ds = MySqlHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FishEntity.QuoteProductEntity model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(FishEntity.QuoteProductEntity model) { return(dal.Add(model)); }