/// <summary>
/// 添加账单
/// </summary>
/// <param name="bill"></param>
/// <returns></returns>
public static int BillInsert(Am_Bill bill)
{
using (var conn = GetOpenConnection())
{
var sql = @"INSERT INTO [dbo].[Am_Bill]
([Number],[BillCode],[AmmeterNumber],[AmmeterCode],[F_U_Number],[F_UserName],[F_U_Name],[T_U_Number],[T_UserName],[T_U_Name],[CreateTime],[Status],[StatusStr],[Money],[OtherFees],[SendTime],[PayTime],[Province],[City],[County],[Cell],[Floor],[Room],[Address],[BeginTime],[EndTime],[Remark])
VALUES(@Number ,@BillCode ,@AmmeterNumber ,@AmmeterCode ,@F_U_Number ,@F_UserName ,@F_U_Name ,@T_U_Number ,@T_UserName ,@T_U_Name ,@CreateTime ,@Status ,@StatusStr ,@Money ,@OtherFees ,@SendTime ,@PayTime ,@Province ,@City ,@County ,@Cell ,@Floor ,@Room ,@Address ,@BeginTime ,@EndTime ,@Remark)";
return(conn.Execute(sql, bill));
}
}
/// <summary>
/// 用户押金
/// </summary>
/// <param name="bill"></param>
private void UserDeposit(Am_Bill bill)
{
List <DbParameter> par1 = new List <DbParameter>();
par1.Add(DbFactory.CreateDbParameter("@Bill_Number", bill.Number));
par1.Add(DbFactory.CreateDbParameter("@ChargeItem_Title", "押金"));
var content = database.FindEntityByWhere <Am_BillContent>(" and Bill_Number=@Bill_Number and ChargeItem_Title=@ChargeItem_Title ", par1.ToArray());
if (content != null && content.Number != null)
{
var deposit = new Am_UserDeposit
{
Number = CommonHelper.GetGuid,
Address = bill.Address,
Ammeter_Code = bill.AmmeterCode,
Ammeter_Number = bill.AmmeterNumber,
Cell = bill.Cell,
City = bill.City,
County = bill.County,
CreateTime = DateTime.Now,
Money = content.Money,
Floor = bill.Floor,
PayTime = DateTime.Now,
Province = bill.Province,
Remark = "",
Room = bill.Room,
Status = 0,
StatusStr = "冻结押金",
UserName = bill.T_UserName,
U_Name = bill.T_U_Name,
U_Number = bill.T_U_Number
};
database.Insert <Am_UserDeposit>(deposit);
}
}
