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();
}
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="tianYiIDList">�����������ñ���б���á�,���ŷָ�</param>
/// <param name="tianYiSetting">������������ʵ����</param>
/// <param name="where">��ʱ����������ͳһ��ǰ��Ҫ�����ӷ���and��or�ȵȣ�</param>
/// <param name="delCache">�ijɹ��������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;
}
/// <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);
}
/// <summary>
/// �������������ļ�¼
/// </summary>
/// <param name="tianYiSetting">������������ʵ����</param>
/// <param name="where">��ʱ����������ͳһ��ǰ��Ҫ�����ӷ���and��or�ȵȣ�</param>
/// <param name="delCache">�ijɹ��������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;
}
/// <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="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;
}
public TianYiController()
{
setting = TianYiSettingHelper.SelectByID(1);
}
