private void frmRoute_Activated(object sender, EventArgs e) { frmMain.Instance.ShowStatusText("正在数据...."); setting = TianYiSettingHelper.SelectByID(1); if (setting.IsNull() || setting.TianYiID.IsNull()) { return; } txtPath.Text = setting.TianYiExePath; frmMain.Instance.ShowStatusText("数据加载完成!"); }
/// <summary> /// 天翼连接设置添加记录 /// </summary> /// <param name="tianYiSetting">天翼连接设置实体类</param> /// <param name="delCache">添加成功后清理的CACHE key,支持正则</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时使用ConnString连接</param> /// <returns>添加是否成功</returns> public static bool Insert(TianYiSetting tianYiSetting, string dbkey = "", string[] delCache = null) { int obj = new SQL().Database(dbkey).Insert(TianYiSetting._) .ValueP(TianYiSetting._TianYiID, tianYiSetting.TianYiID) .ValueP(TianYiSetting._TianYiExePath, tianYiSetting.TianYiExePath) .ToExec(); if (delCache.IsNull()) { return(obj == 1); } Cache2.Remove("TH.Mailer.TianYiSettingCache_", delCache); return(obj == 1); }
/// <summary> /// 天翼连接设置修改多条记录 /// </summary> /// <param name="tianYiIDList">天翼连接设置编号列表,用“,”号分隔</param> /// <param name="tianYiSetting">天翼连接设置实体类</param> /// <param name="where">修改时附加条件,统一的前面要加链接符(and、or等等)</param> /// <param name="delCache">修改成功后清理的CACHE key,支持正则</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时使用ConnString连接</param> /// <returns>修改是否成功</returns> public static bool UpdateByIDList(IEnumerable <int> tianYiIDList, TianYiSetting tianYiSetting, string dbkey = "", Where where = null, string[] delCache = null) { int value = new SQL().Database(dbkey).Update(TianYiSetting._) .SetP(TianYiSetting._TianYiExePath, tianYiSetting.TianYiExePath) .Where(new Where() .And(TianYiSetting._TianYiID, "(" + tianYiIDList.Join(",") + ")", Operator.In) ).Where(where).ToExec(); if (value <= 0) { return(false); } if (delCache.IsNull()) { return(true); } Cache2.Remove("TH.Mailer.TianYiSettingCache_", delCache); return(true); }
private void mnuEdit_Click(object sender, EventArgs e) { if (!FileDirectory.FileExists(txtPath.Text)) { MessageBox.Show("文件不存在!", " 系统提示"); return; } TianYiSetting info = new TianYiSetting(); info.TianYiExePath = txtPath.Text; if (setting.IsNull() || setting.TianYiID.IsNull()) { info.TianYiID = 1; TianYiSettingHelper.Insert(info); } else { info.TianYiID = setting.TianYiID; TianYiSettingHelper.Update(info); } TianYiSettingHelper.ClearCacheAll(); string inifile = info.TianYiExePath.GetParentPath('\\'); inifile = inifile + "NavigateSetting.ini"; if (FileDirectory.FileExists(inifile)) { IniFile ini = new IniFile(inifile); if (ini.ReadValue("DIAL", "AutoDial") == "0") { ini.WriteValue("DIAL", "AutoDial", "1"); } } MessageBox.Show("保存数据成功!", " 系统提示"); this.Close(); }
/// <summary> /// 天翼连接设置修改记录 /// </summary> /// <param name="tianYiSetting">天翼连接设置实体类</param> /// <param name="where">修改时附加条件,统一的前面要加链接符(and、or等等)</param> /// <param name="delCache">修改成功后清理的CACHE key,支持正则</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时使用ConnString连接</param> /// <returns>修改是否成功</returns> public static bool Update(TianYiSetting tianYiSetting, string dbkey = "", Where where = null, string[] delCache = null) { if (tianYiSetting.TianYiID.IsNull()) { return(false); } int value = new SQL().Database(dbkey).Update(TianYiSetting._) .SetP(TianYiSetting._TianYiExePath, tianYiSetting.TianYiExePath) .Where(new Where() .AndP(TianYiSetting._TianYiID, tianYiSetting.TianYiID, Operator.Equal, true) ).Where(where).ToExec(); if (value <= 0) { return(false); } if (delCache.IsNull()) { return(true); } Cache2.Remove("TH.Mailer.TianYiSettingCache_", delCache); return(true); }
public TianYiController() { setting = TianYiSettingHelper.SelectByID(1); }
/// <summary> /// 天翼连接设置添加记录 /// </summary> /// <param name="tianYiSetting">天翼连接设置实体类</param> /// <returns>添加是否成功</returns> public static bool Insert(TianYiSetting tianYiSetting, string dbkey) { return(Insert(tianYiSetting, dbkey, null)); }
/// <summary> /// 天翼连接设置修改多条记录 /// </summary> /// <param name="tianYiIDList">天翼连接设置编号列表,用“,”号分隔</param> /// <param name="tianYiSetting">天翼连接设置实体类</param> /// <returns>修改是否成功</returns> public static bool UpdateByIDList(IEnumerable <int> tianYiIDList, TianYiSetting tianYiSetting, string dbkey) { return(UpdateByIDList(tianYiIDList, tianYiSetting, dbkey, null, null)); }
/// <summary> /// 天翼连接设置修改记录 /// </summary> /// <param name="tianYiSetting">天翼连接设置实体类</param> /// <returns>修改是否成功</returns> public static bool Update(TianYiSetting tianYiSetting, string dbkey) { return(Update(tianYiSetting, dbkey, null, null)); }