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