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 void Remove(CardInfo value)
{
List.Remove(value);
innerListChanged = true;
}
public void Insert(int index, CardInfo value)
{
List.Insert(index, value);
innerListChanged = 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]);
}
}
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);
}
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);
}
