public override List <DomainSynchroHistoryVO> GetModels(ref DomainSynchroHistoryPara mp)
{
string where = GetConditionByPara(mp);
int pStart = mp.PageIndex.Value * mp.PageSize.Value;
int pEnd = mp.PageSize.Value;
string cmd = QUERYPAGE
.Replace("@PAGESIZE", pEnd.ToString())
.Replace("@PTOP", pStart.ToString())
.Replace("@WHERE", where)
.Replace("@ORDER", GetOrderByPara(mp));
CodeCommand command = new CodeCommand();
command.CommandText = cmd;
var table = DbProxyFactory.Instance.Proxy.ExecuteTable(command);
List <DomainSynchroHistoryVO> list = new List <DomainSynchroHistoryVO>();
for (int i = 0; i < table.Rows.Count; i++)
{
list.Add(new DomainSynchroHistoryVO(table.Rows[i]));
}
if (!mp.Recount.HasValue)
{
mp.Recount = GetRecords(mp);
}
return(list);
}
public override string GetOrderByPara(DomainSynchroHistoryPara mp)
{
if (!string.IsNullOrEmpty(mp.OrderBy))
{
return(string.Format(" order by {0}", mp.OrderBy));
}
return("");
}
public override DomainSynchroHistoryVO GetSingle(DomainSynchroHistoryPara mp)
{
var list = GetModels(mp);
if (list.Count == 1)
{
return(list[0]);
}
return(null);
}
public override int GetRecords(DomainSynchroHistoryPara mp)
{
string where = GetConditionByPara(mp);
CodeCommand command = new CodeCommand();
command.CommandText = QUERYCOUNT + where;
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override bool Delete(DomainSynchroHistoryPara mp)
{
string where = GetConditionByPara(mp);
CodeCommand command = new CodeCommand();
command.CommandText = DELETE + where;
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
public override List <DomainSynchroHistoryVO> GetModels(DomainSynchroHistoryPara mp)
{
string where = GetConditionByPara(mp);
CodeCommand command = new CodeCommand();
string cmd = LOAD
.Replace("@WHERE", where)
.Replace("@ORDER", GetOrderByPara(mp));
command.CommandText = cmd;
var table = DbProxyFactory.Instance.Proxy.ExecuteTable(command);
List <DomainSynchroHistoryVO> list = new List <DomainSynchroHistoryVO>();
for (int i = 0; i < table.Rows.Count; i++)
{
list.Add(new DomainSynchroHistoryVO(table.Rows[i]));
}
return(list);
}
public override string GetOtherConditionByPara(DomainSynchroHistoryPara mp)
{
return("");
}
public override string GetConditionByPara(DomainSynchroHistoryPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (mp.ServerId.HasValue)
{
sb.AppendFormat(" AND [ServerId]='{0}' ", mp.ServerId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Name)))
{
sb.AppendFormat(" AND [Name]='{0}' ", mp.Name);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.MainDomain)))
{
sb.AppendFormat(" AND [MainDomain]='{0}' ", mp.MainDomain);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Domains)))
{
sb.AppendFormat(" AND [Domains]='{0}' ", mp.Domains);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.DomainPath)))
{
sb.AppendFormat(" AND [DomainPath]='{0}' ", mp.DomainPath);
}
if (mp.OperType.HasValue)
{
sb.AppendFormat(" AND [OperType]='{0}' ", mp.OperType);
}
if (mp.IsSynchro.HasValue)
{
sb.AppendFormat(" AND [IsSynchro]='{0}' ", mp.IsSynchro);
}
if (mp.SynchroDate.HasValue)
{
sb.AppendFormat(" AND [SynchroDate]='{0}' ", mp.SynchroDate);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ClientIp)))
{
sb.AppendFormat(" AND [ClientIp]='{0}' ", mp.ClientIp);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
if (mp.CreateUserId.HasValue)
{
sb.AppendFormat(" AND [CreateUserId]='{0}' ", mp.CreateUserId);
}
if (mp.UserId.HasValue)
{
sb.AppendFormat(" AND [UserId]='{0}' ", mp.UserId);
}
if (mp.IsDelete.HasValue)
{
sb.AppendFormat(" AND [IsDelete]='{0}' ", mp.IsDelete);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/json";
string sname = context.Request.Params["sname"];
//获取当前IP
string clientIp = DN.Framework.Utility.ClientHelper.ClientIP();
ApiResult result = new ApiResult();
try
{
//检查IP是否认证的IP
ServerInfoPara sip = new ServerInfoPara();
var serv = ServerInfoBLL.Instance.GetSingle(new ServerInfoPara()
{
Name = sname
});
if (serv == null || serv.IsState == 0)
{
result.code = 0;
result.msg = "您的服务器没有经过认证，请联系管理员处理。";
}
else
{
DomainSynchroHistoryPara dsp = new DomainSynchroHistoryPara();
dsp.Name = sname;
dsp.IsSynchro = 0;
var list = DomainSynchroHistoryBLL.Instance.GetModels(dsp);
if (list.Count == 0)
{
result.code = 0;
result.msg = "当前无同步数据。";
}
else
{
result.code = 1;
result.datajson = DN.Framework.Utility.Serializer.SerializeObject(list);
var domains = DomainInfoBLL.Instance.GetModels(new DomainInfoPara());
foreach (var item in list)
{
item.SynchroDate = DateTime.Now;
item.IsSynchro = 1;
DomainSynchroHistoryBLL.Instance.Edit(item);
//自动更新域名池信息
if (!string.IsNullOrEmpty(item.Domains))
{
var tdlist = item.Domains.Split(new char[] { '\r', '\t', '\n', ',' });
foreach (var tdomain in tdlist)
{
if (!string.IsNullOrEmpty(tdomain))
{
var tdinfo = domains.SingleOrDefault(p => p.Domain == tdomain);
if (tdinfo != null)
{
if (item.OperType == 0)
{
tdinfo.IsResolution = 1;
tdinfo.ResolutionDate = DateTime.Now;
tdinfo.SerName = dsp.Name;
tdinfo.IsColse = 0;
DomainInfoBLL.Instance.Edit(tdinfo);
}
else if (item.OperType == 1)
{
tdinfo.IsResolution = 0;
//删除
tdinfo.IsColse = 1;
tdinfo.ColseDate = DateTime.Now;
tdinfo.CloseUserId = 0;
DomainInfoBLL.Instance.Edit(tdinfo);
}
}
}
}
}
}
}
}
}
catch (Exception ex)
{
result.code = 2;
result.msg = ex.Message;
}
string json = DN.Framework.Utility.Serializer.SerializeObject(result);
context.Response.ClearContent();
context.Response.Write(json);
context.Response.End();
}
