Beispiel #1
0
        /// <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;
        }
Beispiel #2
0
        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;
                }
            }
        }
Beispiel #3
0
        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 = "无此会员!";
            }
        }