Camstar客制化开发查询数据库数据并显示在JQDataGrid表中（SQL语句编写在代码中）

设计vp界面

查询数据库显示数据

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Camstar.WebPortal.FormsFramework.WebGridControls;
using CWC = Camstar.WebPortal.FormsFramework.WebControls;
using OM = Camstar.WCF.ObjectStack;
using Camstar.WCF.ObjectStack;
using Camstar.WebPortal.FormsFramework.Utilities;
using Camstar.WebPortal.Utilities;
using Camstar.WebPortal.Personalization;
using Camstar.WebPortal.FormsFramework;
using Camstar.WebPortal.PortalFramework;
using Camstar.WebPortal.FormsFramework.WebControls;

/// <summary>
/// TestRemove 的摘要说明
/// </summary>
namespace Camstar.WebPortal.WebPortlets.Shopfloor
{
    public class TestRemove : MatrixWebPart
    {
        public TestRemove()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }
        #region   捕获控件
        protected virtual ContainerListGrid _Container
        {
            get { return Page.FindCamstarControl("TestRemove_Container") as ContainerListGrid; }
        }

        protected virtual JQDataGrid _Testdetails
        {
            get
            {
                return Page.FindCamstarControl("TestRemove_TestDetails") as JQDataGrid;
            }
        }
        protected virtual Button Submit_bt
        {
            get
            {
                return Page.FindCamstarControl("Submit_bt") as Button;
            }
        }
        #endregion

        #region   Load

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);

            Submit_bt.Click += _Container_DataChanged;//前提是设置vp界面属性AuToPostBack为True
        }
        
        #endregion

        #region   方法

        private void _Container_DataChanged(object sender, EventArgs e)
        {
            var Container = _Container.Data != null ? _Container.Data.ToString() : string.Empty;
            FrameworkSession session = FrameworkManagerUtil.GetFrameworkSession(HttpContext.Current.Session);
            var service = new Camstar.WCF.Services.QueryService(session.CurrentUserProfile);
            var QryOption = new WCF.ObjectStack.QueryOptions();
            var Result = new WCF.ObjectStack.RecordSet();
            ResultStatus success; 
            if(Container!=null){
                string sql = @" select c.containername,pb.productname,p.productrevision,p.description,il.qtyrequired ,
                          il.actualqtyissued,il.actualqty2issued,il.issuecontrol from IssueActualsHistory ih
                         left join container c on c.containerid = ih.fromcontainerid
                         left join product p on p.productid = ih.productid
                         left join productbase pb on pb.productbaseid = p.productbaseid
                         left join issuehistorydetail il on il.issuehistorydetailid = ih.issuehistorydetailid
                         left join container tt on tt.containerid=ih.tocontainerid
                          where tt.containername='{0}'";
                sql = string.Format(sql,Container);
                success = service.ExecuteAdHoc(sql, new WCF.ObjectStack.QueryOptions(), out Result);
                if (success.IsSuccess && Result.Rows != null && Result.Rows.Count() > 0)
                {
                    List<TestDetails> list = new List<TestDetails>();
                    for (int i = 0; i < Result.Rows.Count(); i++)
                    {
                        TestDetails c = new TestDetails();
                        Row rr = Result.Rows[i];
                        c.Container = new ContainerRef(rr.Values[0].ToString());
                        c.Product = new RevisionedObjectRef(rr.Values[1].ToString(), rr.Values[2].ToString());
                        c.Description = rr.Values[3].ToString();
                        c.Qtyrequired = double.Parse(rr.Values[4].ToString());
                        c.ActualQtyIssued = double.Parse(rr.Values[5].ToString());
                        c.RemoveQty = double.Parse(rr.Values[6].ToString());
                        c.IssueReason = new NamedObjectRef(rr.Values[7].ToString());
                        list.Add(c);
                    }
                    _Testdetails.Data = list.ToArray();
                }
            
            }
        }

        #endregion
    }
}

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

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