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));
}
