public RemindSettings GetSettingByProjectId(int projectId)
{
var tableSettings = m_db.Query <TableRemindSettings>("select * from dbo.RemindSettings where project_id = @0", projectId);
RemindSettings rs = null;
foreach (var item in tableSettings)
{
rs = new RemindSettings(item);
}
return(rs);
}
public ConfigurationViewModel GetConfigInfoByProjectId(string projectId)
{
int id = -1;
int.TryParse(projectId, out id);
var accounts = m_dbAdapter.BankAccount.GetAccounts(id, false);
var contacts = m_dbAdapter.Contact.GetContacts(id);
var reminders = m_dbAdapter.Reminder.GetReminders(id);
var setting = m_dbAdapter.RemindSetting.GetSettingByProjectId(id);
NewsSetting newsSetting = m_dbAdapter.Monitor.GetNewsSettingByProjectId(id);
if (newsSetting == null)
{
newsSetting = new NewsSetting()
{
KeyWords = "", Range = ""
};
}
if (setting == null)
{
RemindSettings rs = new RemindSettings()
{
ProjectId = id,
Frequency = int.Parse(MyEnumConvertor.MyRemindSettingDictionary["H24"]),
RemindType = int.Parse(MyEnumConvertor.MyRemindSettingDictionary["短信加邮件"]),
AutoRemind = false,
RemindDaily = false,
};
m_dbAdapter.RemindSetting.AddRemindSettings(rs);
setting = m_dbAdapter.RemindSetting.GetSettingByProjectId(id);
}
ConfigurationViewModel model = new ConfigurationViewModel();
model.AccountList = accounts;
model.ContactList = contacts;
model.ReminderList = reminders;
model.RemindSettings = setting;
model.NewsSetting = newsSetting;
if (id > 0)
{
var project = m_dbAdapter.Project.GetProjectById(id);
model.CurrentProjectGuid = project.ProjectGuid;
}
return(model);
}
public ActionResult SaveRemindSettings(string rowId, string projectId, string autoRemind, string frequency, string typeId, string remindDaily)
{
RemindSettings rs = new RemindSettings()
{
RowId = int.Parse(rowId),
ProjectId = int.Parse(projectId),
AutoRemind = bool.Parse(autoRemind),
Frequency = int.Parse(frequency),
RemindType = int.Parse(typeId),
RemindDaily = bool.Parse(remindDaily),
};
m_dbAdapter.RemindSetting.UpdateRemindSettings(rs);
return(Content("Success"));
}
public void UpdateRemindSettings(RemindSettings rs)
{
m_logger.Log(rs.ProjectId, "更新提醒设置");
m_db.Update("RemindSettings", "row_id", rs.GetTableObject(), rs.RowId);
}
public void AddRemindSettings(RemindSettings rs)
{
m_logger.Log(rs.ProjectId, "新增默认提醒设置");
m_db.Insert(rs.GetTableObject());
}
