コード例 #1
0
ファイル: SyLog.aspx.cs プロジェクト: FirstYangYang/demo
    /// <summary>
    /// 设置页面状态
    /// </summary>
    /// <param name="otype">add,mod,view,cancel,import,export</param>
    private void InitField(ControlHelper.CEnum etype)
    {
        this.lblExportMsg.Text = "";

        try
        {
            switch (etype)
            {
            case ControlHelper.CEnum.VIEW:
                //查看
                this.divDtls.Visible    = true;
                this.divContent.Visible = false;
                this.divExport.Visible  = false;
                break;

            case ControlHelper.CEnum.CANCEL:
                //取消操作
                this.divDtls.Visible    = false;
                this.divContent.Visible = true;
                this.divExport.Visible  = false;
                break;

            case ControlHelper.CEnum.Export:
                //导出操作
                this.divDtls.Visible    = false;
                this.divContent.Visible = false;
                this.divExport.Visible  = true;
                break;
            }
        }
        catch (Exception ex)
        {
            JscriptMsg(ex.Message, "", "Error");
        }
    }
コード例 #2
0
    /// <summary>
    /// 绑定明细记录
    /// </summary>
    /// <param name="etype"></param>
    /// <param name="spkid"></param>
    private void showDtls(ControlHelper.CEnum etype, string spkid)
    {
        try
        {
            this.PKID.Value = spkid.ToString();//this.gvList.SelectedDataKey.Value.ToString();

            string sql = "select {0}.*,bs_user.name as username,bs_user.usablescore,bs_gift.Name as gifName" +
                         " from {0} " +
                         " inner join bs_user on bs_user.id={0}.bs_userid " +
                         " inner join bs_gift on bs_gift.code={0}.bs_giftcode " +
                         " where {0}.{1}='{2}'";
            sql = string.Format(sql, TblName, PKField, PKID.Value);
            using (DataTable dt = DBAccess.getRS(sql)) //dao.getRowItemByPKID(TblName, this.PKID.Value))
            {
                if (dt.Rows.Count > 0)
                {
                    ControlHelper.bindControlByDataRow(this.divDtls, dt.Rows[0], null);
                }
            }
        }
        catch (Exception ex)
        {
            JscriptMsg(ex.Message, "", "Error");
        }
    }
コード例 #3
0
 /// <summary>
 /// 绑定明细记录
 /// </summary>
 /// <param name="etype"></param>
 /// <param name="spkid"></param>
 private void showDtls(ControlHelper.CEnum etype, string spkid)
 {
     try
     {
         using (DataTable dt = DBAccess.getRS(Util.buildItemSQL(TblName, PKField + "='" + spkid + "'"))) //dao.getRowItemByPKID(TblName, this.PKID.Value))
         {
             showDtls(etype, dt);
         }
     }
     catch (Exception ex)
     {
         JscriptMsg(ex.Message, "", "Error");
     }
 }
コード例 #4
0
ファイル: BsAd.aspx.cs プロジェクト: XiangYang88/first-test
 /// <summary>
 /// 绑定明细记录
 /// </summary>
 /// <param name="etype"></param>
 /// <param name="spkid"></param>
 private void showDtls(ControlHelper.CEnum etype, DataTable dt)
 {
     try
     {
         if (dt.Rows.Count > 0)
         {
             this.PKID.Value = dt.Rows[0][PKField].ToString();
             ControlHelper.bindControlByDataRow(this.divDtls, dt.Rows[0], null);
         }
     }
     catch (Exception ex)
     {
         JscriptMsg(ex.Message, "", "Error");
     }
 }
コード例 #5
0
ファイル: BsSendSMS.aspx.cs プロジェクト: FirstYangYang/demo
 /// <summary>
 /// 绑定明细记录
 /// </summary>
 /// <param name="etype"></param>
 /// <param name="spkid"></param>
 private void showDtls(ControlHelper.CEnum etype, string spkid)
 {
     try
     {
         this.PKID.Value = spkid.ToString();                                                                  //this.gvList.SelectedDataKey.Value.ToString();
         using (DataTable dt = DBAccess.getRS(Util.buildItemSQL(TblName, PKField + "='" + PKID.Value + "'"))) //dao.getRowItemByPKID(TblName, this.PKID.Value))
         {
             if (dt.Rows.Count > 0)
             {
                 ControlHelper.bindControlByDataRow(this.divDtls, dt.Rows[0], null);
             }
         }
     }
     catch (Exception ex)
     {
         JscriptMsg(ex.Message, "", "Error");
     }
 }
