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

UserQuery中添加SQL语句
cs代码
  1 using System;
  2 using System.Collections.Generic;
  3 using System.Linq;
  4 using System.Web;
  5 using Camstar.WebPortal.WebPortlets;
  6 using Camstar.WebPortal.FormsFramework.WebControls;
  7 using Camstar.WebPortal.FormsFramework.WebGridControls;
  8 using Camstar.WebPortal.FormsFramework.Utilities;
  9 using Camstar.WCF.Services;
 10 using OM = Camstar.WCF.ObjectStack;
 11 using Camstar.WCF.ObjectStack;
 12 using System.Data;
 13 using Camstar.WebPortal.Personalization;
 14 
 15 namespace Camstar.WebPortal.WebPortlets.Shopfloor
 16 {
 17     /// <summary>
 18     /// desLotComponentRemove 的摘要说明
 19     /// </summary>Camstar.WebPortal.WebPortlets.Shopfloor.desLotComponentRemove
 20     public class desLotComponentRemove : MatrixWebPart
 21     {
 22         public desLotComponentRemove()
 23         {
 24             //
 25             // TODO: 在此处添加构造函数逻辑
 26             //
 27         }
 28 
 29 
 30 
 31         #region 事件
 32         protected override void OnLoad(EventArgs e)
 33         {
 34             base.OnLoad(e);
 35             JQDataGrid containerGrid = ContainerGrid;
 36             _Button_Clear.Click += _Button_ClearClick;
 37             _Button_Remove.Click += _Button_Remove_Click;
 38             if (Page.IsPostBack)
 39             {
 40                 CurrentContainer.DataChanged += new EventHandler(CurrentContainer_DataChanged);
 41             }
 42         }
 43 
 44         private void _Button_Remove_Click(object sender, EventArgs e)  //Remove物料
 45         {
 46             //  throw new NotImplementedException();
 47             FrameworkSession session = FrameworkManagerUtil.GetFrameworkSession(HttpContext.Current.Session);
 48             var service = new Camstar.WCF.Services.desLotComponentRemoveService(session.CurrentUserProfile);
 49             OM.desLotComponentRemove serviceData = new OM.desLotComponentRemove();
 50             serviceData.desNumberingRule = _desNumberingRule.Data as NamedObjectRef;//serviceData传值
 51             serviceData.desRemovalReason = _RemovalReason.Data as NamedObjectRef;
 52             serviceData.Container = CurrentContainer.Data as ContainerRef;
 53             serviceData.desPrintQueue = _PrintQueue.Data as NamedObjectRef;
 54             serviceData.desLableCount = 1;
 55             serviceData.desPrinterLabelDefinition = desPrinterLabelDefinition.Data as RevisionedObjectRef;
 56             desLotComponentRemove_Request request = new desLotComponentRemove_Request();
 57             desLotComponentRemove_Result result = new desLotComponentRemove_Result();
 58             List<desComponentRemoveList> list = new List<desComponentRemoveList>();
 59             JQDataGrid grid = ContainerGrid;
 60             int j = grid.TotalRowCount;
 61             for (int i = j - 1; i >= 0; i--)
 62             {
 63                 desComponentRemoveList Item = (desComponentRemoveList)grid.GridContext.GetItem(i.ToString());
 64                 desComponentRemoveList eiten = new desComponentRemoveList();
 65 
 66                 if (Item.desStatus == true)//传入页面勾选的值（其中desStatus为在Designer中添加的Boolean[Boolean]类型的字段）
 67                 {
 68                     eiten.Product = Item.Product;
 69                     eiten.IssueQty = Item.IssueQty;
 70                     eiten.ProductDescription = Item.ProductDescription;
 71                     eiten.IssueFromContainer = Item.IssueFromContainer;
 72                     eiten.IssueControl = Item.IssueControl;
 73                     eiten.desRemoveLotQty = Item.desRemoveLotQty;
 74                     eiten.desStatus = Item.desStatus;
 75                     eiten.ActualQtyIssued = Item.ActualQtyIssued;
 76                     eiten.IssueActualsHistory = Item.IssueActualsHistory;
 77                     list.Add(eiten);
 78                 }
 79             }
 80             if (list.Count < 1)
 81             {
 82                 Page.DisplayMessage("错误信息:未选择移除的物料！", false);
 83             }
 84             else
 85             {
 86                 serviceData.desComponentRemoveList = list.ToArray();
 87                 ResultStatus resultStatus = new ResultStatus();
 88                 resultStatus = service.ExecuteTransaction(serviceData, request, out result);
 89 
 90                 if (resultStatus.IsSuccess)
 91                 {
 92                     Page.ClearValues(true);
 93                     Page.DisplayMessage("物料移除成功", true);
 94                 }
 95                 else
 96                 {
 97                     Page.ClearValues(false);
 98                     Page.DisplayMessage("物料移除失败："+ resultStatus, false);
 99                 }
100             }
101         }
102 
103         private void _Button_ClearClick(object sender, EventArgs e)
104         {
105             //throw new NotImplementedException();
106             CurrentContainer.ClearData();
107             ContainerGrid.ClearData();
108             Page.ClearValues();
109         }
110         #endregion
111 
112 
113 
114         #region 方法
115         private void CurrentContainer_DataChanged(object sender, EventArgs e)//通过Container查询
116         {
117             //throw new NotImplementedException();
118             var Container = CurrentContainer.Data != null ? CurrentContainer.Data.ToString() : string.Empty;
119             FrameworkSession fs = FrameworkManagerUtil.GetFrameworkSession(this.Page.Session);
120             QueryService queryService = new QueryService(fs.CurrentUserProfile);
121 
122             QueryParameters queryParam = new QueryParameters();
123             queryParam.Parameters = new QueryParameter[1];
124             queryParam.Parameters[0] = new QueryParameter();
125             queryParam.Parameters[0].Name = "containername";
126             queryParam.Parameters[0].Value = Container;
127             QueryOptions queryOption = new QueryOptions();
128             queryOption.QueryType = Camstar.WCF.ObjectStack.QueryType.User;
129             if (Container != null)
130             {
131                 RecordSet record = new RecordSet();
132                 ResultStatus Result = queryService.Execute("desGetComponentRemoveDetail", queryParam, queryOption, out record);
133 
134                 if (Result.IsSuccess && record.TotalCount.ToString()!=null)
135                 {
136                     Page.ClearValues(true);
137                     DataTable resultDt = record.GetAsDataTable();
138                     List<desComponentRemoveList> list = new List<desComponentRemoveList>();
139                     if (resultDt != null && resultDt.Rows != null && resultDt.Rows.Count > 0)
140                     {
141                         foreach (DataRow row in resultDt.Rows)
142                         {
143                             desComponentRemoveList c = new desComponentRemoveList();
144                             c.IssueActualsHistory = new SubentityRef(row[0].ToString());
145                             c.IssueFromContainer = new ContainerRef(row[1].ToString());
146                             c.Product = new RevisionedObjectRef(row[2].ToString(), row[3].ToString());
147                             c.ProductDescription = row[4].ToString();
148                             c.IssueQty = double.Parse(row[5].ToString());
149                             c.ActualQtyIssued = double.Parse(row[6].ToString());
150                             switch (row[7].ToString())
151                             {
152                                 case "1": c.IssueControl = IssueControlEnum.Serialized;break;
153                                 case "2": c.IssueControl = IssueControlEnum.Bulk; break;
154                                 case "3": c.IssueControl = IssueControlEnum.LotAndStockPoint; break;
155                                 case "4": c.IssueControl = IssueControlEnum.StockPointOnly; break;
156                                 case "5": c.IssueControl = IssueControlEnum.NoTracking; break;
157                                 case "6": c.IssueControl = IssueControlEnum.CommentOnly; break;
158                                 default : c.IssueControl = null; break;
159 
160                             }
161                             
162                             c.desRemoveLotQty = double.Parse(row[6].ToString());
163                             
164                             list.Add(c);
165                         }
166                         ContainerGrid.Data = list.ToArray();
167                     }
168                     else
169                     {
170                         Page.DisplayMessage("未查询到Contaienr:" + Container + "的相关信息。", false);
171                     }
172                 }
173               
174             }
175         }
176 
177 
178 
179         #endregion
180 
181 
182         #region 捕获控件
183         protected virtual ContainerListGrid CurrentContainer
184         {
185             get
186             {
187                 return Page.FindCamstarControl("desLotComponentRemove_Container") as ContainerListGrid;
188             }
189         }
190 
191         protected virtual JQDataGrid ContainerGrid
192         {
193             get
194             {
195                 return Page.FindCamstarControl("desLotComponentRemove_desComponentRemoveList") as JQDataGrid;
196             }
197         }
198         protected virtual Button _Button_Clear
199         {
200             get
201             {
202                 return Page.FindCamstarControl("Button_Clear") as Button;
203             }
204         }
205         protected virtual Button _Button_Remove
206         {
207             get
208             {
209                 return Page.FindCamstarControl("Button_Remove") as Button;
210             }
211         }
212         protected virtual NamedObject _RemovalReason
213         {
214             get
215             {
216                 return Page.FindCamstarControl("desLotComponentRemove_desRemovalReason") as NamedObject;
217             }
218         }
219         protected virtual NamedObject _desNumberingRule
220         {
221             get
222             {
223                 return Page.FindCamstarControl("desLotComponentRemove_desNumberingRule") as NamedObject;
224             }
225         }
226 
227         protected virtual TextBox desLableCount
228         {
229             get
230             {
231                 return Page.FindCamstarControl("desLotComponentRemove_desLableCount") as TextBox;
232             }
233         }
234 
235 
236         protected virtual NamedObject _PrintQueue
237         {
238             get
239             {
240                 return Page.FindCamstarControl("desLotComponentRemove_desPrintQueue") as NamedObject;
241             }
242         }
243 
244         protected virtual Camstar.WebPortal.FormsFramework.WebControls.RevisionedObject desPrinterLabelDefinition
245         {
246             get
247             {
248                 return Page.FindCamstarControl("desLotComponentRemove_desPrinterLabelDefinition") as Camstar.WebPortal.FormsFramework.WebControls.RevisionedObject;
249             }
250         }
251         #endregion
252 
253     }
254 }
站在巨人的肩膀上真的会看的更远更清晰！
　　　　　　　　　　　　　　　　　　　　　　　　　　　-----用志不分，乃凝于神