public string DoGuestJob(DateTime date)
{
var content = "开始-客户联系跟踪表";
int currentYear = date.Year;
int currentMonth = date.Month;
int nextYear = date.AddMonths(1).Year;
int nextMonth = date.AddMonths(1).Month;
int currentZhangQi = GetZhouQi(currentMonth);
int nextZhangQi = GetZhouQi(nextMonth);
//if (currentZhangQi == nextZhangQi && currentYear == nextYear)
//{
// return;
//}
List <GuestProBaseInfo> guestProBaseInfos = new GuestProBaseInfoService().GetListArray("GuestPro=1");
TB_GuestTrackService GuestTrackSer = new TB_GuestTrackService();
string sql = string.Format(" 1=1 and QuartNo='{1}' and YearNo='{0}'", currentYear, currentZhangQi);
sql += string.Format(@" and (TB_GuestTrack.id in (select allE_id from tb_EForm where proId in (
select pro_Id from A_ProInfo where pro_Type='客户联系跟踪表') and state='通过') or TB_GuestTrack.id not in (select allE_id from tb_EForm where proId in (
select pro_Id from A_ProInfo where pro_Type='客户联系跟踪表') ))");
List <TB_GuestTrack> GuestTracks = GuestTrackSer.GetListArray(sql);
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlTransaction tan = conn.BeginTransaction();
SqlCommand objCommand = conn.CreateCommand();
objCommand.Transaction = tan;
try
{
objCommand.Parameters.Clear();
foreach (var model in GuestTracks)
{
//客户属性 每个季度需要复制到下一季度，但有一个是需要 特别关注的，就是每年的四季度 如果某个客户的客户属性是 自我开拓，
//来年的一季度，这个客户的客户属性 必须变成 原有资源！！！
//if (currentZhangQi == 4)
//{
// if (model.MyGuestProString == "自我开拓")
// {
// model.MyGuestPro = 2;
// }
//}
model.QuartNo = nextZhangQi.ToString();
model.YearNo = nextYear.ToString();
model.CreateTime = date;
string secondUpdate = GuestTrackSer.UpdateToString(model, model.GuestId, nextYear.ToString(), nextZhangQi.ToString());
if (model.MyGuestProString == "自我开拓")
{
//我们的系统在每个季度的最后一天的晚上12点会自动同步客户信息到下一个季度，我们定义
//． 如该客户目前的属性是自我开拓，该客户从登记之日起，加上自我开拓的有效期月数数字对应的日期，
//如小于（<） 新季度第一天，新季度的客户的属性变成 原有资源，否则 还是自我开拓
if (date.Month == 3 || date.Month == 6 || date.Month == 9 || date.Month == 12)
{
if (date.Day == DateTime.DaysInMonth(date.Year, date.Month) &&
model.Time.AddMonths(guestProBaseInfos[0].GuestMonth) < Convert.ToDateTime(nextYear + "-" + nextMonth + "-01"))
{
model.MyGuestPro = 2;
}
}
}
string update = GuestTrackSer.AddToString(model);
string updateSql = string.Format("if not exists(select id from TB_GuestTrack where guestId='{0}' and yearNo='{1}' and QuartNo='{2}')begin {3} end else begin {4} end",
model.GuestId, nextYear.ToString(), nextZhangQi.ToString(), update, secondUpdate);
objCommand.CommandText = updateSql;
objCommand.ExecuteNonQuery();
}
tan.Commit();
new JobInfoService().Add(new JobInfo
{
JobTime = date,
JobType = 1
});
content += "结束-客户联系跟踪表";
//ServiceAppSetting.LoggerHander.Invoke(string.Format("执行成功! - {0}", DateTime.Now), "");
}
catch (Exception)
{
tan.Rollback();
content += "【异常】账期执行失败";
//ServiceAppSetting.LoggerHander.Invoke(string.Format("账期执行失败! - {0}", DateTime.Now), "Error");
}
}
_logger.InfoFormat(content);
return(content);
}
public void Execute()
{
//OA系统每天晚上23:55，准时发起，一个任务，就是点击缓存按钮的动作，这样我们可以获得 当天的数据的快速列表印象。
if (DateTime.Now.Hour == 22 && DateTime.Now.Minute == 00)
{
ServiceAppSetting.LoggerHander.Invoke(string.Format("执行-缓存! - {0}", DateTime.Now), "");
new JXC_REPORTService().CatchData();
ServiceAppSetting.LoggerHander.Invoke(string.Format("结束-缓存! - {0}", DateTime.Now), "");
}
ServiceAppSetting.LoggerHander.Invoke(string.Format("do! {0}", DateTime.Now), "");
//每天早上1，2，3点处理最高值
if ((DateTime.Now.Hour == 1 || DateTime.Now.Hour == 2 || DateTime.Now.Hour == 3) && DateTime.Now.Minute == 0)
{
ServiceAppSetting.LoggerHander.Invoke(string.Format("执行-最高金额! - {0}", DateTime.Now), "");
CashFlowService cashFlowService = new CashFlowService();
List <CashFlow> cashFlowList = cashFlowService.GetListArray(" AND IsClose=0");
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlCommand objCommand = conn.CreateCommand();
try
{
objCommand.Parameters.Clear();
foreach (var model in cashFlowList)
{
cashFlowService.Update(model, objCommand);
}
}
catch (Exception)
{
}
}
ServiceAppSetting.LoggerHander.Invoke(string.Format("结束-最高金额! - {0}", DateTime.Now), "");
}
if (DateTime.Now.Hour == 23 && DateTime.Now.Minute <= 5)
{
ServiceAppSetting.LoggerHander.Invoke(string.Format("执行一次! - {0}", DateTime.Now), "");
int currentYear = DateTime.Now.Year;
int currentMonth = DateTime.Now.Month;
int nextYear = DateTime.Now.AddMonths(1).Year;
int nextMonth = DateTime.Now.AddMonths(1).Month;
int currentZhangQi = GetZhouQi(currentMonth);
int nextZhangQi = GetZhouQi(nextMonth);
//if (currentZhangQi == nextZhangQi && currentYear == nextYear)
//{
// return;
//}
List <GuestProBaseInfo> guestProBaseInfos = new GuestProBaseInfoService().GetListArray("GuestPro=1");
TB_GuestTrackService GuestTrackSer = new TB_GuestTrackService();
string sql = string.Format(" 1=1 and QuartNo='{1}' and YearNo='{0}' ", currentYear, currentZhangQi);
sql += string.Format(@" and (TB_GuestTrack.id in (select allE_id from tb_EForm where proId in (
select pro_Id from A_ProInfo where pro_Type='客户联系跟踪表') and state='通过') or TB_GuestTrack.id not in (select allE_id from tb_EForm where proId in (
select pro_Id from A_ProInfo where pro_Type='客户联系跟踪表') ))");
List <TB_GuestTrack> GuestTracks = GuestTrackSer.GetListArray(sql);
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlTransaction tan = conn.BeginTransaction();
SqlCommand objCommand = conn.CreateCommand();
objCommand.Transaction = tan;
try
{
objCommand.Parameters.Clear();
foreach (var model in GuestTracks)
{
//if (currentZhangQi == 4)
//{
// if (model.MyGuestProString == "自我开拓")
// {
// model.MyGuestPro = 2;
// }
//}
model.QuartNo = nextZhangQi.ToString();
model.YearNo = nextYear.ToString();
model.CreateTime = DateTime.Now;
string secondUpdate = GuestTrackSer.UpdateToString(model, model.GuestId, nextYear.ToString(), nextZhangQi.ToString());
if (model.MyGuestProString == "自我开拓")
{
//我们的系统在每个季度的最后一天的晚上12点会自动同步客户信息到下一个季度，我们定义
//． 如该客户目前的属性是自我开拓，该客户从登记之日起，加上自我开拓的有效期月数数字对应的日期，
//如小于（<） 新季度第一天，新季度的客户的属性变成 原有资源，否则 还是自我开拓
if (DateTime.Now.Month == 3 || DateTime.Now.Month == 6 || DateTime.Now.Month == 9 || DateTime.Now.Month == 12)
{
if (DateTime.Now.Day == DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) &&
model.Time.AddMonths(guestProBaseInfos[0].GuestMonth) < Convert.ToDateTime(nextYear + "-" + nextMonth + "-01"))
{
model.MyGuestPro = 2;
}
}
}
string update = GuestTrackSer.AddToString(model);
string updateSql = string.Format("if not exists(select id from TB_GuestTrack where guestId='{0}' and yearNo='{1}' and QuartNo='{2}')begin {3} end else begin {4} end",
model.GuestId, nextYear.ToString(), nextZhangQi.ToString(), update, secondUpdate);
objCommand.CommandText = updateSql;
objCommand.ExecuteNonQuery();
}
tan.Commit();
ServiceAppSetting.LoggerHander.Invoke(string.Format("执行成功! - {0}", DateTime.Now), "");
}
catch (Exception)
{
tan.Rollback();
ServiceAppSetting.LoggerHander.Invoke(string.Format("账期执行失败! - {0}", DateTime.Now), "Error");
}
}
}
////增加金蝶发票处理工具
//var kISModel = new KISService().GetKIS();
//var invoiceDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd") + kISModel.InvoiceDate);
//var payableDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd") + kISModel.PayableDate);
//if (DateTime.Now.Hour == invoiceDate.Hour && DateTime.Now.Minute == invoiceDate.Minute)
//{
// var invoiceJob = new Thread(delegate ()
// {
// try
// {
// ServiceAppSetting.LoggerHander.Invoke(string.Format("Invoice_Proc-开始! - {0}", DateTime.Now), "");
// var kisServer = new KISService();
// var invoicesList = kisServer.GetInvoiceErrorInfo(kISModel.AccountName);
// if (invoicesList.Count > 0)
// {
// ServiceAppSetting.LoggerHander.Invoke(string.Format("Invoice_Proc-存在重复发票号数据，JOB 停止！", DateTime.Now), "");
// return;
// }
// //获取选中的数据库连接
// string newConn = KISService.KISDBConn.Replace("AcctCtl", kISModel.AccountName);
// KISService.ExeCommand("Invoice_Proc", newConn, Convert.ToDateTime(kISModel.InvoiceFrom), Convert.ToDateTime(kISModel.InvoiceTo));
// ServiceAppSetting.LoggerHander.Invoke(string.Format("Invoice_Proc-结束! - {0}", DateTime.Now), "");
// }
// catch (Exception ex)
// {
// ServiceAppSetting.LoggerHander.Invoke(string.Format("Invoice_Proc-结束! - {0}，执行异常，请检查！错误信息:{1}", DateTime.Now, ex.Message), "");
// }
// })
// { IsBackground = true };
// invoiceJob.Start();
//}
//if (DateTime.Now.Hour == payableDate.Hour && DateTime.Now.Minute == payableDate.Minute)
//{
// var payableJob = new Thread(delegate ()
// {
// try
// {
// var kisServer = new KISService();
// var payableList = kisServer.GetPayaleErrorInfo(kISModel.AccountName);
// if (payableList.Count > 0)
// {
// ServiceAppSetting.LoggerHander.Invoke(string.Format("Payable_Proc-存在重复发票号数据，JOB 停止！", DateTime.Now), "");
// return;
// }
// ServiceAppSetting.LoggerHander.Invoke(string.Format("Payable_Proc-开始! - {0}", DateTime.Now), "");
// //获取选中的数据库连接
// string newConn = KISService.KISDBConn.Replace("AcctCtl", kISModel.AccountName);
// KISService.ExeCommand("Payable_Proc", newConn, Convert.ToDateTime(kISModel.PayableFrom), Convert.ToDateTime(kISModel.PayableTo));
// ServiceAppSetting.LoggerHander.Invoke(string.Format("Payable_Proc-结束! - {0}", DateTime.Now), "");
// }
// catch (Exception ex)
// {
// ServiceAppSetting.LoggerHander.Invoke(string.Format("Payable_Proc-结束! - {0}，执行异常，请检查！错误信息:{1}", DateTime.Now, ex.Message), "");
// }
// })
// { IsBackground = true };
// payableJob.Start();
//}
}
protected void btnCopy_Click(object sender, EventArgs e)
{
if (ddlYears.Text + ddlOrl.Text == ddlNextYears.Text + ddlBar.Text)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('原季度不能等于目标季度！');</script>");
return;
}
List <GuestProBaseInfo> guestProBaseInfos = new GuestProBaseInfoService().GetListArray("GuestPro=1");
string sql = string.Format(" 1=1 and QuartNo='{1}' and YearNo='{0}' ", ddlYears.Text, ddlOrl.Text);
sql += string.Format(@" and (TB_GuestTrack.id in (select allE_id from tb_EForm where proId in (
select pro_Id from A_ProInfo where pro_Type='客户联系跟踪表') and state='通过') or TB_GuestTrack.id not in (select allE_id from tb_EForm where proId in (
select pro_Id from A_ProInfo where pro_Type='客户联系跟踪表') ))");
List <TB_GuestTrack> GuestTracks = this.GuestTrackSer.GetListArray(sql);
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlTransaction tan = conn.BeginTransaction();
SqlCommand objCommand = conn.CreateCommand();
objCommand.Transaction = tan;
try
{
objCommand.Parameters.Clear();
foreach (var model in GuestTracks)
{
//客户属性 每个季度需要复制到下一季度，但有一个是需要 特别关注的，就是每年的四季度 如果某个客户的客户属性是 自我开拓，
//来年的一季度，这个客户的客户属性 必须变成 原有资源！！！
//if (ddlOrl.Text == "4"&& ddlBar.Text=="1")
//{
// if (model.MyGuestProString == "自我开拓")
// {
// model.MyGuestPro = 2;
// }
//}
model.QuartNo = ddlBar.Text;
model.YearNo = ddlNextYears.Text;
string update = GuestTrackSer.UpdateToString(model, model.GuestId, ddlNextYears.Text, ddlBar.Text);
if (model.MyGuestProString == "自我开拓")
{
//我们的系统在每个季度的最后一天的晚上12点会自动同步客户信息到下一个季度，我们定义
//． 如该客户目前的属性是自我开拓，该客户从登记之日起，加上自我开拓的有效期月数数字对应的日期，
//如小于（<） 新季度第一天，新季度的客户的属性变成 原有资源，否则 还是自我开拓
if (DateTime.Now.Month == 3 || DateTime.Now.Month == 6 || DateTime.Now.Month == 9 || DateTime.Now.Month == 12)
{
if (DateTime.Now.Day == DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) &&
model.Time.AddMonths(guestProBaseInfos[0].GuestMonth) < Convert.ToDateTime(ddlNextYears.Text + "-" + ddlBar.Text + "-01"))
{
model.MyGuestPro = 2;
}
}
}
string add = GuestTrackSer.AddToString(model);
string updateSql =
string.Format(
"if not exists(select id from TB_GuestTrack where guestId='{0}' and yearNo='{1}' and QuartNo='{2}') begin {3} end else begin {4} end ",
model.GuestId, ddlNextYears.Text, ddlBar.Text, add, update);
objCommand.CommandText = updateSql;
objCommand.ExecuteNonQuery();
}
tan.Commit();
}
catch (Exception)
{
tan.Rollback();
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('复制失败！');</script>");
}
}
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('复制成功！');</script>");
}