public object Execute(object param)
{
bool isModified = false;
try
{
Dictionary <string, object> paramMap = param as Dictionary <string, object>;
if (paramMap == null || paramMap.Count < 1)
{
throw (new Exception("No parameter in UpdateReportIsModifiedDAO!"));
}
string reportGuid = paramMap["reportguid"] as string;
using (RisDAL dal = new RisDAL())
{
DataSet ds = new DataSet();
string strLatestSumittedSQL = string.Format("select top 1 reporttext from treportlist where reportguid='{0}' and status = 110 order by operationtime desc", reportGuid);
string strLatestApprovedSQL = string.Format("select top 1 reporttext from treportlist where reportguid='{0}' and status = 120 order by operationtime desc", reportGuid);
string strUpdateIsModified = "update treport set ismodified = {0} where reportguid ='{1}'";
object lastSumittedRptText = Convert.ToString(dal.ExecuteScalar(strLatestSumittedSQL));
if (string.IsNullOrEmpty(Convert.ToString(lastSumittedRptText))) //no submitted record
{
dal.ExecuteNonQuery(string.Format(strUpdateIsModified, 0, reportGuid));
return(isModified);
}
else
{
object lastApprovedRptText = Convert.ToString(dal.ExecuteScalar(strLatestApprovedSQL));
if (string.IsNullOrEmpty(Convert.ToString(lastApprovedRptText))) //no approved record
{
dal.ExecuteNonQuery(string.Format(strUpdateIsModified, 0, reportGuid));
return(isModified);
}
else if (lastSumittedRptText.ToString().Equals(lastApprovedRptText.ToString(), StringComparison.OrdinalIgnoreCase))
{
dal.ExecuteNonQuery(string.Format(strUpdateIsModified, 0, reportGuid));
return(isModified);
}
else
{
dal.ExecuteNonQuery(string.Format(strUpdateIsModified, 1, reportGuid));
return(isModified = true); //sumbmited reporttext differ with approved one
}
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.Assert(false, ex.Message);
ServerPubFun.RISLog_Error(0, "UpdateReportIsModifiedDAO=" + ex.Message,
(new System.Diagnostics.StackFrame()).GetFileName(),
(new System.Diagnostics.StackFrame()).GetFileLineNumber());
return(isModified);
}
}
public override bool AddNewLeafNode(string strItemGuid, string strParentID, int depth, string strItemName, int itemOrder, int type, string strUserID, string strTemplateGuid, string strGender, ReportTemplateModel model)
{
RisDAL dataAccess = new RisDAL();
model.CheckItemName = model.CheckItemName.Replace("'", "''");
model.DoctorAdvice = model.DoctorAdvice.Replace("'", "''");
//model.TechInfo = model.TechInfo.Replace("'", "''");
//model.WYG = model.WYG.Replace("'", "''");
//model.WYS = model.WYS.Replace("'", "''");
string sql = string.Format("Insert into tReportTemplateDirec(ItemGUID,ParentID,Depth,ItemName,ItemOrder,Type,UserGuid,TemplateGuid,Leaf) values('{0}','{1}',{2},'{3}',{4},{5},'{6}','{7}',{8})"
, strItemGuid, strParentID, depth, strItemName, itemOrder, type, strUserID, strTemplateGuid, 1);
string sql1 = string.Format("Insert into tReportTemplate(TemplateGuid,TemplateName,ModalityType,BodyPart,CheckItemName,DoctorAdvice,ShortcutCode,ACRCode,ACRAnatomicDesc,ACRPathologicDesc,BodyCategory) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')"
, strTemplateGuid, model.TemplateName, model.ModalityType, model.BodyPart, model.CheckItemName, model.DoctorAdvice, model.ShortcutCode, model.ACRCode, model.ACRAnatomicDesc, model.ACRPathologicDesc, model.BodyCategory);
try
{
dataAccess.BeginTransaction();
dataAccess.ExecuteNonQuery(sql, RisDAL.ConnectionState.KeepOpen);
dataAccess.ExecuteNonQuery(sql1, RisDAL.ConnectionState.KeepOpen);
byte [] byteWYS = System.Text.Encoding.Default.GetBytes(model.WYS);
byte [] byteWYG = System.Text.Encoding.Default.GetBytes(model.WYG);
byte [] byteAppendInfo = System.Text.Encoding.Default.GetBytes(model.AppendInfo);
byte [] byteTechInfo = System.Text.Encoding.Default.GetBytes(model.TechInfo);
dataAccess.CommitTransaction();
dataAccess.WriteLargeObj("tReportTemplate", "TemplateGuid", strTemplateGuid, "WYS", byteWYS, byteWYS.Length, RisDAL.ConnectionState.CloseOnExit);
dataAccess.WriteLargeObj("tReportTemplate", "TemplateGuid", strTemplateGuid, "WYG", byteWYG, byteWYG.Length, RisDAL.ConnectionState.CloseOnExit);
dataAccess.WriteLargeObj("tReportTemplate", "TemplateGuid", strTemplateGuid, "AppendInfo", byteAppendInfo, byteAppendInfo.Length, RisDAL.ConnectionState.CloseOnExit);
dataAccess.WriteLargeObj("tReportTemplate", "TemplateGuid", strTemplateGuid, "TechInfo", byteTechInfo, byteTechInfo.Length, RisDAL.ConnectionState.CloseOnExit);
}
catch (Exception e)
{
lm.Error((long)ModuleEnum.Templates_DA, ModuleInstanceName.Templates, 1, e.Message, Application.StartupPath.ToString(),
(new System.Diagnostics.StackFrame(true)).GetFileName(),
Convert.ToInt32(new System.Diagnostics.StackFrame(true).GetFileLineNumber().ToString()));
return(false);
}
finally
{
if (dataAccess != null)
{
dataAccess.Dispose();
}
}
return(true);
}
public override void LogOutBySessionID(string SessionID)
{
StringBuilder strBuilder = new StringBuilder();
strBuilder.AppendFormat("Update tOnlineClient Set IsOnline = 0 where SessionID = '{0}'", SessionID);
RisDAL oKodakDAL = new RisDAL();
try
{
oKodakDAL.ExecuteNonQuery(strBuilder.ToString());
}
catch (Exception Ex)
{
logger.Error((long)ModuleEnum.Framework_Client, ModuleInstanceName.Framework, 1, Ex.Message,
string.Empty, (new System.Diagnostics.StackFrame(true)).GetFileName(),
(new System.Diagnostics.StackFrame(true)).GetFileLineNumber());
}
finally
{
if (oKodakDAL != null)
{
oKodakDAL.Dispose();
}
}
}
public override bool ModifyPrintTemplateFieldInfo(string strTemplateGuid, string strTemplateInfo)
{
RisDAL dataAccess = new RisDAL();
string sql = string.Format("Update tPrintTemplate set Version = Version+1 where TemplateGuid = '{0}'", strTemplateGuid);
byte[] byteTemplateInfo = System.Text.Encoding.Unicode.GetBytes(strTemplateInfo);
try
{
dataAccess.ExecuteNonQuery(sql);
dataAccess.WriteLargeObj("tPrintTemplate", "TemplateGuid", strTemplateGuid, "TemplateInfo", byteTemplateInfo, byteTemplateInfo.Length, RisDAL.ConnectionState.CloseOnExit);
}
catch (Exception e)
{
lm.Error((long)ModuleEnum.Templates_DA, ModuleInstanceName.Templates, 1, e.Message, Application.StartupPath.ToString(),
(new System.Diagnostics.StackFrame(true)).GetFileName(),
Convert.ToInt32(new System.Diagnostics.StackFrame(true).GetFileLineNumber().ToString()));
return(false);
}
finally
{
if (dataAccess != null)
{
dataAccess.Dispose();
}
}
return(true);
}
public override void LogOut(string UserGuid, bool bWebUser)
{
StringBuilder strBuilder = new StringBuilder();
if (bWebUser)
{
strBuilder.AppendFormat("Update tOnlineClient Set IsOnline = 0 where UserGuid = '{0}' and (comments = 'web login user')", UserGuid);
}
else
{
strBuilder.AppendFormat("Update tOnlineClient Set IsOnline = 0 where UserGuid = '{0}' and (comments is null or comments != 'web login user')", UserGuid);
}
RisDAL oKodakDAL = new RisDAL();
try
{
oKodakDAL.ExecuteNonQuery(strBuilder.ToString());
}
catch (Exception Ex)
{
logger.Error((long)ModuleEnum.Framework_Client, ModuleInstanceName.Framework, 1, Ex.Message,
string.Empty, (new System.Diagnostics.StackFrame(true)).GetFileName(),
(new System.Diagnostics.StackFrame(true)).GetFileLineNumber());
}
finally
{
if (oKodakDAL != null)
{
oKodakDAL.Dispose();
}
}
}
public object Execute(object param)
{
try
{
Dictionary <string, object> paramMap = param as Dictionary <string, object>;
if (paramMap == null || paramMap.Count < 1)
{
throw (new Exception("No parameter in SaveLeaveSoundDAO!"));
}
using (RisDAL dal = new RisDAL())
{
DataSet ds = paramMap["DataSet"] as DataSet;
foreach (DataRow dr in ds.Tables[0].Rows)
{
string strSoundGuid = Guid.NewGuid().ToString();
string strReportGuid = Convert.ToString(dr["ReportGuid"]);
string strPath = Convert.ToString(dr["Path"]);
int nStatus = 0;
string strLeaveTime = GlobalCommon.ToLongDateTime(DateTime.Now);
string strOwner = Convert.ToString(dr["Owner"]);
string strDomain = Convert.ToString(dr["Domain"]);
string strSQL = string.Format("insert into tLeaveSound(SoundGuid,ReportGuid,Path,Status,LeaveTime,Owner,Domain) values('{0}','{1}','{2}',{3},'{4}','{5}','{6}')",
strSoundGuid, strReportGuid, strPath, nStatus, strLeaveTime, strOwner, strDomain);
dal.ExecuteNonQuery(strSQL);
strSQL = string.Format("update tReport set IsLeaveSound=1 where ReportGuid='{0}'", strReportGuid);
dal.ExecuteNonQuery(strSQL);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.Assert(false, ex.Message);
ServerPubFun.RISLog_Error(0, "SaveLeaveSoundDAO=" + ex.Message,
(new System.Diagnostics.StackFrame()).GetFileName(),
(new System.Diagnostics.StackFrame()).GetFileLineNumber());
return(false);
}
return(true);
}
public object Execute(object param)
{
try
{
Dictionary <string, object> inMap = param as Dictionary <string, object>;
if (inMap == null || inMap.Count < 1)
{
throw (new Exception("No parameter in DeleteReportDAO!"));
}
string orderGuid = "", assignSite = "";
foreach (string key in inMap.Keys)
{
if (key.ToUpper() == "ORDERGUID")
{
orderGuid = inMap[key] as string;
}
else if (key.ToUpper() == "ASSIGNSITE")
{
assignSite = inMap[key] as string;
}
}
if (orderGuid == null || orderGuid.Length < 1 ||
assignSite == null || assignSite.Length < 1)
{
System.Diagnostics.Debug.Assert(false, "Missing Parameter");
throw (new Exception("Miss Parameter in DeleteReportDAO!"));
}
string sql = string.Format("update tRegOrder set Assign2Siet ={0} where orderGuid={1}",
orderGuid, assignSite);
ServerPubFun.RISLog_Info(0, "AssingReportDAO_MSSQL, SQL=" + sql,
(new System.Diagnostics.StackFrame()).GetFileName(),
(new System.Diagnostics.StackFrame()).GetFileLineNumber());
using (RisDAL dal = new RisDAL())
{
dal.ExecuteNonQuery(sql);
}
return(1);
}
catch (Exception ex)
{
System.Diagnostics.Debug.Assert(false, ex.Message);
ServerPubFun.RISLog_Error(0, "AssingReportDAO_MSSQL=" + ex.Message,
(new System.Diagnostics.StackFrame()).GetFileName(),
(new System.Diagnostics.StackFrame()).GetFileLineNumber());
}
return("-1");
}
/// <summary>
/// DeclareNoCase
/// </summary>
public static void DeclareOracleNoCase()
{
try
{
string sql0 = " alter session set nls_comp=ANSI";
string sql1 = " alter session set nls_sort=GENERIC_BASELETTER";
using (RisDAL dal = new RisDAL())
{
if (dal.DriverClassName.ToUpper() == "ORACLE")
{
dal.ExecuteNonQuery(sql0);
dal.ExecuteNonQuery(sql1);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.Assert(false, ex.Message);
}
}
public override bool ModifyReportTemplate(string strTemplateGuid, ReportTemplateModel model)
{
RisDAL dataAccess = new RisDAL();
model.CheckItemName = model.CheckItemName.Replace("'", "''");
model.DoctorAdvice = model.DoctorAdvice.Replace("'", "''");
// model.TechInfo = model.TechInfo.Replace("'", "''");
// model.WYG = model.WYG.Replace("'", "''");
// model.WYS = model.WYS.Replace("'", "''");
int mark = 0;
string sql = string.Format("Update tReportTemplate set TemplateName='{0}',ModalityType='{1}',BodyPart='{2}',CheckItemName='{3}',DoctorAdvice='{4}',ShortcutCode='{5}',ACRCode='{6}',ACRAnatomicDesc='{7}',ACRPathologicDesc='{8}',BodyCategory='{9}'where TemplateGuid='{10}'",
model.TemplateName, model.ModalityType, model.BodyPart, model.CheckItemName, model.DoctorAdvice, model.ShortcutCode, model.ACRCode, model.ACRAnatomicDesc, model.ACRPathologicDesc, model.BodyCategory, strTemplateGuid);
byte[] byteWYS = System.Text.Encoding.Default.GetBytes(model.WYS);
byte[] byteWYG = System.Text.Encoding.Default.GetBytes(model.WYG);
byte[] byteAppendInfo = System.Text.Encoding.Default.GetBytes(model.AppendInfo);
byte[] byteTechInfo = System.Text.Encoding.Default.GetBytes(model.TechInfo);
try
{
mark = dataAccess.ExecuteNonQuery(sql);
dataAccess.WriteLargeObj("tReportTemplate", "TemplateGuid", strTemplateGuid, "WYS", byteWYS, byteWYS.Length, RisDAL.ConnectionState.CloseOnExit);
dataAccess.WriteLargeObj("tReportTemplate", "TemplateGuid", strTemplateGuid, "WYG", byteWYG, byteWYG.Length, RisDAL.ConnectionState.CloseOnExit);
dataAccess.WriteLargeObj("tReportTemplate", "TemplateGuid", strTemplateGuid, "AppendInfo", byteAppendInfo, byteAppendInfo.Length, RisDAL.ConnectionState.CloseOnExit);
dataAccess.WriteLargeObj("tReportTemplate", "TemplateGuid", strTemplateGuid, "TechInfo", byteTechInfo, byteTechInfo.Length, RisDAL.ConnectionState.CloseOnExit);
}
catch (Exception e)
{
lm.Error((long)ModuleEnum.Templates_DA, ModuleInstanceName.Templates, 1, e.Message, Application.StartupPath.ToString(),
(new System.Diagnostics.StackFrame(true)).GetFileName(),
Convert.ToInt32(new System.Diagnostics.StackFrame(true).GetFileLineNumber().ToString()));
return(false);
}
finally
{
if (dataAccess != null)
{
dataAccess.Dispose();
}
}
if (mark == 1)
{
return(true);
}
else
{
return(false);
}
}
public object Execute(object param)
{
try
{
BaseDataSetModel bdsm = param as BaseDataSetModel;
if (bdsm == null || bdsm.DataSetParameter == null)
{
throw (new Exception("No parameter in SaveLeaveWordDAO!"));
}
//KodakDAL dal = new KodakDAL();
{
DataSet ds = bdsm.DataSetParameter;
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
string strReportGuid = Convert.ToString(ds.Tables[0].Rows[0]["ReportGuid"]);
string strLeaveWord = Convert.ToString(ds.Tables[0].Rows[0]["LeaveWord"]);
string strSQL = string.Format("update tReport set isLeaveWord=1, Comments= @Comments where ReportGuid='{0}'", strReportGuid);
using (var dal = new RisDAL())
{
dal.Parameters.Add("@Comments", strLeaveWord);
dal.ExecuteNonQuery(strSQL);
}
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.Assert(false, ex.Message);
ServerPubFun.RISLog_Error(0, "SaveLeaveWordDAO=" + ex.Message,
(new System.Diagnostics.StackFrame()).GetFileName(),
(new System.Diagnostics.StackFrame()).GetFileLineNumber());
return(false);
}
return(true);
}
public object Execute(object param)
{
try
{
Dictionary <string, object> inMap = param as Dictionary <string, object>;
if (inMap == null || inMap.Count < 1)
{
throw (new Exception("No parameter in DisqualifyImageDAO!"));
}
string rpGuids = "", reportGuid = "", curUserGuid = "", reason = "";
string strDomain = CommonGlobalSettings.Utilities.GetCurDomain();
foreach (string key in inMap.Keys)
{
if (key.ToUpper() == "REPORTGUID")
{
reportGuid = inMap[key] as string;
}
else if (key.ToUpper() == "USERID")
{
curUserGuid = inMap[key] as string;
}
else if (key.ToUpper() == "PROCEDUREGUID")
{
rpGuids = inMap[key] as string;
}
else if (key.ToUpper() == "REASON")
{
reason = inMap[key] as string;
}
}
if ((reportGuid == null || reportGuid.Length < 1) &&
(rpGuids == null || rpGuids.Length < 1))
{
System.Diagnostics.Debug.Assert(false, "Missing Parameter");
throw (new Exception("Miss Parameter in DisqualifyImageDAO!"));
}
if (curUserGuid == null || curUserGuid.Length < 1)
{
System.Diagnostics.Debug.Assert(false, "Missing Parameter");
throw (new Exception("Miss Parameter in DisqualifyImageDAO!"));
}
if (reportGuid == null)
{
reportGuid = "";
}
reportGuid = reportGuid.Trim(" ,".ToCharArray());
if (rpGuids == null)
{
rpGuids = "";
}
rpGuids = rpGuids.Trim(" ,".ToCharArray());
reason = reason == null ? "" : reason.Length >= 512 ? reason.Substring(0, 512) : reason;
string sql = " begin ";
if (reportGuid != null && reportGuid.Length > 0)
{
sql += " delete from tReShot where procedureGuid in (select procedureGuid from tRegProcedure "
+ " where reportGuid = '" + reportGuid + "'; "
+ " insert into tReShot(ProcedureGuid) select procedureGuid from tRegProcedure"
+ " where reportGuid = '" + reportGuid + "'; "
+ " update tReShot set reason='" + reason + "', rejectDoctor='" + curUserGuid + "', rejectDt = sysdate,domain='" + strDomain + "' "
+ " where (rejectDoctor is null or rejectDoctor = '')"
+ " and procedureGuid in (select procedureGuid from tRegProcedure "
+ " where reportGuid = '" + reportGuid + "'); ";
sql += " update tRegProcedure set status = " + System.Convert.ToInt32(ReportCommon.RP_Status.Repeatshot).ToString() + " where "
+ " reportGuid = '" + reportGuid + "'; "
+ " delete from tReportlist where reportGuid = '" + reportGuid + "';"
+ " delete from tReport where reportGuid = '" + reportGuid + "'; ";
}
else if (rpGuids != null && rpGuids.Length > 0)
{
if (!rpGuids.Contains("'"))
{
rpGuids = rpGuids.Replace(",", "','");
rpGuids = rpGuids.Replace(";", "','");
rpGuids = "'" + rpGuids + "'";
}
sql += " delete from tReShot where procedureGuid in (" + rpGuids + "); "
+ " insert into tReShot(ProcedureGuid) select procedureGuid from tRegProcedure"
+ " where procedureGuid in (" + rpGuids + "); "
+ " update tReShot set reason='" + reason + "', rejectDoctor='" + curUserGuid + "', rejectDt = sysdate,domain='" + strDomain + "' "
+ " where (rejectDoctor is null or rejectDoctor = '') and procedureGuid in (" + rpGuids + "); ";
sql += " update tRegProcedure set status = " + System.Convert.ToInt32(ReportCommon.RP_Status.Repeatshot).ToString() + " where procedureGuid in (" + rpGuids + "); ";
}
sql += " commit; end;";
// Delete
tagReportInfo rptInfo = ServerPubFun.GetReportInfo2(rpGuids); //ServerPubFun.GetReportInfo(reportGuid);
ServerPubFun.OnReportDelete(rptInfo, ReportCommon.RP_Status.Repeatshot);
using (RisDAL dal = new RisDAL())
{
dal.ExecuteNonQuery(sql);
return(true);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.Assert(false, ex.Message);
ServerPubFun.RISLog_Error(0, "DisqualifyImageDAO=" + ex.Message,
(new System.Diagnostics.StackFrame()).GetFileName(),
(new System.Diagnostics.StackFrame()).GetFileLineNumber());
}
return("-1");
}
public object Execute(object param)
{
try
{
Dictionary <string, object> paramMap = param as Dictionary <string, object>;
if (paramMap == null || paramMap.Count < 1)
{
throw (new Exception("No parameter in GetLockDAO!"));
}
string action = "";
string lockType = "";
string lockGuid = "";
string owner = "";
string ownerIP = "";
foreach (string key in paramMap.Keys)
{
if (key.ToUpper() == "LOCKTYPE")
{
lockType = paramMap[key] as string;
if (lockType == null)
{
lockType = "";
}
}
else if (key.ToUpper() == "LOCKGUID")
{
lockGuid = paramMap[key] as string;
if (lockGuid == null)
{
lockGuid = "";
}
}
else if (key.ToUpper() == "ACTION")
{
action = paramMap[key] as string;
if (action == null)
{
action = "";
}
}
else if (key.ToUpper() == "OWNER")
{
owner = paramMap[key] as string;
if (owner == null)
{
owner = "";
}
}
else if (key.ToUpper() == "OWNERIP")
{
ownerIP = paramMap[key] as string;
if (ownerIP == null)
{
ownerIP = "";
}
}
}
DataSet ds = new DataSet();
//dal.BeginTransaction();
try
{
using (RisDAL dal = new RisDAL())
{
if (action.ToUpper() == "ADD")
{
string sql0 = "merge into tSync D"
+ " using (select " + lockType + " syncType, '" + lockGuid + "' guid, '"
+ owner + "' owner, '" + ownerIP + "' ownerIP from dual) S"
+ " on (s.synctype = d.syncType and s.guid = d.guid)"
+ " when not matched then insert (d.syncType, d.guid, d.owner, d.ownerIP)"
+ " values(s.synctype, s.guid, s.owner, s.ownerip)";
string sql1 = " select * from tSync, tUser where tSync.Owner = tUser.UserGuid"
+ " and tSync.SyncType=" + lockType + " and tSync.Guid='" + lockGuid + "' for update";
string sql2 = " commit";
dal.ExecuteNonQuery(sql0);
dal.ExecuteQuery(sql1, ds, "tSync");
dal.ExecuteNonQuery(sql2);
}
else if (action.ToUpper() == "DELETE" || action.ToUpper() == "DEL")
{
string sql0 = "delete from tSync"
+ " where syncType=" + lockType + " and guid='" + lockGuid + "'";
string sql1 = " select * from tSync, tUser where tSync.Owner = tUser.UserGuid"
+ " and tSync.SyncType=" + lockType + " and tSync.Guid='" + lockGuid + "' ";
string sql2 = " commit";
dal.ExecuteNonQuery(sql0);
dal.ExecuteQuery(sql1, ds, "tSync");
dal.ExecuteNonQuery(sql2);
}
else
{
string sql = "select * from tSync, tUser where tSync.Owner=tUser.UserGuid and tSync.SyncType="
+ lockType + " and tSync.Guid='" + lockGuid + "'";
dal.ExecuteQuery(sql, ds, "tSync");
}
}
}
catch (Exception ex)
{
//dal.RollbackTransaction();
throw (ex);
}
//dal.CommitTransaction();
return(ds);
}
catch (Exception ex)
{
System.Diagnostics.Debug.Assert(false, ex.Message);
ServerPubFun.RISLog_Error(0, "GetLockDAO=" + ex.Message,
(new System.Diagnostics.StackFrame()).GetFileName(),
(new System.Diagnostics.StackFrame()).GetFileLineNumber());
}
return(null);
}
/// <summary>
/// OnReportDelete
/// </summary>
/// <param name="rptInfo"></param>
/// <param name="nextStatus"></param>
public static void OnReportDelete(tagReportInfo rptInfo, ReportCommon.RP_Status nextStatus)
{
try
{
// Need to send gateway
if (!ServerPubFun.GetSystemProfile_Bool("SendToGateServer", ReportCommon.ModuleID.Integration))
{
return;
}
//
// Gateway
using (RisDAL dal = new RisDAL())
{
string guid = Guid.NewGuid().ToString();
if (dal.DriverClassName.ToUpper() == "ORACLE")
#region Oracle
{
string sql = " insert into GW_DataIndex(data_id, data_dt, event_type, RECORD_INDEX_1, Data_Source)"
+ " values('" + guid + "', SYSDATE, '" + (nextStatus == ReportCommon.RP_Status.Repeatshot ? "32" : "33") + "', 'ReportGuid', 'Local'); "
+ " insert into GW_Patient(DATA_ID,DATA_DT,PATIENTID,PATIENT_NAME,PATIENT_LOCAL_NAME,BIRTHDATE,SEX)"
+ " values('" + guid + "', SYSDATE, '" + rptInfo.patientID + "','" + rptInfo.patientName + "',N'" + rptInfo.patientLocalName + "','" + rptInfo.birthday.ToString("yyyy-MM-dd") + "','" + rptInfo.gender + "'); "
+ " insert into GW_Order(DATA_ID,DATA_DT,ORDER_NO,FILLER_NO,PATIENT_ID,EXAM_STATUS) "
+ " values('" + guid + "', SYSDATE, '" + rptInfo.orderGuid + "', '" + rptInfo.AccNO + "', '" + rptInfo.patientID
+ "', '" + (nextStatus == ReportCommon.RP_Status.Repeatshot ? "17" : "16") + "'); "
+ " insert into GW_Report(data_id, data_dt, report_no, ACCESSION_NUMBER, PATIENT_ID, REPORT_STATUS, MODALITY, "
+ " REPORT_TYPE, REPORT_FILE, REPORT_WRITER, REPORT_APPROVER, REPORTDT, OBSERVATIONMETHOD)"
+ " values('" + guid + "', SYSDATE, '"
+ ((rptInfo.reportGuid == null || rptInfo.reportGuid == "") ? " " : rptInfo.reportGuid) + "', '"
+ rptInfo.AccNO + "'," + " '" + rptInfo.patientID + "', '204', '"
+ rptInfo.modality + "', '0', '', '" + rptInfo.reportCreater_LocalName + "',"
+ " '" + rptInfo.reportApprover_LocalName + "', '" + rptInfo.reportApproveDt.ToString("yyyy-MM-dd HH:mm:ss") + "',"
+ " '" + ReportCommon.ReportCommon.StringLeft(rptInfo.operationStep, ServerPubFun.GetColumnWidth("GW_Report", "OBSERVATIONMETHOD") / 2) + "'); ";
sql = "begin " + sql + " commit; end;";
dal.ExecuteNonQuery(sql);
if (rptInfo.wysText != null && rptInfo.wysText.Length > 0)
{
dal.WriteLargeObj("GW_Report", "data_id", guid, "DIAGNOSE", rptInfo.wysText, rptInfo.wysText.Length, RisDAL.ConnectionState.KeepOpen);
}
if (rptInfo.wygText != null && rptInfo.wygText.Length > 0)
{
dal.WriteLargeObj("GW_Report", "data_id", guid, "COMMENTS", rptInfo.wygText, rptInfo.wygText.Length, RisDAL.ConnectionState.KeepOpen);
}
}
#endregion
else if (dal.DriverClassName.ToUpper() == "MSSQL")
#region MSSQL
{
string sql = SaveReportDAO_MSSQL.MakeSQL4GateWay(rptInfo, guid, nextStatus == ReportCommon.RP_Status.Repeatshot ? 32 : 33, 16, 204);
using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(dal.ConnectionString))
{
conn.Open();
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.Connection = conn;
try
{
//
// begin transaction
//cmd.Transaction = conn.BeginTransaction();
ServerPubFun.RISLog_Info(0, "OnReportDelete=" + sql,
(new System.Diagnostics.StackFrame(true)).GetFileName(),
(new System.Diagnostics.StackFrame(true)).GetFileLineNumber());
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
//cmd.Transaction.Rollback();
System.Diagnostics.Debug.Assert(false, ex.Message);
RISLog_Error(0, "OnReportDelete, MSG=" + ex.Message + ", SQL=" + sql,
(new System.Diagnostics.StackFrame(true)).GetFileName(),
(new System.Diagnostics.StackFrame(true)).GetFileLineNumber());
}
}
}
#endregion
else
{
System.Diagnostics.Debug.Assert(false, "Invalid DB setting!");
}
// Hippa
Server.Utilities.HippaLogTool.HippaLogTool.AuditPatientCareAssignMsg(
CommonGlobalSettings.HippaName.ActionCode.Delete,
rptInfo.AccNO, rptInfo.reportGuid, rptInfo.reportName, rptInfo.patientID, rptInfo.patientName, "", true);
}
}
catch
{
Server.Utilities.HippaLogTool.HippaLogTool.AuditPatientCareAssignMsg(
CommonGlobalSettings.HippaName.ActionCode.Delete,
rptInfo.AccNO, rptInfo.reportGuid, rptInfo.reportName, rptInfo.patientID, rptInfo.patientName, "", false);
}
}
public override bool AddPrintTemplate(BaseDataSetModel model)
{
RisDAL dataAccess = new RisDAL();
DataTable myTable = model.DataSetParameter.Tables[0];
string sql = "Insert into tPrintTemplate(TemplateGuid,Type,TemplateName,IsDefaultByType,Version,ModalityType,IsDefaultByModality) values(:TemplateGuid,:TemplateType,:TemplateName,:IsDefaultByType,0,:ModalityType,:IsDefaultByModality)";
dataAccess.Parameters.AddChar(":TemplateGuid", myTable.Rows[0]["TemplateGuid"].ToString());
dataAccess.Parameters.AddInt(":TemplateType", Convert.ToInt32(myTable.Rows[0]["Type"]));
dataAccess.Parameters.AddChar(":TemplateName", myTable.Rows[0]["TemplateName"].ToString());
dataAccess.Parameters.AddInt(":IsDefaultByType", Convert.ToInt32(myTable.Rows[0]["IsDefaultByType"]));
dataAccess.Parameters.AddChar(":ModalityType", Convert.ToString(myTable.Rows[0]["ModalityType"]));
dataAccess.Parameters.AddInt(":IsDefaultByModality", Convert.ToInt32(myTable.Rows[0]["IsDefaultByModality"]));
// string sql1 = string.Format("select TemplateGuid from tPrintTemplate where Type = {0} and IsDefault=1", Convert.ToInt32(myTable.Rows[0]["Type"]));
byte[] byteTemplateInfo = System.Text.Encoding.Unicode.GetBytes(myTable.Rows[0]["TemplateInfo"].ToString());
try
{
// if (myTable.Rows[0]["IsDefault"].ToString() == "0")
// {
dataAccess.ExecuteNonQuery(sql);
dataAccess.WriteLargeObj("tPrintTemplate", "TemplateGuid", myTable.Rows[0]["TemplateGuid"].ToString(), "TemplateInfo", byteTemplateInfo, byteTemplateInfo.Length, RisDAL.ConnectionState.KeepOpen);
// }
//else
//{
// dataAccess.Parameters.Clear();
// Object o = dataAccess.ExecuteScalar(sql1);
// if (o == null )
// {
// sql = "Insert into tPrintTemplate(TemplateGuid,Type,TemplateName,TemplateInfo,IsDefault,Version) values(@TemplateGuid,@Type,@TemplateName,@TemplateInfo,@IsDefault,0)";
// dataAccess.Parameters.AddVarChar("@TemplateGuid", myTable.Rows[0]["TemplateGuid"].ToString());
// dataAccess.Parameters.AddInt("@Type", Convert.ToInt32(myTable.Rows[0]["Type"]));
// dataAccess.Parameters.AddVarChar("@TemplateName", myTable.Rows[0]["TemplateName"].ToString());
// dataAccess.Parameters.Add("@TemplateInfo", System.Text.Encoding.Default.GetBytes(myTable.Rows[0]["TemplateInfo"].ToString()));
// dataAccess.Parameters.AddInt("IsDefault", Convert.ToInt32(myTable.Rows[0]["IsDefault"]));
// dataAccess.ExecuteNonQuery(sql);
// }
// else
// {
// string strTemplateGuid = o.ToString();
// dataAccess.BeginTransaction();
// sql = "Insert into tPrintTemplate(TemplateGuid,Type,TemplateName,TemplateInfo,IsDefault,Version) values(@TemplateGuid,@Type,@TemplateName,@TemplateInfo,@IsDefault,0)";
// dataAccess.Parameters.AddVarChar("@TemplateGuid", myTable.Rows[0]["TemplateGuid"].ToString());
// dataAccess.Parameters.AddInt("@Type", Convert.ToInt32(myTable.Rows[0]["Type"]));
// dataAccess.Parameters.AddVarChar("@TemplateName", myTable.Rows[0]["TemplateName"].ToString());
// dataAccess.Parameters.Add("@TemplateInfo", System.Text.Encoding.Default.GetBytes(myTable.Rows[0]["TemplateInfo"].ToString()));
// dataAccess.Parameters.AddInt("IsDefault", Convert.ToInt32(myTable.Rows[0]["IsDefault"]));
// dataAccess.ExecuteNonQuery(sql, KodakDAL.ConnectionState.KeepOpen);
// string sql2 = string.Format("Update tPrintTemplate set IsDefault = 0 where TemplateGuid = '{0}'", strTemplateGuid);
// dataAccess.ExecuteNonQuery(sql2,KodakDAL.ConnectionState.KeepOpen);
// dataAccess.CommitTransaction();
// }
//}
}
catch (Exception e)
{
lm.Error((long)ModuleEnum.Templates_DA, ModuleInstanceName.Templates, 1, e.Message, Application.StartupPath.ToString(),
(new System.Diagnostics.StackFrame(true)).GetFileName(),
Convert.ToInt32(new System.Diagnostics.StackFrame(true).GetFileLineNumber().ToString()));
return(false);
}
finally
{
if (dataAccess != null)
{
dataAccess.Dispose();
}
}
return(true);
}
public object Execute(object param)
{
try
{
Dictionary <string, object> inMap = param as Dictionary <string, object>;
if (inMap == null || inMap.Count < 1)
{
throw (new Exception("No parameter in SaveReportDAO!"));
}
string[] reportGuids = null;
string curUserGuid = "", comments = "", snapShotSrvPath = "", modalityType = "", modality = "";
int logType = 0, cnt = 1, costTime = 0;
string strType = "", strMultiCostTime = null;
string strPrintTemplateGuid = "";
foreach (string key in inMap.Keys)
{
if (key.ToUpper() == "LOGTYPE")
{
string tmp = inMap[key] as string;
if (tmp != null && tmp.Length > 0)
{
logType = System.Convert.ToInt32(tmp);
}
}
else if (key.ToUpper() == "REPORTGUIDS" || key.ToUpper() == "REPORTGUID")
{
string tmp = inMap[key] as string;
if (tmp != null && (tmp = tmp.Trim(", ".ToCharArray())).Length > 0)
{
reportGuids = tmp.Split(',');
}
}
else if (key.ToUpper() == "COUNT")
{
string tmp = inMap[key] as string;
if (tmp != null && tmp.Length > 0)
{
cnt = System.Convert.ToInt32(tmp);
}
}
else if (key.ToUpper() == "USERID" || key.ToUpper() == "USERGUID")
{
curUserGuid = inMap[key] as string;
}
else if (key.ToUpper() == "COMMENTS")
{
comments = inMap[key] as string;
}
else if (key.ToUpper() == "SNAPSHOTSRVPATH")
{
snapShotSrvPath = inMap[key] as string;
}
else if (key.ToUpper() == "MODALITYTYPE")
{
modalityType = inMap[key] as string;
}
else if (key.ToUpper() == "MODALITY")
{
modality = inMap[key] as string;
}
else if (key.ToUpper() == "COSTTIME")
{
string tmp = inMap[key] as string;
if (tmp != null && tmp.Length > 0)
{
costTime = System.Convert.ToInt32(tmp);
}
}
else if (key.ToUpper() == "TYPE")
{
strType = inMap[key] as string;
}
else if (key.ToUpper() == "MULTICOSTTIME")
{
strMultiCostTime = inMap[key] as string;
}
else if (key.ToUpper() == "PRINTTEMPLATEGUID")
{
strPrintTemplateGuid = inMap[key] as string;
}
}
string sql = "";
string strDomain = CommonGlobalSettings.Utilities.GetCurDomain();
if (strMultiCostTime != null && strMultiCostTime.Trim().Length > 0)
{
string[] arrCostTime = strMultiCostTime.Split('|');
sql += " insert into tEventLog(guid, eventCode, ModalityType, costtime, createdt, operator,Domain)"
+ " values('" + Guid.NewGuid().ToString() + "', " + (int)ReportCommon.ReportLog_Type.EventLog_Exam2Draft + ", '" + modalityType + "', "
+ arrCostTime[0].ToString() + ", getdate(), '" + curUserGuid + "','" + strDomain + "') \r\n";
sql += " insert into tEventLog(guid, eventCode, ModalityType, costtime, createdt, operator,Domain)"
+ " values('" + Guid.NewGuid().ToString() + "', " + (int)ReportCommon.ReportLog_Type.EventLog_Draft2Submit + ", '" + modalityType + "', "
+ arrCostTime[1].ToString() + ", getdate(), '" + curUserGuid + "','" + strDomain + "') \r\n";
sql += " insert into tEventLog(guid, eventCode, ModalityType, costtime, createdt, operator,Domain)"
+ " values('" + Guid.NewGuid().ToString() + "', " + (int)ReportCommon.ReportLog_Type.EventLog_Submit2Approve + ", '" + modalityType + "', "
+ arrCostTime[2].ToString() + ", getdate(), '" + curUserGuid + "','" + strDomain + "') \r\n";
sql += " insert into tEventLog(guid, eventCode, ModalityType, costtime, createdt, operator,Domain)"
+ " values('" + Guid.NewGuid().ToString() + "', " + (int)ReportCommon.ReportLog_Type.EventLog_ApproveStart2End + ", '" + modalityType + "', "
+ arrCostTime[3].ToString() + ", getdate(), '" + curUserGuid + "','" + strDomain + "') \r\n";
}
else
{
if (logType == System.Convert.ToInt32(ReportCommon.ReportLog_Type.EventLog_Exam2Draft) ||
logType == System.Convert.ToInt32(ReportCommon.ReportLog_Type.EventLog_Draft2Submit) ||
logType == System.Convert.ToInt32(ReportCommon.ReportLog_Type.EventLog_Submit2Approve) ||
logType == System.Convert.ToInt32(ReportCommon.ReportLog_Type.EventLog_ApproveStart2End) ||
logType == System.Convert.ToInt32(ReportCommon.ReportLog_Type.EventLog_Exam2Print))
{
if (reportGuids.Length > 0)
{
sql = "insert into tEventLog(guid, eventCode, ModalityType, costtime, createdt, operator,Domain)"
+ " values('" + Guid.NewGuid().ToString() + "', " + logType.ToString() + ", '" + modalityType + "', "
+ costTime.ToString() + ", getdate(), '" + curUserGuid + "','" + strDomain + "')";
}
}
// 2015-06-08, Oscar added (US25173)
else if (logType == (int)ReportCommon.ReportLog_Type.EventLog_SubmitCostTime ||
logType == (int)ReportCommon.ReportLog_Type.EventLog_ApproveCostTime)
{
if (reportGuids.Length > 0)
{
sql += UpsertEventLog(logType, modalityType, costTime, curUserGuid, strDomain, reportGuids[0]);
}
}
else
{
for (int i = 0; i < reportGuids.Length; i++)
{
string tmp = reportGuids.GetValue(i) as string;
if (tmp != null && tmp.Length > 0)
{
if (cnt < 1)
{
sql += " insert into tReportPrintLog(fileGuid, ReportGuid,Printer,PrintDt,Counts,Comments,snapShotSrvPath,Type,Domain) "
+ " values(newid(), '" + tmp + "', '" + curUserGuid + "', getdate(), "
+ cnt.ToString() + ", '" + comments + "', '" + snapShotSrvPath + "','" + strType + "','" + strDomain + "') \r\n";
}
else
{
sql += " update tReport set isPrint=1,Optional1='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "', PrintTemplateGuid ='" + strPrintTemplateGuid + "' where reportGuid='" + tmp + "' \r\n"
+ " insert into tReportPrintLog(fileGuid, ReportGuid,Printer,PrintDt,Counts,Comments,snapShotSrvPath,Type,PrintTemplateGuid,Domain)"
+ " values(newid(), '" + tmp + "', '" + curUserGuid + "', getdate(), "
+ cnt.ToString() + ", '" + comments + "', '" + snapShotSrvPath + "','" + strType + "','" + strPrintTemplateGuid + "','" + strDomain + "') \r\n";
}
}
}
}
}
if (0 == iWrittenLog++ % 100)
{
ServerPubFun.RISLog_Info(0, "RecordLogDAO, UserGuid=" + curUserGuid + ", SQL=" + sql,
(new System.Diagnostics.StackFrame()).GetFileName(),
(new System.Diagnostics.StackFrame()).GetFileLineNumber());
}
else
{
ServerPubFun.RISLog_Info(0, "RecordLogDAO, UserGuid=" + curUserGuid + ", reportGuids=" + reportGuids.ToString(),
(new System.Diagnostics.StackFrame()).GetFileName(),
(new System.Diagnostics.StackFrame()).GetFileLineNumber());
}
if (sql.Length > 0)
{
using (RisDAL dal = new RisDAL())
{
dal.ExecuteNonQuery(sql);
return(true);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.Assert(false, ex.Message);
ServerPubFun.RISLog_Error(0, "RecordLogDAO=" + ex.Message,
(new System.Diagnostics.StackFrame()).GetFileName(),
(new System.Diagnostics.StackFrame()).GetFileLineNumber());
}
return(false);
}
public override bool UpdateEYTemplate(DataSet ds, ref string strError)
{
bool bReturn = true;
RisDAL oKodak = new RisDAL();
try
{
List <string> listSQL = new List <string>();
DataTable dt = ds.Tables["EYTemplate"];
StringBuilder strBuiler = new StringBuilder();
foreach (DataRow dr in dt.Rows)
{
string strTemplateName = Convert.ToString(dr["TemplateName"]);
string strTemplateGuid = Convert.ToString(dr["TemplateGuid"]);
string strSQL = string.Format("SELECT count(*) FROM tEmergencyTemplate where TemplateGuid='{0}'", strTemplateGuid);
object obj = oKodak.ExecuteScalar(strSQL);
if (obj == null)
{
throw new Exception("Unknow error");
}
int nCount = Convert.ToInt32(obj);
if (nCount == 0)
{
throw new Exception("Can not save due to the template not exists.");
}
strSQL = string.Format("SELECT count(*) FROM tEmergencyTemplate where TemplateName='{0}' AND TemplateGuid!='{1}'", strTemplateName, strTemplateGuid);
obj = oKodak.ExecuteScalar(strSQL);
if (obj == null)
{
throw new Exception("Unknow error");
}
nCount = Convert.ToInt32(obj);
if (nCount > 0)
{
throw new Exception("Reduplicate template name");
}
strBuiler.Remove(0, strBuiler.Length);
strBuiler = strBuiler.AppendFormat("UPDATE tEmergencyTemplate SET TemplateName='{0}',NamePrefix='{1}',Birthday=to_date('{2}','YYYY-MM-DD'),Gender='{3}',Telephone='{4}',", Convert.ToString(dr["TemplateName"]), Convert.ToString(dr["NamePrefix"]), Convert.ToDateTime(dr["Birthday"]).ToString("yyyy-MM-dd"), Convert.ToString(dr["GenderValue"]), Convert.ToString(dr["Telephone"]))
.AppendFormat("InhospitalNo='{0}',ClinicNo='{1}',BedNo='{2}',ApplyDept='{3}',", dr["InhospitalNo"].ToString(), dr["ClinicNo"].ToString(), dr["BedNo"].ToString(), dr["ApplyDeptValue"].ToString())
.AppendFormat("ApplyDoctor='{0}',ProcedureCode='{1}',Description='{2}' WHERE TemplateGuid='{3}'", Convert.ToString(dr["ApplyDoctorValue"]), Convert.ToString(dr["ProcedureCode"]), Convert.ToString(dr["Description"]), Convert.ToString(dr["TemplateGuid"]));
listSQL.Add(strBuiler.ToString());
string strApplyDept = Convert.ToString(dr["ApplyDeptValue"]);
string strApplyDoctor = Convert.ToString(dr["ApplyDoctorValue"]);
strApplyDept = strApplyDept.Trim();
if (strApplyDept.Length > 0)
{
strSQL = string.Format("SELECT count(*) FROM tDictionaryValue WHERE (DictionaryValue='{0}' or Description='{1}') and Tag=2", strApplyDept, strApplyDept);
obj = oKodak.ExecuteScalar(strSQL);
if (obj == null)
{
throw new Exception("Unknow error");
}
nCount = Convert.ToInt32(obj);
if (nCount == 0)
{
strSQL = string.Format("INSERT INTO tDictionaryValue(Tag,DictionaryValue,Description,shortcutcode) VALUES(2,'{0}','{1}','')", strApplyDept, strApplyDept);
listSQL.Add(strSQL);
}
}
strApplyDoctor = strApplyDoctor.Trim();
if (strApplyDoctor.Length > 0)
{
strSQL = string.Format("SELECT count(*) FROM tDictionaryValue WHERE (DictionaryValue='{0}' or Description='{1}') and Tag=8", strApplyDoctor, strApplyDoctor);
obj = oKodak.ExecuteScalar(strSQL);
if (obj == null)
{
throw new Exception("Unknow error");
}
nCount = Convert.ToInt32(obj);
if (nCount == 0)
{
strSQL = string.Format("INSERT INTO tDictionaryValue(Tag,DictionaryValue,Description,shortcutcode) VALUES(8,'{0}','{1}','')", strApplyDoctor, strApplyDoctor);
listSQL.Add(strSQL);
}
}
}
oKodak.BeginTransaction();
foreach (string strSQL in listSQL)
{
oKodak.ExecuteNonQuery(strSQL, RisDAL.ConnectionState.KeepOpen);
}
oKodak.CommitTransaction();
}
catch (Exception e)
{
strError = e.Message;
bReturn = false;
lm.Error((long)ModuleEnum.Templates_DA, ModuleInstanceName.Templates, 1, e.Message, Application.StartupPath.ToString(),
(new System.Diagnostics.StackFrame(true)).GetFileName(),
Convert.ToInt32(new System.Diagnostics.StackFrame(true).GetFileLineNumber().ToString()));
}
finally
{
if (oKodak != null)
{
oKodak.Dispose();
}
}
return(bReturn);
}
public object Execute(object param)
{
try
{
Dictionary <string, object> inMap = param as Dictionary <string, object>;
if (inMap == null || inMap.Count < 1)
{
throw (new Exception("No parameter in DeleteReportDAO!"));
}
string reportGuid = "", curUserGuid = "";
foreach (string key in inMap.Keys)
{
if (key.ToUpper() == "REPORTGUID")
{
reportGuid = inMap[key] as string;
}
else if (key.ToUpper() == "USERID")
{
curUserGuid = inMap[key] as string;
}
}
if (reportGuid == null || reportGuid.Length < 1 ||
curUserGuid == null || curUserGuid.Length < 1)
{
System.Diagnostics.Debug.Assert(false, "Missing Parameter");
throw (new Exception("Miss Parameter in DeleteReportDAO!"));
}
string sql = " begin "
+ " update tRegProcedure set status = " + System.Convert.ToInt32(ReportCommon.RP_Status.Examination).ToString()
+ " where reportGuid = '" + reportGuid + "'; "
+ " delete from tReportlist where reportGuid = '" + reportGuid + "';"
+ " delete from tReport where reportGuid = '" + reportGuid + "'; "
+ " commit; end;";
// Delete
tagReportInfo rptInfo = ServerPubFun.GetReportInfo(reportGuid);
ServerPubFun.OnReportDelete(rptInfo, ReportCommon.RP_Status.Examination);
using (RisDAL dal = new RisDAL())
{
dal.ExecuteNonQuery(sql);
}
return(true);
}
catch (Exception ex)
{
System.Diagnostics.Debug.Assert(false, ex.Message);
ServerPubFun.RISLog_Error(0, "DeleteReportDAO_ORACLE=" + ex.Message,
(new System.Diagnostics.StackFrame()).GetFileName(),
(new System.Diagnostics.StackFrame()).GetFileLineNumber());
}
return("-1");
}
public object Execute(object param)
{
try
{
Dictionary <string, object> inMap = param as Dictionary <string, object>;
if (inMap == null || inMap.Count < 1)
{
throw (new Exception("No parameter in DisqualifyImageDAO!"));
}
string rpGuids = "", reportGuid = "", curUserGuid = "", reason = "";
string strDomain = CommonGlobalSettings.Utilities.GetCurDomain();
foreach (string key in inMap.Keys)
{
if (key.ToUpper() == "REPORTGUID")
{
reportGuid = inMap[key] as string;
}
else if (key.ToUpper() == "USERID")
{
curUserGuid = inMap[key] as string;
}
else if (key.ToUpper() == "PROCEDUREGUID")
{
rpGuids = inMap[key] as string;
}
else if (key.ToUpper() == "REASON")
{
reason = inMap[key] as string;
}
}
if ((reportGuid == null || reportGuid.Length < 1) &&
(rpGuids == null || rpGuids.Length < 1))
{
System.Diagnostics.Debug.Assert(false, "Missing Parameter");
throw (new Exception("Miss Parameter in DisqualifyImageDAO!"));
}
if (curUserGuid == null || curUserGuid.Length < 1)
{
System.Diagnostics.Debug.Assert(false, "Missing Parameter");
throw (new Exception("Miss Parameter in DisqualifyImageDAO!"));
}
if (reportGuid == null)
{
reportGuid = "";
}
reportGuid = reportGuid.Trim(" ,".ToCharArray());
if (rpGuids == null)
{
rpGuids = "";
}
rpGuids = rpGuids.Trim(" ,".ToCharArray());
reason = reason == null ? "" : reason.Length >= 512 ? reason.Substring(0, 512) : reason;
string sql = " begin tran \r\n";
using (RisDAL dal = new RisDAL())
{
if (reportGuid != null && reportGuid.Length > 0)
{
string sqlGetRPs = "select procedureGuid from tRegProcedure where ReportGuid='" + reportGuid + "'";
DataTable dtTmp = dal.ExecuteQuery(sqlGetRPs);
if (dtTmp != null)
{
foreach (DataRow dr in dtTmp.Rows)
{
string tmpRP = System.Convert.ToString(dr[0]);
if (string.IsNullOrEmpty(tmpRP))
{
continue;
}
sql += " if exists(select 1 from tReShot where procedureGuid ='" + tmpRP + "') \r\n"
+ " update tReShot set reason='" + reason + "', rejectDoctor='" + curUserGuid + "',"
+ " rejectDt = getdate(),domain='" + strDomain + "' "
+ " where procedureGuid = '" + tmpRP + "' \r\n"
+ " else "
+ " insert tReShot(ProcedureGuid, reason, rejectDoctor, rejectDt, domain) "
+ " values ('" + tmpRP + "', '" + reason + "', '" + curUserGuid + "', getdate(), '" + strDomain + "') \r\n"
;
}
}
//sql += " delete from tReShot where procedureGuid in (select procedureGuid from tRegProcedure where ReportGuid='" + reportGuid + "') \r\n"
// + " insert tReShot(ProcedureGuid) select procedureGuid from tRegProcedure "
// + " where reportGuid = '" + reportGuid + "' \r\n"
// + " update tReShot set reason='" + reason + "', rejectDoctor='" + curUserGuid + "', rejectDt = getdate(),domain='" + strDomain + "' "
// + " where (rejectDoctor is null or rejectDoctor = '')"
// + " and procedureGuid in (select procedureGuid from tRegProcedure"
// + " where reportGuid = '" + reportGuid + "') \r\n";
sql += ""
+ " update tRegProcedure set status = " + System.Convert.ToInt32(ReportCommon.RP_Status.Repeatshot).ToString() + ",reportguid=null where "
+ " reportGuid = '" + reportGuid + "' \r\n"
+ " delete from tReportlist where reportGuid = '" + reportGuid + "' \r\n"
+ " delete from tReport where reportGuid = '" + reportGuid + "' \r\n";
}
else if (rpGuids != null && rpGuids.Length > 0)
{
string[] arrRPs = rpGuids.Split(",;".ToCharArray());
foreach (string tmpRP in arrRPs)
{
if (string.IsNullOrEmpty(tmpRP))
{
continue;
}
sql += " if exists(select 1 from tReShot where procedureGuid ='" + tmpRP + "') \r\n"
+ " update tReShot set reason='" + reason + "', rejectDoctor='" + curUserGuid + "',"
+ " rejectDt = getdate(),domain='" + strDomain + "' "
+ " where procedureGuid = '" + tmpRP + "' \r\n"
+ " else "
+ " insert tReShot(ProcedureGuid, reason, rejectDoctor, rejectDt, domain) "
+ " values ('" + tmpRP + "', '" + reason + "', '" + curUserGuid + "', getdate(), '" + strDomain + "') \r\n"
;
}
if (!rpGuids.Contains("'"))
{
rpGuids = rpGuids.Replace(",", "','");
rpGuids = rpGuids.Replace(";", "','");
rpGuids = "'" + rpGuids + "'";
}
//sql += " delete from tReShot where procedureGuid in (" + rpGuids + ") \r\n"
//+ " insert tReShot(ProcedureGuid) select procedureGuid from tRegProcedure"
//+ " where procedureGuid in (" + rpGuids + ") \r\n"
//+ " update tReShot set reason='" + reason + "', rejectDoctor='" + curUserGuid + "', rejectDt = getdate(),domain='" + strDomain + "' "
//+ " where (rejectDoctor is null or rejectDoctor = '') and procedureGuid in (" + rpGuids + ") \r\n";
sql += " update tRegProcedure set status = " + System.Convert.ToInt32(ReportCommon.RP_Status.Repeatshot).ToString()
+ " where procedureGuid in (" + rpGuids + ") \r\n";
}
sql += " commit";
ServerPubFun.RISLog_Info(0, "DisqualifyImageDAO_MSSQL, SQL=" + sql,
(new System.Diagnostics.StackFrame()).GetFileName(),
(new System.Diagnostics.StackFrame()).GetFileLineNumber());
// Delete
tagReportInfo rptInfo = ServerPubFun.GetReportInfo2(rpGuids); //ServerPubFun.GetReportInfo(reportGuid);
ServerPubFun.OnReportDelete(rptInfo, ReportCommon.RP_Status.Repeatshot);
dal.ExecuteNonQuery(sql);
return(true);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.Assert(false, ex.Message);
ServerPubFun.RISLog_Error(0, "DisqualifyImageDAO=" + ex.Message,
(new System.Diagnostics.StackFrame()).GetFileName(),
(new System.Diagnostics.StackFrame()).GetFileLineNumber());
}
return("-1");
}