/// <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));
}
