/// <summary>
/// 查询数据
/// </summary>
private void QueryData(string wherestr)
{
string str = @"SELECT
' ' 序号,
mg.blh,
yb.brxm,
(
CASE
WHEN yb.xb = 1 THEN '男'
WHEN yb.xb = 2 THEN '女'
ELSE '未知'
END
) xb,
yb.csrq,
mm.jzrq ,
mj.JSSJ,
dbo.fun_getDeptname(mj.JSKSDM) ksname,
mj.JSKSDM,
dbo.fun_getEmpName(mj.JSYSDM) ysname,
mj.JSYSDM,
mm.lxdh,
mm.xzdz,
(SELECT yk.KH FROM YY_KDJB AS yk WHERE mg.KDJID = yk.KDJID) kahao,
(select NAME from JC_OCCUPATI where CODE =mm.zy) as zy,
mg.GHSJ,
mm.jzxm ,
CASE WHEN mm.tiwen = 0 THEN NULL ELSE mm.tiwen END tiwen,
CASE WHEN mm.xueya = 0 THEN NULL ELSE mm.xueya END xueya,
CASE WHEN mm.maibo = 0 THEN NULL ELSE mm.maibo END maibo,
mm.yxjb ,
( CASE
WHEN mm.fenji = 1 THEN '1级'
WHEN mm.fenji = 2 THEN '2级'
WHEN mm.fenji = 3 THEN '3级'
END )
fenji ,
mm. fbrq ,
mm.zdsj ,
mm.lxbxjcs,
( CASE
WHEN mm.cfz = 0 THEN '初诊'
WHEN mm.cfz = 1 THEN '复诊'
END )cfz,
mm.crbyq ,
mm.bgr ,
CASE WHEN mm.xinlv = 0 THEN NULL ELSE mm.xinlv END xinlv,
CASE WHEN mm.huxi = 0 THEN NULL ELSE mm.huxi END huxi,
CASE WHEN mm.ssy = 0 THEN NULL ELSE mm.ssy END ssy,
mm.yishi ,
CASE WHEN mm.MEWSdf = 0 THEN NULL ELSE mm.MEWSdf END MEWSdf,
CASE WHEN mm.ksxt = 0 THEN NULL ELSE mm.ksxt END ksxt,
mm.xybhd ,
mm.brqx ,
mm.fenqu,
mm.zhusu ,
mm.shenzhi ,
ryfs ,
mg.ZDMC,
( CASE
WHEN mm.sffr= 0 THEN '否'
WHEN mm.sffr = 1 THEN '是'
END )
sffr
FROM MZYS_JZJL mj
INNER JOIN dbo.VI_YY_BRXX yb
ON mj.BRXXID = yb.BRXXID
INNER JOIN dbo.VI_MZ_GHXX mg
ON mj.GHXXID = mg.GHXXID
AND mj.BJSBZ = 1
LEFT JOIN MZ_MZRZ mm
ON mg.blh = mm.blh
where 1=1 ";
DataTable dt = new DataTable();
dt = DbOpt.GetDataTable(str + wherestr);
Fun.AddRowtNo(dt);
dgvList.DataSource = dt;
}
private void GetData()
{
try
{
ParameterEx[] parameters = new ParameterEx[3];
parameters[0].Text = "@rq1";
parameters[0].Value = dtpBjksj.Value.ToString();
parameters[1].Text = "@rq2";
parameters[1].Value = dtpEjksj.Value.ToString();
parameters[2].Text = "@DocId";
parameters[2].Value = TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId;
DataSet dset = new DataSet();
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("sp_ReportBuessinessQuerybyDoc", parameters, dset, "sfmx", 60);
Fun.AddRowtNo(dset.Tables[0]);
DataTable dt = dset.Tables[0];
dt.Columns.Add("药品总额", typeof(decimal));
dt.Columns.Add("药品比例", typeof(decimal));
dt.Columns.Add("西药比例", typeof(decimal));
dt.Columns.Add("自制药比例", typeof(decimal));
dt.Columns.Add("中成药比例", typeof(decimal));
dt.Columns.Add("中草药比例", typeof(decimal));
dt.Columns.Add("膏方比例", typeof(decimal));
dt.Columns.Add("其他药品比例", typeof(decimal));
if (dt.Rows.Count <= 1)
{
dt.Rows[0]["药品总额"] = 0;
dt.Rows[0]["药品比例"] = 0;
dt.Rows[0]["西药比例"] = 0;
dt.Rows[0]["自制药比例"] = 0;
dt.Rows[0]["中成药比例"] = 0;
dt.Rows[0]["中草药比例"] = 0;
dt.Rows[0]["膏方比例"] = 0;
dt.Rows[0]["其他药品比例"] = 0;
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
decimal num = 0;
dt.Rows[i]["药品总额"] = Decimal.Parse(dt.Rows[i]["西药"].ToString()) +
Decimal.Parse(dt.Rows[i]["自制药"].ToString()) +
Decimal.Parse(dt.Rows[i]["中成药"].ToString()) +
Decimal.Parse(dt.Rows[i]["中草药"].ToString()) +
Decimal.Parse(dt.Rows[i]["膏方"].ToString()) +
Decimal.Parse(dt.Rows[i]["其他药品"].ToString());
decimal total = Decimal.Parse(dt.Rows[i]["合计"].ToString());
if (total != 0)
{
num = Decimal.Parse(dt.Rows[i]["药品总额"].ToString()) / Decimal.Parse(dt.Rows[i]["合计"].ToString()) * 100;
dt.Rows[i]["药品比例"] = num.ToString("f2");
num = Decimal.Parse(dt.Rows[i]["西药"].ToString()) / Decimal.Parse(dt.Rows[i]["合计"].ToString()) * 100;
dt.Rows[i]["西药比例"] = num.ToString("f2");
num = Decimal.Parse(dt.Rows[i]["自制药"].ToString()) / Decimal.Parse(dt.Rows[i]["合计"].ToString()) * 100;
dt.Rows[i]["自制药比例"] = num.ToString("f2");
num = Decimal.Parse(dt.Rows[i]["中成药"].ToString()) / Decimal.Parse(dt.Rows[i]["合计"].ToString()) * 100;
dt.Rows[i]["中成药比例"] = num.ToString("f2");
num = Decimal.Parse(dt.Rows[i]["中草药"].ToString()) / Decimal.Parse(dt.Rows[i]["合计"].ToString()) * 100;
dt.Rows[i]["中草药比例"] = num.ToString("f2");
num = Decimal.Parse(dt.Rows[i]["膏方"].ToString()) / Decimal.Parse(dt.Rows[i]["合计"].ToString()) * 100;
dt.Rows[i]["膏方比例"] = num.ToString("f2");
num = Decimal.Parse(dt.Rows[i]["其他药品"].ToString()) / Decimal.Parse(dt.Rows[i]["合计"].ToString()) * 100;
dt.Rows[i]["其他药品比例"] = num.ToString("f2");
}
else
{
dt.Rows[i]["药品比例"] = 0;
dt.Rows[i]["西药比例"] = 0;
dt.Rows[i]["自制药比例"] = 0;
dt.Rows[i]["中成药比例"] = 0;
dt.Rows[i]["中草药比例"] = 0;
dt.Rows[i]["膏方比例"] = 0;
dt.Rows[i]["其他药品比例"] = 0;
}
}
}
int col = 4;
dt.Columns["药品总额"].SetOrdinal(col); ++col;
dt.Columns["药品比例"].SetOrdinal(col); ++col;
dt.Columns["西药"].SetOrdinal(col); ++col;
dt.Columns["西药比例"].SetOrdinal(col); ++col;
dt.Columns["自制药"].SetOrdinal(col); ++col;
dt.Columns["自制药比例"].SetOrdinal(col); ++col;
dt.Columns["中成药"].SetOrdinal(col); ++col;
dt.Columns["中成药比例"].SetOrdinal(col); ++col;
dt.Columns["中草药"].SetOrdinal(col); ++col;
dt.Columns["中草药比例"].SetOrdinal(col); ++col;
dt.Columns["膏方"].SetOrdinal(col); ++col;
dt.Columns["膏方比例"].SetOrdinal(col); ++col;
dt.Columns["其他药品"].SetOrdinal(col); ++col;
dt.Columns["其他药品比例"].SetOrdinal(col); ++col;
this.dataGridView1.DataSource = dt;
for (int i = 0; i < this.dataGridView1.Columns.Count; i++)
{
this.dataGridView1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
if (this.dataGridView1.Columns[i].Name.ToLower() == "ksdm" || this.dataGridView1.Columns[i].Name.ToLower() == "sort")
{
this.dataGridView1.Columns[i].Visible = false;
}
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 统计数据
/// </summary>
private void SelectData()
{
try
{
string where_date = "";
if (chksfrq.Checked)
{
where_date = TjMeans.GetDateWhere("a.sfrq", this.list_datewhere);
}
else
{
where_date = TjMeans.GetDateWhere("qrsj", this.list_datewhere);
}
int _isview = 0;
if (this.isview)
{
_isview = 1;
}
ParameterEx[] parameters = new ParameterEx[7];
parameters[0].Text = "@isview";
parameters[0].Value = _isview;//chksfrq.Checked == true ? dtp1.Value.ToString() : "";
parameters[1].Text = "@datewhere";
parameters[1].Value = where_date;//chksfrq.Checked == true ? dtp2.Value.ToString() : "";
parameters[2].Text = "@type";
parameters[2].Value = rdJg.Checked == true ? 0 : 1;
int _jsfs = 0;
if (rbYb.Checked)
{
_jsfs = 1;
}
else if (rbZf.Checked)
{
_jsfs = 2;
}
else
{
_jsfs = 0;
}
parameters[3].Text = "@jsfs";
parameters[3].Value = _jsfs;
parameters[4].Text = "@jgbm";
parameters[4].Value = Convert.ToInt32(Convertor.IsNull(cmbjgbm.SelectedValue, "0"));
parameters[5].Text = "@include_kdks";
parameters[5].Value = checkBox2.Checked == true ? 0 : 1;
//parameters[6].Text = "@qsfrq1";
//parameters[6].Value = chkqfrq.Checked == true ? where_date : "";//chkqfrq.Checked == true ? dtpqrrq1.Value.ToString() : "";
//parameters[7].Text = "@qsfrq2";
//parameters[7].Value = chkqfrq.Checked == true ? dtpqrrq2.Value.ToString() : "";
parameters[6].Text = "@zxksdm";
parameters[6].Value = Convertor.IsNull(txtzxks.Tag, "0").ToString();
DataSet dset = new DataSet();
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("SP_MZSF_TJ_SK_ZxkssrtjByDate", parameters, dset, "sfmx", 30);
Fun.AddRowtNo(dset.Tables[0]);
this.dataGridView1.DataSource = dset.Tables[0];
}
catch (Exception ea)
{
MessageBox.Show("出现异常!原因:" + ea.Message, "提示");
}
}
private void GetDataMx(string docName, string srks, string kdksName)
{
try
{
ParameterEx[] parameters = new ParameterEx[6];
int ii = 0;
parameters[ii].Text = "@rq1";
parameters[ii].Value = dtpBjksj.Value.ToString();
++ii;
parameters[ii].Text = "@rq2";
parameters[ii].Value = dtpEjksj.Value.ToString();
++ii;
parameters[ii].Text = "@DeptID";
parameters[ii].Value = TrasenFrame.Forms.FrmMdiMain.CurrentDept.DeptId;
++ii;
parameters[ii].Text = "@docName";
parameters[ii].Value = docName;
++ii;
parameters[ii].Text = "@srksName";
parameters[ii].Value = srks;
++ii;
parameters[ii].Text = "@kdksName";
parameters[ii].Value = kdksName;
++ii;
DataSet dset = new DataSet();
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("sp_ReportBuessinessQuerybyDept_MX", parameters, dset, "sfmx", 90);
Fun.AddRowtNo(dset.Tables[0]);
DataTable dt = dset.Tables[0];
//int col = 3;
//dt.Columns["药品总额"].SetOrdinal(col); ++col;
//dt.Columns["西药"].SetOrdinal(col); ++col;
//dt.Columns["自制药"].SetOrdinal(col); ++col;
//dt.Columns["中成药"].SetOrdinal(col); ++col;
//dt.Columns["中草药"].SetOrdinal(col); ++col;
//dt.Columns["膏方"].SetOrdinal(col); ++col;
//dt.Columns["其他药品"].SetOrdinal(col); ++col;
this.dataGridView2.Columns.Clear();
this.dataGridView2.DataSource = dt;
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void buttj_Click(object sender, EventArgs e)
{
try
{
if (chkbkrq.Checked == false &&
chkye.Checked == false && chkdj.Checked == false && chkgs.Checked == false &&
txtjtdz.Text.Trim() == "" && txtgzdw.Text.Trim() == ""
)
{
MessageBox.Show("检索的范围太大,请选择条件", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
ParameterEx[] parameters = new ParameterEx[21];
parameters[0].Text = "@klx";
parameters[0].Value = 0;
parameters[1].Text = "@kh";
parameters[1].Value = "";
parameters[2].Text = "@brxm";
parameters[2].Value = "";
parameters[3].Text = "@BRLXFS";
parameters[3].Value = "";
parameters[4].Text = "@BRLX";
parameters[4].Value = 0;;
parameters[5].Text = "@gj";
parameters[5].Value = "";
parameters[6].Text = "@mz";
parameters[6].Value = "";
parameters[7].Text = "@sfzh";
parameters[7].Value = "";
parameters[8].Text = "@cblx";
parameters[8].Value = 0;
parameters[9].Text = "@zy";
parameters[9].Value = "";
parameters[10].Text = "@csdz";
parameters[10].Value = "";
parameters[11].Text = "@jtdz";
parameters[11].Value = txtjtdz.Text.Trim();
parameters[12].Text = "@gzdw";
parameters[12].Value = txtgzdw.Text.Trim();
parameters[13].Text = "@DJSJ1";
parameters[13].Value = chkbkrq.Checked == true?dtpjsrq1.Value.ToString() : "";
parameters[14].Text = "@DJSJ2";
parameters[14].Value = chkbkrq.Checked == true?dtpjsrq2.Value.ToString() : "";
parameters[15].Text = "@CSRQ1";
parameters[15].Value = "";
parameters[16].Text = "@CSRQ2";
parameters[16].Value = "";
parameters[17].Text = "@djy";
parameters[17].Value = 0;
parameters[18].Text = "@BYE";
parameters[18].Value = chkye.Checked == true ? 1 : 0;
parameters[19].Text = "@BDJ";
parameters[19].Value = chkdj.Checked == true ? 1 : 0;
parameters[20].Text = "@BGS";
parameters[20].Value = chkgs.Checked == true ? 1 : 0;
dset = new DataSet();
InstanceForm.BDatabase.AdapterFillDataSet("SP_MZSF_CX_BRXX_JCQK", parameters, dset, "sfmx", 30);
Fun.AddRowtNo(dset.Tables[0]);
this.dataGridView1.DataSource = dset.Tables[0];
lblbkzs.Text = dset.Tables[0].Rows.Count.ToString();
lblljcr.Text = dset.Tables[0].Compute("sum(累计存入)", "").ToString();
lblljxf.Text = dset.Tables[0].Compute("sum(累计消费)", "").ToString();
lbljcje.Text = dset.Tables[0].Compute("sum(卡余额)", "").ToString();
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void GetData()
{
try
{
ParameterEx[] parameters = new ParameterEx[10];
int ii = 0;
parameters[ii].Text = "@rq1";
parameters[ii].Value = dtpBjksj.Value.ToString();
++ii;
parameters[ii].Text = "@rq2";
parameters[ii].Value = dtpEjksj.Value.ToString();
++ii;
parameters[ii].Text = "@userName";
parameters[ii].Value = "";
++ii;
parameters[ii].Text = "@dept";
parameters[ii].Value = "";
++ii;
parameters[ii].Text = "@inpatientType";
parameters[ii].Value = comboBox1.Text;
++ii;
parameters[ii].Text = "@ChargeType";
parameters[ii].Value = 0;
++ii;
parameters[ii].Text = "@BillNo";
parameters[ii].Value = "";
++ii;
parameters[ii].Text = "@LackNo";
parameters[ii].Value = Decimal.Parse(textBox3.Text == ""?"0":textBox3.Text);
++ii;
parameters[ii].Text = "@zyh";
parameters[ii].Value = textBox1.Text;
++ii;
parameters[ii].Text = "@ReportType";
parameters[ii].Value = 0;
++ii;
DataSet dset = new DataSet();
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("dbo_zy_LackDisChargeReport", parameters, dset, "sfmx", 60);
Fun.AddRowtNo(dset.Tables[0]);
DataTable dt = dset.Tables[0];
this.dataGridView1.Columns.Clear();
this.dataGridView1.DataSource = dt;
for (int i = 0; i < this.dataGridView1.Columns.Count; i++)
{
this.dataGridView1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
if (this.dataGridView1.Columns[i].Name.ToLower() == "ksdm" || this.dataGridView1.Columns[i].Name.ToLower() == "sort")
{
this.dataGridView1.Columns[i].Visible = false;
}
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butcx_Click(object sender, EventArgs e)
{
if (txtkh.Text.Trim() == "" && txtxm.Text.Trim() == "" && chkcsrq.Checked == false &&
txtjtdh.Text.Trim() == "" && txtjtdz.Text.Trim() == "" && txtsfzh.Text.Trim() == "" && txtgrlxfs.Text.Trim() == "" &&
dtpDjsj1.Checked == false && dtpDjsj2.Checked == false && txtzyh.Text.Trim() == "")
{
MessageBox.Show("查询范围过大，至少需要输入一个查询条件", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
try
{
ParameterEx[] parameters = new ParameterEx[12];
parameters[0].Text = "@klx";
parameters[0].Value = Convert.ToInt32(Convertor.IsNull(cmbklx.SelectedValue, "0"));
parameters[1].Text = "@kh";
parameters[1].Value = txtkh.Text.Trim();
parameters[2].Text = "@brxm";
parameters[2].Value = txtxm.Text.Trim();
parameters[3].Text = "@BRLXFS";
parameters[3].Value = txtgrlxfs.Text.Trim();
parameters[4].Text = "@jtdz";
parameters[4].Value = txtjtdz.Text.Trim();
parameters[5].Text = "@jtdh";
parameters[5].Value = txtjtdh.Text.Trim();
parameters[6].Text = "@CSRQ";
parameters[6].Value = chkcsrq.Checked == true?dtpcsrq.Value.ToShortDateString() : "";
parameters[7].Text = "@sfzh";
parameters[7].Value = txtsfzh.Text.Trim();
int zt = 0;
if (rdDJ.Checked)
{
zt = 1;
}
if (rdGS.Checked)
{
zt = 2;
}
if (rdozf.Checked)
{
zt = 9;
}
parameters[8].Text = "@zt";
parameters[8].Value = zt;
parameters[9].Text = "@bdjsj";
parameters[9].Value = dtpDjsj1.Checked == true?dtpDjsj1.Value.ToString("yyyy-MM-dd") + " 00:00:00" : "";
parameters[10].Text = "@edjsj";
parameters[10].Value = dtpDjsj2.Checked == true?dtpDjsj2.Value.ToString("yyyy-MM-dd") + " 23:59:59" : "";
parameters[11].Text = "@zyh";
parameters[11].Value = txtzyh.Text.Trim();
DataTable tb = InstanceForm.BDatabase.GetDataTable("SP_MZSF_CX_JKHK", parameters, 30);
Fun.AddRowtNo(tb);
this.dataGridView2.DataSource = tb;
GetJhkJl(Guid.Empty);
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void DsetSelect(int xmly, int zyyf, int execdeptid, string ss)
{
string filter = "";
filter = filter.Replace("%", "[%]");
filter = filter.Replace("'", "''");
filter = filter.Replace("[", "[[]");
filter = filter + " 项目id>0 ";
if (rdomh.Checked == true)
{
ss = "%" + ss;
}
if (rdopy.Checked == true)
{
filter = filter + " and (拼音码 LIKE '" + ss + "%') ";
}
if (rdowb.Checked == true)
{
filter = filter + " and (五笔码 LIKE '" + ss + "%') ";
}
if (rdomc.Checked == true)
{
filter = filter + " and (项目内容 LIKE '%" + ss + "%') ";
}
if (_tjdxm != "" && _tjdxm == "03") //如果是新开处方并且是中药处方的话只能开中草药
{
filter = filter + " and statitem_code='03' ";
}
else if (_tjdxm == "02") //如果是成药处方就不能开中草药
{
filter = filter + " and statitem_code<>'03'";
}
else if (new SystemCfg(3047).Config == "1" && _tjdxm == "01")//Add By Zj 2012-12-26 中药与西药不能开在一张处方上
{
filter = filter + " and statitem_code<>'03'";
}
else
{
filter = filter + "";
}
if ((execdeptid > 0 && xmly == 1) || (execdeptid > 0 && cfg_ff.Config == "0"))
{
filter = filter + " and zxksid = " + execdeptid + " ";
}
if (xmly != 0)
{
filter = filter + " and 项目来源 = " + xmly + " ";
}
if (zyyf == 1)
{
filter = filter + " and ( ( kslx2 = '住院药房'or kslx2 ='病室药房' ) or 项目来源=2)";
}
else
{
filter = filter + " and ( kslx2 <> '住院药房' or kslx2 <> '病室药房' )";
}
DataRow[] drs = Dset.Tables["ITEM"].Select(filter, " bmcd ASC");
for (int i = 0; i < Dset.Tables["ITEM"].Columns.Count; i++)
{
Console.WriteLine(Dset.Tables["ITEM"].Columns[i].ColumnName);
Console.WriteLine(Dset.Tables["ITEM"].Columns[i].Caption);
}
DataTable tb = (DataTable)dataGridView1.DataSource;
DataTable tab = tb.Clone();
DataRow[] row_bl = null;
for (int i = 0; i <= drs.Length - 1; i++)
{
if (_issfy && drs[i]["项目来源"].ToString() == "1")
{
continue;
}
//Add By zp 2014-01-10
if (_lgzdyfid > 0 && drs[i]["项目来源"].ToString() == "1")
{
if (_lgzdyfid != Convert.ToInt32(drs[i]["zxksid"]))
{
continue;
}
}
//找医保比例
string ssss = "";
if (drs[i]["项目来源"].ToString() == "1")
{
ssss = " xmid=" + drs[i]["ggid"] + " and yblx=" + yblx.ToString() + " and xmly=" + drs[i]["项目来源"] + "";
}
else
{
ssss = " xmid=" + drs[i]["项目id"] + " and yblx=" + yblx.ToString() + " and xmly=" + drs[i]["项目来源"] + "";
}
row_bl = Dset.Tables["ZFBL"].Select(ssss, "");
if (row_bl.Length > 0)
{
try
{
drs[i]["医保比例"] = Convertor.IsNull(row_bl[0]["zfbl"], "") == "" ? "" : Convert.ToString(Convert.ToDouble(row_bl[0]["zfbl"]) * 100) + "%";
}
catch
{
drs[i]["医保比例"] = Convertor.IsNull(row_bl[0]["zfbl"], "") == "" ? "0" : Convert.ToString(Convert.ToDouble(row_bl[0]["zfbl"]) * 100) + "%";
}
}
else
{
if (_issfy)
{
drs[i]["医保比例"] = "0";
}
else
{
drs[i]["医保比例"] = ""; //护士留观划价 模板的dt该列为decimal类型
}
}
drs[i]["序号"] = Convert.ToString(i + 1);
tab.ImportRow(drs[i]);
if (_issfy)
{
tab.Rows[tab.Rows.Count - 1]["项目内容"] = drs[i]["项目名称"];
}
}
Fun.AddRowtNo(tab); //Add by CC
dataGridView1.DataSource = tab;
}
private void buttj_Click(object sender, EventArgs e)
{
try
{
ParameterEx[] parameters = new ParameterEx[9];
parameters[0].Text = "@rq1";
parameters[0].Value = chksfrq.Checked == true?dtp1.Value.ToString() : "";
parameters[1].Text = "@rq2";
parameters[1].Value = chksfrq.Checked == true?dtp2.Value.ToString() : "";
parameters[2].Text = "@type";
parameters[2].Value = rdJg.Checked == true ? 0 : 1;
int _jsfs = 0;
if (rbYb.Checked)
{
_jsfs = 1;
}
else if (rbZf.Checked)
{
_jsfs = 2;
}
else
{
_jsfs = 0;
}
parameters[3].Text = "@jsfs";
parameters[3].Value = _jsfs;
parameters[4].Text = "@jgbm";
parameters[4].Value = Convert.ToInt32(Convertor.IsNull(cmbjgbm.SelectedValue, "0"));
parameters[5].Text = "@include_kdks";
parameters[5].Value = checkBox2.Checked == true ? 0 : 1;
parameters[6].Text = "@qsfrq1";
parameters[6].Value = chkqfrq.Checked == true?dtpqrrq1.Value.ToString() : "";
parameters[7].Text = "@qsfrq2";
parameters[7].Value = chkqfrq.Checked == true?dtpqrrq2.Value.ToString() : "";
parameters[8].Text = "@zxksdm";
parameters[8].Value = Convertor.IsNull(txtzxks.Tag, "0").ToString();
DataSet dset = new DataSet();
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("SP_MZSF_TJ_SK_Zxkssrtj", parameters, dset, "sfmx", 30);
Fun.AddRowtNo(dset.Tables[0]);
//if (this.dataGridView1.ColumnCount > 4)
//{
// this.dataGridView1.Columns[0].Frozen = false;
// this.dataGridView1.Columns[1].Frozen = false;
// this.dataGridView1.Columns[2].Frozen = false;
// this.dataGridView1.Columns[3].Frozen = false;
//}
// 添加冻结功能 by fangke
dataGridView1.Columns.Clear();
this.dataGridView1.DataSource = dset.Tables[0];
this.dataGridView1.Columns[0].Frozen = true;
this.dataGridView1.Columns[1].Frozen = true;
this.dataGridView1.Columns[2].Frozen = true;
this.dataGridView1.Columns[3].Frozen = true;
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSelect_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
try
{
this.Cursor = PubStaticFun.WaitCursor();
btnSelect.Enabled = false;
int tjlx = 0;
if (rdoks.Checked == true)
{
tjlx = 1;
}
if (rdoys.Checked == true)
{
tjlx = 2;
}
ParameterEx[] parameters = new ParameterEx[5];
parameters[0].Value = dtp1.Value.ToShortDateString() + "";
parameters[1].Value = dtp2.Value.ToShortDateString() + "";
parameters[2].Value = tjlx;
parameters[3].Value = Convertor.IsNull(txtks.Tag, "0");
parameters[4].Value = Convertor.IsNull(txtys.Tag, "0");
parameters[0].Text = "@rq1";
parameters[1].Text = "@rq2";
parameters[2].Text = "@tjlx";
parameters[3].Text = "@ksdm";
parameters[4].Text = "@ysdm";
DataSet dset = new DataSet();
InstanceForm.BDatabase.AdapterFillDataSet("SP_YP_KSSZB_ZYDDD", parameters, dset, "kss", 30);
dset.Tables[0].TableName = "Tb";
this.dataGridView1.DataSource = dset.Tables[0];
Fun.AddRowtNo(dset.Tables[0]);
DataRow rows = null;
if (rdoyp.Checked == true && dset.Tables[1].Rows.Count > 0)
{
rows = dset.Tables[1].Rows[0];
}
if (rdoks.Checked == true && dset.Tables[0].Rows.Count > 0)
{
rows = dset.Tables[0].Rows[dset.Tables[0].Rows.Count - 1];
}
if (rdoys.Checked == true && dset.Tables[0].Rows.Count > 0)
{
rows = dset.Tables[0].Rows[dset.Tables[0].Rows.Count - 1];
}
txtDDD.Text = rows["累计DDD数"].ToString();
txtoutPatient.Text = rows["总出院人数"].ToString();
txtAvgOutpatient.Text = rows["平均住院天数"].ToString();
txtpatientCount.Text = rows["同期收治患者人天数"].ToString();
txtqiangdu.Text = rows["抗菌药物使用强度"].ToString();
txtkjywrc.Text = rows["使用抗菌药物出院总人数"].ToString();
txtksssyl.Text = rows["抗菌药物使用率"].ToString();
btnSelect.Enabled = true;
}
catch (System.Exception err)
{
btnSelect.Enabled = true;
MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
this.Cursor = Cursors.Arrow;
}
}
private void buttj_Click(object sender, EventArgs e)
{
try
{
//Modify By Zj 2012-12-28 增加统计口径
ParameterEx[] parameters = new ParameterEx[4];
parameters[0].Text = "@rq1";
parameters[0].Value = dtp1.Value.ToString();
parameters[1].Text = "@rq2";
parameters[1].Value = dtp2.Value.ToString();
parameters[2].Text = "@jgbm";
parameters[2].Value = Convert.ToInt32(Convertor.IsNull(cmbjgbm.SelectedValue, "0"));
parameters[3].Text = "@tjlx";
parameters[3].Value = radioButton1.Checked ? 0 : 1;
if (TrasenFrame.Classes.Constant.HospitalName == "邵阳市第一人民医院")
{
parameters[3].Value = checkBox2.Checked ? 1 : 0;//Modify by zouchihua 2013-5-22 邵阳这里是区分合并还是不合并
}
dset = new DataSet();
//add by zouchihua 2013-4-2 增加医保人次统计
if (CHbYb.Checked == false)
{
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("SP_MZSF_TJ_gh_ghrctj", parameters, dset, "sfmx", 30);
}
else
{
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("SP_MZSF_TJ_gh_ghrctj_YBLX", parameters, dset, "sfmx", 30);
}
//DataTable tb = TrasenFrame.Forms.FrmMdiMain.Database.GetDataTable("SP_MZSF_TJ_gh_ghrctj", parameters, 30);
for (int i = 0; i <= dset.Tables[2].Columns.Count - 1; i++)
{
DataGridViewTextBoxColumn col = new DataGridViewTextBoxColumn();
col.HeaderText = dset.Tables[2].Columns[i].ColumnName != "急诊小计" ? dset.Tables[2].Columns[i].ColumnName.Replace("急诊", "") : dset.Tables[2].Columns[i].ColumnName;
col.DataPropertyName = dset.Tables[2].Columns[i].ColumnName;
col.Name = dset.Tables[2].Columns[i].ColumnName;
switch (col.Name)
{
case "序号":
col.Width = 40;
break;
case "科室":
col.Width = 100;
break;
default:
col.Width = 50;
break;
}
if (dataGridView1.Columns.Contains(dset.Tables[2].Columns[i].ColumnName) == false)
{
dataGridView1.Columns.Add(col);
}
}
Fun.AddRowtNo(dset.Tables[2]);
this.dataGridView1.DataSource = dset.Tables[2];
//for (int i = 0; i <= tb.Columns.Count - 1; i++)
//{
// DataGridViewTextBoxColumn col = new DataGridViewTextBoxColumn();
// col.HeaderText = tb.Columns[i].ColumnName.Replace("急诊", "");
// col.DataPropertyName = tb.Columns[i].ColumnName;
// col.Name = tb.Columns[i].ColumnName;
// if (dataGridView1.Columns.Contains(tb.Columns[i].ColumnName) == false)
// dataGridView1.Columns.Add(col);
//}
//Fun.AddRowtNo(tb);
//this.dataGridView1.DataSource =tb;
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butcx_Click(object sender, EventArgs e)
{
try
{
if (txtkh.Text.Trim() == "" && txtbrxm.Text.Trim() == "" &&
txtbrlxfs.Text.Trim() == "" && txtsfzh.Text.Trim() == "" && txtcsdz.Text.Trim() == "" &&
txtjtdz.Text.Trim() == "" && txtgzdw.Text.Trim() == "" && chkcsrq.Checked == false &&
chkdjsj.Checked == false)
{
MessageBox.Show("检索的范围太大,请选择条件", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
ParameterEx[] parameters = new ParameterEx[18];
parameters[0].Text = "@klx";
parameters[0].Value = Convert.ToInt32(Convertor.IsNull(cmbklx.SelectedValue, "0"));
parameters[1].Text = "@kh";
parameters[1].Value = txtkh.Text.Trim();
parameters[2].Text = "@brxm";
parameters[2].Value = txtbrxm.Text.Trim();
parameters[3].Text = "@BRLXFS";
parameters[3].Value = txtbrlxfs.Text.Trim();
parameters[4].Text = "@BRLX";
parameters[4].Value = Convert.ToInt32(Convertor.IsNull(cmbbrlx.SelectedValue, "0"));;
parameters[5].Text = "@gj";
parameters[5].Value = cmbgj.Text.Trim();
parameters[6].Text = "@mz";
parameters[6].Value = cmbmz.Text.Trim();
parameters[7].Text = "@sfzh";
parameters[7].Value = txtsfzh.Text.Trim();
parameters[8].Text = "@cblx";
parameters[8].Value = Convert.ToInt32(Convertor.IsNull(cmbcblx.SelectedValue, "0"));;
parameters[9].Text = "@zy";
parameters[9].Value = txtzy.Text.Trim();
parameters[10].Text = "@csdz";
parameters[10].Value = txtcsdz.Text.Trim();
parameters[11].Text = "@jtdz";
parameters[11].Value = txtjtdz.Text.Trim();
parameters[12].Text = "@gzdw";
parameters[12].Value = txtgzdw.Text.Trim();
parameters[13].Text = "@DJSJ1";
parameters[13].Value = chkdjsj.Checked == true?dtpdjsj1.Value.ToShortDateString() + " 00:00:00" : "";
parameters[14].Text = "@DJSJ2";
parameters[14].Value = chkdjsj.Checked == true?dtpdjsj2.Value.ToShortDateString() + " 23:59:59" : "";
parameters[15].Text = "@CSRQ1";
parameters[15].Value = chkcsrq.Checked == true?dtpcsrq1.Value.ToShortDateString() + " 00:00:00" : "";
parameters[16].Text = "@CSRQ2";
parameters[16].Value = chkcsrq.Checked == true?dtpcsrq2.Value.ToShortDateString() + " 23:59:59" : "";
parameters[17].Text = "@djy";
parameters[17].Value = Convertor.IsNull(cmbdjy.SelectedValue, "0");
DataTable tb = TrasenFrame.Forms.FrmMdiMain.Database.GetDataTable("SP_MZSF_CX_BRXX", parameters, 30);
Fun.AddRowtNo(tb);
this.dataGridView1.DataSource = tb;
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void dataGridView1_DoubleClick(object sender, EventArgs e)
{
try
{
DataTable tb = (DataTable)dataGridView1.DataSource;
if (tb == null)
{
return;
}
if (tb.Rows.Count == 0)
{
return;
}
int nrow = dataGridView1.CurrentCell.RowIndex;
int sfy = Convert.ToInt32(tb.Rows[nrow]["sfy"]);
ParameterEx[] parameters = new ParameterEx[5];
parameters[0].Text = "@pjlx";
parameters[0].Value = rdogh.Checked == true ? 1 : 0;
parameters[1].Text = "@ksh";
parameters[1].Value = Convertor.IsNull(txtksh.Text, "0");
parameters[2].Text = "@jsh";
parameters[2].Value = Convertor.IsNull(txtjsh.Text, "0");
parameters[3].Text = "@sfy";
parameters[3].Value = sfy;
parameters[4].Text = "@type";
parameters[4].Value = 1;
DataSet dset = new DataSet();
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("SP_MZSF_TJ_FPHXHZ", parameters, dset, "sfmx", 30);
Fun.AddRowtNo(dset.Tables[0]);
Fun.AddRowtNo(dset.Tables[1]);
Fun.AddRowtNo(dset.Tables[2]);
DataTable tb2 = (DataTable)dataGridView2.DataSource;
DataTable tb3 = (DataTable)dataGridView3.DataSource;
DataTable tb4 = (DataTable)dataGridView4.DataSource;
if (tb2 != null)
{
tb2.Rows.Clear();
}
if (tb3 != null)
{
tb3.Rows.Clear();
}
if (tb4 != null)
{
tb4.Rows.Clear();
}
this.dataGridView2.DataSource = dset.Tables[0];
this.dataGridView3.DataSource = dset.Tables[1];
this.dataGridView4.DataSource = dset.Tables[2];
SelectFp(sfy);
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void buttj_Click(object sender, EventArgs e)
{
try
{
ParameterEx[] parameters = new ParameterEx[9];
parameters[0].Text = "@rq1";
parameters[0].Value = dtp1.Value.ToString();
parameters[1].Text = "@rq2";
parameters[1].Value = dtp2.Value.ToString();
parameters[2].Text = "@type";
parameters[2].Value = rdJg.Checked == true ? 0 : 1;
//add by Daniel 2014-09-22
if (cmbQt.SelectedIndex != -1)
{
parameters[2].Text = "type";
parameters[2].Value = cmbQt.SelectedIndex + 2;
}
int _jsfs = 0;
if (rbYb.Checked)
{
_jsfs = 1;
}
else if (rbZf.Checked)
{
_jsfs = 2;
}
else
{
_jsfs = 0;
}
parameters[3].Text = "@jsfs";
parameters[3].Value = _jsfs;
parameters[4].Text = "@jgbm";
parameters[4].Value = Convert.ToInt32(Convertor.IsNull(cmbjgbm.SelectedValue, "0"));
parameters[5].Text = "@bks";
parameters[5].Value = checkBox2.Checked == true ? 1 : 0;
parameters[6].Text = "@dept_id";
parameters[6].Value = Convert.ToInt32(Convertor.IsNull(cmbdept.SelectedValue, "0"));
parameters[7].Text = "@sfdeptid";
parameters[7].Value = this.Cmb_SfDept.SelectedValue.ToString().Trim() == "-1" ? "" : this.Cmb_SfDept.SelectedValue.ToString().Trim();
//150203 chencan/ 添加"显示病人明细"
parameters[8].Text = "@patient";
parameters[8].Value = ckb_patient.Checked == true ? 1 : 0;
DataSet dset = new DataSet();
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("SP_MZSF_TJ_SK_yssrtj", parameters, dset, "sfmx", 30);
Fun.AddRowtNo(dset.Tables[0]);
this.dataGridView1.DataSource = null;
this.dataGridView1.DataSource = dset.Tables[0];
this.dataGridView1.Columns["KSDM"].Visible = false;
this.dataGridView1.Refresh();
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void GetData()
{
try
{
ParameterEx[] parameters = new ParameterEx[5];
int ii = 0;
parameters[ii].Text = "@rq1";
//if (ckbJkrq.Checked)
//{
parameters[ii].Value = dtpBjksj.Value.ToString();
//}
//else
//{
//parameters[ii].Value ="2000/01/01 00:00:00";
//}
++ii;
parameters[ii].Text = "@rq2";
//if (ckbJkrq.Checked)
//{
parameters[ii].Value = dtpEjksj.Value.ToString();
//}
//else
//{
// parameters[ii].Value = DateTime.Now.AddDays(1).ToString("yyyy/MM/dd HH:mm:ss");
//}
++ii;
parameters[ii].Text = "@DeptID";
parameters[ii].Value = TrasenFrame.Forms.FrmMdiMain.CurrentDept.DeptId;
++ii;
parameters[ii].Text = "@inpatientNo";
parameters[ii].Value = textBox1.Text.Trim();
++ii;
parameters[ii].Text = "@itemName";
parameters[ii].Value = textBox2.Text.Trim();
++ii;
DataSet dset = new DataSet();
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("sp_zy_zxsrtj_mx", parameters, dset, "sfmx", 60);
Fun.AddRowtNo(dset.Tables[0]);
DataTable dt = dset.Tables[0];
dt.Rows[dt.Rows.Count - 1]["住院号"] = "";
this.dataGridView1.Columns.Clear();
this.dataGridView1.DataSource = dt;
for (int i = 0; i < this.dataGridView1.Columns.Count; i++)
{
this.dataGridView1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
if (this.dataGridView1.Columns[i].Name.ToLower() == "ksdm" || this.dataGridView1.Columns[i].Name.ToLower() == "sort")
{
this.dataGridView1.Columns[i].Visible = false;
}
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void btref_Click(object sender, EventArgs e)
{
try
{
string execdept = "";
for (int i = 0; i <= TreeDept.Nodes[0].Nodes.Count - 1; i++)
{
if (TreeDept.Nodes[0].Nodes[i].Checked == true)
{
execdept = execdept + TreeDept.Nodes[0].Nodes[i].Tag + ",";
}
}
if (execdept != "")
{
execdept = "(" + execdept.Substring(0, execdept.Length - 1) + ")";
}
else
{
MessageBox.Show("请选择科室", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string tjdxm = "";
for (int i = 0; i <= TreeXm.Nodes[0].Nodes.Count - 1; i++)
{
if (TreeXm.Nodes[0].Nodes[i].Checked == true)
{
tjdxm = tjdxm + "'" + TreeXm.Nodes[0].Nodes[i].Tag + "',";
}
}
if (tjdxm != "")
{
tjdxm = "(" + tjdxm.Substring(0, tjdxm.Length - 1) + ")";
}
ParameterEx[] parameters = new ParameterEx[8];
parameters[0].Text = "@execdept";
parameters[0].Value = execdept;
parameters[1].Text = "@RQ1";
parameters[1].Value = chksfrq.Checked == true?dtp1.Value.ToString() : "";
parameters[2].Text = "@RQ2";
parameters[2].Value = chksfrq.Checked == true?dtp2.Value.ToString() : "";
parameters[3].Text = "@jgbm";
parameters[3].Value = Convert.ToInt64(cmbjgbm.SelectedValue);
parameters[4].Text = "@qrrq1";
parameters[4].Value = chkqfrq.Checked == true?dtpqrrq1.Value.ToString() : "";
parameters[5].Text = "@qrrq2";
parameters[5].Value = chkqfrq.Checked == true?dtpqrrq2.Value.ToString() : "";
parameters[6].Text = "@tjdxm";
parameters[6].Value = tjdxm;
parameters[7].Text = "@zxr";
parameters[7].Value = 0;
DataSet dset = new DataSet();
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("SP_MZSF_TJ_SK_kssrtj_mx", parameters, dset, "sfmx", 30);
Fun.AddRowtNo(dset.Tables[0]);
Fun.AddRowtNo(dset.Tables[1]);
Fun.AddRowtNo(dset.Tables[2]);
Fun.AddRowtNo(dset.Tables[3]);
decimal je = Convert.ToDecimal(Convertor.IsNull(dset.Tables[0].Compute("sum(金额)", ""), "0"));
decimal je1 = Convert.ToDecimal(Convertor.IsNull(dset.Tables[1].Compute("sum(金额)", ""), "0"));
decimal je2 = Convert.ToDecimal(Convertor.IsNull(dset.Tables[2].Compute("sum(金额)", ""), "0"));
//add by zouchihua 2013-6-25
decimal je3 = Convert.ToDecimal(Convertor.IsNull(dset.Tables[3].Compute("sum(金额)", ""), "0"));
DataRow row = dset.Tables[0].NewRow();
row["序号"] = "合计";
row["金额"] = je.ToString();
dset.Tables[0].Rows.Add(row);
DataRow row1 = dset.Tables[1].NewRow();
row1["序号"] = "合计";
row1["金额"] = je1.ToString();
dset.Tables[1].Rows.Add(row1);
DataRow row2 = dset.Tables[2].NewRow();
row2["序号"] = "合计";
row2["金额"] = je2.ToString();
dset.Tables[2].Rows.Add(row2);
DataRow row3 = dset.Tables[3].NewRow();
row3["序号"] = "合计";
row3["金额"] = je3.ToString();
dset.Tables[3].Rows.Add(row3);
dataGridView1.DataSource = dset.Tables[0];
dataGridView2.DataSource = dset.Tables[2];
dataGridView3.DataSource = dset.Tables[1];
//add by zouchihua 2013-6-25
dataGridView4.DataSource = dset.Tables[3];
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void ShowReportData()
{
try
{
if (string.IsNullOrEmpty(this._param.itemStringOfCol))
{
ParameterEx[] parameters = new ParameterEx[6];
parameters[0].Text = "@sourceType";
parameters[0].Value = this._param.sourceType;
parameters[1].Text = "@ksType";
parameters[1].Value = this._param.ksType;
parameters[2].Text = "@rq1";
parameters[2].Value = this._param.rq1;
parameters[3].Text = "@rq2";
parameters[3].Value = this._param.rq2;
parameters[4].Text = "@isZXKS";
parameters[4].Value = this._param.isZXKS;
parameters[5].Text = "@departmentID";
parameters[5].Value = this._param.departmentID;
DataSet dset = new DataSet();
if (this._param.itemCode == 0)
{
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("report_BusinessIncomeReport_Drugs_doc", parameters, dset, "sfmx", 30);
}
else if (this._param.itemCode == 1)
{
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("ReportBuessinessOfMedicalTechnology_doc", parameters, dset, "sfmx", 30);
}
else if (this._param.itemCode == 2)
{
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("ReportBuessinessOfMediaclServer_doc", parameters, dset, "sfmx", 30);
}
Fun.AddRowtNo(dset.Tables[0]);
this.dataGridView1.DataSource = dset.Tables[0];
for (int i = 0; i < this.dataGridView1.Columns.Count; i++)
{
this.dataGridView1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
if (this.dataGridView1.Columns[i].Name.ToLower() == "ksdm")
{
this.dataGridView1.Columns[i].Visible = false;
}
}
}
else
{
ParameterEx[] parameters = new ParameterEx[7];
parameters[0].Text = "@sourceType";
parameters[0].Value = this._param.sourceType;
parameters[1].Text = "@ksType";
parameters[1].Value = this._param.ksType;
parameters[2].Text = "@rq1";
parameters[2].Value = this._param.rq1;
parameters[3].Text = "@rq2";
parameters[3].Value = this._param.rq2;
parameters[4].Text = "@isZXKS";
parameters[4].Value = this._param.isZXKS;
parameters[5].Text = "@departmentID";
parameters[5].Value = this._param.departmentID;
parameters[6].Text = "@itemCode";
parameters[6].Value = this._param.itemStringOfCol;
DataSet dset = new DataSet();
if (this._param.itemCode == 0)
{
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("report_BusinessIncomeReport_DrugItem_doc", parameters, dset, "sfmx", 30);
}
else if (this._param.itemCode == 1)
{
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("ReportBuessinessOfMedicalTechnology_item_doc", parameters, dset, "sfmx", 30);
}
else if (this._param.itemCode == 2)
{
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("ReportBuessinessOfMediaclServer_item_doc", parameters, dset, "sfmx", 30);
}
Fun.AddRowtNo(dset.Tables[0]);
this.dataGridView1.DataSource = dset.Tables[0];
for (int i = 0; i < this.dataGridView1.Columns.Count; i++)
{
this.dataGridView1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
if (this.dataGridView1.Columns[i].Name.ToLower() == "ksdm")
{
this.dataGridView1.Columns[i].Visible = false;
}
}
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void buttj_Click(object sender, EventArgs e)
{
try
{
Cursor = PubStaticFun.WaitCursor();
int count = 10;
if (speci.Equals(1))
{
count = 9;
}
//Modify By Kevin 2013-10-16
ParameterEx[] parameters = new ParameterEx[count];
parameters[0].Text = "@RQ1";
parameters[0].Value = dtp1.Value.ToString();
parameters[1].Text = "@RQ2";
parameters[1].Value = dtp2.Value.ToString();
int type = 0;
if (rbJg.Checked)
{
type = 0;
}
else
{
type = 1;
}
parameters[2].Text = "@TYPE";
parameters[2].Value = type;
int tj_type = 0;
if (rbJsrq.Checked)
{
tj_type = 1;
}
if (rbDqzy.Checked)
{
tj_type = 2;
}
parameters[3].Text = "@TJ_TYPE";
parameters[3].Value = tj_type;
parameters[4].Text = "@YKS";
parameters[4].Value = Convert.ToInt32(Convertor.IsNull(cmbZcDept.SelectedValue, "0"));
parameters[5].Text = "@XKS";
parameters[5].Value = Convert.ToInt32(Convertor.IsNull(cmbZrDept.SelectedValue, "0"));
//Add By Tany 2011-07-04
parameters[6].Text = "@ISBRMX";
parameters[6].Value = chkBrmx.Checked ? 1 : 0;
//Modify By Tany 2011-12-06 增加机构编码过滤
parameters[7].Text = "@JGBM";
parameters[7].Value = FrmMdiMain.Jgbm;
parameters[8].Text = "@ISZRKS";
parameters[8].Value = chkZrks.Checked ? 1 : 0;
if (!speci.Equals(1))
{
//Modify By Daniel 2015-01-22 增加住院号
parameters[9].Text = "@ZYH";
parameters[9].Value = txtInp_NO.Text.Trim();
}
string Sp_name = "[SP_ZY_TJ_BRSRTJ_ZKBR_zyf2]";
if (speci == 1)
{
Sp_name = "[SP_ZY_TJ_BRSRTJ_ZKBR_ICU]";
}
DataSet dset = new DataSet();
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet(Sp_name, parameters, dset, "sfmx", 60);
Fun.AddRowtNo(dset.Tables[0]);
DataTable tb = dset.Tables[0];
tb.Columns["病人科室"].ColumnName = "计费科室";
//DataTable tb = InstanceForm.BDatabase.GetDataTable(Sp_name, parameters, 120);
//AddRowtNo(tb);
if (tb.Columns.Contains("序号") && tb.Rows.Count > 0)
{
tb.Rows[tb.Rows.Count - 1]["序号"] = "合计";
}
tb.Columns[3].SetOrdinal(5);
//tb.Columns[3].SetOrdinal(4);
this.dataGridView1.Columns.Clear();
this.dataGridView1.DataSource = tb;
//Modify By Daniel 2015-01-22 当病人科室与转入科室不一致时，该行背景色变为淡蓝色
//Begin
//if (chkBrmx.Checked == true)
//{
// for (int i = 0; i < tb.Rows.Count; i++)
// {
// if (tb.Rows[i]["病人科室"].ToString() != tb.Rows[i]["转入科室"].ToString())
// {
// this.dataGridView1.Rows[i].DefaultCellStyle.BackColor = Color.Aqua;
// }
// }
//}
//End
//Modify By Daniel 2015-02-11 修改转入科室的背景色为淡蓝色，转出科室的背景色为黄绿色
this.dataGridView1.Columns["转入科室"].DefaultCellStyle.BackColor = Color.Blue;
this.dataGridView1.Columns["转出科室"].DefaultCellStyle.BackColor = Color.Yellow;
for (int i = 0; i < this.dataGridView1.Columns.Count; i++)
{
if (this.dataGridView1.Columns[i].Name == "sort")
{
this.dataGridView1.Columns[i].Visible = false;
break;
}
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Cursor = Cursors.Default;
}
}
/// <summary>
/// 统计 modify by zp 2013-05-24 存储过程新增入参 株洲省直中医院需求
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttj_Click(object sender, EventArgs e)
{
try
{
try
{
ParameterEx[] parameters = new ParameterEx[8];
parameters[0].Text = "@rq1";
parameters[0].Value = dtp1.Value.ToString();
parameters[1].Text = "@rq2";
parameters[1].Value = dtp2.Value.ToString();
parameters[2].Text = "@type";
parameters[2].Value = cbType.SelectedIndex;//rdJg.Checked == true ? 0 : 1;
int _jsfs = cbJsfs.SelectedIndex;
parameters[3].Text = "@jsfs";
parameters[3].Value = _jsfs;
parameters[4].Text = "@jgbm";
parameters[4].Value = Convert.ToInt32(Convertor.IsNull(cmbjgbm.SelectedValue, "0"));
parameters[5].Text = "@tjlx";
parameters[5].Value = _menuTag.Function_Name == "Fun_ts_mz_tjbb_kssrtj" ? 0 : 1;;
parameters[6].Text = "@include_kdks";
parameters[6].Value = chkKdks.Checked ? 1 : 0;
parameters[7].Text = "@sfdeptid";
parameters[7].Value = this.Cmb_SfDept.SelectedValue.ToString().Trim() == "-1" ? "" : this.Cmb_SfDept.SelectedValue.ToString().Trim();
DataSet dset = new DataSet();
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("SP_MZSF_TJ_SK_Kssrtj", parameters, dset, "sfmx", 30);
Fun.AddRowtNo(dset.Tables[0]);
this.dataGridView1.DataSource = dset.Tables[0];
}
catch
{
try
{
ParameterEx[] parameters = new ParameterEx[7];
parameters[0].Text = "@rq1";
parameters[0].Value = dtp1.Value.ToString();
parameters[1].Text = "@rq2";
parameters[1].Value = dtp2.Value.ToString();
parameters[2].Text = "@type";
parameters[2].Value = cbType.SelectedIndex;//rdJg.Checked == true ? 0 : 1;
int _jsfs = cbJsfs.SelectedIndex;
parameters[3].Text = "@jsfs";
parameters[3].Value = _jsfs;
parameters[4].Text = "@jgbm";
parameters[4].Value = Convert.ToInt32(Convertor.IsNull(cmbjgbm.SelectedValue, "0"));
parameters[5].Text = "@tjlx";
parameters[5].Value = _menuTag.Function_Name == "Fun_ts_mz_tjbb_kssrtj" ? 0 : 1;;
parameters[6].Text = "@include_kdks";
parameters[6].Value = chkKdks.Checked ? 1 : 0;
//parameters[7].Text = "@sfdeptid";
//parameters[7].Value = this.Cmb_SfDept.SelectedValue.ToString().Trim() == "-1" ? "" : this.Cmb_SfDept.SelectedValue.ToString().Trim();
DataSet dset = new DataSet();
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("SP_MZSF_TJ_SK_Kssrtj", parameters, dset, "sfmx", 30);
Fun.AddRowtNo(dset.Tables[0]);
this.dataGridView1.DataSource = dset.Tables[0];
}
catch
{
ParameterEx[] parameters = new ParameterEx[9];
parameters[0].Text = "@rq1";
parameters[0].Value = chbSfrq.Checked ? dtp1.Value.ToString() : "";
parameters[1].Text = "@rq2";
parameters[1].Value = chbSfrq.Checked ? dtp2.Value.ToString() : "";
parameters[2].Text = "@type";
parameters[2].Value = cbType.SelectedIndex;//rdJg.Checked == true ? 0 : 1;
int _jsfs = cbJsfs.SelectedIndex;
parameters[3].Text = "@jsfs";
parameters[3].Value = _jsfs;
parameters[4].Text = "@jgbm";
parameters[4].Value = Convert.ToInt32(Convertor.IsNull(cmbjgbm.SelectedValue, "0"));
parameters[5].Text = "@tjlx";
parameters[5].Value = _menuTag.Function_Name == "Fun_ts_mz_tjbb_kssrtj" ? 0 : 1;;
parameters[6].Text = "@include_kdks";
parameters[6].Value = chkKdks.Checked ? 1 : 0;
parameters[7].Text = "@jkrq1";
parameters[7].Value = ckbJkrq.Checked ? dtpBjksj.Value.ToString() : "";
parameters[8].Text = "@jkrq2";
parameters[8].Value = ckbJkrq.Checked ? dtpEjksj.Value.ToString() : "";
//parameters[7].Text = "@sfdeptid";
//parameters[7].Value = this.Cmb_SfDept.SelectedValue.ToString().Trim() == "-1" ? "" : this.Cmb_SfDept.SelectedValue.ToString().Trim();
DataSet dset = new DataSet();
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("SP_MZSF_TJ_SK_Kssrtj", parameters, dset, "sfmx", 30);
Fun.AddRowtNo(dset.Tables[0]);
this.dataGridView1.DataSource = dset.Tables[0];
}
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private DataTable GetDataOfPrint()
{
try
{
ParameterEx[] parameters = new ParameterEx[10];
int ii = 0;
parameters[ii].Text = "@rq1";
parameters[ii].Value = dtpBjksj.Value.ToString();
++ii;
parameters[ii].Text = "@rq2";
parameters[ii].Value = dtpEjksj.Value.ToString();
++ii;
parameters[ii].Text = "@userName";
parameters[ii].Value = "";
++ii;
parameters[ii].Text = "@dept";
parameters[ii].Value = "";
++ii;
parameters[ii].Text = "@inpatientType";
parameters[ii].Value = comboBox1.Text;
++ii;
parameters[ii].Text = "@ChargeType";
parameters[ii].Value = 0;
++ii;
parameters[ii].Text = "@BillNo";
parameters[ii].Value = "";
++ii;
parameters[ii].Text = "@LackNo";
parameters[ii].Value = Decimal.Parse(textBox3.Text == "" ? "0" : textBox3.Text);
++ii;
parameters[ii].Text = "@zyh";
parameters[ii].Value = textBox1.Text;
++ii;
parameters[ii].Text = "@ReportType";
parameters[ii].Value = 1;
++ii;
DataSet dset = new DataSet();
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("dbo_zy_LackDisChargeReport", parameters, dset, "sfmx", 60);
Fun.AddRowtNo(dset.Tables[0]);
DataTable dt = dset.Tables[0];
return(dt);
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(null);
}
}
/// <summary>
/// 查询
/// </summary>
/// <param name="rq1">登记时间</param>
/// <param name="rq2">登记时间</param>
/// <param name="djy">登记员</param>
/// <param name="shbz">审核标志 0 为未入院审核的记录 1为已审核</param>
/// <param name="brxxid">病人信息id</param>
/// <param name="_DataBase"></param>
/// <returns></returns>
public static DataTable GetRecord(string rq1, string rq2, long djy, int shbz, int klx, string kh, string brxm, Guid brxxid, RelationalDatabase _DataBase)
{
//string ssql = "select '' 序号,brxm 姓名,dbo.FUN_ZY_SEEKSEXNAME(xb) 性别,dbo.fun_zy_age(csrq,3,getdate()) 年龄,mzzdmc 门诊诊断,"+
//" dbo.fun_getdeptname(dryks) 入院科室,jyyj 建议押金,c.name 入院途径,bz 备注,BRYBZ 已入院,rydjsj 入院登记时间,b.id, dbo.fun_getDeptname(tjks) AS 登记科室, "+
//"dbo.fun_getEmpName(a.DJY) AS 登记医生,"+
//"a.DJSJ 登记时间 "+
//",mzh 门诊号 from YY_BRXX a inner join mzys_zyzdj b on a.brxxid=b.brxxid left join jc_rytj c on b.rytj=c.id "+
//" left join yy_kdjb d on a.brxxid=d.brxxid and zfbz=0 where b.bscbz=0 ";
// 上面注释的查询语句错误 modify by fangke 2014.11.18
string ssql = @"SELECT '' 序号,
yb.BRXM 姓名,
dbo.FUN_ZY_SEEKSEXNAME(yb.XB) 性别,
dbo.fun_zy_age(yb.CSRQ,3,getdate()) 年龄,
mz.MZZDMC 门诊诊断,
dbo.fun_getdeptname(mz.DRYKS) 入院科室,
mz.JYYJ 建议押金,
jr.NAME 入院途径,
mz.BZ 备注,
mz.BRYBZ 已入院,
mz.RYDJSJ 入院登记时间,
mz.ID,
dbo.fun_getDeptname(mz.TJKS) AS 登记科室,
dbo.fun_getEmpName(mz.DJY) AS 登记医生,
mz.DJSJ 登记时间,
mz.MZH 门诊号
FROM MZYS_ZYZDJ AS mz
LEFT JOIN YY_BRXX AS yb
ON mz.BRXXID = yb.BRXXID
LEFT JOIN JC_RYTJ AS jr
ON mz.RYTJ = jr.ID
LEFT JOIN YY_KDJB AS yk
ON mz.BRXXID = yk.BRXXID AND yk.ZFBZ = 0
WHERE mz.BSCBZ<>1 ";
//150204 chencan 过滤过期的住院证
SystemCfg cfg5152 = new SystemCfg(5152);
if (!String.IsNullOrEmpty(cfg5152.Config))
{
try
{
ssql += string.Format(" and mz.djsj+{0}>=getdate()", Int32.Parse(cfg5152.Config));
}
catch { }
}
if (rq1 != "")
{
ssql = ssql + " and mz.DJSJ BETWEEN '" + rq1 + " 00:00:00' and '" + rq2 + " 23:59:59'";
}
if (brxxid != Guid.Empty)
{
ssql = ssql + " and mz.BRXXID='" + brxxid + "'";
}
if (kh != "")
{
ssql = ssql + " and yk.KH='" + kh + "' and KLX=" + klx + " ";
}
if (brxm != "")
{
ssql = ssql + " and yb.BRXM like '%" + brxm + "%'";
}
if (shbz >= 0)
{
ssql = ssql + " and mz.BRYBZ=" + shbz + "";
}
DataTable tb = _DataBase.GetDataTable(ssql);
Fun.AddRowtNo(tb);
return(tb);
}
private void buttj_Click(object sender, EventArgs e)
{
try
{
if (radioButton2.Checked == true)
{
ParameterEx[] parameters1 = new ParameterEx[3];
parameters1[0].Text = "@KSRQ";
parameters1[0].Value = dtp1.Value.ToString();
parameters1[1].Text = "@JSRQ";
parameters1[1].Value = dtp2.Value.ToString();
parameters1[2].Text = "@jky";
parameters1[2].Value = 0;
dset = new DataSet();
InstanceForm.BDatabase.AdapterFillDataSet("SP_MZSF_TJ_JK_TJ_YJJCX", parameters1, dset, "sfmx", 30);
Fun.AddRowtNo(dset.Tables[0]);
this.dataGridView1.DataSource = dset.Tables[0];
for (int i = 0; i <= dset.Tables[0].Columns.Count - 1; i++)
{
if (i > 1)
{
dataGridView1.Columns[i].Width = 70;
}
if (dataGridView1.Columns[i].HeaderText == "缴款日期")
{
dataGridView1.Columns[i].Width = 120;
}
}
//Mod by Hxy 20150110 设置金额以及数量列靠右。
this.DGVFormat();
return;
}
if (dtpjsrq2.Value > DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase) && radioButton1.Checked == true)
{
MessageBox.Show("统计时间不能大于当前系统时间", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
ParameterEx[] parameters = new ParameterEx[3];
parameters[0].Text = "@sky";
parameters[0].Value = 0;
parameters[1].Text = "@jsrq";
parameters[1].Value = dtpjsrq2.Value.ToString();
parameters[2].Text = "@err_text";
parameters[2].ParaDirection = ParameterDirection.Output;
parameters[2].ParaSize = 100;
dset = new DataSet();
InstanceForm.BDatabase.AdapterFillDataSet("SP_MZSF_TJ_JK_TJ_YJJ", parameters, dset, "sfmx", 30);
string err_text = Convertor.IsNull(parameters[2].Value, "");
if (err_text != "")
{
MessageBox.Show(err_text, "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
butjk.Enabled = false;
}
dset.Tables[0].Columns.Add("jkid"); //add by wangzhi 2014-08-05 加jkid列，与历史查询保持输出到报表的列一致，不然会导致打印时收费员列显示不正确
Fun.AddRowtNo(dset.Tables[0]);
this.dataGridView1.DataSource = dset.Tables[0];
yjjrow = Convert.ToInt32(Convertor.IsNull(dset.Tables[2].Rows[0][0], "0"));
fpbrow = Convert.ToInt32(Convertor.IsNull(dset.Tables[2].Rows[0][1], "0"));
for (int i = 0; i <= dset.Tables[0].Columns.Count - 1; i++)
{
if (i > 1)
{
dataGridView1.Columns[i].Width = 70;
}
}
//Mod by Hxy 20150110 设置金额以及数量列靠右。
this.DGVFormat();
butjk.Enabled = true;
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void GetData()
{
ParameterEx[] parameters = new ParameterEx[4];
parameters[0].Text = "@rq1";
parameters[0].Value = dtpBjksj.Value.ToString();
parameters[1].Text = "@rq2";
parameters[1].Value = dtpEjksj.Value.ToString();
parameters[2].Text = "@deptID";
parameters[2].Value = TrasenFrame.Forms.FrmMdiMain.CurrentDept.DeptId;
parameters[3].Text = "@mzh";
if (this.checkBox1.Checked == false)
{
parameters[3].Value = "0";
}
else
{
if (string.IsNullOrEmpty(this.textBox1.Text))
{
parameters[3].Value = "0";
}
else
{
parameters[3].Value = this.textBox1.Text;
}
}
DataSet dset = new DataSet();
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("sp_Mz_BusinessOfZXKS", parameters, dset, "sfmx", 60);
DataTable dt = dset.Tables[0];
if (dt.Rows.Count > 0)
{
decimal sum = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
sum += decimal.Parse(dt.Rows[i]["金额"].ToString());
}
string[] data = new string[6];
data[0] = "合计";
data[5] = sum.ToString();
dt.Rows.Add(data);
}
else
{
MessageBox.Show("没有找到数据");
return;
}
Fun.AddRowtNo(dt);
this.dataGridView1.DataSource = dt;
for (int i = 0; i < this.dataGridView1.Columns.Count; i++)
{
this.dataGridView1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
if (this.dataGridView1.Columns[i].Name.ToLower() == "ksdm" || dset.Tables[0].Columns[i].ColumnName.ToLower() == "cfid")
{
this.dataGridView1.Columns[i].Visible = false;
}
}
}
