/// <summary>
/// 排序方法
/// </summary>
public int Compare(object x, object y)
{
ItemizedBill o1 = (x as ItemizedBill);
ItemizedBill o2 = (y as ItemizedBill);
string oX = o1.OperDate; //操作日期
string oY = o2.OperDate; //
int nComp;
if (oX == null)
{
nComp = (oY != null) ? -1 : 0;
}
else if (oY == null)
{
nComp = 1;
}
else
{
nComp = string.Compare(oX.ToString(), oY.ToString());
}
return(nComp);
}
private ArrayList QueryItemizedData(string execSql, DataSource dataSource, DateTime beginDate, DateTime endDate)
{
if (dataManagment.ExecQuery(execSql, this.DrugDept.ID, this.DrugCode, beginDate.ToString(), endDate.ToString()) == -1)
{
MessageBox.Show("执行查询Sql语句发生错误" + this.dataManagment.Err);
return(null);
}
ArrayList alData = new ArrayList();
while (this.dataManagment.Reader.Read())
{
ItemizedBill info = new ItemizedBill();
info.Source = dataSource;
info.OperDate = this.dataManagment.Reader[0].ToString(); //日期
info.ListNO = this.dataManagment.Reader[1].ToString(); //单据号
info.OperType = this.dataManagment.Reader[2].ToString(); //权限类别
info.TargetDeptNO = this.dataManagment.Reader[3].ToString();
info.Qty = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.dataManagment.Reader[4]);
info.RetailPrice = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.dataManagment.Reader[5]);
info.Cost = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.dataManagment.Reader[6]);
if (dataManagment.Reader.FieldCount > 7)
{
info.BatchNo = this.dataManagment.Reader[7].ToString();
}
if (dataManagment.Reader.FieldCount > 8)
{
info.PurchasePrice = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.dataManagment.Reader[8]);
}
alData.Add(info);
}
return(alData);
}
/// <summary>
/// 数据检索显示
/// </summary>
/// <param name="alData">所有数据</param>
/// <returns>成功返回1 失败返回-1</returns>
protected int ShowData(ArrayList alData)
{
this.neuSpread1_Sheet1.Rows.Count = 0;
this.neuSpread1_Sheet1.Rows.Count = 0;
int iRowIndex = 0;
string currentMonthStr = "";
for (int i = 0; i < alData.Count; i++)
{
ItemizedBill info = alData[i] as ItemizedBill;
this.neuSpread1_Sheet1.Rows.Add(iRowIndex, 1);
this.neuSpread1_Sheet1.Cells[iRowIndex, 0].Text = info.OperDate; //日期
this.neuSpread1_Sheet1.Cells[iRowIndex, 1].Text = info.ListNO; //凭证编号
this.neuSpread1_Sheet1.Cells[iRowIndex, 2].Text = info.TargetDeptNO; //摘要
// 购入价
if (info.Source == DataSource.In || info.Source == DataSource.Out)
{
this.neuSpread1_Sheet1.Cells[iRowIndex, 3].Text = info.PurchasePrice.ToString();
}
else
{
this.neuSpread1_Sheet1.Cells[iRowIndex, 3].Text = "";
}
//增加批号显示 sdh 2010-01-07
this.neuSpread1_Sheet1.Cells[iRowIndex, 12].Text = info.BatchNo;//批号
string source = info.OperType;
if ((info.Source == DataSource.In) || (info.Source == DataSource.Adjust && info.OperType == "调盈") ||
(info.Source == DataSource.Check && info.OperType == "盘盈"))
{
this.neuSpread1_Sheet1.Cells[iRowIndex, 4].Text = info.Qty.ToString();
this.neuSpread1_Sheet1.Cells[iRowIndex, 5].Text = info.RetailPrice.ToString();
this.neuSpread1_Sheet1.Cells[iRowIndex, 6].Text = info.Cost.ToString();
if (this.hsProduce.ContainsKey(info.TargetDeptNO))
{
source = source + "(" + this.hsProduce[info.TargetDeptNO] + ")";
}
}
else if ((info.Source == DataSource.Out) || (info.Source == DataSource.Adjust && info.OperType == "调亏") ||
(info.Source == DataSource.Check && info.OperType == "盘亏"))
{
this.neuSpread1_Sheet1.Cells[iRowIndex, 7].Text = info.Qty.ToString();
this.neuSpread1_Sheet1.Cells[iRowIndex, 8].Text = info.RetailPrice.ToString();
this.neuSpread1_Sheet1.Cells[iRowIndex, 9].Text = info.Cost.ToString();
if (this.hsDept.ContainsKey(info.TargetDeptNO))
{
source = source + "(" + this.hsDept[info.TargetDeptNO] + ")";
}
}
else if (info.Source == DataSource.MonthCurrent || info.Source == DataSource.MonthLast)
{
this.neuSpread1_Sheet1.Cells[iRowIndex, 10].Text = info.Qty.ToString();
this.neuSpread1_Sheet1.Cells[iRowIndex, 11].Text = info.Cost.ToString();
this.neuSpread1_Sheet1.Rows[iRowIndex].Tag = info.Source.ToString();
}
this.neuSpread1_Sheet1.Cells[iRowIndex, 2].Text = source; //摘要
if (info.Source == DataSource.In)
{
this.neuSpread1_Sheet1.Cells[iRowIndex, 2].Text = source + "(" + info.TargetDeptNO + ")";
}
if (info.OperType == "本期库存")
{
iRowIndex++;
this.neuSpread1_Sheet1.Rows.Add(iRowIndex, 1);
this.neuSpread1_Sheet1.Cells[iRowIndex, 0].Text = info.OperDate.Substring(0, 7);
this.neuSpread1_Sheet1.Cells[iRowIndex, 2].Text = "本期合计";
this.neuSpread1_Sheet1.Rows[iRowIndex].Tag = "1"; //标识合计行
}
iRowIndex++;
currentMonthStr = info.OperDate.Substring(0, 8);
//if (string.IsNullOrEmpty(currentMonthStr) == true)
//{
// currentMonthStr = info.OperDate.Substring(0, 7);
//}
//else
//{
// if (currentMonthStr != info.OperDate.Substring(0, 7)) //不是同一个月的数据
// {
// this.neuSpread1_Sheet1.Rows.Add(iRowIndex, 1);
// this.neuSpread1_Sheet1.Cells[iRowIndex, 0].Text = info.OperDate.Substring(0, 7);
// this.neuSpread1_Sheet1.Cells[iRowIndex, 2].Text = "本期合计";
// this.neuSpread1_Sheet1.Rows[iRowIndex].Tag = "1"; //标识合计行
// iRowIndex++;
// currentMonthStr = info.OperDate.Substring(0, 7);
// }
//}
}
//this.neuSpread1_Sheet1.Rows.Add(iRowIndex, 1);
//this.neuSpread1_Sheet1.Cells[iRowIndex, 0].Text = currentMonthStr;
//this.neuSpread1_Sheet1.Cells[iRowIndex, 2].Text = "本期合计";
//this.neuSpread1_Sheet1.Rows[iRowIndex].Tag = "1";
this.neuSpread1_Sheet1.Rows.Add(iRowIndex, 1);
this.neuSpread1_Sheet1.Cells[iRowIndex, 0].Text = "";
this.neuSpread1_Sheet1.Cells[iRowIndex, 2].Text = "当前合计";
this.neuSpread1_Sheet1.Rows[iRowIndex].Tag = "1"; //标识合计行
this.SumByMonth();
return(1);
}