private void button1_Click(object sender, EventArgs e)
{
string id = "oRrdQt6gB6cEbIZETSL9_YkaAN24";
string time = "30";
PhoenixDataBaseOperate.IDataBaseOperate operate = PhoenixDataBaseConnect.GenerateFactory.GenerateConnect();
string strSql = @"select * from ywapp.jzhz_relation a where a.vglid='{0}'";
strSql = string.Format(strSql, id);
DataTable dt = operate.ExecDataSql(strSql);
var sfzhs = dt.AsEnumerable().Select(a => a["VSFZH"].ToString());
string stj = "nvl(ndel,0)=0 and NDDLX=1 and VSFZH in (" + string.Join(",", sfzhs.Select(a => "'" + a + "'")) + ")";
DataSetPAYMENT ds = HYHISAPP.Rules.HYHISAPPStaticRules.GetPAYMENT_SelectAll(stj);
var aa = ds.PAYMENT.Cast <RowPAYMENT>();
var r = ds.PAYMENT.Cast <RowPAYMENT>().Select(a =>
{
string ztmc = "";
short nstate = a.NSTATE;
if (a.NSTATE == 0)
{
if ((DateTime.Now - a.DDDRQ).TotalMinutes >= Convert.ToInt32(time))
{
ztmc = "超时取消";
nstate = 2;
}
else
{
ztmc = "未支付";
}
}
else if (a.NSTATE == 1)
{
ztmc = "已支付";
}
return(new
{
VDDLSH = a.VDDLSH,
VCLINICNO = a.VCLINICNO,
VNAME = a.VNAME,
NCOSTS = a.NCOSTS.ToString("0.00"),
NSTATE = nstate,//0未支付，1已支付，2超时取消
ZTMC = ztmc,
DJZRQ = a.IsDJZRQNull() ? "" : a.DJZRQ.ToString("yyyy-MM-dd"),
DDDRQ = a.IsDDDRQNull() ? "" : a.DDDRQ.ToString("yyyy-MM-dd HH:mm:ss"),
VAPPTIME = a.VAPPTIME,
VDEPT = a.VDEPT,
VDOCTOR = a.VDOCTOR,
VHAOBIE = a.VHAOBIE,
NGHF = a.NGHF,
NZLF = a.NZLF
});
}).OrderByDescending(a => a.DDDRQ).ToList <object>();
}
internal static DataTable SelectTable(string sql)
{
PhoenixDataBaseOperate.IDataBaseOperate operate = PhoenixDataBaseConnect.GenerateFactory.GenerateConnect();
DataTable dt = operate.ExecDataSql(sql);
operate.Dispose();
return(dt);
}
internal static void WriteErrLog(string msg)
{
string id = Guid.NewGuid().ToString();
string txt = msg;
string date = "to_date('" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-mm-dd hh24:mi:ss')";
string sql = "insert into ywapp.errorlog values('{0}','{1}',{2})";
sql = string.Format(sql, id, txt, date);
PhoenixDataBaseOperate.IDataBaseOperate operate = PhoenixDataBaseConnect.GenerateFactory.GenerateConnect();
operate.ExecSingleSql(sql, true);
operate.Dispose();
}
