/// <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);
}
