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);
}
}
