private void RefreshPositionItem(IssueItem issueItem) { for (int i = 0; i < mListPositionItems.Count; i++) { var posItem = mListPositionItems[i]; int pos = posItem.Pos; string serial = issueItem.Serial; var dataItem = mListLargeSmallData.FirstOrDefault(l => l.Serial == serial && l.Pos == pos); if (dataItem == null) { continue; } LargeSmallItem item = new LargeSmallItem(); item.Serial = serial; item.Date = issueItem.Date; item.Number = issueItem.Number; item.Pos = pos; item.Large = dataItem.Large; item.Small = dataItem.Small; item.Single = dataItem.Single; item.Double = dataItem.Double; item.LargeSmallNum = dataItem.LargeSmallNum; item.SingleDoubleNum = dataItem.SingleDoubleNum; item.LargeNum = dataItem.LargeNum; item.SmallNum = dataItem.SmallNum; item.SingleNum = dataItem.SingleNum; item.DoubleNum = dataItem.DoubleNum; posItem.Items.Add(item); } }
private void RefreshSumValueItem(IssueItem issueItem) { int pos = 6; string serial = issueItem.Serial; var dataItem = mListLargeSmallData.FirstOrDefault(l => l.Serial == serial && l.Pos == pos); if (dataItem == null) { return; } LargeSmallItem item = new LargeSmallItem(); item.Serial = serial; item.Date = issueItem.Date; item.Number = issueItem.Number; item.Pos = pos; item.SumValue = issueItem.SumValue; item.Large = dataItem.Large; item.Small = dataItem.Small; item.Single = dataItem.Single; item.Double = dataItem.Double; item.LargeSmallNum = dataItem.LargeSmallNum; item.SingleDoubleNum = dataItem.SingleDoubleNum; item.LargeNum = dataItem.LargeNum; item.SmallNum = dataItem.SmallNum; item.SingleNum = dataItem.SingleNum; item.DoubleNum = dataItem.DoubleNum; mListSumValueItems.Add(item); }
private void InitSumValueItems() { mListSumValueItems.Clear(); int pos = 6; var dateItem = ComboDate.SelectedItem as DateItem; if (dateItem == null) { return; } int date = dateItem.Date; if (PageParent == null) { return; } var issueItems = PageParent.ListIssueItems; if (issueItems == null) { return; } var data = mListLargeSmallData.Where(l => l.Date == date && l.Pos == pos).ToList(); for (int i = 0; i < data.Count; i++) { var dataItem = data[i]; string serial = dataItem.Serial; var issueItem = issueItems.FirstOrDefault(s => s.Serial == serial); if (issueItem == null) { continue; } LargeSmallItem item = new LargeSmallItem(); item.Serial = serial; item.Date = date; item.Number = issueItem.Number; item.Pos = dataItem.Pos; item.SumValue = issueItem.SumValue; item.Large = dataItem.Large; item.Small = dataItem.Small; item.Single = dataItem.Single; item.Double = dataItem.Double; item.LargeSmallNum = dataItem.LargeSmallNum; item.SingleDoubleNum = dataItem.SingleDoubleNum; item.LargeNum = dataItem.LargeNum; item.SmallNum = dataItem.SmallNum; item.SingleNum = dataItem.SingleNum; item.DoubleNum = dataItem.DoubleNum; mListSumValueItems.Add(item); } }
private void LoadLargeSmallData() { mListLargeSmallData.Clear(); if (PageParent == null) { return; } var issueItems = PageParent.ListIssueItems; if (issueItems == null) { return; } var systemConfig = PageParent.SystemConfig; if (systemConfig == null) { return; } var db = systemConfig.Database; if (db == null) { return; } string strConn = db.GetConnectionString(); var first = issueItems.FirstOrDefault(); if (first == null) { return; } long begin = long.Parse(first.Serial); long end = long.Parse(first.Serial); for (int i = 0; i < issueItems.Count; i++) { var item = issueItems[i]; long serial = long.Parse(item.Serial); begin = Math.Min(serial, begin); end = Math.Max(serial, end); } string strSql = string.Format( "SELECT * FROM t_111_19 WHERE C001 >= {0} AND C001 <= {1} ORDER BY C001", begin, end); OperationReturn optReturn = MssqlOperation.GetDataSet(strConn, strSql); if (!optReturn.Result) { ShowException(string.Format("load large small data fail. [{0}]{1}", optReturn.Code, optReturn.Message)); return; } DataSet objDataSet = optReturn.Data as DataSet; if (objDataSet == null) { return; } for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++) { DataRow dr = objDataSet.Tables[0].Rows[i]; LargeSmallItem item = new LargeSmallItem(); item.Serial = dr["C001"].ToString(); item.Date = Convert.ToInt32(dr["C002"]); item.Number = Convert.ToInt32(dr["C003"]); item.Pos = Convert.ToInt32(dr["C004"]); item.Large = Convert.ToInt32(dr["C005"]) == 1; item.Small = Convert.ToInt32(dr["C006"]) == 1; item.Single = Convert.ToInt32(dr["C007"]) == 1; item.Double = Convert.ToInt32(dr["C008"]) == 1; item.LargeSmallNum = Convert.ToInt32(dr["C009"]); item.SingleDoubleNum = Convert.ToInt32(dr["C010"]); item.LargeNum = Convert.ToInt32(dr["C011"]); item.SmallNum = Convert.ToInt32(dr["C012"]); item.SingleNum = Convert.ToInt32(dr["C013"]); item.DoubleNum = Convert.ToInt32(dr["C014"]); mListLargeSmallData.Add(item); } }