/// <summary>
/// 根据VIPID获得VIP照片
/// </summary>
/// <returns></returns>
public byte[] VipPhotoSelectById(VIPInfo vip)
{
string sql = "VIP_PHOTO_SELECT_BY_ID";
dt = new DataTable();
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@VIPID", SqlDbType.Int)
};
para[0].Value = vip.VipId;
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para))
{
dt.Load(dr);
}
byte[] Photo = (byte[])(dt.Rows[0]["VIPPHOTO"]);
return(Photo);
}
catch (Exception ex)
{
except.ExceptionInsert("查询VIP信息出错：" + ex.Message, "VipSelectById", DateTime.Now);
return(null);
}
}
private void BtnDeleteClick(object vipInfo)
{
this.Invoke(new Action(() =>
{
VIPInfo v = new VIPInfo();
v = vipInfo as VIPInfo;
if (vipBLL.VipDelete(v))
{
MessageBox.Show("删除成功！");
LogInfo logInfo = new LogInfo();
logInfo.UserId = StaticData.userLocal.UserId;
logInfo.Content = "删除了会员‘" + (vipInfo as VIPInfo).VipName + "'";
logInfo.LogTime = DateTime.Now;
logInfo.DpId = StaticData.departLocal.DpId;
bool b = new LogBLL().LogInsert(logInfo);
if (IsNameSelect)
{
btnOK.Enabled = false;
progressBar1.Visible = true;
backgroundWorker2.RunWorkerAsync();
}
else
{
btnOK.Enabled = false;
progressBar1.Visible = true;
backgroundWorker1.RunWorkerAsync();
}
}
else
{
MessageBox.Show("删除失败！");
}
}));
}
private void 除会员ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (lvVip.SelectedItems.Count != 1)
{
MessageBox.Show("请选择一行!");
}
else
{
if (!IsAdmin)
{
MessageBox.Show("您无此权限");
return;
}
DialogResult result = MessageBox.Show("该操作不可逆，请问您确认删除该会员吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.No)
{
return;
}
int id = (lvVip.SelectedItems[0].Tag as VIPInfo).VipId;
string vipName = lvVip.SelectedItems[0].SubItems[3].Text;
VIPInfo vipInfo = new VIPInfo();
vipInfo.VipId = id;
vipInfo.VipName = vipName;
Thread th = new Thread(new ParameterizedThreadStart(BtnDeleteClick));
th.IsBackground = true;
th.Start(vipInfo);
}
}
/// <summary>
/// 检查VIP密码是否正确
/// </summary>
/// <param name="vip"></param>
/// <returns></returns>
public VIPInfo VipCheck(VIPInfo vip)
{
VIPInfo vipTemp = new VIPInfo();
try
{
string sql = "VIP_CHECK";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@VIPNUMBER", SqlDbType.VarChar, 200),
new SqlParameter("@VIPPWD", SqlDbType.VarChar, 50)
};
para[0].Value = vip.VipNumber;
para[1].Value = vip.VipPWD;
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para))
{
while (dr.Read())
{
vipTemp.VipId = (int)dr["VIPID"];
}
}
return(vipTemp);
}
catch (Exception ex)
{
except.ExceptionInsert("查询VIP信息出错：" + ex.Message, "VipCheck", DateTime.Now);
return(null);
}
}
/// <summary>
/// 根据VIPID获得VIP基本信息
/// </summary>
/// <returns></returns>
public VIPInfo VipSelectById_MainPage(VIPInfo vip)
{
string sql = "VIP_SELECT_BY_ID_MAINPAGE";
dt = new DataTable();
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@VIPID", SqlDbType.Int)
};
para[0].Value = vip.VipId;
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para))
{
dt.Load(dr);
}
VIPInfo vipInfo = new VIPInfo();
vipInfo.VipId = vip.VipId;
vipInfo.VipNumber = Convert.ToString(dt.Rows[0]["VIPNUMBER"]);
vipInfo.VipName = Convert.ToString(dt.Rows[0]["VIPNAME"]);
vipInfo.VipAddress = Convert.ToString(dt.Rows[0]["VIPADDRESS"]);
vipInfo.VipPhone = Convert.ToString(dt.Rows[0]["VIPPHONE"]);
return(vipInfo);
}
catch (Exception ex)
{
except.ExceptionInsert("查询VIP信息出错：" + ex.Message, "VipSelectById", DateTime.Now);
return(null);
}
}
public void LoadVipInfoInfo()
{
CsvReader reader = LoadCSVtoPath("UI/VIPInfo");
if (reader == null)
{
return;
}
string[] headers = reader.GetFieldHeaders();
int index_id = System.Array.IndexOf(headers, "id");
int index_cash_purchase_count = System.Array.IndexOf(headers, "cash_purchase_count");
int index_daily_food = System.Array.IndexOf(headers, "daily food");
int index_daily_items = System.Array.IndexOf(headers, "daily items");
while (reader.ReadNextRecord())
{
VIPInfo data = new VIPInfo();
data.Set(reader[index_id], reader[index_cash_purchase_count], reader[index_daily_food], reader[index_daily_items]);
VIPInfoDatas.Add(data);
}
}
private void LoadMember()
{
//根据会员编号和会员电话进行查询
Dictionary <string, string> dic = new Dictionary <string, string>();
if (txtId.Text != "")
{
dic.Add("mid", txtId.Text);
}
if (txtPhone.Text != "")
{
dic.Add("mPhone", txtPhone.Text);
}
VIPInfoBll miBll = new VIPInfoBll();
var list = miBll.GetList(dic);
if (list.Count > 0)
{
//根据信息查到了会员
VIPInfo mi = list[0];
lblMoney.Text = mi.MCount.ToString();
lblTypeTitle.Text = mi.MTypeTitle;
lblDiscount.Text = mi.MDiscount.ToString();
//计算折扣价
lblPayMoneyDiscount.Text =
(Convert.ToDecimal(lblPayMoney.Text) * Convert.ToDecimal(lblDiscount.Text)).ToString();
}
else
{
MessageBox.Show("会员信息有误");
}
}
public AddVipWindow()
{
InitializeComponent();
vipModel = new VIPInfo();
vipBLL = new VipBLL();
vipLVList = new List <VipLevelInfo>();
bg.DoWork += new DoWorkEventHandler(bg_DoWork); //异步操作时要做的操作，一般去查列表，这个列表在本页面内先声明，然后在这个dowork方法里去取数填充他
bg.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); //这个是取数完成后进行的操作，去到数后，这里取用去到的列表绑定到控件
}
public BeforeBorrow(bool isvip, bool isBorrow)
{
InitializeComponent();
isVip = isvip;
vipBLL = new VipBLL();
vipInfo = new VIPInfo();
vipNoBLL = new VipNoBLL();
vipNoInfo = new VipNoInfo();
IsBorrow = isBorrow;
}
public ChangeVipWindow(int vipid)
{
InitializeComponent();
vipId = vipid;
vipBLL = new VipBLL();
levelBLL = new VipLevelBLL();
vipInfo = new VIPInfo();
departBLL = new DepartBLL();
vipInfo.VipId = vipId;
}
public BeforeBorrow(string num, bool isvip, bool isBorrow)
{
InitializeComponent();
txtCard.Text = num;
isVip = isvip;
vipBLL = new VipBLL();
vipInfo = new VIPInfo();
vipNoBLL = new VipNoBLL();
vipNoInfo = new VipNoInfo();
IsBorrow = isBorrow;
}
public VipBorrowWindow(int id)
{
InitializeComponent();
vipInfo = new VIPInfo();
borrowKindBLL = new BorrowKindBLL();
vipBorrowBLL = new VipBorrowBLL();
vipBLL = new VipBLL();
dpBLL = new DepartBLL();
vipInfo.VipId = id;
vipLVBLL = new VipLevelBLL();
vipMoneyBLL = new VipMoneyBLL();
}
/// <summary>
/// VIP添加
/// </summary>
/// <param name="vip"></param>
/// <returns></returns>
public bool VipInsert(VIPInfo vip, double money)
{
int result;
try
{
string sql = "VIP_INSERT";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@VIPNUMBER", SqlDbType.VarChar, 200),
new SqlParameter("@VIPNAME", SqlDbType.VarChar, 50),
new SqlParameter("@VIPSEX", SqlDbType.Bit),
new SqlParameter("@VIPPHOTO", SqlDbType.Image),
new SqlParameter("@VIPLEVELID", SqlDbType.Int),
new SqlParameter("@VIPPWD", SqlDbType.VarChar, 50),
new SqlParameter("@VIPPHONE", SqlDbType.VarChar, 50),
new SqlParameter("@VIPCARD", SqlDbType.VarChar, 200),
new SqlParameter("@VIPBIRTHDAY", SqlDbType.Date),
new SqlParameter("@VIPADDRESS", SqlDbType.VarChar, 200),
new SqlParameter("@DPID", SqlDbType.Int),
new SqlParameter("@ADDDATE", SqlDbType.DateTime),
new SqlParameter("@USERID", SqlDbType.Int),
new SqlParameter("@CHARGEMONEY", SqlDbType.Money),
new SqlParameter("@VIPMARK", SqlDbType.VarChar, 1000)
};
para[0].Value = vip.VipNumber;
para[1].Value = vip.VipName;
para[2].Value = vip.VipSex;;
if (vip.VipPhoto == null)
{
vip.VipPhoto = new Byte[0];
}
para[3].Value = vip.VipPhoto;
para[4].Value = vip.VipLevelId;
para[5].Value = vip.VipPWD;
para[6].Value = vip.VipPhone;
para[7].Value = vip.VipCard;
para[8].Value = vip.VipBirthDay;
para[9].Value = vip.VipAddress;
para[10].Value = vip.DpId;
para[11].Value = DateTime.Now;
para[12].Value = vip.UserId;
para[13].Value = money;
para[14].Value = vip.Mark;
result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para);
return(result > 0 ? true : false);
}
catch (Exception ex)
{
except.ExceptionInsert("添加VIP出错：" + ex.Message, "VipInsert", DateTime.Now);
return(false);
}
}
private void FillVipMessage(string vipCardNumber)
{
VIPInfo vipTemp = new VIPInfo();
vipTemp = vipBLL.VipSelectByCardNumber(vipCardNumber);
if (vipTemp == null)
{
epMessge.SetError(txtCard, "此卡号不存在");
return;
}
epMessge.SetError(txtCard, "");
if (cmbVipDepart.SelectedValue.ToString() == vipTemp.DpId.ToString())
{
cmbVipId.SelectedValue = vipTemp.VipId;
}
else
{
IsCardChang = true;
cmbVipDepart.SelectedValue = vipTemp.DpId;
vipId = vipTemp.VipId;
}
txtAddress.Text = vipTemp.VipAddress;
txtBirthday.Text = vipTemp.VipBirthDay.ToShortDateString();
txtCard.Text = vipTemp.VipNumber;
txtPhone.Text = vipTemp.VipPhone;
txtVipName.Text = vipTemp.VipName;
txtVipCard.Text = vipTemp.VipCard;
int vipLV = vipTemp.VipLevelId;
VipLevelInfo levelInfo = new VipLevelInfo();
levelInfo.LvId = vipLV;
levelInfo = vipLVBLL.VipLevelSelectById(levelInfo);
txtVipLv.Text = levelInfo.LvName;
int dpid = vipTemp.DpId;
DepartInfo dpInfo = new DepartInfo();
dpInfo.DpId = dpid;
dpInfo = dpBLL.DepartSelectById(dpInfo);
try
{
MemoryStream stream = new MemoryStream(vipTemp.VipPhoto, true);
stream.Write(vipTemp.VipPhoto, 0, vipTemp.VipPhoto.Length);
pbVip.Image = new Bitmap(stream);
pbVip.SizeMode = PictureBoxSizeMode.StretchImage;
}
catch (Exception ex)
{
pbVip.Image = null;
}
}
public int Update(VIPInfo vip)
{
string sql = "update memberinfo set mname=@name,mtypeid=@typeid,mphone=@phone,mmoney=@moneyn where mid=@id";
SQLiteParameter[] sp =
{
new SQLiteParameter("@id", vip.MId),
new SQLiteParameter("@name", vip.MName),
new SQLiteParameter("@typeid", vip.MTypeId),
new SQLiteParameter("@phone", vip.MPhone),
new SQLiteParameter("@money", vip.MCount),
};
return(SqliteHelper.ExcuteNoQuery(sql, sp));
}
/// <summary>
/// 根据分店ID获得该分店下的VIP列表
/// </summary>
/// <param name="dpId"></param>
/// <returns></returns>
public List <VIPInfo> VipSelectByDpId(int dpId)
{
string sql = "VIP_SELECT_BY_DPID";
List <VIPInfo> listVip = new List <VIPInfo>();
dt = new DataTable();
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@DPID", SqlDbType.Int)
};
para[0].Value = dpId;
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para))
{
dt.Load(dr);
}
VIPInfo vipInfo;
for (int i = 0; i < dt.Rows.Count; i++)
{
vipInfo = new VIPInfo();
vipInfo.VipId = Convert.ToInt32(dt.Rows[i]["VIPID"]);
vipInfo.VipNumber = Convert.ToString(dt.Rows[i]["VIPNUMBER"]);
vipInfo.VipName = Convert.ToString(dt.Rows[i]["VIPNAME"]);
vipInfo.VipSex = (bool)(dt.Rows[i]["VIPSEX"]);
vipInfo.VipLevelId = Convert.ToInt32(dt.Rows[i]["VIPLEVELID"]);
vipInfo.VipPhone = Convert.ToString(dt.Rows[i]["VIPPHONE"]);
vipInfo.VipCard = Convert.ToString(dt.Rows[i]["VIPCARD"]);
vipInfo.VipBirthDay = Convert.ToDateTime(dt.Rows[i]["VIPBIRTHDAY"]);
vipInfo.VipAddress = Convert.ToString(dt.Rows[i]["VIPADDRESS"]);
vipInfo.VipPWD = Convert.ToString(dt.Rows[i]["VIPPWD"]);
vipInfo.AddDate = (DateTime)dt.Rows[i]["ADDDATE"];
try
{
vipInfo.Mark = dt.Rows[0]["MARK"].ToString();
}
catch (Exception)
{
vipInfo.Mark = "";
}
listVip.Add(vipInfo);
}
return(listVip);
}
catch (Exception ex)
{
except.ExceptionInsert("查询VIP信息出错：" + ex.Message, "VipSelectByDpId", DateTime.Now);
return(null);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtId.Text == "添加时无编号")
{
//添加功能
if (txtNameAdd.Text == "")
{
MessageBox.Show("请输入用户名！");
return;
}
VIPInfo vi = new VIPInfo()
{
MName = txtNameAdd.Text,
MCount = Convert.ToDecimal(txtMoney.Text),
MPhone = txtPhoneAdd.Text,
MTypeId = Convert.ToInt32(ddlType.SelectedValue)
};
if (bll.Add(vi))
{
MessageBox.Show("添加成功！");
Refresh();
}
else
{
MessageBox.Show("添加失败！请稍后重试");
Refresh();
}
}
else
{
//修改功能
VIPInfo vip = new VIPInfo();
vip.MName = txtNameAdd.Text;
vip.MTypeId = ddlType.SelectedIndex;
vip.MPhone = txtPhoneAdd.Text;
vip.MCount = Convert.ToDecimal(txtMoney.Text);
if (bll.Edit(vip))
{
MessageBox.Show("修改成功！");
Refresh();
}
else
{
MessageBox.Show("修改失败！请稍后重试！");
Refresh();
}
}
}
/// <summary>
/// 插入新的数据
/// </summary>
/// <param name="vi"></param>
/// <returns></returns>
public int Insert(VIPInfo vi)
{
string sql =
"insert into memberinfo(mtypeid,mname,mphone,mmoney,misdelete) values(@typeid,@name,@phone,@money,@isdelete)";
SQLiteParameter[] sp =
{
new SQLiteParameter("@typeid", vi.MTypeId),
new SQLiteParameter("@name", vi.MName),
new SQLiteParameter("@phone", vi.MPhone),
new SQLiteParameter("@money", vi.MCount),
new SQLiteParameter("@isdelete", vi.MIsdelete),
};
return(SqliteHelper.ExcuteNoQuery(sql, sp));
}
public VipManageWindow(bool isAdmin)
{
InitializeComponent();
bg.DoWork += new DoWorkEventHandler(bg_DoWork); //异步操作时要做的操作，一般去查列表，这个列表在本页面内先声明，然后在这个dowork方法里去取数填充他
bg.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); //这个是取数完成后进行的操作，去到数后，这里取用去到的列表绑定到控件
vipModel = new VIPInfo();
vipBLL = new VipBLL();
departBLL = new DepartBLL();
departInfo = new DepartInfo();
levelBLL = new VipLevelBLL();
levelInfo = new VipLevelInfo();
moneyTemp = new VipMoney();
moneyBLL = new VipMoneyBLL();
IsAdmin = isAdmin;
}
public VipOrNoBorrowSelectWindow(bool isAdmin)
{
InitializeComponent();
vipBLL = new VipBLL();
vipNoBLL = new VipNoBLL();
vipInfo = new VIPInfo();
vipLVBLL = new VipLevelBLL();
dpBLL = new DepartBLL();
vipBorrowBLL = new VipBorrowBLL();
bikeReturnBLL = new BikeReturnBLL();
vipNoBorrowBLL = new VipNoBorrowBLL();
IsAdmin = isAdmin;
IsFirst = true;
departList = new List <DepartInfo>();
}
public ReChargeWindow(bool isAdmin)
{
InitializeComponent();
chargeMoney = 0;
vipBLL = new VipBLL();
vipInfo = new VIPInfo();
vipLVBLL = new VipLevelBLL();
dpBLL = new DepartBLL();
moneyBLL = new VipMoneyBLL();
vipNoInfo = new VipNoInfo();
bgWord.DoWork += new DoWorkEventHandler(bgWord_DoWork);
bgWord.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bgWord_RunWorkerCompleted);
bgWord.ProgressChanged += new ProgressChangedEventHandler(bgWord_ProgressChanged);
bgWord.WorkerReportsProgress = true;
IsAdmin = isAdmin;
}
/// <summary>
/// 获取所有VIP信息
/// </summary>
/// <returns></returns>
public List <VIPInfo> VipSelect()
{
string sql = "VIP_SELECT";
List <VIPInfo> listVip = new List <VIPInfo>();
dt = new DataTable();
try
{
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, null))
{
dt.Load(dr);
}
VIPInfo vipTemp;
for (int i = 0; i < dt.Rows.Count; i++)
{
vipTemp = new VIPInfo();
vipTemp.VipId = Convert.ToInt32(dt.Rows[i]["VIPID"]);
vipTemp.VipNumber = Convert.ToString(dt.Rows[i]["VIPNUMBER"]);
vipTemp.VipName = Convert.ToString(dt.Rows[i]["VIPNAME"]);
vipTemp.VipSex = (bool)(dt.Rows[i]["VIPSEX"]);
vipTemp.VipLevelId = Convert.ToInt32(dt.Rows[i]["VIPLEVELID"]);
vipTemp.VipPhone = Convert.ToString(dt.Rows[i]["VIPPHONE"]);
vipTemp.VipCard = Convert.ToString(dt.Rows[i]["VIPCARD"]);
vipTemp.VipBirthDay = Convert.ToDateTime(dt.Rows[i]["VIPBIRTHDAY"]);
vipTemp.VipAddress = Convert.ToString(dt.Rows[i]["VIPADDRESS"]);
vipTemp.DpId = Convert.ToInt32(dt.Rows[i]["DPID"]);
vipTemp.VipPWD = Convert.ToString(dt.Rows[i]["VIPPWD"]);
vipTemp.AddDate = DateTime.Parse(dt.Rows[i]["ADDDATE"].ToString());
try
{
vipTemp.Mark = dt.Rows[0]["MARK"].ToString();
}
catch (Exception)
{
vipTemp.Mark = "";
}
listVip.Add(vipTemp);
}
return(listVip);
}
catch (Exception ex)
{
except.ExceptionInsert("查询VIP信息出错：" + ex.Message, "VipSelect", DateTime.Now);
return(null);
}
}
private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
lvMsg.BeginUpdate();
lvMsg.Items.Clear();
if (rechargeList.Count == 0)
{
MessageBox.Show("无充值记录");
lvMsg.EndUpdate();
progressBar1.Visible = false;
btnOk.Enabled = true;
return;
}
if (rechargeList.Count != 0)
{
for (int i = 0; i < rechargeList.Count; i++)
{
UserInfo user = new UserInfo();
user.UserId = rechargeList[i].UserId;
user = userBLL.SelectUserById(user);
DepartInfo depart = new DepartInfo();
depart.DpId = rechargeList[i].DepartId;
depart = departBLL.DepartSelectById(depart);
lvMsg.Items.Add("");
if (rechargeList[i].IsVip)
{
VIPInfo vip = new VIPInfo();
vip.VipId = rechargeList[i].VipId;
lvMsg.Items[i].SubItems[0].Text = vipBLL.VipSelectById(vip).VipName;
}
else
{
VipNoInfo vip = new VipNoInfo();
vip.VipId = rechargeList[i].VipId;
lvMsg.Items[i].SubItems[0].Text = vipNoBLL.VipNoSelectByVIPNoId(vip).VipName;
}
lvMsg.Items[i].SubItems.Add(rechargeList[i].ChargeMoney.ToString());
lvMsg.Items[i].SubItems.Add(user.UserName);
lvMsg.Items[i].SubItems.Add(rechargeList[i].RechargeTime.ToString());
lvMsg.Items[i].SubItems.Add(depart.DpName);
}
}
lvMsg.EndUpdate();
progressBar1.Visible = false;
btnOk.Enabled = true;
}
private void btnOK_Click(object sender, EventArgs e)
{
if (txtCard.Text.Trim() == "")
{
epMessage.SetError(txtCard, "请刷入卡号或姓名!");
return;
}
if (txtPwd.Text.Trim() == "")
{
epMessage.SetError(txtPwd, "请输入密码!");
return;
}
if (isVip)
{
vipInfo.VipNumber = txtCard.Text.Trim();
vipInfo.VipPWD = txtPwd.Text.Trim();
vipInfo = vipBLL.VipCheck(vipInfo);
if (vipInfo.VipId == 0)
{
MessageBox.Show("租车密码与卡号不相符!");
}
else
{
isTrue = true;
vipId = vipInfo.VipId;
this.Close();
}
}
else
{
vipNoInfo.VipNumber = txtCard.Text.Trim();
vipNoInfo.VipPwd = txtPwd.Text.Trim();
vipNoInfo = vipNoBLL.VipNoCheck(vipNoInfo);
if (vipNoInfo.VipId == 0)
{
MessageBox.Show("租车密码与卡号不相符!");
}
else
{
isTrue = true;
vipId = vipNoInfo.VipId;
this.Close();
}
}
}
public void SetDaily(VIPInfo vipInfo)
{
if (vipInfo._daily_item_count <= 0)
{
label_daily.gameObject.SetActive(false);
grid_daily.gameObject.SetActive(false);
return;
}
else
{
label_daily.gameObject.SetActive(true);
grid_daily.gameObject.SetActive(true);
}
int diffCount = 2 - grid_daily.GetChildList().Count;
for (int i = 0; i < lst_ItemBoxes_Daily.Count; i++)
{
lst_ItemBoxes_Daily[i].gameObject.SetActive(true);
}
while (diffCount > 0)
{
GameObject go = Main.Instance.MakeObjectToTarget(ObjectPool.Instance.GetPrefab("UI/Reward_ItemBox"), grid_daily.gameObject);
lst_ItemBoxes_Daily.Add(go.GetComponent <Reward_ItemBox>());
diffCount--;
}
RewardItem reward_Item = new RewardItem();
reward_Item.itemKind = "GameItemType";
reward_Item.itemId = vipInfo._daily_item_name;
reward_Item.count = vipInfo._daily_item_count;
lst_ItemBoxes_Daily[0].SetSize(size);
lst_ItemBoxes_Daily[0].Set(reward_Item);
RewardItem reward_Item2 = new RewardItem();
reward_Item.itemKind = "";
reward_Item2.itemId = "icon_bread";
reward_Item2.count = vipInfo._daily_food;
lst_ItemBoxes_Daily[1].SetSize(size);
lst_ItemBoxes_Daily[1].Set(reward_Item2);
}
private void GetVipInfoById(object vip)
{
VIPInfo vipTemp = vipBLL.VipSelectById((VIPInfo)vip);
this.Invoke(new Action(() =>
{
txtVipNumber.Text = vipTemp.VipNumber;
cmbVipLevel.SelectedValue = vipTemp.VipLevelId;
txtVipName.Text = vipTemp.VipName;
cmbDPID.SelectedValue = vipTemp.DpId;
if (vipTemp.VipSex)
{
rbtnSex1.Checked = true;
}
else
{
rbtnSex2.Checked = true;
}
txtVipPWD.Text = vipTemp.VipPWD;
txtVipPWD2.Text = vipTemp.VipPWD;
txtVipPhone.Text = vipTemp.VipPhone;
txtVipCard.Text = vipTemp.VipCard;
txtVipAddress.Text = vipTemp.VipAddress;
image = vipTemp.VipPhoto;
txtMark.Text = vipTemp.Mark;
try
{
if (vipTemp.VipPhoto == new Byte[0])
{
picUser.Image = null;
return;
}
MemoryStream stream = new MemoryStream(vipTemp.VipPhoto, true);
stream.Write(vipTemp.VipPhoto, 0, vipTemp.VipPhoto.Length);
picUser.Image = new Bitmap(stream);
picUser.SizeMode = PictureBoxSizeMode.StretchImage;
}
catch (Exception ex)
{
picUser.Image = null;
}
cmbDPID.SelectedValue = vipTemp.DpId;
}));
}
private void btnOKClick()
{
this.Invoke(new Action(() =>
{
vipInfo = new VIPInfo();
vipInfo.VipId = vipId;
vipInfo.VipNumber = txtVipNumber.Text;
vipInfo.VipLevelId = Convert.ToInt32(cmbVipLevel.SelectedValue);
vipInfo.VipName = txtVipName.Text;
vipInfo.VipPWD = txtVipPWD.Text;
vipInfo.VipSex = rbtnSex1.Checked;
vipInfo.VipPhone = txtVipPhone.Text;
vipInfo.VipCard = txtVipCard.Text;
string cid = txtVipCard.Text.Trim();
DateTime birthDay = DateTime.Parse(cid.Substring(6, 4) + "-" + cid.Substring(10, 2) + "-" + cid.Substring(12, 2));
vipInfo.VipBirthDay = birthDay;
vipInfo.VipAddress = txtVipAddress.Text;
vipInfo.VipPhoto = image;
if (txtMark.TextLength > 0)
{
vipInfo.Mark = txtMark.Text.Trim();
}
else
{
vipInfo.Mark = "";
}
vipInfo.DpId = Convert.ToInt32(cmbDPID.SelectedValue);
if (vipBLL.VipUpdate(vipInfo))
{
MessageBox.Show("修改会员成功", "系统提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk);
LogInfo logInfo = new LogInfo();
logInfo.UserId = StaticData.userLocal.UserId;
logInfo.Content = "修改会员‘" + txtVipName.Text + "'的信息";
logInfo.LogTime = DateTime.Now;
logInfo.DpId = StaticData.departLocal.DpId;
bool b = new LogBLL().LogInsert(logInfo);
this.Close();
}
else
{
MessageBox.Show("添修改会员失败", "系统提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}));
}
/// <summary>
/// 根据会员卡号获得VIP基本信息
/// </summary>
/// <param name="vip">会员卡号</param>
/// <returns></returns>
public VIPInfo VipSelectByCardNumber(string vipCard)
{
try
{
string sql = "VIP_SELECT_BY_VIPNUMBER";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@VIPNUMBER", vipCard)
};
dt = new DataTable();
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, param))
{
dt.Load(dr);
}
VIPInfo vipInfo = new VIPInfo();
vipInfo.VipId = Convert.ToInt32(dt.Rows[0]["VIPID"]);
vipInfo.VipNumber = Convert.ToString(dt.Rows[0]["VIPNUMBER"]);
vipInfo.VipName = Convert.ToString(dt.Rows[0]["VIPNAME"]);
vipInfo.VipSex = (bool)(dt.Rows[0]["VIPSEX"]);
vipInfo.VipLevelId = Convert.ToInt32(dt.Rows[0]["VIPLEVELID"]);
vipInfo.VipPhone = Convert.ToString(dt.Rows[0]["VIPPHONE"]);
vipInfo.VipCard = Convert.ToString(dt.Rows[0]["VIPCARD"]);
vipInfo.VipBirthDay = Convert.ToDateTime(dt.Rows[0]["VIPBIRTHDAY"]);
vipInfo.VipAddress = Convert.ToString(dt.Rows[0]["VIPADDRESS"]);
vipInfo.DpId = Convert.ToInt32(dt.Rows[0]["DPID"]);
vipInfo.VipPWD = Convert.ToString(dt.Rows[0]["VIPPWD"]);
vipInfo.AddDate = (DateTime)dt.Rows[0]["ADDDATE"];
try
{
vipInfo.Mark = dt.Rows[0]["MARK"].ToString();
}
catch (Exception)
{
vipInfo.Mark = "";
}
return(vipInfo);
}
catch (Exception ex)
{
except.ExceptionInsert("查询VIP信息出错：" + ex.Message, "VipSelectByCardNumber", DateTime.Now);
return(null);
}
}
/// <summary>
/// 查询新建VIP列表
/// </summary>
/// <param name="dpId"></param>
/// <returns></returns>
public List <VIPInfo> GetNewVipList(int dpId, DateTime beginTime, DateTime endTime)
{
string sql = "VIP_SELECT_NEW_BY_DPID";
List <VIPInfo> vipList = new List <VIPInfo>();
dt = new DataTable();
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@ADDDATE", SqlDbType.DateTime),
new SqlParameter("@DPID", SqlDbType.Int),
new SqlParameter("@beginTime", SqlDbType.DateTime),
new SqlParameter("@endTime", SqlDbType.DateTime)
};
para[0].Value = System.DateTime.Now;
para[1].Value = dpId;
para[2].Value = beginTime;
para[3].Value = endTime;
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para))
{
dt.Load(dr);
}
VIPInfo vipTemp;
for (int i = 0; i < dt.Rows.Count; i++)
{
vipTemp = new VIPInfo();
vipTemp.VipId = Convert.ToInt32(dt.Rows[i]["VIPID"]);
vipTemp.VipNumber = Convert.ToString(dt.Rows[i]["VIPNUMBER"]);
vipTemp.VipName = Convert.ToString(dt.Rows[i]["VIPNAME"]);
vipTemp.UserId = Convert.ToInt32(dt.Rows[i]["USERID"]);
vipTemp.AddDate = DateTime.Parse(dt.Rows[i]["ADDDATE"].ToString());
vipList.Add(vipTemp);
}
return(vipList);
}
catch (Exception ex)
{
except.ExceptionInsert("查询新增VIP信息出错：" + ex.Message, "GetNewVipList", DateTime.Now);
return(null);
}
}
/// <summary>
/// 删除VIP信息
/// </summary>
/// <param name="vip"></param>
/// <returns></returns>
public bool VipDelete(VIPInfo vip)
{
string sql = "VIP_DELETE";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@VIPID", SqlDbType.Int)
};
para[0].Value = vip.VipId;
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringShop, CommandType.StoredProcedure, sql, para);
return(result > 0 ? true : false);
}
catch (Exception ex)
{
except.ExceptionInsert("删除VIP出错：" + ex.Message, "VipDelete", DateTime.Now);
return(false);
}
}
