/// <summary> /// 短信导出 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="list"></param> /// <param name="sheet"></param> /// <returns></returns> private static IWorkbook shortinfopirent <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) { DXmemberModel model = item as DXmemberModel; //每遍历一条数据创建一行 row = sheet.CreateRow(rowIndex); //创建行中的单元格 row.CreateCell(0).SetCellValue(model.CardNumber); row.CreateCell(1).SetCellValue(model.MemberName); row.CreateCell(2).SetCellValue(model.TelPhone); row.CreateCell(3).SetCellValue(model.Date); row.CreateCell(4).SetCellValue(model.SaleMan); row.CreateCell(5).SetCellValue(model.Content); row.CreateCell(6).SetCellValue(model.DianPu); rowIndex++; } return(sheet.Workbook); }
//在寄存信息中显示的 显示已经发送的短信的内容 public List <DXmemberModel> selectListTJ(string begindate, string enddate, string dpname) { List <DXmemberModel> list = new List <DXmemberModel>(); string dp = FilterClass.DianPu1.UserName.Trim(); string str = ""; //SqlParameter[] pms; DXmemberModel model; if (dp == "admin") { if (dpname.Trim() == "全部") { foreach (KeyValuePair <string, int> iteam in FilterClass.dic) { str += "select * from "; str += "DXSend" + iteam.Value + ""; str += " where Date between '" + begindate + "' and '" + enddate + "'"; str += " union all "; } str = str.Substring(0, str.Length - 10); //pms = new SqlParameter[] { //}; } else { int id = FilterClass.dic[dpname.Trim()]; str = "select * from DXSend" + id + " where Date between '" + begindate + "' and '" + enddate + "'"; //pms = new SqlParameter[] { //}; } } else { str = "select * from DXSend" + ID + " where Date between '" + begindate + "' and '" + enddate + "'"; //pms = new SqlParameter[] { //}; } SqlDataReader read = SqlHelper.ExecuteReader(str); while (read.Read()) { if (read.HasRows) { model = new DXmemberModel(); model.CardNumber = read["CardNumber"].ToString().Trim(); model.MemberName = read["MemberName"].ToString().Trim(); model.TelPhone = read["TelPhone"].ToString().Trim(); model.Date = read["Date"].ToString().Trim(); model.SaleMan = read["SaleMan"].ToString().Trim(); model.Content = read["ContentNR"].ToString().Trim(); model.DianPu = read["DianPu"].ToString().Trim(); list.Add(model); } } return(list); }
private void button11_Click(object sender, EventArgs e) { string[] sourse; DXmemberModel model; List <DXmemberModel> list1 = new List <DXmemberModel>(); List <string> listr = new List <string>(); List <DXmemberModel> list = (List <DXmemberModel>)dataGridView1.DataSource; foreach (var iteam in list) { if (iteam.SendInfo) { list1.Add(iteam); listr.Add(iteam.TelPhone); } } string[] stringArray1 = listr.ToArray <string>(); string[] stringArray = textBox2.Lines; if (stringArray1.Length != 0) { sourse = stringArray.Concat <string>(stringArray1).ToArray <string>(); } else { sourse = stringArray; } bool result = Commond.SendInfo.Send(sourse, textBox1.Text.Trim()); if (result) { MessageBox.Show("发送成功!"); foreach (var iteam in sourse) { model = new DXmemberModel(); model.TelPhone = iteam.Trim(); list1.Add(model); } dxsendbll.AddList(list1, textBox1.Text.Trim()); } else { MessageBox.Show("发送失败!"); } }
//发送短信的时候 首先先查询出在本店的会员记录 public List <DXmemberModel> SelectDXList() { string dpname = FilterClass.DianPu1.UserName.Trim(); int i = 1; List <DXmemberModel> list = new List <DXmemberModel>(); DXmemberModel model; string str; SqlParameter[] pms; if (dpname == "admin") { str = "select memberCardNo,memberName,memberTel from memberInfo"; pms = new SqlParameter[] { }; } else { str = "select memberCardNo,memberName,memberTel from memberInfo where dianName=@dianName"; pms = new SqlParameter[] { new SqlParameter("@dianName", dpname) }; } SqlDataReader read = SqlHelper.ExecuteReader(str, pms); while (read.Read()) { if (read.HasRows) { model = new DXmemberModel(); model.No = i; model.CardNumber = read["memberCardNo"].ToString(); model.MemberName = read["MemberName"].ToString(); model.TelPhone = read["memberTel"].ToString(); model.SendInfo = false; i++; list.Add(model); } } return(list); }