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