/// <summary> /// 将获取的洗衣数据填充之ListView, /// </summary> /// <param name="Lv">目标</param> /// <param name="AndSql">sql语句and条件</param> /// <param name="AutoCheck">是否自动打勾</param> /// <returns></returns> public static bool GetAllCode(ListView Lv, string AndSql,ref int shopId, bool AutoCheck = false) { COM.CreateSQL GetAlls = new COM.CreateSQL(wa_code.FormName, wa_wash.FormName); GetAlls.SelectInit(wa_code.COID,wa_code.Wname,wa_code.shopID,wa_wash.WID,wa_wash.XiangMu,wa_wash.YangShi,wa_wash.color,wa_wash.JiaGe,wa_wash.number,wa_wash.discount,wa_wash.FuKuan,wa_wash.toID,wa_wash.GuaDian,wa_wash.CPay); GetAlls.AddAnd(wa_wash.Wnumber + "=" + wa_code.COID + " and " + AndSql); GetAlls.OrderDesc(wa_code.COID); GetAlls.Limit(100); using (IDataReader idr = GetAlls.SelectExec(null)) { Lv.Items.Clear(); if (idr == null) { MessageBox.Show("读取失败:" + Mysqlcom.error, "错误"); return false; } int i = 0; for (; idr.Read(); i++) { shopId = (int)idr[wa_code.shopID]; //编号 Lv.Items.Add(idr[wa_code.COID].ToString()); ///姓名 Lv.Items[i].SubItems.Add(idr[wa_code.Wname].ToString()); ///项目 Lv.Items[i].SubItems.Add(idr[wa_wash.XiangMu].ToString()); ////颜色+样式 Lv.Items[i].SubItems.Add(idr[wa_wash.color].ToString() + idr[wa_wash.YangShi].ToString()); ///挂点 // listView1.Items[i].SubItems.Add(""); ///挂点 if ((int)idr[wa_wash.GuaDian] == -1) Lv.Items[i].SubItems.Add("无"); else Lv.Items[i].SubItems.Add(idr[wa_wash.GuaDian].ToString()); ///数量 Lv.Items[i].SubItems.Add(idr[wa_wash.number].ToString()); ///总价 Lv.Items[i].SubItems.Add(idr[wa_wash.CPay].ToString()); ///付款 Lv.Items[i].SubItems.Add(idr[wa_wash.FuKuan].ToString()); ///付衣 if (idr[wa_wash.toID].ToString() == "") { Lv.Items[i].SubItems.Add("未取"); if (AutoCheck) Lv.Items[i].Checked = true; } else { Lv.Items[i].SubItems.Add("已取"); Lv.Items[i].ForeColor = System.Drawing.Color.DarkGray; } ///WID Lv.Items[i].SubItems.Add(idr[wa_wash.WID].ToString()); ///折扣 Lv.Items[i].SubItems.Add(idr[wa_wash.discount].ToString()); ///单价 Lv.Items[i].SubItems.Add(idr[wa_wash.JiaGe].ToString()); } if (i == 0) { MessageBox.Show("没有找到此内容", "错误"); return false; } } return true; }
private void listView1_SelectedIndexChanged(object sender, EventArgs e) { if (listView1.SelectedIndices.Count > 0) { int inde = listView1.SelectedIndices[0]; COM.CreateSQL GetInfo = new COM.CreateSQL(wa_code.FormName, wa_wash.FormName); GetInfo.SelectInit(wa_code.cardid, wa_code.Wphone, wa_code.fromdate,wa_wash.XiaCi, wa_wash.todate, wa_wash.mark); GetInfo.AddAnd(wa_wash.Wnumber +"=" + wa_code.COID ); GetInfo.AddAnd(wa_wash.WID , "=" ,listView1.Items[inde].SubItems[9].Text); int cardId = -1; using (IDataReader idr = GetInfo.SelectExec(null)) { if (idr == null || !idr.Read()) { label2.Text = "详细信息读取失败!"; label3.Text = ""; return; } label2.Text = "顾客姓名:" + listView1.Items[inde].SubItems[1].Text; if ((int)idr[wa_code.cardid] != -1) { cardId = (int)idr[wa_code.cardid]; label3.Text = "卡 号:" + cardId; } else label3.Text = "卡 号:无"; label2.Text += "\n顾客电话:" + idr[wa_code.Wphone]; label3.Text += "\n备 注:" + idr[wa_wash.mark]; label2.Text += "\n收衣日期:" + idr[wa_code.fromdate]; label3.Text += "\n取衣日期:" + idr[wa_wash.todate]; label2.Text += "\n瑕 疵:" + idr[wa_wash.XiaCi]; } if(cardId>0) { double deposit = sql.VIP.GetDepositByCardId(cardId); label3.Text += "\n余 额:" + deposit; } } }
private void dataGridView1_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count < 1) return; int selecti = dataGridView1.SelectedRows[0].Index; if (selecti < 0) return; COM.CreateSQL GetByCard = new COM.CreateSQL(wa_vip.FormName); GetByCard.SelectInit(wa_vip.vipid, wa_vip.Telphone, wa_vip.ChunKuan); using (IDataReader ida = GetByCard.SelectExec(wa_vip.Card + "=" + page1.dt.Rows[selecti][wa_chongzhi.Ccardid])) { if (ida == null) return; if (ida.Read()) label3.Text = "卡号:" + page1.dt.Rows[selecti][wa_chongzhi.Ccardid] + " 姓名:" + ida[wa_vip.vipid] + " 电话:" + ida[wa_vip.Telphone] + " 卡内余额:" + ida[wa_vip.ChunKuan]; else label3.Text = "无此会员!"; } }