コード例 #1
0
        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 + ";");
        }
コード例 #2
0
        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);
        }