protected void Button2_Click(object sender, EventArgs e) { int TrueCount = 0; string info = ""; for (int i = 0; i < this.GridView1.Rows.Count; i++) { if ((this.GridView1.Rows[i].FindControl("CheckBox1") as CheckBox).Checked) { string ss = ((HiddenField)GridView1.Rows[i].FindControl("HiddenField1")).Value; using (SqlConnection con = new SqlConnection(DAL.DBHelper.connString)) { con.Open(); SqlTransaction tran = con.BeginTransaction(); try { BLL.MobileSMS sms = new BLL.MobileSMS(); DataTable dt = sms.GetSMS(tran, ss); BLL.MobileSMS.SendMsgTo(tran, dt.Rows[0]["CustomerID"].ToString(), dt.Rows[0]["CustomerID"].ToString(), dt.Rows[0]["mobile"].ToString(), dt.Rows[0]["sendMsg"].ToString(), out info, (Model.SMSCategory)Convert.ToInt32(dt.Rows[0]["Category"].ToString())); sms.DelSMS(tran, ss); if (info.IndexOf("发送成功") != -1) { TrueCount++; } tran.Commit(); } catch { tran.Rollback(); } finally { con.Close(); } } } } ClientScript.RegisterStartupScript(this.GetType(), "", "alert('" + GetTran("007902", "共成功发送") + TrueCount + GetTran("006978", "条") + "!')", true); }
protected void Button1_Click(object sender, EventArgs e) { for (int i = 0; i < this.GridView1.Rows.Count; i++) { if ((this.GridView1.Rows[i].FindControl("CheckBox1") as CheckBox).Checked) { string ss = ((HiddenField)GridView1.Rows[i].FindControl("HiddenField1")).Value; using (SqlConnection con = new SqlConnection(DAL.DBHelper.connString)) { con.Open(); SqlTransaction tran = con.BeginTransaction(); try { BLL.MobileSMS sms = new BLL.MobileSMS(); BLL.CommonClass.ChangeLogs cl = new BLL.CommonClass.ChangeLogs("h_mobileMsg", "ltrim(rtrim(str(id)))"); cl.AddRecordtran(tran, ss); sms.DelSMS(tran, ss); cl.AddRecordtran(tran, ss); cl.DeletedIntoLogs(BLL.CommonClass.ChangeCategory.company65, Session["Company"].ToString(), BLL.CommonClass.ENUM_USERTYPE.objecttype10); tran.Commit(); } catch { tran.Rollback(); } finally { con.Close(); } } } } btnSearch_Click(null, null); }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { string id = e.CommandArgument.ToString(); if (e.CommandName == "Del") { using (SqlConnection con = new SqlConnection(DAL.DBHelper.connString)) { con.Open(); SqlTransaction tran = con.BeginTransaction(); try { BLL.MobileSMS sms = new BLL.MobileSMS(); BLL.CommonClass.ChangeLogs cl = new BLL.CommonClass.ChangeLogs("h_mobileMsg", "ltrim(rtrim(str(id)))"); cl.AddRecordtran(tran, id); sms.DelSMS(tran, id); cl.AddRecordtran(tran, id.ToString()); cl.DeletedIntoLogs(BLL.CommonClass.ChangeCategory.company65, Session["Company"].ToString(), BLL.CommonClass.ENUM_USERTYPE.objecttype10); tran.Commit(); ClientScript.RegisterStartupScript(this.GetType(), "", "alert('" + BLL.Translation.Translate("000008", "删除成功") + "')", true); btnSearch_Click(null, null); } catch { tran.Rollback(); ClientScript.RegisterStartupScript(this.GetType(), "", "alert('" + BLL.Translation.Translate("000009", "删除失败") + "')", true); } finally { con.Close(); } } } if (e.CommandName == "AgainSend") { string info = ""; string[] AllValue = e.CommandArgument.ToString().Split(','); string CommName = e.CommandArgument.ToString(); using (SqlConnection con = new SqlConnection(DAL.DBHelper.connString)) { con.Open(); SqlTransaction tran = con.BeginTransaction(); try { BLL.MobileSMS sms = new BLL.MobileSMS(); BLL.MobileSMS.SendMsgTo(tran, AllValue[2], AllValue[2], AllValue[1], AllValue[3], out info, (Model.SMSCategory)Convert.ToInt32(AllValue[4])); sms.DelSMS(tran, AllValue[0]); tran.Commit(); //BLL.MobileSMS.SendMsgTo(tran, bianhao, bianhao, mobile, msg, out info, Model.SMSCategory.sms_ManualSent); ClientScript.RegisterStartupScript(this.GetType(), "", "alert('" + info + "');", true); btnSearch_Click(null, null); } catch { tran.Rollback(); ClientScript.RegisterStartupScript(this.GetType(), "", "alert('" + info + "');", true); } finally { con.Close(); } } } }