protected void btnSend_Click(object sender, EventArgs e) { string strCardId = ""; string strCardLast = ""; string strNowDate = DateTime.Now.Date.ToString("yyyy-MM-dd"); string strNowTime = DateTime.Now.Date.ToString("hh:MM:ss"); string strMemName = ""; string strMoney = ""; string levelid = this.ddlLevelID.Items.Count > 0 ? ddlLevelID.SelectedItem.Value : ""; string strContent = this.txtContent.Text; if (strContent == "") { Common.ShowMsg("发送内容不能为空!"); return; } string strSql = @"select a.MemName,a.Mobile,b.Account,c.LevelName,b.Pwd,b.cardid from Mem a,Mem_Card b,Mem_Card_Level c where a.CardId = b.CardId and b.CardLevel = c.LevelId and c.LevelId = '" + levelid + "'"; DataTable dt = new DataTable(); DBManager db = DBManager.Instance(); dt = db.GetDataTable(strSql); string strTel = ""; for (int i = 0; i < dt.Rows.Count; i++) { strTel = dt.Rows[i]["mobile"].ToString().Trim(); if (strTel.Length != 11) { continue; } else { strCardId = dt.Rows[i]["cardid"].ToString(); strMemName = dt.Rows[i]["MemName"].ToString(); strMoney = dt.Rows[i]["account"].ToString(); strCardLast = strCardId.Substring(strCardId.Length - 4); string strTemp = strContent; strTemp.Replace("#CardID#", strCardId); strTemp.Replace("#LCardID#", strCardLast); strTemp.Replace("#Date#", strNowDate); strTemp.Replace("#Time#", strNowTime); strTemp.Replace("##Name#", strMemName); strTemp.Replace("#Money#", strMoney); sms.Send(strTel, strContent); SMSOperate.SaveRecord(strTel, strContent); } } Common.ShowMsg("短信发送操作已完成!"); //RecordOperate.SaveRecord(Session["UserID"].ToString(), "短信平台", "使用系统数据发送短信;用户组ID:" + groupid + ";发送内容:" + strContent); //RecordOperate.SaveRecord(Session["UserID"].ToString(), "短信平台", "使用系统数据发送短信;会员级别:" + levelid + ";"); }
protected void btnSend_Click(object sender, EventArgs e) { string strNumTemp = this.txtNumber.Text.Trim(); string strContent = this.txtContent.Text; string[] strNums = strNumTemp.Split(';'); string strCardId = ""; string strCardLast = ""; string strNowDate = DateTime.Now.Date.ToString("yyyy-MM-dd HH:mm:ss"); string strNowTime = DateTime.Now.Date.ToString("hh:MM:ss"); string strMemName = ""; string strMoney = ""; if (strContent.Contains("#")) { DBManager db = DBManager.Instance(); DataTable dt = db.GetDataTable(@"select a.mobile, a.MemName,a.cardid,b.account from mem a,mem_card b where a.CardId = b.CardId "); foreach (string num in strNums) { if (num.Length != 11) { continue; } DataRow[] dr = dt.Select("mobile ='" + num + "'"); if (dr.Length > 0) { strCardId = dr[0]["cardid"].ToString(); strMemName = dr[0]["MemName"].ToString(); strMoney = dr[0]["account"].ToString(); strCardLast = strCardId.Substring(strCardId.Length - 4); string strTemp = strContent; strTemp.Replace("#CardID#", strCardId); strTemp.Replace("#LCardID#", strCardLast); strTemp.Replace("#Date#", strNowDate); strTemp.Replace("#Time#", strNowTime); strTemp.Replace("##Name#", strMemName); strTemp.Replace("#Money#", strMoney); res = sms.Send(num, strTemp); SMSOperate.SaveRecord(num, strTemp); } } } else { foreach (string num in strNums) { if (num.Length != 11) { continue; } res = sms.Send(num, strContent); SMSOperate.SaveRecord(num, strContent); } } //res = sms.Send(strNumTemp, strContent); Common.ShowMsg("短信发送操作已完成!"); //RecordOperate.SaveRecord(Session["UserID"].ToString(), "短信平台", "使用系统数据发送短信;对象号码:" + strNumTemp + ";发送内容:" + strContent); //RecordOperate.SaveRecord(Session["UserID"].ToString(), "短信平台", "使用系统数据发送短信;对象号码:" + strNumTemp + ";"); //SMSOperate.SaveRecord(strNumTemp,strContent); }