/// <summary>
/// 查询
/// </summary>
/// <returns>成功返回1 失败返回-1</returns>
protected int Query()
{
if (!this.IsValid())
{
return(-1);
}
string strSqlIndex = this.GetSqlIndex();
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
DataSet ds = new DataSet();
if (dataManager.ExecQuery(strSqlIndex, ref ds, this.cmbDrug.Tag.ToString(), this.BeginTime.ToString(), this.EndTime.ToString()) == -1)
{
MessageBox.Show(Language.Msg("执行查询发生错误") + dataManager.Err);
return(-1);
}
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
this.neuSpread1_Sheet1.DataSource = ds;
}
else
{
this.neuSpread1_Sheet1.DataSource = null;
this.neuSpread1_Sheet1.Rows.Count = 0;
}
return(1);
}
/// <summary>
/// 查询
/// </summary>
/// <returns></returns>
protected int Query()
{
if (this.cmbStockDept.Tag == null || this.cmbStockDept.Tag.ToString() == "")
{
MessageBox.Show(Language.Msg("请选择查询药房"));
return(-1);
}
System.Data.DataSet ds = new DataSet();
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
if (dataManager.ExecQuery("Pharmacy.DayStore.DayReport", ref ds, this.cmbStockDept.Tag.ToString(), this.BeginTime.ToString(), this.EndTime.ToString()) == -1)
{
MessageBox.Show(Language.Msg("查询发生错误") + dataManager.Err);
return(-1);
}
if (ds == null || ds.Tables.Count <= 0)
{
return(0);
}
this.fpHead.DataSource = ds;
return(1);
}
/// <summary>
/// 查询
/// </summary>
/// <returns>成功返回1 失败返回-1</returns>
protected int Query()
{
if (!this.IsValid())
{
return(-1);
}
this.neuSpread1_Sheet1.Reset();
string strSqlIndex = this.GetSqlIndex();
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
DataSet ds = new DataSet();
if (dataManager.ExecQuery(strSqlIndex, ref ds, this.cmbDrug.Tag.ToString(), this.BeginTime.ToString(), this.EndTime.ToString()) == -1)
{
MessageBox.Show(Language.Msg("执行查询发生错误") + dataManager.Err);
return(-1);
}
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
this.neuSpread1_Sheet1.DataSource = ds;
//{F371AF75-B75B-43a1-82BD-849A1FECB300}取消第一行的空行
//this.neuSpread1_Sheet1.Rows.Add(0, 1);
//this.neuSpread1_Sheet1.Cells[0, 0].ColumnSpan = this.neuSpread1_Sheet1.Columns.Count;
}
else
{
this.neuSpread1_Sheet1.DataSource = null;
this.neuSpread1_Sheet1.Rows.Count = 0;
}
return(1);
}
/// <summary>
/// 查询
/// </summary>
/// <returns></returns>
protected int Query()
{
if (this.cmbStockDept.Tag == null || this.cmbStockDept.Tag.ToString() == "")
{
MessageBox.Show(Language.Msg("请选择查询药库"));
return(-1);
}
System.Data.DataSet ds = new DataSet();
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
if (dataManager.ExecQuery("Pharmacy.Report.InputSum", ref ds, this.cmbStockDept.Tag.ToString(), this.BeginTime.ToString(), this.EndTime.ToString()) == -1)
{
MessageBox.Show(Language.Msg("没有相关信息！") + dataManager.Err);
return(-1);
}
if (ds == null || ds.Tables.Count <= 0)
{
return(0);
}
this.fpSpread1_Sheet1.DataSource = ds;
int iTotIndex = this.fpSpread1_Sheet1.RowCount;
decimal sumNum4 = 0;
decimal sumNum3 = 0;
decimal sumNum2 = 0;
decimal sumNum1 = 0;
for (int i = 0; i < iTotIndex; i++)
{
sumNum1 = sumNum1 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 1].Text);
sumNum2 = sumNum2 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 2].Text);
sumNum3 = sumNum3 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 3].Text);
sumNum4 = sumNum4 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 4].Text);
}
//this.fpSpread1_Sheet1.RowCount = iTotIndex + 1;
this.fpSpread1_Sheet1.Rows.Add(iTotIndex, 1);
this.fpSpread1_Sheet1.Cells[iTotIndex, 0].Text = "合计";
this.fpSpread1_Sheet1.Cells[iTotIndex, 1].Text = sumNum1.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex, 2].Text = sumNum2.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex, 3].Text = sumNum3.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex, 4].Text = sumNum4.ToString();
return(1);
}
/// <summary>
/// 查询
/// </summary>
/// <returns></returns>
protected int Query()
{
//if (this.cmbStockDept.Tag == null || this.cmbStockDept.Tag.ToString() == "")
//{
// MessageBox.Show(Language.Msg("请选择查询药库"));
// return -1;
//}
ds.Clear();
this.GetQueryTime();
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
if (dataManager.ExecQuery("Pharmacy.Report.ExpenseQuery", ref ds, this.cmbNurseCellCode.Tag.ToString(), this.cmbDrugCode.Tag.ToString(), this.BeginTime.ToString(), this.EndTime.ToString(), DateNum) == -1)
{
MessageBox.Show(Language.Msg("没有相关信息！") + dataManager.Err);
return(-1);
}
if (ds == null || ds.Tables.Count <= 0)
{
return(0);
}
//this.filterField = new string[2] { "病区", "药品名称" };
this.dv = new DataView(this.ds.Tables[0]);
this.fpSpread1_Sheet1.DataSource = this.dv;
//int iTotIndex = this.fpSpread1_Sheet1.RowCount;
//decimal sumNum4 = 0;
//decimal sumNum3 = 0;
//decimal sumNum2 = 0;
//decimal sumNum1 = 0;
//for (int i = 0; i < iTotIndex; i++)
//{
// sumNum1 = sumNum1 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 1].Text);
// sumNum2 = sumNum2 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 2].Text);
// sumNum3 = sumNum3 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 3].Text);
// sumNum4 = sumNum4 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 4].Text);
//}
////this.fpSpread1_Sheet1.RowCount = iTotIndex + 1;
//this.fpSpread1_Sheet1.Rows.Add(iTotIndex, 1);
//this.fpSpread1_Sheet1.Cells[iTotIndex, 0].Text = "合计";
//this.fpSpread1_Sheet1.Cells[iTotIndex, 1].Text = sumNum1.ToString();
//this.fpSpread1_Sheet1.Cells[iTotIndex, 2].Text = sumNum2.ToString();
//this.fpSpread1_Sheet1.Cells[iTotIndex, 3].Text = sumNum3.ToString();
//this.fpSpread1_Sheet1.Cells[iTotIndex, 4].Text = sumNum4.ToString();
return(1);
}
/// <summary>
/// 查询
/// </summary>
/// <returns></returns>
protected int Query()
{
if (this.cmbStockDept.Tag == null || this.cmbStockDept.Tag.ToString() == "")
{
MessageBox.Show(Language.Msg("请选择查询药库"));
return(-1);
}
if (this.dtpBeginTime.Value > this.dtpEndTime.Value)
{
MessageBox.Show("开始时间不能大于结束时间！");
return(-1);
}
string sqlID = string.Empty;
if (neuCheckBox1.Checked)
{
//显示药品类别
sqlID = "WinForms.Report.Logistics.Pharmacy.InputSumBYDrugType";
}
else
{
//只按供货单位分组
sqlID = "Report.Logistics.Pharmacy.InputSum";
}
System.Data.DataSet ds = new DataSet();
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
if (dataManager.ExecQuery(sqlID, ref ds, this.cmbStockDept.Tag.ToString(), this.BeginTime.ToString(), this.EndTime.ToString()) == -1)
{
MessageBox.Show(Language.Msg("没有相关信息！") + dataManager.Err);
return(-1);
}
if (ds == null || ds.Tables.Count <= 0)
{
return(0);
}
this.fpSpread1_Sheet1.DataSource = ds;
int iTotIndex = this.fpSpread1_Sheet1.RowCount;
decimal sumNum4 = 0;
decimal sumNum3 = 0;
decimal sumNum2 = 0;
decimal sumNum1 = 0;
if (neuCheckBox1.Checked)
{
for (int i = 0; i < iTotIndex; i++)
{
sumNum1 = sumNum1 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 5].Text);
sumNum2 = sumNum2 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 2].Text);
sumNum3 = sumNum3 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 3].Text);
sumNum4 = sumNum4 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 4].Text);
}
//this.fpSpread1_Sheet1.RowCount = iTotIndex + 1;
this.fpSpread1_Sheet1.Rows.Add(iTotIndex, 1);
this.fpSpread1_Sheet1.Cells[iTotIndex, 0].Text = "合计";
this.fpSpread1_Sheet1.Cells[iTotIndex, 5].Text = sumNum1.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex, 2].Text = sumNum2.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex, 3].Text = sumNum3.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex, 4].Text = sumNum4.ToString();
}
else
{
for (int i = 0; i < iTotIndex; i++)
{
sumNum1 = sumNum1 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 1].Text);
sumNum2 = sumNum2 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 2].Text);
sumNum3 = sumNum3 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 3].Text);
sumNum4 = sumNum4 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 4].Text);
}
//this.fpSpread1_Sheet1.RowCount = iTotIndex + 1;
this.fpSpread1_Sheet1.Rows.Add(iTotIndex, 1);
this.fpSpread1_Sheet1.Cells[iTotIndex + 1, 0].Text = "合计";
this.fpSpread1_Sheet1.Cells[iTotIndex + 1, 1].Text = sumNum1.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex + 1, 2].Text = sumNum2.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex + 1, 3].Text = sumNum3.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex + 1, 4].Text = sumNum4.ToString();
}
return(1);
}