public static bool DeleteRptRuntime(RptRuntime rpt)
{
IDbTransaction tran = null;
try {
if (rpt == null || string.IsNullOrEmpty(rpt.Id))
{
return(false);
}
using (var conn = new MySqlConnection(CommonConst.ConStr)) {
conn.Open();
tran = conn.BeginTransaction();
var flag = conn.Delete(rpt);
var result = conn.Execute("delete from rpt_design where Id=@Id", new { Id = rpt.RptId }, tran);
flag &= result > 0;
tran.Commit();
return(flag);
}
} catch (Exception ex) {
log.Error(string.Format("message:{0},StackTrace:{1}", ex.Message, ex.StackTrace));
if (tran != null)
{
tran.Rollback();
}
return(false);
}
}
public static bool SaveRptRuntime(RptRuntime rpt)
{
try {
if (rpt == null || string.IsNullOrEmpty(rpt.RptId))
{
return(false);
}
using (var conn = new MySqlConnection(CommonConst.ConStr)) {
var d = conn.Query <RptRuntime> ("select * from rpt_runtime where RptId=@RptId", new { RptId = rpt.RptId }).FirstOrDefault();
if (d == null)
{
rpt.Id = Guid.NewGuid().ToString("N");
rpt.QueryCount = 0;
rpt.ExportCount = 0;
rpt.LastQueryTime = DateTime.Now.ToString("yyyyMMddHHmmss");
var flag = conn.Insert(rpt);
return(flag >= 0);
}
else
{
if (rpt.ExportCount != 0)
{
d.ExportCount = rpt.ExportCount;
}
if (rpt.LastQeuryPerson != null)
{
d.LastQeuryPerson = rpt.LastQeuryPerson;
}
if (rpt.QueryCount != 0)
{
d.QueryCount = rpt.QueryCount;
}
if (!string.IsNullOrEmpty(rpt.RptId))
{
d.RptId = rpt.RptId;
}
d.LastQueryTime = DateTime.Now.ToString("yyyyMMddHHmmss");
return(conn.Update(d));
}
}
} catch (Exception ex) {
log.Error(string.Format("message:{0},StackTrace:{1}", ex.Message, ex.StackTrace));
return(false);
}
}
public static void RecordRuntime(string rptName, string user, int flag)
{
if (string.IsNullOrEmpty(rptName))
{
return;
}
RptRuntime runtime = GetRptRuntimeByName(rptName);
if (runtime == null)
{
var design = GetRptDesignByName(rptName);
if (design == null)
{
return;
}
SaveRptRuntime(new RptRuntime()
{
QueryCount = 1,
ExportCount = 1,
LastQeuryPerson = user,
RptId = design.Id
});
}
else
{
if (flag == 0)
{
runtime.QueryCount += 1;
}
else if (flag == 1)
{
runtime.ExportCount += 1;
}
runtime.LastQeuryPerson = user;
SaveRptRuntime(runtime);
}
}
