Пример #1
0
        private static IWorkbook huiyuanExitDan <T>(List <T> list, ISheet sheet)
        {
            int  rowIndex = 0;
            IRow row      = sheet.CreateRow(rowIndex);

            #region MyRegion//表头
            row.CreateCell(0).SetCellValue("会员名称");
            row.CreateCell(1).SetCellValue("会员卡号");
            row.CreateCell(2).SetCellValue("业务员");
            row.CreateCell(3).SetCellValue("所属店铺");
            row.CreateCell(4).SetCellValue("金额");
            row.CreateCell(5).SetCellValue("服务名称");
            row.CreateCell(6).SetCellValue("退单时间");
            rowIndex++;
            #endregion
            foreach (T item in list)
            {
                ExitDanModel model = item as ExitDanModel;
                //每遍历一条数据创建一行
                row = sheet.CreateRow(rowIndex);
                //创建行中的单元格
                row.CreateCell(0).SetCellValue(model.memberName);
                row.CreateCell(1).SetCellValue(model.memberCardNo);
                row.CreateCell(2).SetCellValue(model.saleMen);
                row.CreateCell(3).SetCellValue(model.DPName);
                row.CreateCell(4).SetCellValue(model.DanMoney);
                row.CreateCell(5).SetCellValue(model.StaffName);
                row.CreateCell(6).SetCellValue(model.ExitDanTime);
                rowIndex++;
            }
            return(sheet.Workbook);
        }
Пример #2
0
        //查询退弹信息   在统计报表中显示
        public List <ExitDanModel> SelectAllList(string begindate, string enddate, string dpname)
        {
            List <ExitDanModel> list = new List <ExitDanModel>();
            string       dpna        = FilterClass.DianPu1.UserName;
            ExitDanModel model;
            string       str = "";

            if (dpname == "全部")
            {
                foreach (KeyValuePair <string, int> iteam in FilterClass.dic)
                {
                    str += "select * from ";
                    str += "ExitDan" + iteam.Value + "";
                    str += " where ExitDanTime between '" + begindate + "' and '" + enddate + "'";
                    str += " union all ";
                }
                str = str.Substring(0, str.Length - 10);
            }
            else if (dpname == "")
            {
                str = "select * from ExitDan" + ID + " where ExitDanTime BETWEEN '" + begindate + "' and '" + enddate + "'";
            }
            else
            {
                int id = FilterClass.dic[dpname.Trim()];
                str = "select * from ExitDan" + id + " where ExitDanTime BETWEEN '" + begindate + "' and '" + enddate + "'";
            }
            SqlDataReader read = SqlHelper.ExecuteReader(str);

            while (read.Read())
            {
                if (read.HasRows)
                {
                    model              = new ExitDanModel();
                    model.ID           = Convert.ToInt32(read["ID"]);
                    model.memberName   = read["memberName"].ToString().Trim();
                    model.memberCardNo = read["memberCardNo"].ToString().Trim();
                    model.saleMen      = read["saleMen"].ToString().Trim();
                    model.DPName       = read["DPName"].ToString().Trim();
                    model.DanMoney     = read["DanMoney"].ToString().Trim();
                    model.StaffName    = read["StaffName"].ToString().Trim();
                    model.ExitDanTime  = read["ExitDanTime"].ToString().Trim();
                    model.IsMoney      = read["IsMoney"].ToString();
                    list.Add(model);
                }
            }
            return(list);
        }
Пример #3
0
        //添加退单信息
        public void AddExitDan(ExitDanModel model)
        {
            if (ID == null)
            {
                return;
            }
            string str = "insert into ExitDan" + ID + "(memberName,memberCardNo,saleMen,DPName,DanMoney,StaffName,ExitDanTime,IsMoney) values(@memberName,@memberCardNo,@saleMen,@DPName,@DanMoney,@StaffName,@ExitDanTime,@IsMoney)";

            SqlParameter[] pms = new SqlParameter[] {
                new SqlParameter("@memberName", model.memberName),
                new SqlParameter("@memberCardNo", model.memberCardNo),
                new SqlParameter("@saleMen", model.saleMen),
                new SqlParameter("@DPName", model.DPName),
                new SqlParameter("@DanMoney", model.DanMoney),
                new SqlParameter("@StaffName", model.StaffName),
                new SqlParameter("@ExitDanTime", model.ExitDanTime),
                new SqlParameter("@IsMoney", model.IsMoney)
            };
            SqlHelper.ExecuteNonQuery(str, pms);
        }
Пример #4
0
 public void AddExitDan(ExitDanModel model)
 {
     dal.AddExitDan(model);
 }