public bool Exists(MailSendListInfo info) { string SQL_EXISTS = @" DECLARE @Result INT; IF EXISTS( SELECT TOP 1 * FROM [MES].[TT_SYS_MAIL_SEND_LIST](nolock) WHERE SYS_ID= '{0}' AND DATEDIFF(DAY, CREATE_DATE,GETDATE()) = 0 ) SET @Result = 1; ELSE SET @Result = 0; SELECT @Result;"; Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(string.Format(SQL_EXISTS, info.SysId)); return(int.Parse("0" + db.ExecuteScalar(dbCommand)) > 0); }
/// <summary> /// Add /// </summary> /// <param name="info"> info</param> public int Add(MailSendListInfo info) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(TT_SYS_MAIL_SEND_LIST_INSERT); db.AddInParameter(dbCommand, "@PLANT", DbType.String, info.Plant); db.AddInParameter(dbCommand, "@WORKSHOP", DbType.String, info.Workshop); db.AddInParameter(dbCommand, "@ASSEMBLY_LINE", DbType.String, info.AssemblyLine); db.AddInParameter(dbCommand, "@PRODUCT", DbType.String, info.Product); db.AddInParameter(dbCommand, "@SYS_ID", DbType.Int32, info.SysId); db.AddInParameter(dbCommand, "@ALARM_NAME", DbType.String, info.AlarmName); db.AddInParameter(dbCommand, "@ALARM_SUBJECT", DbType.String, info.AlarmSubject); db.AddInParameter(dbCommand, "@MAIL_BODY", DbType.String, info.MailBody); db.AddInParameter(dbCommand, "@CC_MAIL_GROUP", DbType.String, info.CcMailGroup); db.AddInParameter(dbCommand, "@MAILS", DbType.String, info.Mails); db.AddInParameter(dbCommand, "@SEND_STATUS", DbType.Int32, info.SendStatus); db.AddInParameter(dbCommand, "@SEND_DATE", DbType.DateTime, info.SendDate); db.AddInParameter(dbCommand, "@CREATE_USER", DbType.String, info.CreateUser); db.AddInParameter(dbCommand, "@CREATE_DATE", DbType.DateTime, info.CreateDate); db.AddInParameter(dbCommand, "@UPDATE_USER", DbType.String, info.UpdateUser); db.AddInParameter(dbCommand, "@UPDATE_DATE", DbType.DateTime, info.UpdateDate); return(int.Parse("0" + db.ExecuteScalar(dbCommand))); }