private void fpMainInfo_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
this.GetPrePayData();
}
private void neuSpread1_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
ModifyEmployee();
}
private void fpGroup_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
OpenGroupPropertyForm();
}
private void neuSpread1_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
AddDataInfo();
}
private void fpSpreadRegistRecord_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
bool boolTabPageFocus = true;
if (this.Parent.GetType() == typeof(TabPage))
{
TabControl tabControl = this.Parent.Parent as TabControl;
foreach (TabPage page in tabControl.TabPages)
{
foreach (Control c1 in page.Controls)
{
if (c1.GetType() == typeof(ucInvoiceInfoQuery))
{
if (boolTabPageFocus)
{
tabControl.SelectedTab = page;
}
boolTabPageFocus = false;
ucInvoiceInfoQuery ucInvoiceInfoQuery = c1 as ucInvoiceInfoQuery;
Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm("正在检索信息...");
Application.DoEvents();
// 费用明细数据集
System.Data.DataSet dsResult = new DataSet();
//初始化行数为0
ucInvoiceInfoQuery.SheetFeeDetail.Rows.Count = 0;
// 显示费用明细
this.intReturn = function.GetFeeDetailByClinicCode(this.Register.ID, ref dsResult);
if (this.intReturn == -1)
{
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
MessageBox.Show("获取费用明细失败!\n" + function.Err);
return;
}
if (dsResult.Tables[0].Rows.Count == 0)
{
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
MessageBox.Show("没有费用信息!");
return;
}
// 设置费用数据源为查询结果
for (int k = 0; k < dsResult.Tables[0].Rows.Count; k++)
{
ucInvoiceInfoQuery.SheetFeeDetail.Rows.Add(k, 1);
for (int j = 0; j < dsResult.Tables[0].Columns.Count; j++)
{
ucInvoiceInfoQuery.SheetFeeDetail.Cells[k, j].Text = dsResult.Tables[0].Rows[k][j].ToString();
}
}
ucInvoiceInfoQuery.SheetFeeDetail.Rows.Count = dsResult.Tables[0].Rows.Count;
ucInvoiceInfoQuery.SheetFeeDetail.Columns.Count = dsResult.Tables[0].Columns.Count;
Neusoft.HISFC.Components.Common.Classes.Function.DrawCombo(ucInvoiceInfoQuery.SheetFeeDetail, 6, 6);
foreach (FarPoint.Win.Spread.Column col in ucInvoiceInfoQuery.SheetFeeDetail.Columns)
{
col.Width = col.GetPreferredWidth();
}
for (int i = 0; i < ucInvoiceInfoQuery.SheetFeeDetail.Rows.Count; i++)
{
ucInvoiceInfoQuery.SheetFeeDetail.Rows[i].BackColor = Color.White;
if (ucInvoiceInfoQuery.SheetFeeDetail.Cells[i, 2].Text == "退费")
{
ucInvoiceInfoQuery.SheetFeeDetail.Rows[i].BackColor = Color.MistyRose;
}
}
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
}
else if (c1.GetType() == typeof(ucOrderHistoryQuery))
{
if (boolTabPageFocus)
{
tabControl.SelectedTab = page;
}
boolTabPageFocus = false;
ucOrderHistoryQuery ucOrderHistoryQuery = c1 as ucOrderHistoryQuery;
ucOrderHistoryQuery.OnSetValue(this.register);
}
}
}
}
}
/// <summary>
/// 双击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void neuSpread1_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
this.PopSelectWindow();
}
private void fpSpread1_CellClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
}
private void fpView_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
OpenSalesUnitPriceMaster();
}
private void neuSpread1_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
this.EditData();
}
private void fpSpread1_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
OkBtn.PerformClick();
}
private void fspdMc_CellClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
ComSpread.Spread_CellClickChangeBColor(fspdMc, e, Color.Lavender);
}
/// <summary>
/// 双击弹出患者明细信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void neuSpread1_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
if (e.Row < 0)
{
return;
}
DateTime dtBegin = new DateTime();
DateTime dtEnd = new DateTime();
DataTable dt = new DataTable();
DataSet ds1 = new DataSet();
DataSet ds2 = new DataSet();
string tempSQL = "";
string strErr = "";
string strDeptNM = "";
string strSubNM = "";
dtBegin = new DateTime(this.dtpBeginDate.Value.Year, this.dtpBeginDate.Value.Month, this.dtpBeginDate.Value.Day, 0, 0, 0);
dtEnd = new DateTime(this.dtpEndDate.Value.Year, this.dtpEndDate.Value.Month, this.dtpEndDate.Value.Day, 23, 59, 59);
strSubNM = this.neuSpread1_Sheet1.Cells[e.Row, 0].Text;
strDeptNM = this.neuSpread1_Sheet1.Cells[e.Row, 1].Text;
string caseInfo = string.Empty;
if (showCASInfo)
{
caseInfo = casInfoSql;
}
tempSQL = string.Format(strSQL2, dtBegin.ToString("yyyy-MM-dd"), dtEnd.ToString("yyyy-MM-dd"), strSubNM, caseInfo);
string exeSql = string.Format(strSQL3, dtBegin.ToString("yyyy-MM-dd"), dtEnd.ToString("yyyy-MM-dd"), strSubNM, caseInfo);
try
{
// interManager.ExecQuery(tempSQL, ref ds1);
//interManager.ExecQuery(exeSql, ref ds2);
}
catch (Exception ex)
{
strErr = "查询数据失败！" + ex.Message;
MessageBox.Show(strErr);
neuSpread1_Sheet2.RowCount = 0;
return;
}
if (ds2 != null && ds2.Tables.Count > 0 && ds2.Tables[0] != null)
{
this.sheetView2.ColumnHeader.Cells.Get(1, 0).Value = "病案已回收 查询时间：" + dtpBeginDate.Value.ToShortDateString() +
" 至 " + dtpEndDate.Value.ToShortDateString() +
" 科室：" + strDeptNM +
" 共" + ds2.Tables[0].Rows.Count.ToString() + "条记录";
sheetView2.RowCount = 0;
sheetView2.DataSource = ds2.Tables[0].DefaultView;
}
if (ds1 != null && ds1.Tables.Count > 0 && ds1.Tables[0] != null)
{
dt = ds1.Tables[0];
this.neuSpread1_Sheet2.ColumnHeader.Cells.Get(1, 0).Value = "病案未回收 查询时间：" + dtpBeginDate.Value.ToShortDateString() +
" 至 " + dtpEndDate.Value.ToShortDateString() +
" 科室：" + strDeptNM +
" 共" + dt.Rows.Count.ToString() + "条记录";
neuSpread1_Sheet2.RowCount = 0;
neuSpread1_Sheet2.DataSource = dt.DefaultView;
}
neuTab.SelectedIndex = 1;
}
/// <summary>
/// 双击，添加评分
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void fpSpread2_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
#region old
//判断是否已经有了
// this.fpSpread1_Sheet1.Rows.Add(this.fpSpread1_Sheet1.RowCount,1);
// int iRow = this.fpSpread1_Sheet1.RowCount -1;
// Neusoft.HISFC.Models.EPR.QCScore qcScore = (this.fpSpread2_Sheet1.ActiveRow.Tag as Neusoft.HISFC.Models.EPR.QCScore).Clone();
// this.fpSpread1_Sheet1.Cells[iRow ,0].Text = qcScore.ID;
// this.fpSpread1_Sheet1.Cells[iRow ,1].Text = qcScore.Type;
// this.fpSpread1_Sheet1.Cells[iRow ,2].Text = qcScore.Name;
// this.fpSpread1_Sheet1.Cells[iRow ,3].Text = qcScore.MiniScore;
// this.fpSpread1_Sheet1.Cells[iRow ,4].Text = qcScore.Memo;
#endregion
if (e.Row < 0)
{
return;
}
if (this.fpSpread2_Sheet1.Cells[e.Row, 5].Text.ToUpper() == "TRUE")
{
this.fpSpread2_Sheet1.Cells[e.Row, 5].Text = "False";
}
else
{
this.fpSpread2_Sheet1.Cells[e.Row, 5].Text = "True";
}
//#region zgx-2007-10-1
// if(e.Row <0) return;
// if(this.fpSpread2_Sheet1.Cells[e.Row ,5].Text.ToUpper()=="TRUE")
// {
// this.fpSpread2_Sheet1.Cells[e.Row ,5].Text = "False";
// this.fpSpread2_Sheet1.Cells[e.Row,4].Text="1";
// }
// else
// {
// if (this.fpSpread2_Sheet1.Cells[e.Row,4].Text.Trim()!="单项否决"&&this.fpSpread2_Sheet1.Cells[e.Row,4].Text.Trim()!="单项扣分")
// {
// id=this.fpSpread2_Sheet1.Cells[e.Row,0].Text;
// type=this.fpSpread2_Sheet1.Cells[e.Row,1].Text;
// name=this.fpSpread2_Sheet1.Cells[e.Row,2].Text;
// totalScore=this.fpSpread2_Sheet1.Cells[e.Row,3].Text;
// miniScore=this.fpSpread2_Sheet1.Cells[e.Row,5].Text;
// fqcsitem.StartPosition=FormStartPosition.CenterParent;
// fqcsitem.ShowDialog(this);
// if(fqcsitem.strItem>0)
// {
// nowRow6=fqcsitem.strItem;
// this.fpSpread2_Sheet1.Cells[e.Row,6].Text=Convert.ToString(fqcsitem.strItem);
// }
// else
// {
// this.fpSpread2_Sheet1.Cells[e.Row,6].Text="1";
// }
// }
// this.fpSpread2_Sheet1.Cells[e.Row ,7].Text = "True";
// }
// }
// #endregion
}
private void grdView_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
fwd = xC.xtDB.fwdDB.selectByPk1(grdView.Sheets[0].Cells[e.Row, colID].Value == null ? "" : grdView.Sheets[0].Cells[e.Row, colID].Value.ToString());
setControl();
setEnable(false);
}
private void neuSpread1_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
this.ShowMonthStoreDetail();
}
/// <summary>
/// 已维护终端双击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void neuSpread1_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
this.DeleteTerminal("1");
}
/// <summary>
/// 药品信息表格双击
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void fpMedicine_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
ArrayList rateList = new ArrayList();
int index = this.fpMedicine_Sheet1.ActiveRowIndex;
if (index < 0)
{
return;
}
else
{
Neusoft.HISFC.Models.Fee.Inpatient.FeeItemList item = this.fpMedicine_Sheet1.ActiveRow.Tag as Neusoft.HISFC.Models.Fee.Inpatient.FeeItemList;
rateList = this.localManager.QueryComparedItemCenterRate("2", item.Item.ID);
if (rateList == null)
{
MessageBox.Show("获取项目【" + item.Item.Name + "】的对照信息的中心自付比例失败 " + this.localManager.Err);
return;
}
else if (rateList.Count == 0)
{
MessageBox.Show("项目【" + item.Item.Name + "】没有进行对照或是目录外的项目 " + this.localManager.Err);
return;
}
else
{
frmSelectItemOwnRate frmRate = new frmSelectItemOwnRate();
frmRate.RateList = rateList;
frmRate.ShowDialog();
if (frmRate.DialogResult == DialogResult.OK)
{
if (frmRate.IsCheckAll)
{
for (int i = 0; i < this.fpMedicine_Sheet1.RowCount; i++)
{
Neusoft.HISFC.Models.Fee.Inpatient.FeeItemList fee = this.fpMedicine_Sheet1.Rows[i].Tag as Neusoft.HISFC.Models.Fee.Inpatient.FeeItemList;
if (fee.Item.ID == item.Item.ID)
{
fee.Item.SpecialFlag3 = "1";
fee.Item.SpecialFlag2 = frmRate.RateMemmo.ToString();
if (!string.IsNullOrEmpty(frmRate.RateMemmo.ToString()))
{
fee.Item.SpecialFlag1 = frmRate.Rate.ToString();
this.fpMedicine_Sheet1.Cells[i, 0].Value = true;
this.fpMedicine_Sheet1.Rows[i].ForeColor = Color.Black;
this.fpMedicine_Sheet1.Cells[i, 1].Text = frmRate.Rate.ToString();
this.fpMedicine_Sheet1.Cells[i, 2].Text = frmRate.RateMemmo.ToString();
}
else
{
fee.Item.SpecialFlag1 = "";
this.fpMedicine_Sheet1.Cells[i, 0].Value = true;
this.fpMedicine_Sheet1.Rows[i].ForeColor = Color.Black;
this.fpMedicine_Sheet1.Cells[i, 1].Text = fee.Item.SpecialFlag1;
this.fpMedicine_Sheet1.Cells[i, 2].Text = frmRate.RateMemmo.ToString();
}
this.fpMedicine_Sheet1.Rows[i].Tag = fee;
}
}
}
else
{
item.Item.SpecialFlag3 = "1";
item.Item.SpecialFlag2 = frmRate.RateMemmo.ToString();
if (!string.IsNullOrEmpty(frmRate.RateMemmo.ToString()))
{
item.Item.SpecialFlag1 = frmRate.Rate.ToString();
this.fpMedicine_Sheet1.Cells[index, 0].Value = true;
this.fpMedicine_Sheet1.Rows[index].ForeColor = Color.Black;
this.fpMedicine_Sheet1.Cells[index, 1].Text = frmRate.Rate.ToString();
this.fpMedicine_Sheet1.Cells[index, 2].Text = frmRate.RateMemmo.ToString();
}
else
{
item.Item.SpecialFlag1 = "";
this.fpMedicine_Sheet1.Cells[index, 0].Value = true;
this.fpMedicine_Sheet1.Rows[index].ForeColor = Color.Black;
this.fpMedicine_Sheet1.Cells[index, 1].Text = item.Item.SpecialFlag1;
this.fpMedicine_Sheet1.Cells[index, 2].Text = frmRate.RateMemmo.ToString();
}
this.fpMedicine_Sheet1.Rows[index].Tag = item;
}
}
}
}
}
void neuSpread1_CellClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
OnSort();
}
private void fpView_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
OnEdit();
}
private void spdDataDetail_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
frmLotHistory VLTH = new frmLotHistory(spdDataDetail.ActiveSheet.GetValue(spdDataDetail.ActiveSheet.ActiveRowIndex, 0).ToString());
VLTH.ShowDialog();
}
private void fpSpread1_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
this.Modify();
}
private void sp1_CellClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
GVar.gvSCode = sp1.ActiveSheet.Cells[e.Row, 0].Text;
GVar.gvSName = sp1.ActiveSheet.Cells[e.Row, 1].Text;
this.Close();
}
private void neuSpread9_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
this.ShowDetail(this.fpProblemList.Cells[e.Row, 0].Text, this.fpProblemList.Rows[e.Row].Tag);
this.neuTabControl1.TabPages[0].Select();
}
private void neuSpread2_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
this.DeleteSelectedRow();
}
private void fpSpreadRegistRecord_CellClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
// 显示挂号信息
this.Register = (Neusoft.HISFC.Models.Registration.Register) this.GetRowTag(this.SheetRegistRecord, e.Row);
}
private void neuSpread1_CellClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
try
{
Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm(Language.Msg("正在查询，请稍候..."));
Application.DoEvents();
string strCheckCode = string.Empty;
string strDeptID = string.Empty;
string strCheckDate = string.Empty;
decimal sumNum4 = 0;
decimal sumNum3 = 0;
decimal sumNum2 = 0;
decimal sumNum1 = 0;
int rowCount = 0;
DataSet ds1 = new DataSet();
DataSet ds2 = new DataSet();
strCheckCode = this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.ActiveRowIndex, 0].Text;
strDeptID = this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.ActiveRowIndex, 1].Text;
string[] param = { strCheckCode, strDeptID };
if (QueryDataBySql("WinForms.Report.Logistics.Pharmacy.Checkdetail1", ref ds1, param) == -1)
{
return;
}
this.neuSpread2_Sheet1.DataSource = ds1.Tables[0].DefaultView;
if (QueryDataBySql("WinForms.Report.Logistics.Pharmacy.Checkdetail2", ref ds2, param) == -1)
{
return;
}
this.neuSpread3_Sheet1.DataSource = ds2.Tables[0].DefaultView;
//label赋值
strCheckDate = this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.ActiveRowIndex, 5].Text;
this.lb21.Text = "科别：" + deptName;
this.lb22.Text = "封帐时间：" + strCheckDate;
this.lb23.Text = "封帐人：" + this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.ActiveRowIndex, 4].Text;
this.lb24.Text = "结存人：" + this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.ActiveRowIndex, 6].Text;
this.lb26.Text = "盘点单号：" + strCheckCode;
this.lb31.Text = "科别：" + deptName;
this.lb32.Text = "封帐时间：" + strCheckDate;
this.lb33.Text = "封帐人：" + this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.ActiveRowIndex, 4].Text;
this.lb34.Text = "结存人：" + this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.ActiveRowIndex, 6].Text;
this.lb36.Text = "盘点单号：" + strCheckCode;
//合计
rowCount = this.neuSpread2_Sheet1.RowCount;
for (int i = 0; i < rowCount; i++)
{
sumNum1 = sumNum1 + NConvert.ToDecimal(this.neuSpread2_Sheet1.Cells[i, 12].Text);
sumNum2 = sumNum2 + NConvert.ToDecimal(this.neuSpread2_Sheet1.Cells[i, 13].Text);
}
this.neuSpread2_Sheet1.Rows.Add(rowCount, 1);
//rowCount = this.neuSpread2_Sheet1.RowCount;
this.neuSpread2_Sheet1.Cells[rowCount, 0].Text = "合计：";
this.neuSpread2_Sheet1.Cells[rowCount, 12].Text = sumNum1.ToString();
this.neuSpread2_Sheet1.Cells[rowCount, 13].Text = sumNum2.ToString();
rowCount = this.neuSpread3_Sheet1.RowCount;
for (int i = 0; i < rowCount; i++)
{
sumNum3 = sumNum3 + NConvert.ToDecimal(this.neuSpread3_Sheet1.Cells[i, 9].Text);
sumNum4 = sumNum4 + NConvert.ToDecimal(this.neuSpread3_Sheet1.Cells[i, 10].Text);
}
this.neuSpread3_Sheet1.Rows.Add(rowCount, 1);
//rowCount = this.neuSpread3_Sheet1.RowCount;
this.neuSpread3_Sheet1.Cells[rowCount, 0].Text = "合计：";
this.neuSpread3_Sheet1.Cells[rowCount, 9].Text = sumNum3.ToString();
this.neuSpread3_Sheet1.Cells[rowCount, 10].Text = sumNum4.ToString();
this.neuTabControl1.SelectedIndex = 1;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
}
}
private void fpUser_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
OpenCreateUserForm();
}
/// <summary>
/// 删除一行
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void fpSpread2_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
del(e.Row);
}
private void spdData_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
this.Close();
}
private void GrdView_CellClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
this.Close();
}
