Camstar客制化开发查询数据库数据并显示在JQDataGrid表中（SQL语句编写在UserQuery中）同时获取JQDataGrid中值回传到Designer中

UserQuery中添加SQL语句

cs代码

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Camstar.WebPortal.WebPortlets;
using Camstar.WebPortal.FormsFramework.WebControls;
using Camstar.WebPortal.FormsFramework.WebGridControls;
using Camstar.WebPortal.FormsFramework.Utilities;
using Camstar.WCF.Services;
using OM = Camstar.WCF.ObjectStack;
using Camstar.WCF.ObjectStack;
using System.Data;
using Camstar.WebPortal.Personalization;

namespace Camstar.WebPortal.WebPortlets.Shopfloor
{
    /// <summary>
    /// desLotComponentRemove 的摘要说明
    /// </summary>Camstar.WebPortal.WebPortlets.Shopfloor.desLotComponentRemove
    public class desLotComponentRemove : MatrixWebPart
    {
        public desLotComponentRemove()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }



        #region 事件
        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            JQDataGrid containerGrid = ContainerGrid;
            _Button_Clear.Click += _Button_ClearClick;
            _Button_Remove.Click += _Button_Remove_Click;
            if (Page.IsPostBack)
            {
                CurrentContainer.DataChanged += new EventHandler(CurrentContainer_DataChanged);
            }
        }

        private void _Button_Remove_Click(object sender, EventArgs e)  //Remove物料
        {
            //  throw new NotImplementedException();
            FrameworkSession session = FrameworkManagerUtil.GetFrameworkSession(HttpContext.Current.Session);
            var service = new Camstar.WCF.Services.desLotComponentRemoveService(session.CurrentUserProfile);
            OM.desLotComponentRemove serviceData = new OM.desLotComponentRemove();
            serviceData.desNumberingRule = _desNumberingRule.Data as NamedObjectRef;//serviceData传值
            serviceData.desRemovalReason = _RemovalReason.Data as NamedObjectRef;
            serviceData.Container = CurrentContainer.Data as ContainerRef;
            serviceData.desPrintQueue = _PrintQueue.Data as NamedObjectRef;
            serviceData.desLableCount = 1;
            serviceData.desPrinterLabelDefinition = desPrinterLabelDefinition.Data as RevisionedObjectRef;
            desLotComponentRemove_Request request = new desLotComponentRemove_Request();
            desLotComponentRemove_Result result = new desLotComponentRemove_Result();
            List<desComponentRemoveList> list = new List<desComponentRemoveList>();
            JQDataGrid grid = ContainerGrid;
            int j = grid.TotalRowCount;
            for (int i = j - 1; i >= 0; i--)
            {
                desComponentRemoveList Item = (desComponentRemoveList)grid.GridContext.GetItem(i.ToString());
                desComponentRemoveList eiten = new desComponentRemoveList();

                if (Item.desStatus == true)//传入页面勾选的值（其中desStatus为在Designer中添加的Boolean[Boolean]类型的字段）
                {
                    eiten.Product = Item.Product;
                    eiten.IssueQty = Item.IssueQty;
                    eiten.ProductDescription = Item.ProductDescription;
                    eiten.IssueFromContainer = Item.IssueFromContainer;
                    eiten.IssueControl = Item.IssueControl;
                    eiten.desRemoveLotQty = Item.desRemoveLotQty;
                    eiten.desStatus = Item.desStatus;
                    eiten.ActualQtyIssued = Item.ActualQtyIssued;
                    eiten.IssueActualsHistory = Item.IssueActualsHistory;
                    list.Add(eiten);
                }
            }
            if (list.Count < 1)
            {
                Page.DisplayMessage("错误信息:未选择移除的物料！", false);
            }
            else
            {
                serviceData.desComponentRemoveList = list.ToArray();
                ResultStatus resultStatus = new ResultStatus();
                resultStatus = service.ExecuteTransaction(serviceData, request, out result);

                if (resultStatus.IsSuccess)
                {
                    Page.ClearValues(true);
                    Page.DisplayMessage("物料移除成功", true);
                }
                else
                {
                    Page.ClearValues(false);
                    Page.DisplayMessage("物料移除失败："+ resultStatus, false);
                }
            }
        }

        private void _Button_ClearClick(object sender, EventArgs e)
        {
            //throw new NotImplementedException();
            CurrentContainer.ClearData();
            ContainerGrid.ClearData();
            Page.ClearValues();
        }
        #endregion



        #region 方法
        private void CurrentContainer_DataChanged(object sender, EventArgs e)//通过Container查询
        {
            //throw new NotImplementedException();
            var Container = CurrentContainer.Data != null ? CurrentContainer.Data.ToString() : string.Empty;
            FrameworkSession fs = FrameworkManagerUtil.GetFrameworkSession(this.Page.Session);
            QueryService queryService = new QueryService(fs.CurrentUserProfile);

            QueryParameters queryParam = new QueryParameters();
            queryParam.Parameters = new QueryParameter[1];
            queryParam.Parameters[0] = new QueryParameter();
            queryParam.Parameters[0].Name = "containername";
            queryParam.Parameters[0].Value = Container;
            QueryOptions queryOption = new QueryOptions();
            queryOption.QueryType = Camstar.WCF.ObjectStack.QueryType.User;
            if (Container != null)
            {
                RecordSet record = new RecordSet();
                ResultStatus Result = queryService.Execute("desGetComponentRemoveDetail", queryParam, queryOption, out record);

                if (Result.IsSuccess && record.TotalCount.ToString()!=null)
                {
                    Page.ClearValues(true);
                    DataTable resultDt = record.GetAsDataTable();
                    List<desComponentRemoveList> list = new List<desComponentRemoveList>();
                    if (resultDt != null && resultDt.Rows != null && resultDt.Rows.Count > 0)
                    {
                        foreach (DataRow row in resultDt.Rows)
                        {
                            desComponentRemoveList c = new desComponentRemoveList();
                            c.IssueActualsHistory = new SubentityRef(row[0].ToString());
                            c.IssueFromContainer = new ContainerRef(row[1].ToString());
                            c.Product = new RevisionedObjectRef(row[2].ToString(), row[3].ToString());
                            c.ProductDescription = row[4].ToString();
                            c.IssueQty = double.Parse(row[5].ToString());
                            c.ActualQtyIssued = double.Parse(row[6].ToString());
                            switch (row[7].ToString())
                            {
                                case "1": c.IssueControl = IssueControlEnum.Serialized;break;
                                case "2": c.IssueControl = IssueControlEnum.Bulk; break;
                                case "3": c.IssueControl = IssueControlEnum.LotAndStockPoint; break;
                                case "4": c.IssueControl = IssueControlEnum.StockPointOnly; break;
                                case "5": c.IssueControl = IssueControlEnum.NoTracking; break;
                                case "6": c.IssueControl = IssueControlEnum.CommentOnly; break;
                                default : c.IssueControl = null; break;

                            }
                            
                            c.desRemoveLotQty = double.Parse(row[6].ToString());
                            
                            list.Add(c);
                        }
                        ContainerGrid.Data = list.ToArray();
                    }
                    else
                    {
                        Page.DisplayMessage("未查询到Contaienr:" + Container + "的相关信息。", false);
                    }
                }
              
            }
        }



        #endregion


        #region 捕获控件
        protected virtual ContainerListGrid CurrentContainer
        {
            get
            {
                return Page.FindCamstarControl("desLotComponentRemove_Container") as ContainerListGrid;
            }
        }

        protected virtual JQDataGrid ContainerGrid
        {
            get
            {
                return Page.FindCamstarControl("desLotComponentRemove_desComponentRemoveList") as JQDataGrid;
            }
        }
        protected virtual Button _Button_Clear
        {
            get
            {
                return Page.FindCamstarControl("Button_Clear") as Button;
            }
        }
        protected virtual Button _Button_Remove
        {
            get
            {
                return Page.FindCamstarControl("Button_Remove") as Button;
            }
        }
        protected virtual NamedObject _RemovalReason
        {
            get
            {
                return Page.FindCamstarControl("desLotComponentRemove_desRemovalReason") as NamedObject;
            }
        }
        protected virtual NamedObject _desNumberingRule
        {
            get
            {
                return Page.FindCamstarControl("desLotComponentRemove_desNumberingRule") as NamedObject;
            }
        }

        protected virtual TextBox desLableCount
        {
            get
            {
                return Page.FindCamstarControl("desLotComponentRemove_desLableCount") as TextBox;
            }
        }


        protected virtual NamedObject _PrintQueue
        {
            get
            {
                return Page.FindCamstarControl("desLotComponentRemove_desPrintQueue") as NamedObject;
            }
        }

        protected virtual Camstar.WebPortal.FormsFramework.WebControls.RevisionedObject desPrinterLabelDefinition
        {
            get
            {
                return Page.FindCamstarControl("desLotComponentRemove_desPrinterLabelDefinition") as Camstar.WebPortal.FormsFramework.WebControls.RevisionedObject;
            }
        }
        #endregion

    }
}

站在巨人的肩膀上真的会看的更远更清晰！

　　　　　　　　　　　　　　　　　　　　　　　　　　　-----用志不分，乃凝于神