/// <summary> /// 修改保险 /// </summary> /// <param name="item"></param> /// <returns>true:成功 false:失败</returns> public bool Update(MComInsurance item) { string sql = "UPDATE tbl_ComInsurance SET InsuranceName= @InsuranceName,UnitPrice = @UnitPrice WHERE InsuranceId = @InsuranceId AND CompanyId = @CompanyId"; DbCommand comm = this._db.GetSqlStringCommand(sql); this._db.AddInParameter(comm, "@InsuranceName", DbType.String, item.InsuranceName); this._db.AddInParameter(comm, "@UnitPrice", DbType.Decimal, item.UnitPrice); this._db.AddInParameter(comm, "@InsuranceId", DbType.AnsiStringFixedLength, item.InsuranceId); this._db.AddInParameter(comm, "@CompanyId", DbType.AnsiStringFixedLength, item.CompanyId); int result = DbHelper.ExecuteSql(comm, this._db); return(result > 0 ? true : false); }
/// <summary> /// 添加保险 /// </summary> /// <param name="item"></param> /// <returns>true:成功 false:失败</returns> public bool Add(MComInsurance item) { string sql = "INSERT INTO tbl_ComInsurance(CompanyId,InsuranceId,InsuranceName,UnitPrice) VALUES(@CompanyId,@InsuranceId,@InsuranceName,@UnitPrice)"; DbCommand comm = this._db.GetSqlStringCommand(sql); this._db.AddInParameter(comm, "@CompanyId", DbType.AnsiStringFixedLength, item.CompanyId); this._db.AddInParameter(comm, "@InsuranceId", DbType.AnsiStringFixedLength, System.Guid.NewGuid().ToString()); this._db.AddInParameter(comm, "@InsuranceName", DbType.String, item.InsuranceName); this._db.AddInParameter(comm, "@UnitPrice", DbType.Decimal, item.UnitPrice); int result = DbHelper.ExecuteSql(comm, this._db); return(result > 0 ? true : false); }
/// <summary> /// 获取保险实体 /// </summary> /// <param name="InsuranceId">保险编号</param> /// <returns></returns> public MComInsurance GetModel(string InsuranceId) { string sql = "SELECT * FROM tbl_ComInsurance WHERE InsuranceId = @InsuranceId"; DbCommand comm = this._db.GetSqlStringCommand(sql); this._db.AddInParameter(comm, "@InsuranceId", DbType.AnsiStringFixedLength, InsuranceId); MComInsurance model = null; using (IDataReader reader = DbHelper.ExecuteReader(comm, this._db)) { while (reader.Read()) { model = new MComInsurance() { CompanyId = reader["CompanyId"].ToString(), InsuranceId = reader["InsuranceId"].ToString(), InsuranceName = reader["InsuranceName"].ToString(), UnitPrice = reader.IsDBNull(reader.GetOrdinal("UnitPrice")) ? 0 : reader.GetDecimal(reader.GetOrdinal("UnitPrice")) }; } } return(model); }
/// <summary> /// 修改保险 /// </summary> /// <param name="item"></param> /// <returns>true:成功 false:失败</returns> public bool Update(MComInsurance item) { return(dal.Update(item)); }
/// <summary> /// 添加保险 /// </summary> /// <param name="item"></param> /// <returns>true:成功 false:失败</returns> public bool Add(MComInsurance item) { return(dal.Add(item)); }