コード例 #6
0
ファイル: SyRole.aspx.cs プロジェクト: FirstYangYang/demo
    /// <summary>
    /// 绑定明细记录
    /// </summary>
    /// <param name="etype"></param>
    /// <param name="spkid"></param>
    private void showDtls(ControlHelper.CEnum etype, string spkid)
    {
        try
        {
            this.PKID.Value = spkid.ToString();                                                                  //this.gvList.SelectedDataKey.Value.ToString();
            using (DataTable dt = DBAccess.getRS(Util.buildItemSQL(TblName, PKField + "='" + PKID.Value + "'"))) //dao.getRowItemByPKID(TblName, this.PKID.Value))
            {
                if (dt.Rows.Count > 0)
                {
                    ControlHelper.bindControlByDataRow(this.divDtls, dt.Rows[0], null);
                }


                //绑定控件权限
                DataTable ctrl = DBAccess.getRS("select a.pkid from sy_control a,sy_RoleCtrl b where a.pkid=b.sy_controlpkid and b.Sy_RolePKID='"
                                                + PKID.Value + "' and a.status=0");
                foreach (ListItem li in chkControlList.Items)
                {
                    li.Selected = false;
                }
                foreach (ListItem li in chkControlList.Items)
                {
                    foreach (DataRow dr in ctrl.Rows)
                    {
                        if (dr["pkid"].ToString() == li.Value)
                        {
                            li.Selected = true;
                            break;
                        }
                    }
                }
            }
        }
        catch (Exception ex)
        {
            JscriptMsg(ex.Message, "", "Error");
        }
    }
コード例 #7
0
ファイル: SyUser.aspx.cs プロジェクト: FirstYangYang/demo
    /// <summary>
    /// 绑定明细记录
    /// </summary>
    /// <param name="etype"></param>
    /// <param name="spkid"></param>
    private void showDtls(ControlHelper.CEnum etype, string spkid)
    {
        try
        {
            this.PKID.Value = spkid.ToString();                                                                  //this.gvList.SelectedDataKey.Value.ToString();
            using (DataTable dt = DBAccess.getRS(Util.buildItemSQL(TblName, PKField + "='" + PKID.Value + "'"))) //dao.getRowItemByPKID(TblName, this.PKID.Value))
            {
                if (dt.Rows.Count > 0)
                {
                    ControlHelper.bindControlByDataRow(this.divDtls, dt.Rows[0], null);
                }


                //绑定角色
                DataTable role = DBAccess.getRS("select * from sy_userrole where Sy_UserFK='" + PKID.Value + "'");
                foreach (ListItem li in chkRoleList.Items)
                {
                    li.Selected = false;
                }
                foreach (ListItem li in chkRoleList.Items)
                {
                    foreach (DataRow dr in role.Rows)
                    {
                        if (dr["Sy_RoleFK"].ToString() == li.Value)
                        {
                            li.Selected = true;
                            break;
                        }
                    }
                }
            }
        }
        catch (Exception ex)
        {
            JscriptMsg(ex.Message, "", "Error");
        }
    }
コード例 #8
0
    /// <summary>
    /// 设置页面状态
    /// </summary>
    /// <param name="otype">add,mod,view,cancel,import,export</param>
    private void InitField(ControlHelper.CEnum etype)
    {
        this.lblExportMsg.Text = "";
        this.lblImportMsg.Text = "";
        try
        {
            switch (etype)
            {
            case ControlHelper.CEnum.ADD:
                //新增
                this.btnSvAdd.Visible = true;
                this.divDtls.Visible  = true;

                this.btnSvEdit.Visible  = false;
                this.divContent.Visible = false;
                this.divImport.Visible  = false;
                this.divExport.Visible  = false;
                ControlHelper.setControlsEmpty(divDtls);

                string pc = getViewState("pcode");
                this.KK_SortNo.Value = Util.getNextSortNo(TblName, "SortNo",
                                                          pc != "" ? string.Format(FKField + "='{0}'", pc) : pc).ToString();
                break;

            case ControlHelper.CEnum.MOD:
                //修改
                this.btnSvEdit.Visible  = true;
                this.divDtls.Visible    = true;
                this.btnSvAdd.Visible   = false;
                this.divContent.Visible = false;
                this.divImport.Visible  = false;
                this.divExport.Visible  = false;
                break;

            case ControlHelper.CEnum.VIEW:
                //查看
                this.btnSvAdd.Visible   = false;
                this.divDtls.Visible    = true;
                this.btnSvEdit.Visible  = false;
                this.divContent.Visible = false;
                this.divImport.Visible  = false;
                this.divExport.Visible  = false;
                ControlHelper.setControlsLocked(divDtls, true);
                break;

            case ControlHelper.CEnum.CANCEL:
                //取消操作
                this.divContent.Visible = true;
                this.divDtls.Visible    = false;
                this.divImport.Visible  = false;
                this.divExport.Visible  = false;
                break;

            case ControlHelper.CEnum.Import:
                //导入操作
                this.divContent.Visible = false;
                this.divDtls.Visible    = false;
                this.divImport.Visible  = true;
                this.divExport.Visible  = false;
                break;

            case ControlHelper.CEnum.Export:
                //导出操作
                this.divContent.Visible = false;
                this.divDtls.Visible    = false;
                this.divImport.Visible  = false;
                this.divExport.Visible  = true;
                break;
            }
        }
        catch (Exception ex)
        {
            JscriptMsg(ex.Message, "", "Error");
        }
    }
