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;
}
private void Initialize()
{
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.SelectedIndex = 0;
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.SelectedIndex = 0;
this.dropAddCardUser.DataSource = listuser;
Helper.SetDropDownList(this.dropAddCardUser);
this.dropAddCardUser.SelectedIndex = 0;
this.txtAddCardOpenDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
this.dropCardAddAccountType.DataSource = StaticRescourse.GetAccountType();
Helper.SetDropDownList(this.dropCardAddAccountType);
this.dropCardAddAccountType.SelectedIndex = 0;
}
private void BindDataGrid(List<QueryElement> list)
{
userColl = UserMethods.GetUser(list);
this.UserListDataGrid.DataSource = userColl;
this.UserListDataGrid.DataBind();
for (int i = 0; i < userColl.Count; i++)
{
this.UserListDataGrid.Items[i].Cells[4].Text = StaticRescourse.DisplayRole(userColl[i].Role);
}
}
/// <summary>
/// 根据动态参数查询用户
/// </summary>
/// <param name="strFields"></param>
/// <param name="strValues"></param>
/// <returns></returns>
public static UserCollection GetUser(List<QueryElement> list)
{
StringBuilder sb = new StringBuilder();
UserCollection coll = new UserCollection();
sb.AppendFormat("{0} ","select * from user where 1=1");
if (list.Count > 0)
{
MySqlParameter[] pars = new MySqlParameter[list.Count];
for (int i = 0; i < list.Count; i++)
{
QueryElement query = list[i];
sb.AppendFormat("{0} {1} {2} @{3} ", query.QueryLogic, query.Queryname, query.QueryOperation, query.Queryname);
pars[i] = new MySqlParameter("@" + query.Queryname, query.QueryElementType);
if (query.QueryOperation.Equals("like"))
{
pars[i].Value = "%" + query.Queryvalue + "%";
}
else
{
pars[i].Value = query.Queryvalue;
}
}
using(MySqlDataReader reader=MySqlDBHelper.GetReader(sb.ToString(),pars))
{
while(reader.Read())
{
coll.Add(new UserInfo(reader));
}
}
}
else
{
using(MySqlDataReader reader=MySqlDBHelper.GetReader(sb.ToString()))
{
while(reader.Read())
{
coll.Add(new UserInfo(reader));
}
}
}
return coll;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string[] strfields;
string[] strvalues;
if (Session["userSelectName"] != null && Session["userSelectValue"] != null)
{
strfields = Session["userSelectName"].ToString().Split('¢');
strvalues = Session["userSelectValue"].ToString().Split('¢');
}
else
{
strfields = null;
strvalues = null;
}
userColl = UserMethods.GetUser(strfields, strvalues);
this.UserListDataGrid.DataSource = userColl;
this.UserListDataGrid.DataBind();
}
}
public UserCollection Pagination(int pageIndex, int pageSize)
{
if (InnerList.Count == 0)
{
return(null);
}
int start = pageSize * (pageIndex - 1);
int end = start + pageSize - 1;
if (end > InnerList.Count - 1)
{
end = InnerList.Count - 1;
}
UserCollection pages = new UserCollection();
for (int i = start; i <= end; i++)
{
pages.Add(InnerList[i] as UserInfo);
}
return(pages);
}
public ExpensesCollectionEnumerator(UserCollection mappings)
{
enumerator = ((IEnumerable)mappings).GetEnumerator();
}
public static UserCollection GetUser(List<QueryElement> list)
{
UserCollection coll = new UserCollection();
coll = UserDAL.GetUser(list);
return coll;
}
public static UserCollection GetOwnerByCardNumber(string cardNumber)
{
UserCollection userColl = new UserCollection();
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" {0} ", "SELECT user.* FROM user,card WHERE user.Id=card.OwnerId and CardNumber=@CardNumber");
MySqlParameter par = new MySqlParameter("@CardNumber", MySqlDbType.String);
par.Value = cardNumber;
using (MySqlDataReader reader = MySqlDBHelper.GetReader(sb.ToString(), par))
{
while (reader.Read())
{
userColl.Add(new UserInfo(reader));
}
}
return userColl;
}
public ExpensesCollectionEnumerator(UserCollection mappings)
{
enumerator = ((IEnumerable)mappings).GetEnumerator();
}
public UserCollection Pagination(int pageIndex, int pageSize)
{
if (InnerList.Count == 0)
return null;
int start = pageSize * (pageIndex - 1);
int end = start + pageSize - 1;
if (end > InnerList.Count - 1)
end = InnerList.Count - 1;
UserCollection pages = new UserCollection();
for (int i = start; i <= end; i++)
{
pages.Add(InnerList[i] as UserInfo);
}
return pages;
}
public void AddRange(UserCollection value)
{
for (int i = 0; (i < value.Count); i++)
{
this.Add(value.List[i] as UserInfo);
}
}
private void InitializeQuery()
{
List<DropItem> listQueryAccountType = new List<DropItem>();
List<DropItem> listBank = new List<DropItem>();
List<DropItem> listUser = new List<DropItem>();
UserCollection userColl = new UserCollection();
DropItem dr = new DropItem { ValueField = "", DisplayField = " " };
listQueryAccountType.Add(dr);
listQueryAccountType.AddRange(StaticRescourse.GetAccountType());
this.dropCardQueryAccountType.DataSource = listQueryAccountType;
Helper.SetDropDownList(this.dropCardQueryAccountType);
this.dropCardQueryAccountType.SelectedValue = string.Empty;
listBank.Add(dr);
listBank.AddRange(StaticRescourse.GetBank());
this.dropCardQueryBank.DataSource = listBank;
Helper.SetDropDownList(this.dropCardQueryBank);
this.dropCardQueryBank.SelectedValue = string.Empty;
userColl = UserMethods.GetUser(new List<QueryElement>());
if (userColl != null && userColl.Count > 0)
{
listUser.Add(dr);
foreach (var userInfo in userColl)
{
listUser.Add(new DropItem { ValueField = userInfo.Id.ToString(), DisplayField = userInfo.Name });
}
this.dropCardQueryUser.DataSource = listUser;
}
this.dropCardQueryUser.DataSource = listUser;
Helper.SetDropDownList(this.dropCardQueryUser);
this.dropCardQueryUser.SelectedValue = string.Empty;
this.txtCardQueryCardNumber.Text = string.Empty;
this.txtCardQueryBankName.Text = string.Empty;
this.txtCardQueryBOpenDate.Text = string.Empty;
this.txtCardQueryEOpenDate.Text = string.Empty;
}
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");
}
}
