public static BorrowORLoanViewInfo BuildBorrowORLoanViewInfo(BorrowORLoanInfo info) { BorrowORLoanViewInfo viewInfo = new BorrowORLoanViewInfo(); viewInfo.Id = info.Id; viewInfo.Lender = info.Lender; viewInfo.LoanAccount = info.LoanAccount; if (info.ReturnDate.CompareTo(new DateTime(2001, 1, 1)) > 0) { viewInfo.ReturnDate = info.ReturnDate.ToString("yyyy-MM-dd"); } if (info.HappenedDate.CompareTo(new DateTime(2001, 1, 1)) > 0) { viewInfo.HappenedDate = info.HappenedDate.ToString("yyyy-MM-dd"); } viewInfo.Status = info.Status; viewInfo.Amount = info.Amount; viewInfo.BorrowedAccount = info.BorrowedAccount; viewInfo.Borrower = info.Borrower; viewInfo.BorrowORLoan = info.BorrowORLoan; viewInfo.BorrowORLoanAccountId = info.BorrowORLoanAccountId; viewInfo.BorrowORLoanType = info.BorrowORLoanType; viewInfo.Content = info.Content; return viewInfo; }
public BorrowORLoanInfo Get(long id) { if (indexerForPrimaryKeys == null || innerListChanged) { innerListChanged = false; indexerForPrimaryKeys = new Dictionary <string, int>(); for (int i = 0, count = this.List.Count; i < count; i++) { BorrowORLoanInfo borrowInfo = this.List[i] as BorrowORLoanInfo; indexerForPrimaryKeys.Add(string.Concat(borrowInfo.Id.ToString()), i); } } int index; if (indexerForPrimaryKeys.TryGetValue(string.Concat(id.ToString()), out index)) { return(this.List[index] as BorrowORLoanInfo); } else { return(null); } }
public bool Contains(BorrowORLoanInfo value) { if (IndexOf(value) > -1) { return(true); } return(false); }
public int IndexOf(BorrowORLoanInfo value) { for (int i = 0, count = this.List.Count; i < count; i++) { if (value.Equals(this.List[i] as BorrowORLoanInfo)) { return(i); } } return(-1); }
public BorrowORLoanInfo(BorrowORLoanInfo borrowInfo) { this.id = borrowInfo.Id; this.borrowORLoan = borrowInfo.BorrowORLoan; this.borrowORLoanType = borrowInfo.BorrowORLoanType; this.borrowORLoanAccountId = borrowInfo.BorrowORLoanAccountId; this.borrowedAccount = borrowInfo.BorrowedAccount; this.borrower = borrowInfo.Borrower; this.loanAccount = borrowInfo.LoanAccount; this.lender = borrowInfo.Lender; this.amount = borrowInfo.Amount; this.happenedDate = borrowInfo.HappenedDate; this.returnDate = borrowInfo.ReturnDate; this.status = borrowInfo.Status; this.content = borrowInfo.Content; }
public static BorrowORLoanInfo GetLoanById(int id) { BorrowORLoanInfo loanInfo = new BorrowORLoanInfo(); StringBuilder sb = new StringBuilder(); sb.Append(" select * from borrowing where id = @Id "); MySqlParameter par = new MySqlParameter("@Id",MySqlDbType.Int32); par.Value = id; using (MySqlDataReader reader = MySqlDBHelper.GetReader(sb.ToString(), par)) { while (reader.Read()) { loanInfo = new BorrowORLoanInfo(reader); } } return loanInfo; }
public override bool Equals(object obj) { if (!base.Equals(obj)) { return(false); } if (obj == null) { return(false); } if (this.GetType() != obj.GetType()) { return(false); } BorrowORLoanInfo borrowInfo = obj as BorrowORLoanInfo; return(this.id.Equals(borrowInfo.Id)); }
public static void AddTableRow(DataTable table, BorrowORLoanInfo borrowInfo) { System.Data.DataRow dr = table.NewRow(); dr["Id"] = borrowInfo.id; dr["BorrowORLoan"] = borrowInfo.borrowORLoan; dr["BorrowORLoanType"] = borrowInfo.borrowORLoanType; dr["BorrowORLoanAccountId"] = borrowInfo.borrowORLoanAccountId; dr["BorrowedAccount"] = borrowInfo.borrowedAccount; dr["Borrower"] = borrowInfo.borrower; dr["LoanAccount"] = borrowInfo.loanAccount; dr["Lender"] = borrowInfo.lender; dr["Amount"] = borrowInfo.amount; dr["HappenedDate"] = borrowInfo.happenedDate; dr["ReturnDate"] = borrowInfo.returnDate; dr["Status"] = borrowInfo.status; dr["Content"] = borrowInfo.content; table.Rows.Add(dr); }
public static int InsertOrUpdatetoBorrowed(BorrowORLoanInfo info) { int iSuccess = 0; int uSuccess = 0; BorrowORLoanInfo borrowInfo = new BorrowORLoanInfo(); UserInfo userInfo = UserDAL.GetUserByName(info.Borrower); CardInfo cardInfo = CardDAL.GetCardByCardNumber(info.BorrowedAccount, userInfo.Id); if (info.Id > 0) { borrowInfo = BorrowDAL.GetBorrowById(info.Id); } BorrowDAL.InsertOrUpdatetoBorrowed(info, out iSuccess); if (iSuccess > 0 && info.BorrowORLoanType == 2) { float amount = 0; float borrowAmount = 0; if (info.Id > 0) { amount = cardInfo.Amount + (info.Amount - borrowInfo.Amount); borrowAmount = cardInfo.BorrowAmount + (info.Amount - borrowInfo.Amount); } else { amount = cardInfo.Amount + info.Amount; borrowAmount = cardInfo.BorrowAmount + info.Amount; } CardDAL.UpdateCardAmount(amount, borrowAmount, cardInfo.Id, 3, out uSuccess); } if ((iSuccess > 0 && info.Id > 0) && ((info.BorrowORLoanType == 2 && uSuccess > 0) || (info.BorrowORLoanType != 2 && uSuccess == 0))) { return 2; } else if ((iSuccess > 0 && info.Id == 0) && ((info.BorrowORLoanType == 2 && uSuccess > 0) || (info.BorrowORLoanType != 2 && uSuccess == 0))) { return 1; } else { return 0; } }
public static int InsertOrUpdatetoLoan(BorrowORLoanInfo info) { int iSuccess = 0; int uSuccess = 0; BorrowORLoanInfo loanInfo = new BorrowORLoanInfo(); UserInfo userInfo = UserDAL.GetUserByName(info.Lender); CardInfo cardInfo = CardDAL.GetCardByCardNumber(info.LoanAccount, userInfo.Id); if (info.Id > 0) { loanInfo = LoanDAL.GetLoanById(info.Id); } LoanDAL.InsertOrUpdatetoLoan(info, out iSuccess); if (iSuccess > 0 && info.BorrowORLoanType == 2) { float amount = 0; float loanAmount = 0; if (info.Id > 0) { amount = cardInfo.Amount + (info.Amount - loanInfo.Amount); loanAmount = cardInfo.Amount + (info.Amount - loanInfo.Amount); } else { amount = cardInfo.Amount + info.Amount; loanAmount = cardInfo.Amount + info.Amount; } CardDAL.UpdateCardAmount(amount, loanAmount, cardInfo.Id, 4, out uSuccess); } if ((iSuccess > 0 && info.Id > 0) && ((info.BorrowORLoanType == 2 && uSuccess > 0) || (info.BorrowORLoanType != 2 && uSuccess == 0))) { return 2; } else if ((iSuccess > 0 && info.Id == 0) && ((info.BorrowORLoanType == 2 && uSuccess > 0) || (info.BorrowORLoanType != 2 && uSuccess == 0))) { return 1; } else { return 0; } }
public void Remove(BorrowORLoanInfo value) { List.Remove(value); innerListChanged = true; }
public int IndexOf(BorrowORLoanInfo value) { for (int i = 0, count = this.List.Count; i < count; i++) { if (value.Equals(this.List[i] as BorrowORLoanInfo)) return i; } return -1; }
public void Insert(int index, BorrowORLoanInfo value) { List.Insert(index, value); innerListChanged = true; }
public bool Contains(BorrowORLoanInfo value) { if (IndexOf(value) > -1) return true; return false; }
public void CopyTo(BorrowORLoanInfo[] array, int index) { this.List.CopyTo(array, index); }
public int Add(BorrowORLoanInfo value) { return this.List.Add(value); }
public void AddRange(BorrowORLoanInfo[] value) { for (int i = 0; (i < value.Length); i++) { this.Add(value[i]); } }
public static int InsertOrUpdatetoLoan(BorrowORLoanInfo info) { return LoanProxy.InsertOrUpdatetoLoan(info); }
public static int InsertOrUpdatetoBorrowed(BorrowORLoanInfo info) { return BorrowProxy.InsertOrUpdatetoBorrowed(info); }
public int Add(BorrowORLoanInfo value) { return(this.List.Add(value)); }
/// <summary> /// Constructor using CcZlCzBillInfo array. /// </summary> /// <param name="value" /> public BorrowORLoanCollection(BorrowORLoanInfo[] value) { this.AddRange(value); }
protected void btnLoanAddSubmit_Click(object sender, EventArgs e) { BorrowORLoanInfo loanInfo = new BorrowORLoanInfo(); if (!string.IsNullOrEmpty(this.HiddenField1.Value.Trim())) { loanInfo.Id = Convert.ToInt32(this.HiddenField1.Value.Trim()); } else { loanInfo.Id = 0; } #region 验证 if (!CheckLoanAddForm()) { string type = this.RadioLoanAddLoanType.SelectedValue; string temp = this.HidderField2.Value; this.ClientScript.RegisterStartupScript(this.GetType(), "fillForm", "DisplayAddLoandiv('" + type + "');fillFormField({loanAccount:'" + temp + "'});", true); return; } #endregion loanInfo.Borrower = this.txtLoanAddBorrower.Text.Trim(); if (this.RadioLoanAddLoanType.SelectedValue == "2" && !string.IsNullOrEmpty(this.HidderField2.Value.Trim())) { string[] s = this.HidderField2.Value.Split(','); CardInfo cardInfo = CardMethods.GetCardById(Convert.ToInt32(s[0])); loanInfo.LoanAccount = cardInfo.CardNumber ; loanInfo.BorrowORLoanAccountId = cardInfo.Id; } loanInfo.Lender = this.txtLoanAddLender.Text.Trim(); loanInfo.BorrowedAccount = this.txtLoanAddBorrowAccount.Text.Trim(); loanInfo.BorrowORLoanType = Convert.ToInt32(this.RadioLoanAddLoanType.SelectedValue); loanInfo.Amount = Convert.ToSingle(this.txtLoanAddLoanAmount.Text.Trim()); loanInfo.HappenedDate = HelperCommon.ConverToDateTime(string.Format("{0:d}", this.txtLoanAddLoanDate.Text.Trim())); if (!string.IsNullOrEmpty(this.txtLoanAddReturnDate.Text.Trim())) { loanInfo.ReturnDate = HelperCommon.ConverToDateTime(string.Format("{0:d}", this.txtLoanAddReturnDate.Text.Trim())); } loanInfo.Status = Convert.ToInt32(this.dropLoanAddStatus.SelectedValue); loanInfo.Content = this.txtLoanAddContent.Text.Trim(); int iSuccess = LoanMethods.InsertOrUpdatetoLoan(loanInfo); this.ClientScript.RegisterStartupScript(this.GetType(), "", "DisplayAddLoandiv();", true); if (iSuccess == 1) { Alert.Show(this, "新增一条收入成功!"); } else if (iSuccess == 2) { Alert.Show(this, "修改成功!"); } else { Alert.Show(this, "操作失败!"); } queryList = new List<QueryElement>(); BindLoanListDataGrid(queryList); }
/// <summary> /// 新增或修改 /// </summary> /// <param name="mySqlTransaction"></param> /// <param name="info"></param> /// <param name="iSuccess"></param> public static void InsertOrUpdatetoLoan(BorrowORLoanInfo info, out int iSuccess) { StringBuilder sb = new StringBuilder(); if (info.Id > 0) { sb.Append(" update borrowing set BorrowORLoanType = @BorrowORLoanType,BorrowORLoanAccountId=@BorrowORLoanAccountId,BorrowedAccount = @BorrowedAccount,LoanAccount=@LoanAccount,"); sb.Append("Lender = @Lender,Amount = @Amount,HappenedDate = @HappenedDate,ReturnDate = @ReturnDate,Status=@Status,Content = @Content "); sb.Append(" where Id = @Id "); } else { sb.Append(" insert into borrowing (borrowORLoan,BorrowORLoanType,BorrowORLoanAccountId,BorrowedAccount,Borrower,LoanAccount,Lender,Amount,HappenedDate,ReturnDate,Status,Content) "); sb.Append(" Values (@borrowORLoan,@BorrowORLoanType,@BorrowORLoanAccountId,@BorrowedAccount,@Borrower,@LoanAccount,@Lender,@Amount,@HappenedDate,@ReturnDate,@Status,@Content) "); } MySqlParameter[] pars = new MySqlParameter[] { new MySqlParameter("@Id",MySqlDbType.Int32), new MySqlParameter("@borrowORLoan",MySqlDbType.Int32), new MySqlParameter("@BorrowORLoanType",MySqlDbType.Int32), new MySqlParameter("@BorrowORLoanAccountId",MySqlDbType.Int32), new MySqlParameter("@BorrowedAccount",MySqlDbType.String), new MySqlParameter("@Borrower",MySqlDbType.String), new MySqlParameter("@LoanAccount",MySqlDbType.String), new MySqlParameter("@Lender",MySqlDbType.String), new MySqlParameter("@Amount",MySqlDbType.Float), new MySqlParameter("@HappenedDate",MySqlDbType.DateTime), new MySqlParameter("@ReturnDate",MySqlDbType.DateTime), new MySqlParameter("@Status",MySqlDbType.Int32), new MySqlParameter("@Content",MySqlDbType.String) }; pars[0].Value = info.Id; pars[1].Value = 2; pars[2].Value = info.BorrowORLoanType; pars[3].Value = info.BorrowORLoanAccountId; pars[4].Value = info.BorrowedAccount; pars[5].Value = info.Borrower; pars[6].Value = info.LoanAccount; pars[7].Value = info.Lender; pars[8].Value = info.Amount; pars[9].Value = info.HappenedDate; pars[10].Value = info.ReturnDate; pars[11].Value = info.Status; pars[12].Value = info.Content; iSuccess = MySqlDBHelper.ExecuteCommand(sb.ToString(), pars); }