コード例 #9
0
ファイル: BsSendSMS.aspx.cs プロジェクト: FirstYangYang/demo
    /// <summary>
    /// 设置页面状态
    /// </summary>
    /// <param name="otype">add,mod,view,cancel,import,export</param>
    private void InitField(ControlHelper.CEnum etype)
    {
        this.lblExportMsg.Text = "";
        this.lblImportMsg.Text = "";

        try
        {
            switch (etype)
            {
            case ControlHelper.CEnum.ADD:
                //新增
                this.btnSvAdd.Visible = true;
                this.divDtls.Visible  = true;

                this.btnSvEdit.Visible  = false;
                this.divContent.Visible = false;
                this.divImport.Visible  = false;
                this.divExport.Visible  = false;
                ControlHelper.setControlsEmpty(divDtls);
                break;

            case ControlHelper.CEnum.MOD:
                //修改
                this.btnSvEdit.Visible  = true;
                this.divDtls.Visible    = true;
                this.btnSvAdd.Visible   = false;
                this.divContent.Visible = false;
                this.divImport.Visible  = false;
                this.divExport.Visible  = false;
                break;

            case ControlHelper.CEnum.VIEW:
                //查看
                this.btnSvAdd.Visible   = false;
                this.divDtls.Visible    = true;
                this.btnSvEdit.Visible  = false;
                this.divContent.Visible = false;
                this.divImport.Visible  = false;
                this.divExport.Visible  = false;
                ControlHelper.setControlsLocked(divDtls, true);
                break;

            case ControlHelper.CEnum.CANCEL:
                //取消操作
                this.divContent.Visible = true;
                this.divDtls.Visible    = false;
                this.divImport.Visible  = false;
                this.divExport.Visible  = false;
                break;

            case ControlHelper.CEnum.Import:
                //导入操作
                this.divContent.Visible = false;
                this.divDtls.Visible    = false;
                this.divImport.Visible  = true;
                this.divExport.Visible  = false;
                break;

            case ControlHelper.CEnum.Export:
                //导出操作
                this.divContent.Visible = false;
                this.divDtls.Visible    = false;
                this.divImport.Visible  = false;
                this.divExport.Visible  = true;
                break;
            }
        }
        catch (Exception ex)
        {
            JscriptMsg(ex.Message, "", "Error");
        }
    }
コード例 #10
0
    /// <summary>
    /// 设置页面状态
    /// </summary>
    /// <param name="otype">add,mod,view,cancel,import,export</param>
    private void InitField(ControlHelper.CEnum etype)
    {
        this.lblExportMsg.Text = "";
        this.lblImportMsg.Text = "";

        try
        {
            switch (etype)
            {
            case ControlHelper.CEnum.ADD:
                //新增
                this.btnSvAdd.Visible = true;
                this.divDtls.Visible  = true;

                this.btnSvEdit.Visible  = false;
                this.divContent.Visible = false;
                this.divImport.Visible  = false;
                this.divExport.Visible  = false;

                ControlHelper.setControlsEmpty(divDtls);
                this.KK_Code.Value = DateTime.Now.ToString("yyMMddss") + CSA.Text.Util.getRnd(1000, 9999);
                ControlHelper.setControlsLocked(divDtls, false);

                break;

            case ControlHelper.CEnum.MOD:
                //修改
                this.btnSvEdit.Visible  = true;
                this.divDtls.Visible    = true;
                this.btnSvAdd.Visible   = false;
                this.divContent.Visible = false;
                this.divImport.Visible  = false;
                this.divExport.Visible  = false;
                ControlHelper.setControlsLocked(divDtls, true);
                break;

            case ControlHelper.CEnum.VIEW:
                //查看
                this.btnSvAdd.Visible   = false;
                this.divDtls.Visible    = true;
                this.btnSvEdit.Visible  = false;
                this.divContent.Visible = false;
                this.divImport.Visible  = false;
                this.divExport.Visible  = false;
                break;

            case ControlHelper.CEnum.CANCEL:
                //取消操作
                this.divContent.Visible = true;
                this.divDtls.Visible    = false;
                this.divImport.Visible  = false;
                this.divExport.Visible  = false;
                break;

            case ControlHelper.CEnum.Import:
                //导入操作
                this.divContent.Visible = false;
                this.divDtls.Visible    = false;
                this.divImport.Visible  = true;
                this.divExport.Visible  = false;
                break;

            case ControlHelper.CEnum.Export:
                //导出操作
                this.divContent.Visible = false;
                this.divDtls.Visible    = false;
                this.divImport.Visible  = false;
                this.divExport.Visible  = true;
                break;
            }
        }
        catch (Exception ex)
        {
            JscriptMsg(ex.Message, "", "Error");
        }
    }