private void frmRoute_Activated(object sender, EventArgs e)
{
frmMain.Instance.ShowStatusText("正在数据....");
routeSetting = RouteSettingHelper.SelectByID(1);
if (routeSetting.IsNull() || routeSetting.RouteID.IsNull()) return;
txtPassword.Text = routeSetting.RPassword;
txtRouteIP.Text = routeSetting.RouteIP;
txtUserName.Text = routeSetting.UserName;
txtRouteConnect.Text = routeSetting.RouteConnect;
txtRouteDisConnect.Text = routeSetting.RouteDisConnect;
if (routeSetting.RouteMethod == "GET") rdoGET.Checked = true;
if (routeSetting.RouteMethod == "POST") rdoPOST.Checked = true;
frmMain.Instance.ShowStatusText("数据加载完成！");
}
private void mnuEdit_Click(object sender, EventArgs e)
{
RouteSetting info = new RouteSetting();
info.UserName = txtUserName.Text;
info.RPassword = txtPassword.Text;
info.RouteIP = txtRouteIP.Text;
info.RouteConnect = txtRouteConnect.Text;
info.RouteDisConnect = txtRouteDisConnect.Text;
info.RouteMethod = rdoGET.Checked ? "GET" : "POST";
if (routeSetting.IsNull() || routeSetting.RouteID.IsNull()) {
info.RouteID = 1;
RouteSettingHelper.Insert(info);
} else {
info.RouteID = routeSetting.RouteID;
RouteSettingHelper.Update(info);
}
RouteSettingHelper.ClearCacheAll();
MessageBox.Show("保存数据成功！", " 系统提示");
this.Close();
}
public RouteController()
{
routeInfo = RouteSettingHelper.SelectByID(1);
}
/// <summary>
/// ·����Ӽ�¼
/// </summary>
/// <param name="routeSetting">·��ʵ����</param>
/// <param name="delCache">��ӳɹ��������CACHE key��֧������</param>
/// <param name="dbkey">�������ݿ����ӳ��е�����key��Ϊ��ʱʹ��ConnString����</param>
/// <returns>����Ƿ�ɹ�</returns>
public static bool Insert(RouteSetting routeSetting, string dbkey = "", string[] delCache = null)
{
int obj = new SQL().Database(dbkey).Insert(RouteSetting._)
.ValueP(RouteSetting._RouteID, routeSetting.RouteID)
.ValueP(RouteSetting._RouteIP, routeSetting.RouteIP)
.ValueP(RouteSetting._UserName, routeSetting.UserName)
.ValueP(RouteSetting._RPassword, routeSetting.RPassword)
.ValueP(RouteSetting._RouteConnect, routeSetting.RouteConnect)
.ValueP(RouteSetting._RouteDisConnect, routeSetting.RouteDisConnect)
.ValueP(RouteSetting._RouteMethod, routeSetting.RouteMethod)
.ToExec();
if (delCache.IsNull()) return obj == 1;
Cache2.Remove("TH.Mailer.RouteSettingCache_", delCache);
return obj == 1;
}
/// <summary>
/// ·���Ķ�����¼
/// </summary>
/// <param name="routeIDList">·�ɱ���б���á�,���ŷָ�</param>
/// <param name="routeSetting">·��ʵ����</param>
/// <returns>���Ƿ�ɹ�</returns>
public static bool UpdateByIDList(IEnumerable<int> routeIDList, RouteSetting routeSetting, string dbkey)
{
return UpdateByIDList(routeIDList, routeSetting, dbkey, null, null);
}
/// <summary>
/// ·���Ķ�����¼
/// </summary>
/// <param name="routeIDList">·�ɱ���б���á�,���ŷָ�</param>
/// <param name="routeSetting">·��ʵ����</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> routeIDList, RouteSetting routeSetting, string dbkey = "", Where where = null, string[] delCache = null)
{
int value = new SQL().Database(dbkey).Update(RouteSetting._)
.SetP(RouteSetting._RouteIP, routeSetting.RouteIP)
.SetP(RouteSetting._UserName, routeSetting.UserName)
.SetP(RouteSetting._RPassword, routeSetting.RPassword)
.SetP(RouteSetting._RouteConnect, routeSetting.RouteConnect)
.SetP(RouteSetting._RouteDisConnect, routeSetting.RouteDisConnect)
.SetP(RouteSetting._RouteMethod, routeSetting.RouteMethod)
.Where(new Where()
.And(RouteSetting._RouteID, "(" + routeIDList .Join(",") + ")", Operator.In)
).Where(where).ToExec();
if (value <= 0) return false;
if (delCache.IsNull()) return true;
Cache2.Remove("TH.Mailer.RouteSettingCache_", delCache);
return true;
}
/// <summary>
/// ·���ļ�¼
/// </summary>
/// <param name="routeSetting">·��ʵ����</param>
/// <returns>���Ƿ�ɹ�</returns>
public static bool Update(RouteSetting routeSetting, string dbkey)
{
return Update(routeSetting, dbkey, null, null);
}
/// <summary>
/// ·���ļ�¼
/// </summary>
/// <param name="routeSetting">·��ʵ����</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(RouteSetting routeSetting, string dbkey = "", Where where = null, string[] delCache = null)
{
if (routeSetting.RouteID.IsNull()) return false;
int value = new SQL().Database(dbkey).Update(RouteSetting._)
.SetP(RouteSetting._RouteIP, routeSetting.RouteIP)
.SetP(RouteSetting._UserName, routeSetting.UserName)
.SetP(RouteSetting._RPassword, routeSetting.RPassword)
.SetP(RouteSetting._RouteConnect, routeSetting.RouteConnect)
.SetP(RouteSetting._RouteDisConnect, routeSetting.RouteDisConnect)
.SetP(RouteSetting._RouteMethod, routeSetting.RouteMethod)
.Where(new Where()
.AndP(RouteSetting._RouteID, routeSetting.RouteID, Operator.Equal, true)
).Where(where).ToExec();
if (value <= 0) return false;
if (delCache.IsNull()) return true;
Cache2.Remove("TH.Mailer.RouteSettingCache_", delCache);
return true;
}
/// <summary>
/// ·����Ӽ�¼
/// </summary>
/// <param name="routeSetting">·��ʵ����</param>
/// <returns>����Ƿ�ɹ�</returns>
public static bool Insert(RouteSetting routeSetting, string dbkey)
{
return Insert(routeSetting, dbkey, null);
}