private void InitializeEdit(CardInfo info) { List<DropItem> listOwner = new List<DropItem>(); List<DropItem> listuser = new List<DropItem>(); listuser.Add(new DropItem { ValueField = "", DisplayField = " " }); this.dropAddBank.DataSource = StaticRescourse.GetBank(); Helper.SetDropDownList(this.dropAddBank); this.dropAddBank.SelectedValue = info.BankId.ToString(); UserCollection userColl = new UserCollection(); //userColl = UserMethods.GetUser(null, null); if (userColl != null && userColl.Count > 0) { foreach (var userInfo in userColl) { listOwner.Add(new DropItem { ValueField = userInfo.Id.ToString(), DisplayField = userInfo.Name }); listuser.Add(new DropItem { ValueField = userInfo.Id.ToString(), DisplayField = userInfo.Name }); } } this.dropAddCardOwner.DataSource = listOwner; Helper.SetDropDownList(this.dropAddCardOwner); this.dropAddCardOwner.SelectedValue=info.OwnerId.ToString(); this.dropAddCardUser.DataSource = listuser; Helper.SetDropDownList(this.dropAddCardUser); this.dropAddCardUser.SelectedValue=info.UserId>0?info.UserId.ToString():string.Empty; this.txtAddCardOpenDate.Text = !string.IsNullOrEmpty(info.OpenDate.ToString("yyyy-MM-dd")) ? info.OpenDate.ToString("yyyy-MM-dd") : string.Empty; this.dropCardAddAccountType.DataSource = StaticRescourse.GetAccountType(); Helper.SetDropDownList(this.dropCardAddAccountType); this.dropCardAddAccountType.SelectedValue = info.AccountType.ToString(); this.txtAddCardNumber.Text = info.CardNumber; this.txtAddBankName.Text = !string.IsNullOrEmpty(info.BankName) ? info.BankName : string.Empty; this.txtCardAddContent.Text = !string.IsNullOrEmpty(info.Content) ? info.Content : string.Empty; }
public static CardInfo GetCardById(int id) { CardInfo cardInfo = new CardInfo(); StringBuilder sb = new StringBuilder(); sb.AppendFormat(" {0} ", "select card.*,a.name as ownerName,b.name as userName from card left join user a on card.ownerId=a.id left join user b on card.userId = b.id where card.id =@Id"); MySqlParameter par = new MySqlParameter("@Id", MySqlDbType.Int32); par.Value = id; using (MySqlDataReader reader = MySqlDBHelper.GetReader(sb.ToString(), par)) { while (reader.Read()) { cardInfo = new CardInfo(reader); } } return cardInfo; }
public static int InsertOrUpdatetoCard(CardInfo info) { int iSuccess = 0; MySqlTransaction mySqlTransaction = null; CardDAL.InsertOrUpdatetoCard(mySqlTransaction,info,out iSuccess); if (iSuccess > 0) { return 1; } else if (iSuccess == -1) { return -1; } else { return 0; } }
/// <summary> /// 根据Code查询用户 /// </summary> /// <param name="cardNumber"></param> /// <returns></returns> public static CardInfo GetCardByCardNumber(string cardNumber, int ownerId) { CardInfo cardInfo = new CardInfo(); StringBuilder sb = new StringBuilder(); sb.Append(" select card.*,a.name as ownerName,b.name as userName from card left join user a on card.ownerId=a.id left join user b on card.userId = b.id where CardNumber = @CardNumber and card.UserId=@UserId"); MySqlParameter[] par = new MySqlParameter[] { new MySqlParameter( "@CardNumber", MySqlDbType.String), new MySqlParameter("@UserId",MySqlDbType.Int32) }; par[0].Value = cardNumber; par[1].Value = ownerId; using (MySqlDataReader reader = MySqlDBHelper.GetReader(sb.ToString(), par)) { while (reader.Read()) { cardInfo = new CardInfo(reader); } } return cardInfo; }
public CardInfo(CardInfo cardInfo) { this.id = cardInfo.Id; this.bankId = cardInfo.BankId; this.cardnumber = cardInfo.CardNumber; this.accountType = cardInfo.AccountType; this.amount = cardInfo.Amount; this.expenditureAmount = cardInfo.ExpenditureAmount; this.borrowAmount = cardInfo.BorrowAmount; this.loanAmount = cardInfo.LoanAmount; this.incomeAmount = cardInfo.IncomeAmount; this.ownerId = cardInfo.OwnerId; this.ownerCode = cardInfo.OwnerCode; this.ownerName = cardInfo.OwnerName; this.userId = cardInfo.UserId; this.userCode = cardInfo.UserCode; this.userName = cardInfo.UserName; this.bankName = cardInfo.BankName; this.openDate = cardInfo.OpenDate; this.content = cardInfo.Content; }
public static void AddTableRow(DataTable table, CardInfo cardInfo) { System.Data.DataRow dr = table.NewRow(); dr["Id"] = cardInfo.id; dr["BankId"] = cardInfo.bankId; dr["Card_Number"] = cardInfo.cardnumber; dr["AccountType"] = cardInfo.accountType; dr["Amount"] = cardInfo.amount; dr["ExpenditureAmount"] = cardInfo.expenditureAmount; dr["BorrowAmount"] = cardInfo.borrowAmount; dr["LoanAmount"] = cardInfo.loanAmount; dr["IncomeAmount"] = cardInfo.incomeAmount; dr["OwnerId"] = cardInfo.ownerId; dr["OwnerCode"] = cardInfo.ownerCode; dr["OwnerName"] = cardInfo.ownerName; dr["UserId"] = cardInfo.userId; dr["UserCode"] = cardInfo.userCode; dr["UserName"] = cardInfo.userName; dr["BankName"] = cardInfo.bankName; dr["OpenDate"] = cardInfo.openDate; dr["Content"] = cardInfo.content; table.Rows.Add(dr); }
protected void btnCardAddS_Click(object sender, EventArgs e) { CardInfo cardInfo = new CardInfo(); this.ClientScript.RegisterStartupScript(this.GetType(), "", "DisplayCardAdddiv();", true); ClearEditForm(); Initialize(cardInfo); }
/// <summary> /// 新增或修改 /// </summary> /// <param name="mySqlTransaction"></param> /// <param name="info"></param> /// <param name="iSuccess"></param> public static void InsertOrUpdatetoCard(MySqlTransaction mySqlTransaction, CardInfo info, out int iSuccess) { StringBuilder sb = new StringBuilder(); CardInfo cardInfo = GetCardByCardNumber(info.CardNumber, info.UserId); if (cardInfo.Id > 0) { sb.Append(" update card set BankId = @BankId,CardNumber = @CardNumber,AccountType = @AccountType,Amount=@Amount,"); sb.Append("ExpenditureAmount = @ExpenditureAmount,BorrowAmount = @BorrowAmount,LoanAmount = @LoanAmount,IncomeAmount = @IncomeAmount,"); sb.Append("OwnerId = @OwnerId,OwnerCode = @OwnerCode,UserId = @UserId,UserCode = @UserCode,BankName = @BankName,OpenDate = @OpenDate,Content=@Content "); sb.Append(" where Id = @Id"); info.Id = cardInfo.Id; info.Amount = cardInfo.Amount; info.ExpenditureAmount = cardInfo.ExpenditureAmount; info.BorrowAmount = cardInfo.BorrowAmount; info.IncomeAmount = cardInfo.IncomeAmount; } else { sb.Append(" insert into card (BankId,CardNumber,AccountType,Amount,ExpenditureAmount,BorrowAmount,LoanAmount,IncomeAmount,OwnerId,OwnerCode,UserId,UserCode,BankName,OpenDate,Content) "); sb.Append(" Values (@BankId,@CardNumber,@AccountType,@Amount,@ExpenditureAmount,@BorrowAmount,@LoanAmount,@IncomeAmount,@OwnerId,@OwnerCode,@UserId,@UserCode,@BankName,@OpenDate,@Content)"); } MySqlParameter[] pars = new MySqlParameter[] { new MySqlParameter("@id",MySqlDbType.Int32), new MySqlParameter("@BankId",MySqlDbType.Int32), new MySqlParameter("@CardNumber",MySqlDbType.String), new MySqlParameter("@AccountType",MySqlDbType.Int32), new MySqlParameter("@Amount",MySqlDbType.Float), new MySqlParameter("@ExpenditureAmount",MySqlDbType.Float), new MySqlParameter("@BorrowAmount",MySqlDbType.Float), new MySqlParameter("@LoanAmount",MySqlDbType.Float), new MySqlParameter("@IncomeAmount",MySqlDbType.Float), new MySqlParameter("@OwnerId",MySqlDbType.Int32), new MySqlParameter("@OwnerCode",MySqlDbType.String), new MySqlParameter("@UserId",MySqlDbType.Int32), new MySqlParameter("@UserCode",MySqlDbType.String), new MySqlParameter("@BankName",MySqlDbType.String), new MySqlParameter("@OpenDate",MySqlDbType.DateTime), new MySqlParameter("@Content",MySqlDbType.String), }; pars[0].Value = info.Id; pars[1].Value = info.BankId; pars[2].Value = info.CardNumber; pars[3].Value = info.AccountType; pars[4].Value = info.Amount; pars[5].Value = info.ExpenditureAmount; pars[6].Value = info.BorrowAmount; pars[7].Value = info.LoanAmount; pars[8].Value = info.IncomeAmount; pars[9].Value = info.OwnerId; pars[10].Value = info.OwnerCode; pars[11].Value = info.UserId; pars[12].Value = info.UserCode; pars[13].Value = info.BankName; pars[14].Value = info.OpenDate; pars[15].Value = info.Content; iSuccess = MySqlDBHelper.ExecuteCommand(mySqlTransaction, sb.ToString(), pars); if (cardInfo.Id > 0) { iSuccess = -1; } }
public void Remove(CardInfo value) { List.Remove(value); innerListChanged = true; }
public void Insert(int index, CardInfo value) { List.Insert(index, value); innerListChanged = true; }
public int Add(CardInfo value) { return this.List.Add(value); }
protected void btnCardAddSave_Click(object sender, EventArgs e) { #region 验证 if (string.IsNullOrEmpty(this.txtAddCardNumber.Text.Trim())) { Alert.Show(this, "请输入卡号!"); this.txtAddCardNumber.Focus(); return; } if (string.IsNullOrEmpty(this.txtAddCardOpenDate.Text.Trim())) { Alert.Show(this, "开户日期不能为空!"); this.txtAddCardOpenDate.Focus(); return; } #endregion CardInfo cardInfo = new CardInfo(); cardInfo.BankId = Convert.ToInt32(this.dropAddBank.SelectedValue); cardInfo.CardNumber = this.txtAddCardNumber.Text.Trim(); cardInfo.AccountType = Convert.ToInt32(this.dropCardAddAccountType.SelectedValue); cardInfo.OwnerId = Convert.ToInt32(this.dropAddCardOwner.SelectedValue); cardInfo.OwnerCode = UserMethods.GetUserById(Convert.ToInt32(this.dropAddCardOwner.SelectedValue)).Code; if (!string.IsNullOrEmpty(this.dropAddCardUser.SelectedValue)) { cardInfo.UserId = Convert.ToInt32(this.dropAddCardUser.SelectedValue); cardInfo.UserCode = UserMethods.GetUserById(Convert.ToInt32(this.dropAddCardUser.SelectedValue)).Code; } else { cardInfo.UserId = 0; cardInfo.UserCode = string.Empty; } cardInfo.BankName = this.txtAddBankName.Text.Trim(); cardInfo.OpenDate = Convert.ToDateTime(this.txtAddCardOpenDate.Text.Trim()); cardInfo.Content = this.txtCardAddContent.Text.Trim(); int i = CardMethods.InsertOrUpdatetoCard(cardInfo); if (i > 0) { this.ClientScript.RegisterStartupScript(this.GetType(), "", "closeWin();", true); } }
public int IndexOf(CardInfo value) { for (int i = 0, count = this.List.Count; i < count; i++) { if (value.Equals(this.List[i] as CardInfo)) return i; } return -1; }
public void CopyTo(CardInfo[] array, int index) { this.List.CopyTo(array, index); }
public bool Contains(CardInfo value) { if (IndexOf(value) > -1) return true; return false; }
public void AddRange(CardInfo[] value) { for (int i = 0; (i < value.Length); i++) { this.Add(value[i]); } }
private void Initialize(CardInfo info) { List<DropItem> listUser = new List<DropItem>(); UserCollection userColl = new UserCollection(); UserInfo loginInfo = new UserInfo(); if (Session["UserCode"] != null) { loginInfo = UserMethods.GetUserByCode(Session["UserCode"].ToString()); } userColl = UserMethods.GetUser(new List<QueryElement>()); if (userColl != null && userColl.Count > 0) { foreach (var userInfo in userColl) { listUser.Add(new DropItem { ValueField = userInfo.Id.ToString(), DisplayField = userInfo.Name }); } } this.dropAddBank.DataSource = StaticRescourse.GetBank(); Helper.SetDropDownList(this.dropAddBank); this.dropAddCardOwner.DataSource = listUser; Helper.SetDropDownList(this.dropAddCardOwner); this.dropAddCardUser.DataSource = listUser; Helper.SetDropDownList(this.dropAddCardUser); this.dropCardAddAccountType.DataSource = StaticRescourse.GetAccountType(); Helper.SetDropDownList(this.dropCardAddAccountType); if (info.Id > 0) { string str =info.OpenDate.ToString("yyyy-MM-dd"); int date = Convert.ToInt32(str.Substring(0,4)+str.Substring(5,2)+str.Substring(8,2)); this.dropAddBank.SelectedValue = info.BankId.ToString(); this.dropAddCardOwner.SelectedValue = info.OwnerId.ToString(); this.dropAddCardUser.SelectedValue = info.UserId.ToString(); this.dropCardAddAccountType.SelectedValue = info.AccountType.ToString(); this.txtAddCardNumber.Text = info.CardNumber; this.txtCardAddContent.Text = !string.IsNullOrEmpty(info.Content) ? info.Content : string.Empty; this.txtAddBankName.Text = !string.IsNullOrEmpty(info.BankName) ? info.BankName : string.Empty; this.txtAddCardOpenDate.Text = date > 20000101 ? info.OpenDate.ToString("yyyy-MM-dd") : string.Empty; this.txtAddCardNumber.Enabled = false; this.dropAddBank.Enabled = false; this.dropCardAddAccountType.Enabled = false; } else { this.txtAddCardNumber.Enabled = true; this.dropAddBank.Enabled = true; this.dropCardAddAccountType.Enabled = true; this.dropAddBank.SelectedIndex = 0; this.dropCardAddAccountType.SelectedIndex = 0; //this.dropAddCardOwner.SelectedValue = loginInfo.Id.ToString(); //this.dropAddCardUser.SelectedValue = loginInfo.Id.ToString(); this.txtAddCardOpenDate.Text = DateTime.Now.ToString("yyyy-MM-dd"); } }
/// <summary> /// Constructor using CcZlCzBillInfo array. /// </summary> /// <param name="value" /> public CardCollection(CardInfo[] value) { this.AddRange(value); }
public static int InsertOrUpdatetoCard(CardInfo info) { return CardProxy.InsertOrUpdatetoCard(info); }
public int Add(CardInfo value) { return(this.List.Add(value)); }
private void CardEditSubmit(ref int i) { this.ClientScript.RegisterStartupScript(this.GetType(), "", "DisplayCardAdddiv();", true); #region 验证 // if (string.IsNullOrEmpty(Request.Form["txtAddCardNumber"].ToString())) if (string.IsNullOrEmpty(this.txtAddCardNumber.Text.Trim())) { Alert.Show(this, "请输入卡号!"); this.txtAddCardNumber.Focus(); return; } if (string.IsNullOrEmpty(this.txtAddCardOpenDate.Text.Trim())) { Alert.Show(this, "开户日期不能为空!"); this.txtAddCardOpenDate.Focus(); return; } #endregion CardInfo cardInfo = new CardInfo(); cardInfo.BankId = Convert.ToInt32(this.dropAddBank.SelectedValue); //cardInfo.CardNumber = Request.Form["txtAddCardNumber"].ToString().Trim(); cardInfo.CardNumber = this.txtAddCardNumber.Text.Trim(); cardInfo.AccountType = Convert.ToInt32(this.dropCardAddAccountType.SelectedValue); cardInfo.OwnerId = Convert.ToInt32(this.dropAddCardOwner.SelectedValue); cardInfo.OwnerCode = UserMethods.GetUserById(Convert.ToInt32(this.dropAddCardOwner.SelectedValue)).Code; if (!string.IsNullOrEmpty(this.dropAddCardUser.SelectedValue)) { cardInfo.UserId = Convert.ToInt32(this.dropAddCardUser.SelectedValue); cardInfo.UserCode = UserMethods.GetUserById(Convert.ToInt32(this.dropAddCardUser.SelectedValue)).Code; } else { cardInfo.UserId = 0; cardInfo.UserCode = string.Empty; } cardInfo.BankName = this.txtAddBankName.Text.Trim(); cardInfo.OpenDate = Convert.ToDateTime(this.txtAddCardOpenDate.Text.Trim()); cardInfo.Content = this.txtCardAddContent.Text.Trim(); i = CardMethods.InsertOrUpdatetoCard(cardInfo); }