protected void btnSubmit_onserverclick(object sender, EventArgs e)
        {
            if (asd.action == "add" || asd.action == "alter")
            {
                string    sql1 = "select count(SPID) from OM_SP where SPFATHERID='" + asd.sjid + "' and SPLX='NDPXJH'";
                DataTable dt   = DBCallCommon.GetDTUsingSqlText(sql1);
                if (dt.Rows[0][0].ToString() == "0")
                {
                    Response.Write("<script>alert('请先点击”保存“再提交审批!!!')</script>");
                    return;
                }
                string sql = "update OM_SP set SPZT='1',SPJB='" + rblSPJB.SelectedValue + "'";
                if (rblSPJB.SelectedValue == "1")
                {
                    if (txtSPR1.Text.Trim() == "")
                    {
                        Response.Write("<script>alert('请先选择审批人再提交审批!!!')</script>");
                        return;
                    }
                    sql += ",SPR1='" + txtSPR1.Text.Trim() + "',SPR1ID='" + hidSPR1ID.Value + "'";
                }
                else if (rblSPJB.SelectedValue == "2")
                {
                    if (txtSPR2.Text.Trim() == "" || txtSPR1.Text.Trim() == "")
                    {
                        Response.Write("<script>alert('请先选择审批人再提交审批!!!')</script>");
                        return;
                    }
                    sql += ",SPR1='" + txtSPR1.Text.Trim() + "',SPR1ID='" + hidSPR1ID.Value + "'";
                    sql += ",SPR2='" + txtSPR2.Text.Trim() + "',SPR2ID='" + hidSPR2ID.Value + "'";
                }
                else if (rblSPJB.SelectedValue == "3")
                {
                    if (txtSPR2.Text.Trim() == "" || txtSPR1.Text.Trim() == "" || txtSPR3.Text.Trim() == "")
                    {
                        Response.Write("<script>alert('请先选择审批人再提交审批!!!')</script>");
                        return;
                    }
                    sql += ",SPR1='" + txtSPR1.Text.Trim() + "',SPR1ID='" + hidSPR1ID.Value + "'";
                    sql += ",SPR2='" + txtSPR2.Text.Trim() + "',SPR2ID='" + hidSPR2ID.Value + "'";
                    sql += ",SPR3='" + txtSPR3.Text.Trim() + "',SPR3ID='" + hidSPR3ID.Value + "'";
                }
                sql += " where SPFATHERID='" + asd.sjid + "' and SPLX='NDPXJH'";
                try
                {
                    DBCallCommon.ExeSqlText(sql);

                    //邮件提醒
                    string sprid     = "";
                    string sptitle   = "";
                    string spcontent = "";
                    sprid     = hidSPR1ID.Value.Trim();
                    sptitle   = "年度培训计划审批";
                    spcontent = "有年度培训计划需要您审批,请登录查看!";
                    DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(sprid), new List <string>(), new List <string>(), sptitle, spcontent);
                }
                catch
                {
                    Response.Write("<script>alert('提交审批的sql语句出现问题,请与管理员联系!!!')</script>");
                    return;
                }
                Response.Redirect("OM_NDPXJH_GL.aspx");
            }
        }
 /// <summary>
 /// 批量导出BY sqltext(设置行数)
 /// </summary>
 /// <param name="sqltext"></param>
 /// <param name="filename"></param>
 /// <param name="filestandard"></param>
 /// <param name="row_hang"></param>
 /// <param name="ifwidth"></param>
 /// <param name="ifmyownstyle"></param>
 /// <param name="ifxuhao"></param>
 public static void exporteasy(string sqltext, string filename, string filestandard, int row_hang, bool ifwidth, bool ifmyownstyle, bool ifxuhao)
 {
     System.Data.DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext);
     exporteasy(dt, filename, filestandard, row_hang, ifwidth, ifmyownstyle, ifxuhao);
 }