/// <summary>
/// 查询已候诊的病人Old
/// </summary>
/// <param name="ksdm">科室代码</param>
/// <param name="rq1">开始日期</param>
/// <param name="rq2">结束日期</param>
/// <param name="klx">卡类型</param>
/// <param name="kh">卡号</param>
/// <param name="blh">病历号</param>
/// <param name="_DataBase"></param>
/// <returns></returns>
public static DataSet Select_yhzbr(int ksdm, string rq1, string rq2, int klx, string kh, string blh, RelationalDatabase _DataBase)
{
try
{
ParameterEx[] parameters = new ParameterEx[6];
parameters[0].Text = "@ksdm";
parameters[0].Value = ksdm;
parameters[1].Text = "@rq1";
parameters[1].Value = rq1;
parameters[2].Text = "@rq2";
parameters[2].Value = rq2;
parameters[3].Text = "@klx";
parameters[3].Value = klx;
parameters[4].Text = "@kh";
parameters[4].Value = kh;
parameters[5].Text = "@blh";
parameters[5].Value = blh;
DataSet dset = new DataSet();
_DataBase.AdapterFillDataSet("SP_mzys_fz_yhzbr", parameters, dset, "sfmx", 30);
return(dset);
}
catch (System.Exception err)
{
throw new System.Exception(err.ToString());
}
}
private void buttj_Click(object sender, EventArgs e)
{
try
{
ParameterEx[] parameter = new ParameterEx[2];
parameter[0].Text = "@StratTime";
parameter[0].Value = StartTime.Value.ToString();
parameter[1].Text = "@EndTime";
parameter[1].Value = EndTime.Value.ToString();
DataSet ds = new DataSet();
db.AdapterFillDataSet("SP_ZZ_CCB_TJ", parameter, ds, "dztj", 30);
Fun.AddRowtNo(ds.Tables[0]);
dataGridView1.DataSource = ds.Tables[0];
/*
* //如果医院端与银行端数据不符合，标红显示
* if (this.dataGridView1.Rows[0].Cells["交易总金额"].ToString() != this.dataGridView1.Rows[1].Cells["交易总金额"].ToString())
* {
* this.dataGridView1.Columns["交易总金额"].DefaultCellStyle.BackColor = System.Drawing.Color.Red;
* }
* if (this.dataGridView1.Rows[0].Cells["交易笔数"].ToString() != this.dataGridView1.Rows[1].Cells["交易笔数"].ToString())
* {
* this.dataGridView1.Columns["交易笔数"].DefaultCellStyle.BackColor = System.Drawing.Color.Red;
* }
* */
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static DataSet GetFpResult(string fpid, out int err_code, out string err_text, RelationalDatabase _DataBase)
{
try
{
ParameterEx[] parameters = new ParameterEx[3];
parameters[0].Text = "@fpid";
parameters[0].Value = fpid;
parameters[1].Text = "@err_code";
parameters[1].ParaDirection = ParameterDirection.Output;
parameters[1].DataType = System.Data.DbType.Int32;
parameters[1].ParaSize = 100;
parameters[2].Text = "@err_text";
parameters[2].ParaDirection = ParameterDirection.Output;
parameters[2].ParaSize = 100;
DataSet dset = new DataSet();
_DataBase.AdapterFillDataSet("SP_MZSF_GetFpResult_Htdw", parameters, dset, "sfmx", 30);
err_code = Convert.ToInt32(parameters[1].Value);
err_text = Convert.ToString(parameters[2].Value);
return(dset);
}
catch (System.Exception err)
{
throw new System.Exception(err.Message);
}
}
public void CcbMxTj(string startTime, string endTime, Guid tjId)
{
try
{
bDateTime = startTime;
eDateTime = endTime;
ParameterEx[] parameters = new ParameterEx[3];
parameters[0].Text = "@StartTime";
parameters[0].Value = Convert.ToDateTime(startTime).ToString("yyyy-MM-dd HH:mm:ss");
parameters[1].Text = "@EndTime";
parameters[1].Value = Convert.ToDateTime(endTime).ToString("yyyy-MM-dd HH:mm:ss");
parameters[2].Text = "@TJID";
parameters[2].Value = tjId;
DataSet ds = new DataSet();
db.AdapterFillDataSet("SP_ZZ_CCB_TJMX", parameters, ds, "tjmx", 30);
Fun.AddRowtNo(ds.Tables[0]);
Fun.AddRowtNo(ds.Tables[1]);
this.dataGridView1.DataSource = ds.Tables[0];
this.dataGridView2.DataSource = ds.Tables[1];
lblyhzs.Text = ds.Tables[0].Rows.Count.ToString();
lblyhje.Text = ds.Tables[0].Compute("SUM(银行交易金额)", "").ToString();
lblyyzs.Text = ds.Tables[1].Rows.Count.ToString();
lblyyje.Text = ds.Tables[1].Compute("SUM(医院交易金额)", "").ToString();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public xsClass(string zqip, RelationalDatabase database)
{
_GetGroupName = new string[] { "科室" };
_GetColumnName = new string[] { "姓名", "就诊时间" };
_PanelColCount = 3;
_PanelRowCount = 2;
string ssql = @"select dbo.fun_getdeptname(fzks) 科室,dbo.fun_getghjb(ghjb) 级别,brxm 姓名,pdxh 候诊号,
yysd 候诊时段 ,dbo.fun_getzsmc(zsid) 诊室,'' 备注 from mz_ghxx a inner join mzhs_fzjl b on a.ghxxid=b.ghxxid
inner join yy_brxx c on a.brxxid=c.brxxid
where fzsj>='2013-01-26 00:00:00' and fzsj<='2013-01-31 23:00:00'";
_Dset = new DataSet();
database.AdapterFillDataSet(ssql, Dset, "ghxx", 30);
//计算分组
DataTable tb = Dset.Tables[0];
string[] GroupbyField3 = _GetGroupName;
string[] ComputeField3 = { };
string[] CField3 = { "count" };
_tbGroup = GroupbyDataTable(tb, GroupbyField3, ComputeField3, CField3, null);
}
/// <summary>
/// 查询已分诊的病人 Modify by zp 2013-11-05
/// </summary>
/// <param name="zqid">诊区id</param>
/// <param name="rq1">开始日期</param>
/// <param name="rq2">结束日期</param>
/// <param name="klx">卡类型</param>
/// <param name="kh">卡号</param>
/// <param name="blh">病历号</param>
/// <param name="sort">检索方式0检索全天1检索上午2检索下午</param>
/// <param name="_DataBase"></param>
/// <returns></returns>
public static DataSet Select_yfzpat(int zqid, string rq1, string rq2, int klx, string kh, string blh, int sort, RelationalDatabase _DataBase)
{
try
{
ParameterEx[] parameters = new ParameterEx[7];
parameters[0].Text = "@zqid";
parameters[0].Value = zqid;
parameters[1].Text = "@rq1";
parameters[1].Value = rq1;
parameters[2].Text = "@rq2";
parameters[2].Value = rq2;
parameters[3].Text = "@klx";
parameters[3].Value = klx;
parameters[4].Text = "@kh";
parameters[4].Value = kh;
parameters[5].Text = "@blh";
parameters[5].Value = blh;
parameters[6].Text = "@sort";
parameters[6].Value = sort;
DataSet dset = new DataSet();
_DataBase.AdapterFillDataSet("SP_mzhs_fz_yfzpat", parameters, dset, "sfmx", 30);
return(dset);
}
catch (System.Exception err)
{
throw new System.Exception(err.ToString());
}
}
/// <summary>
/// 获取挂号收费明细
/// </summary>
/// <param name="ghlx">挂号类型</param>
/// <param name="brlx">病人类型</param>
/// <param name="brlx">医保类型</param>
/// <param name="ghks">挂号科室</param>
/// <param name="ghjb">挂号级别</param>
/// <param name="ghys">挂号医生</param>
/// <param name="blb">病历本</param>
/// <param name="ybzf">医保支付</param>
/// <param name="err_code">错误号</param>
/// <param name="err_text">错误文本</param>
/// <returns></returns>
public static DataSet mzgh_get_sfmx(int ghlx, int brlx, int yblx, int ghks, int ghjb, int ghys, string blb, decimal ybzf, int klx, Guid yhlxid, long jgbm, out int err_code, out string err_text, string funname, RelationalDatabase _DataBase)
{
try
{
ParameterEx[] parameters = new ParameterEx[14];
parameters[0].Text = "@ghlx";
parameters[0].Value = ghlx;
parameters[1].Text = "@brlx";
parameters[1].Value = brlx;
parameters[2].Text = "@yblx";
parameters[2].Value = yblx;
parameters[3].Text = "@ghks";
parameters[3].Value = ghks;
parameters[4].Text = "@ghjb";
parameters[4].Value = ghjb;
parameters[5].Text = "@ghys";
parameters[5].Value = ghys;
parameters[6].Text = "@blb";
parameters[6].Value = blb;
parameters[7].Text = "@ybzf";
parameters[7].Value = ybzf;
parameters[8].Text = "@klx";
parameters[8].Value = klx;
parameters[9].Text = "@yhlxid";
parameters[9].Value = yhlxid;
parameters[10].Text = "@jgbm";
parameters[10].Value = jgbm;
parameters[11].Text = "@err_code";
parameters[11].ParaDirection = ParameterDirection.Output;
parameters[11].DataType = System.Data.DbType.Int32;
parameters[11].ParaSize = 100;
parameters[12].Text = "@err_text";
parameters[12].ParaDirection = ParameterDirection.Output;
parameters[12].ParaSize = 100;
parameters[13].Text = "@funname";
parameters[13].Value = funname;
DataSet dset = new DataSet();
_DataBase.AdapterFillDataSet("SP_MZGH_get_sfmx", parameters, dset, "ghsfxx", 30);
err_code = Convert.ToInt32(parameters[11].Value);
err_text = Convert.ToString(parameters[12].Value);
return(dset);
}
catch (System.Exception err)
{
throw new System.Exception(err.Message);
}
}