public EntityDisplayClientRpt GetRowObject()
{
EntityDisplayClientRpt vo = null;
if (this.gvReport.FocusedRowHandle >= 0)
{
vo = this.gvReport.GetRow(this.gvReport.FocusedRowHandle) as EntityDisplayClientRpt;
}
return(vo);
}
public EntityDisplayClientRpt GetRptRowsObject()
{
EntityDisplayClientRpt vo = null;
if (gvTjReport.FocusedRowHandle >= 0)
{
vo = gvTjReport.GetRow(gvTjReport.FocusedRowHandle) as EntityDisplayClientRpt;
}
return(vo);
}
public override void Edit()
{
EntityDisplayClientRpt report = GetRowObject();
if (report == null)
{
return;
}
frmPopup2020101 frm = new frmPopup2020101(report);
frm.ShowDialog();
}
private void gvReportItem_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
if (e.RowHandle < 0)
{
return;
}
EntityDisplayClientRpt vo = gvReportItem.GetRow(e.RowHandle) as EntityDisplayClientRpt;
if (vo == null)
{
return;
}
using (ProxyHms proxy = new ProxyHms())
{
gcReportItemData.DataSource = proxy.Service.GetReportItems(vo.reportId);
gcReportItemData.RefreshDataSource();
}
}
private void gcTjReport_Click(object sender, EventArgs e)
{
EntityDisplayClientRpt vo = GetRptRowsObject();
using (ProxyHms proxy = new ProxyHms())
{
gcMainItemData.DataSource = proxy.Service.GetReportMainItem(vo.reportNo);
gcMainItemData.RefreshDataSource();
proxy.Service.GetTjResult(vo.reportNo, out lstTjResult, out lstXjResult, out tjjljyVo);
if (tjjljyVo != null)
{
this.memResult.Text = tjjljyVo.results + Environment.NewLine + tjjljyVo.sumup;
this.memSugg.Text = tjjljyVo.suggTage;
}
else
{
this.memResult.Text = "";
this.memSugg.Text = "";
}
}
}
/// <summary>
/// 列表
/// </summary>
/// <param name="parms"></param>
/// <returns></returns>
public List <EntityDisplayClientRpt> GetTjReports(List <EntityParm> parms = null)
{
List <EntityDisplayClientRpt> data = null;
SqlHelper svc = new SqlHelper(EnumBiz.onlineDB);
string Sql = string.Empty;
Sql = @"select clientName,
clientNo,
gender,
age,
company,
gradeName,
reportNo,
regTimes,
idcard,
reportDate
from v_tjxx a where clientNo is not null ";
List <IDataParameter> lstParm = new List <IDataParameter>();
string strSub = string.Empty;
if (parms != null)
{
foreach (var po in parms)
{
switch (po.key)
{
case "search":
strSub += " and (a.clientName like '%" + po.value + "%' or a.clientNo like '" + po.value + "%' or a.reportNo like '%" + po.value + "%' )";
break;
case "reportDate":
IDataParameter parm1 = svc.CreateParm();
parm1.Value = po.value.Split('|')[0];
lstParm.Add(parm1);
IDataParameter parm2 = svc.CreateParm();
parm2.Value = po.value.Split('|')[1];
lstParm.Add(parm2);
strSub += " and (a.reportDate between ? and ? )";
break;
default:
break;
}
}
}
Sql += strSub;
Sql += " order by reportDate";
DataTable dt = svc.GetDataTable(Sql, lstParm.ToArray());
if (dt != null && dt.Rows.Count > 0)
{
data = new List <EntityDisplayClientRpt>();
EntityDisplayClientRpt vo = null;
foreach (DataRow dr in dt.Rows)
{
vo = new EntityDisplayClientRpt();
vo.clientName = dr["clientName"].ToString();
vo.clientNo = dr["clientNo"].ToString();
vo.gender = Function.Int(dr["gender"]);
if (vo.gender == 1)
{
vo.sex = "男";
}
if (vo.gender == 2)
{
vo.sex = "女";
}
vo.reportNo = dr["reportNo"].ToString();
vo.reportDate = Function.Datetime(dr["reportDate"]).ToString("yyyy-MM-dd");
vo.company = dr["company"].ToString();
vo.gradeName = dr["gradeName"].ToString();
vo.age = dr["age"].ToString();
vo.reportCount = Function.Int(dr["regTimes"]);
data.Add(vo);
}
}
return(data);
}
public frmPopup2020101(EntityDisplayClientRpt _tjReport)
{
InitializeComponent();
tjReport = _tjReport;
}
