JCFXBL辅助类----Helper类介绍

编写Helper类的目的主要是简化在C# .NET环境下的编程。尤其是简化在Windows Forms中的Combox控件、DataGridView控件、以及DataTable对象与数据库进行交互的目的。

使用下面的Helper类的前提是要引用

using JCFXBL.SrvInterface;
using JCFXBL.SrvInterface.Core.ProtocolLayer;

对应的程序集如下：

源代码如下：

[csharp]
using JCFXBL.SrvInterface;
using JCFXBL.SrvInterface.Core.ProtocolLayer;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace JCFXBL.API
{
    public class Helper
    {
        public static string ServerUrl;

        /// <summary>
        /// 把DIC字典数据自动填充进combox控件
        /// </summary>
        /// <param name="dic">字典名称</param>
        /// <param name="cmb">combox控件对象</param>
        public static void FillComboxByDic(string dic, ComboBox cmb)
        {
            BIRequest BIR = new BIRequest();
            BIR.url = Helper.ServerUrl + "Execute.ashx?Serlet=GetDICStore&ACT=GET&dic=" + dic;
            if (BIR.Request())
            {
                try
                {
                    SrvResponse r = new SrvResponse(BIR.Response());
                    DataTable dt = r.GetResultTable();
                    cmb.DataSource = dt;
                    cmb.DisplayMember = "value";
                    cmb.ValueMember = "key";
                }
                catch (Exception ex)
                {
                   // MessageBox.Show(ex.Message);
                }
            }
        }

        /// <summary>
        /// 把数据表中对应的数据字段填充进combox控件
        /// </summary>
        /// <param name="cmb">combox控件对象</param>
        /// <param name="Parms">查询参数</param>
        /// <param name="act">存储过程名称</param>
        /// <param name="DisplayMember">combox显示字段</param>
        /// <param name="ValueMember">combox值字段</param>
        public static void FillComboBoxByTable(ComboBox cmb, System.Collections.ArrayList Parms, string act, string DisplayMember, string ValueMember)
        {
            BIRequest BIR = new BIRequest();
            BIR.url = Helper.ServerUrl + "Execute.ashx?Serlet=GetDBStore&ACT=" + act;

            if (Parms != null)
                for (int i = 0; i < Parms.Count; i++)
                {
                    PostParm p = (PostParm)Parms[i];
                    BIR.AddFormParam(p.ParmName, p.ParmValue);

                }
            if (BIR.Request())
            {
                try
                {
                    SrvResponse r = new SrvResponse(BIR.Response());
                    DataTable dt = r.GetResultTable();
                    cmb.DataSource = dt;
                    cmb.DisplayMember = DisplayMember;// "";
                    cmb.ValueMember = ValueMember;// "";
                }

补充：软件开发 , C语言 ,