/// <summary>
/// 新增支出登帐信息
/// </summary>
/// <param name="model">支出登帐信息实体</param>
/// <returns>返回1成功，其他失败</returns>
public int AddSpendRegister(EyouSoft.Model.FinanceStructure.MSpendRegister model)
{
if (model == null)
{
return(0);
}
return(dal.AddSpendRegister(model));
}
/// <summary>
/// 新增支出登帐信息
/// </summary>
/// <param name="model">支出登帐信息实体</param>
/// <returns>返回1成功，其他失败</returns>
public int AddSpendRegister(EyouSoft.Model.FinanceStructure.MSpendRegister model)
{
if (model == null)
{
return(0);
}
DbCommand dc = _db.GetSqlStringCommand(Sql_SpendRegister_Insert);
_db.AddInParameter(dc, "CompanyId", DbType.Int32, model.CompanyId);
_db.AddInParameter(dc, "PayTime", DbType.DateTime, model.PayTime);
_db.AddInParameter(dc, "PayType", DbType.Byte, (int)model.PayType);
_db.AddInParameter(dc, "Amount", DbType.Decimal, model.Amount);
_db.AddInParameter(dc, "SupplierId", DbType.Int32, model.SupplierId);
_db.AddInParameter(dc, "SupplierName", DbType.String, model.SupplierName);
_db.AddInParameter(dc, "Realname", DbType.String, model.Realname);
_db.AddInParameter(dc, "Telephone", DbType.String, model.Telephone);
_db.AddInParameter(dc, "Remark", DbType.String, model.Remark);
_db.AddInParameter(dc, "RegisterTime", DbType.DateTime, model.RegisterTime);
_db.AddInParameter(dc, "OperatorId", DbType.Int32, model.OperatorId);
_db.AddInParameter(dc, "OffAmount", DbType.Decimal, model.OffAmount);
return(DbHelper.ExecuteSql(dc, _db) > 0 ? 1 : 0);
}
/// <summary>
/// 获取支出登帐信息
/// </summary>
/// <param name="model">支出登帐信息查询实体</param>
/// <param name="HaveUserIds">用户Id集合，半角逗号分割</param>
/// <param name="PageSize">每页条数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">总记录数</param>
/// <returns></returns>
public IList <EyouSoft.Model.FinanceStructure.MSpendRegister> GetList(EyouSoft.Model.FinanceStructure.MQuerySpendRegister model, string HaveUserIds, int PageSize, int PageIndex, ref int RecordCount)
{
if (model == null || model.CompanyId <= 0)
{
return(null);
}
IList <EyouSoft.Model.FinanceStructure.MSpendRegister> list = new List <EyouSoft.Model.FinanceStructure.MSpendRegister>();
string strFiles = " [RegisterId],[CompanyId],[PayTime],[Amount],[PayType],[SupplierId],[SupplierName],[Realname],[Telephone],[Remark],[RegisterTime],[OperatorId],[OffAmount] ";
string strOrder = string.Empty;
string strWhere = this.GetSqlWhere(model, HaveUserIds, ref strOrder);
using (IDataReader dr = DbHelper.ExecuteReader(_db, PageSize, PageIndex, ref RecordCount, "tbl_CashierRegister", "ID", strFiles, strWhere, strOrder))
{
EyouSoft.Model.FinanceStructure.MSpendRegister tmpModel = null;
while (dr.Read())
{
tmpModel = new EyouSoft.Model.FinanceStructure.MSpendRegister();
if (!dr.IsDBNull(dr.GetOrdinal("RegisterId")))
{
tmpModel.RegisterId = dr.GetInt32(dr.GetOrdinal("RegisterId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CompanyId")))
{
tmpModel.CompanyId = dr.GetInt32(dr.GetOrdinal("CompanyId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("PayTime")))
{
tmpModel.PayTime = dr.GetDateTime(dr.GetOrdinal("PayTime"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Amount")))
{
tmpModel.Amount = dr.GetDecimal(dr.GetOrdinal("Amount"));
}
if (!dr.IsDBNull(dr.GetOrdinal("PayType")))
{
tmpModel.PayType = (EyouSoft.Model.EnumType.TourStructure.RefundType)dr.GetInt32(dr.GetOrdinal("PayType"));
}
if (!dr.IsDBNull(dr.GetOrdinal("SupplierId")))
{
tmpModel.SupplierId = dr.GetInt32(dr.GetOrdinal("SupplierId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("SupplierName")))
{
tmpModel.SupplierName = dr.GetString(dr.GetOrdinal("SupplierName"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Realname")))
{
tmpModel.Realname = dr.GetString(dr.GetOrdinal("Realname"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Telephone")))
{
tmpModel.Telephone = dr.GetString(dr.GetOrdinal("Telephone"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Remark")))
{
tmpModel.Remark = dr.GetString(dr.GetOrdinal("Remark"));
}
if (!dr.IsDBNull(dr.GetOrdinal("RegisterTime")))
{
tmpModel.RegisterTime = dr.GetDateTime(dr.GetOrdinal("RegisterTime"));
}
if (!dr.IsDBNull(dr.GetOrdinal("OperatorId")))
{
tmpModel.OperatorId = dr.GetInt32(dr.GetOrdinal("OperatorId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("OffAmount")))
{
tmpModel.OffAmount = dr.GetDecimal(dr.GetOrdinal("OffAmount"));
}
list.Add(tmpModel);
}
}
return(list);
}
