/// <summary> /// Заполняем таблицу SMSBase /// </summary> /// <param name="data"></param> public void SMSBaseSet(SmsBase.SmsBaseSet data) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@SenderId", SqlDbType.NVarChar, data.SenderId); parameters.AddInputParameter("@StatusId", SqlDbType.BigInt, data.StatusId); parameters.AddInputParameter("@StatusDate", SqlDbType.DateTime, data.StatusDate); parameters.AddInputParameter("@CreateDate", SqlDbType.DateTime, data.CreateDate); parameters.AddInputParameter("@Message", SqlDbType.NVarChar, data.Message); parameters.AddInputParameter("@Comment", SqlDbType.NVarChar, data.Comment); Execute_StoredProcedure("SMSBase_Set", parameters); }
public void Execute(IJobExecutionContext context) { try { ISmsBusinessLogic smsBusinessLogic; smsBusinessLogic = new SmsBusinessLogic(); SmsTemplate sms = smsBusinessLogic.SmsTemplate_Get(); SmsBase.SmsBaseSet set = new SmsBase.SmsBaseSet(sms); smsBusinessLogic.SMSBaseSet(set); WriteFileLog("Job1 выполнен " + DateTime.Now); } catch (Exception exp) { WriteFileLog("Job1 не выполнен " + DateTime.Now); WriteFileLog(exp.Message); } }
public void SMSBaseSet(SmsBase.SmsBaseSet data) { SmsMessageDao.Instance.SMSBaseSet(data); }