public static bool GenMobileDeviceRec(string mac, string remark)
{
bool flag = string.IsNullOrWhiteSpace(mac);
bool result;
if (flag)
{
result = false;
}
else
{
Database database = LogicContext.GetDatabase();
HSQL sql = new HSQL(database);
sql.Clear();
sql.Add("SELECT MOBILEDEVICE_DEVICEID FROM MOBILEDEVICE WHERE MOBILEDEVICE_MAC = :MOBILEDEVICE_MAC");
sql.ParamByName("MOBILEDEVICE_MAC").Value = mac;
object obj = database.ExecScalar(sql);
bool flag2 = obj != null;
if (flag2)
{
sql.Clear();
sql.Add("UPDATE MOBILEDEVICE SET");
sql.Add(" MOBILEDEVICE_PROCESSED = 'N'");
sql.Add(",MODIFIERID = :MODIFIERID");
sql.Add(",MODIFIER = :MODIFIER");
sql.Add(",MODIFIEDTIME = :MODIFIEDTIME");
sql.Add("WHERE MOBILEDEVICE_DEVICEID = :MOBILEDEVICE_DEVICEID");
sql.ParamByName("MOBILEDEVICE_DEVICEID").Value = obj;
sql.ParamByName("MODIFIERID").Value = "ADMIN";
sql.ParamByName("MODIFIER").Value = "管理员";
sql.ParamByName("MODIFIEDTIME").Value = DateTime.Now;
}
else
{
sql.Clear();
sql.Add("INSERT INTO MOBILEDEVICE(MOBILEDEVICE_DEVICEID,MOBILEDEVICE_MAC,MOBILEDEVICE_PROCESSED,MOBILEDEVICE_REMARK");
sql.Add(",CREATERID,CREATER,CREATEDTIME,MODIFIERID,MODIFIER,MODIFIEDTIME)");
sql.Add("VALUES");
sql.Add("(:MOBILEDEVICE_DEVICEID,:MOBILEDEVICE_MAC,:MOBILEDEVICE_PROCESSED,:MOBILEDEVICE_REMARK");
sql.Add(",:CREATERID,:CREATER,:CREATEDTIME,:MODIFIERID,:MODIFIER,:MODIFIEDTIME)");
sql.ParamByName("MOBILEDEVICE_DEVICEID").Value = TimIdUtils.GenUtoId("MDEVICEID", "M", 8);
sql.ParamByName("MOBILEDEVICE_MAC").Value = mac;
sql.ParamByName("MOBILEDEVICE_PROCESSED").Value = "N";
sql.ParamByName("MOBILEDEVICE_REMARK").Value = remark;
sql.ParamByName("CREATERID").Value = "ADMIN";
sql.ParamByName("CREATER").Value = "管理员";
sql.ParamByName("CREATEDTIME").Value = DateTime.Now;
sql.ParamByName("MODIFIERID").Value = "ADMIN";
sql.ParamByName("MODIFIER").Value = "管理员";
sql.ParamByName("MODIFIEDTIME").Value = DateTime.Now;
database.ExecSQL(sql);
}
result = true;
}
return(result);
}
public static double ShareFile(double fileId)
{
double shareGroupId = (double)TimIdUtils.GenUtoId("DFS_FGID");
Database db = LogicContext.GetDatabase();
HSQL hsql = new HSQL(db);
hsql.Add("INSERT INTO DFSGROUP(DFSGROUP_GROUPID,DFSGROUP_FILEID");
hsql.Add("VALUES(:DFSGROUP_GROUPID,:DFSGROUP_FILEID)");
hsql.AddParam("DFSGROUP_GROUPID", TimDbType.Float, 0, shareGroupId);
hsql.AddParam("DFSGROUP_FILEID", TimDbType.Float, 0, fileId);
db.ExecSQL(hsql);
return(shareGroupId);
}
internal static DocFileInfo AddFile(string fileSourcePath, string fileName, long fileSize, double groupId)
{
DocFileInfo result = null;
bool flag = groupId == 0.0;
if (flag)
{
groupId = (double)TimIdUtils.GenUtoId("DFS_FGID");
}
double fileId = (double)TimIdUtils.GenUtoId("DFS_FILEID");
string fsId = FileService.GetDfsFsId();
string dfsFileName = fileName.ToFileName();
string dfsExtName = fileName.ToFileExtName();
Database db = LogicContext.GetDatabase();
db.BeginTrans();
try
{
FileService.InsertDfsFile(fsId, fileId, dfsFileName, dfsExtName, fileSize);
FileService.InsertDfsGroup(groupId, fileId);
File.Move(fileSourcePath, FileService.GenDfsPath(fileId));
result = new DocFileInfo();
result.FsId = fsId;
result.FileGroupId = groupId;
result.FileId = fileId;
result.FileName = dfsFileName;
result.ExtName = dfsExtName;
result.FileSize = fileSize;
db.CommitTrans();
}
catch (Exception ex)
{
db.RollbackTrans();
throw ex;
}
return(result);
}
internal static double GenFileId()
{
return((double)TimIdUtils.GenUtoId("DFS_FILEID"));
}
public static void WriteServiceLog(TaskBase task)
{
Database database = LogicContext.GetDatabase();
try
{
database.BeginTrans();
HSQL sql = new HSQL(database);
sql.Add("insert into JOBLOG(JOBLOG_JOBID, JOBLOG_LOGNO, JOBLOG_LOGTIME, JOBLOG_OPERTYPE, JOBLOG_EXECRESULT, JOBLOG_DESC, JOBLOG_DETAIL)");
sql.Add("values(:JOBLOG_JOBID, :JOBLOG_LOGNO, :JOBLOG_LOGTIME, :JOBLOG_OPERTYPE, :JOBLOG_EXECRESULT, :JOBLOG_DESC, :JOBLOG_DETAIL)");
sql.ParamByName("JOBLOG_JOBID").Value = task.JobId;
sql.ParamByName("JOBLOG_LOGNO").Value = TimIdUtils.GenUtoId("JOBLOGNO");
sql.ParamByName("JOBLOG_LOGTIME").Value = AppRuntime.ServerDateTime;
sql.ParamByName("JOBLOG_OPERTYPE").Value = "E";
sql.ParamByName("JOBLOG_DETAIL").Value = string.Empty;
StringBuilder stringBuilder = new StringBuilder();
foreach (string str in task.LogInfoDetail)
{
stringBuilder.AppendLine(str);
}
string str2 = stringBuilder.ToString();
string str3 = string.Empty;
bool flag = task.TaskResult == TaskExecResult.Success;
if (flag)
{
str3 = string.Format("{0} 作业计划执行成功。", task.RequiredExecuteTime.ToString());
bool flag2 = string.IsNullOrEmpty(str2);
if (flag2)
{
str2 = str3;
}
sql.ParamByName("JOBLOG_EXECRESULT").Value = "A";
sql.ParamByName("JOBLOG_DESC").Value = str3;
sql.AddParam("JOBLOG_DETAIL", TimDbType.Blob, 0, str2);
}
else
{
bool flag3 = task.TaskResult == TaskExecResult.Failure;
if (flag3)
{
str3 = string.Format("{0} 作业计划执行失败。", task.RequiredExecuteTime.ToString());
bool flag4 = string.IsNullOrEmpty(str2);
if (flag4)
{
str2 = str3;
}
sql.ParamByName("JOBLOG_EXECRESULT").Value = "B";
sql.ParamByName("JOBLOG_DESC").Value = str3;
sql.AddParam("JOBLOG_DETAIL", TimDbType.Blob, 0, str2);
JobLogUtils.SendErrorMsgToMail(task);
}
else
{
bool flag5 = task.TaskResult == TaskExecResult.Skip;
if (flag5)
{
str3 = "部分作业计划已过期，跳过运行。";
bool flag6 = string.IsNullOrEmpty(str2);
if (flag6)
{
str2 = str3;
}
sql.ParamByName("JOBLOG_EXECRESULT").Value = "C";
sql.ParamByName("JOBLOG_DESC").Value = str3;
sql.AddParam("JOBLOG_DETAIL", TimDbType.Blob, 0, str2);
}
else
{
bool flag7 = task.TaskResult == TaskExecResult.Exception;
if (flag7)
{
str3 = string.Format("{0} 作业计划执行错误。", task.RequiredExecuteTime.ToString());
bool flag8 = string.IsNullOrEmpty(str2);
if (flag8)
{
str2 = str3;
}
sql.ParamByName("JOBLOG_EXECRESULT").Value = "D";
sql.ParamByName("JOBLOG_DESC").Value = str3;
sql.AddParam("JOBLOG_DETAIL", TimDbType.Blob, 0, str2);
JobLogUtils.SendErrorMsgToMail(task);
}
else
{
bool flag9 = task.TaskResult == TaskExecResult.StartExecute;
if (flag9)
{
str3 = string.Format("{0} 作业计划开始执行。", task.RequiredExecuteTime.ToString());
bool flag10 = string.IsNullOrEmpty(str2);
if (flag10)
{
str2 = str3;
}
sql.ParamByName("JOBLOG_EXECRESULT").Value = "A";
sql.ParamByName("JOBLOG_DESC").Value = str3;
sql.AddParam("JOBLOG_DETAIL", TimDbType.Blob, 0, str2);
}
}
}
}
}
database.ExecSQL(sql);
task.LogInfoDetail.Clear();
sql.Clear();
sql.Add("update JOB set JOB_PREEXECTIME = :JOB_PREEXECTIME,JOB_PREEXECSTATUS = :JOB_PREEXECSTATUS,JOB_PREEXECDESC = :JOB_PREEXECDESC ");
sql.Add(" where JOB_JOBID = :JOB_JOBID");
sql.ParamByName("JOB_PREEXECSTATUS").Value = ((task.TaskResult != TaskExecResult.Success) ? ((task.TaskResult != TaskExecResult.Failure) ? ((task.TaskResult != TaskExecResult.Exception) ? "C" : "D") : "B") : "A");
sql.ParamByName("JOB_PREEXECTIME").Value = task.ExecuteTime;
sql.ParamByName("JOB_PREEXECDESC").Value = str3;
sql.ParamByName("JOB_JOBID").Value = task.JobId;
database.ExecSQL(sql);
database.CommitTrans();
}
catch (Exception ex)
{
database.RollbackTrans();
AppEventLog.Error("记录作业计划日志失败，原因：" + ex.Message);
}
}
