/// <summary>
/// 保存记账记录
/// </summary>
/// <param name="_entity"></param>
/// <returns></returns>
public bool SaveOutBill(OutBillEntity _entity)
{
int _result = 0;
if (string.IsNullOrEmpty(_entity.SubID) &&
!string.IsNullOrEmpty(_entity.SubContent))
{
_entity.SubID = LoadMaxSubId();
}
if (string.IsNullOrEmpty(_entity.SubID))
{
_entity.SubID = "null";
}
string _sql = string.Format(_insertSql, _entity.OpenId,
_entity.ItemName, _entity.ItemMoney, _entity.ItemDate, _entity.SubID);
_result = DataAccess.ExecNonQuery(_sql);
if (_result <= 0)
{
return(_result > 0);
}
if (!string.IsNullOrEmpty(_entity.SubContent))
{
_sql = string.Format(_subSql, _entity.SubID, _entity.SubContent);
_result = DataAccess.ExecNonQuery(_sql);
}
return(_result > 0);
}
/// <summary>
/// 保存记账记录
/// </summary>
/// <param name="OpenId">用户标识</param>
/// <param name="ItemName">项目名称</param>
/// <param name="ItemMoney">项目金额</param>
/// <param name="ItemDate">记录时间</param>
/// <param name="SubID">备注ID</param>
/// <param name="SubContent">备注内容</param>
/// <returns></returns>
public bool SaveOutBill(string OpenId, string ItemName, string ItemMoney, string ItemDate, string SubID, string SubContent = "")
{
OutBillEntity _entiry = new OutBillEntity();
_entiry.OpenId = OpenId;
_entiry.ItemName = ItemName;
_entiry.ItemMoney = ItemMoney;
_entiry.ItemDate = ItemDate;
_entiry.SubID = SubID;
_entiry.SubContent = SubContent;
return(SaveOutBill(_entiry));
}