private void HistoryExport(Framework.Task.Task task, ref string errmsg)
{
YwData entity = (YwData)task.Entity;
YwDataService service = new YwDataService();
YwData param = new YwData();
param.BegD = DateTime.Parse("" + entity.Year + "-" + entity.Month + "-01");
param.EndD = param.BegD.AddMonths(1);
param.Depart = entity.Depart;
param.Ywy = entity.Ywy;
IWorkbook book = null;
if (entity.SysUserType == "ywy")
{
param.Ywy = entity.SysUserCode;
book = service.QueryExportData("ywy", param, ref errmsg);
}
else
{
param.GetOpType = "departPri";
book = service.QueryExportData("all", param, ref errmsg);
}
if (task.paralist == null)
{
task.paralist = new System.Collections.ArrayList();
}
task.paralist.Add(book);
}
private void button1_Click(object sender, EventArgs e)
{
YwDataService service = new YwDataService();
IList <YwData> dataList = GetYwDataList();
List <YwData> tempList = new List <YwData>();
if (dataList.Count > 0)
{
foreach (YwData temp in dataList)
{
if (temp.Status == "2" || temp.Status == "3" || temp.Status == "4" || temp.Status == "5")
{
tempList.Add(temp);
}
}
foreach (YwData temp in tempList)
{
//if (temp.Status == "2" || temp.Status == "3")
//{
// if (temp.Bbr.Length <= 4)
// {
// if (temp.Sfypz == "是")
// {
// service.FirstCalculate(1, temp);
// service.SeconeCalculate(temp);
// }
// }
// else
// {
// service.FirstCalculate(1, temp);
// service.SeconeCalculate(temp);
// }
//}
try
{
service.FirstCalculate(1, temp);
service.SeconeCalculate(temp);
//if (temp.Status=="2"||temp.Status == "3")
//{
// service.FirstCalculate(1, temp);
//}
//else
//{
// service.FirstCalculate(1, temp);
// service.SeconeCalculate(temp);
//}
temp.Status = "4";
baseD.Update(temp);
}
catch
{
continue;
}
}
}
MessageBox.Show("Ok");
}
private void DataExportLastZQ(Framework.Task.Task task, ref string errmsg)
{
YwData entity = (YwData)task.Entity;
YwDataService service = new YwDataService();
YwData param = new YwData();
param.EndD = service.GetBegDate();
param.BegD = param.EndD.AddMonths(-1);
IWorkbook book = null;
if (entity.SysUserType == "ywy")
{
param.Ywy = entity.Ywy;
book = service.QueryExportData("ywy", param, ref errmsg);
}
else
{
param.GetOpType = "departPri";
book = service.QueryExportData("all", param, ref errmsg);
}
if (task.paralist == null)
{
task.paralist = new System.Collections.ArrayList();
}
task.paralist.Add(book);
}
private bool CwSave(Framework.Task.Task task, ref string errmsg)
{
bool result = true;
try
{
YwData entity = task.Entity as YwData;
BaseDao baseDao = new BaseDao();
YwDataService service = new YwDataService();
DateTime begD = service.GetBegDate();
if (entity.CreateDate < begD)
{
throw new Exception("数据已经超过结账日，不允许修改");
}
service.FirstCalculate(1, entity);
service.SeconeCalculate(entity);
entity.CwConfirm = DateTime.Now;
baseDao.Update(entity);
if (result == true)
{
errmsg = "保存成功";
task.ParentRebind = true;
task.IsClose = true;
}
}
catch (Exception ex)
{
errmsg = "保存失败:" + ex.Message;
return(false);
}
return(result);
}
//承保审核退回
private bool CbUnComfirm(Framework.Task.Task task, ref string errmsg)
{
bool result = true;
try
{
YwData entity = task.Entity as YwData;
BaseDao baseDao = new BaseDao();
YwDataService service = new YwDataService();
entity.Status = "2";
entity.Cbback = "Y";
DateTime begD = service.GetBegDate();
if (entity.CreateDate < begD)
{
throw new Exception("数据已经超过结账日，不允许修改");
}
baseDao.Update(entity);
if (result == true)
{
errmsg = "操作成功";
task.ParentRebind = true;
task.IsClose = true;
}
}
catch (Exception ex)
{
errmsg = ex.Message;
return(false);
}
return(result);
}
//承保编辑保存
private bool CbSave(Framework.Task.Task task, ref string errmsg)
{
bool result = true;
try
{
YwData entity = task.Entity as YwData;
YwDataService service = new YwDataService();
if (service.Validate("cbEdit", entity, ref errmsg) == false)
{
return(false);
}
DateTime begD = service.GetBegDate();
if (entity.CreateDate < begD)
{
throw new Exception("数据已经超过结账日，不允许修改");
}
BaseDao baseDao = new BaseDao();
if (entity.Sybf <= 0)
{
entity.Xz = "交强险";
}
else
{
entity.Xz = "商业险";
}
if (entity.Xz == "商业险")
{
entity.Status = "2";
}
else
{
entity.Status = "4";
service.FirstCalculate(1, entity);
service.SeconeCalculate(entity);
}
entity.CbSubmit = DateTime.Now;
int count = baseDao.Update(entity);
if (count <= 0)
{
errmsg = "数据在页面显示后被其他人修改过，请重新打开编辑";
task.ParentRebind = true;
task.IsClose = true;
return(false);
}
if (result == true)
{
errmsg = "保存成功";
task.ParentRebind = true;
task.IsClose = true;
}
}
catch (Exception ex)
{
errmsg = ex.Message;
return(false);
}
return(result);
}
private void YwyExportLastZQ(Framework.Task.Task task, ref string errmsg)
{
YwData entity = (YwData)task.Entity;
YwDataService service = new YwDataService();
YwData param = new YwData();
param.EndD = service.GetBegDate();
param.BegD = param.EndD.AddMonths(-1);
param.Ywy = entity.Ywy;
IWorkbook book = service.QueryExportData("ywy", param, ref errmsg);
if (task.paralist == null)
{
task.paralist = new System.Collections.ArrayList();
}
task.paralist.Add(book);
}
public override bool Execute(Framework.Task.Task task, ref string errmsg)
{
switch (task.Command)
{
case "jz": //结帐
YwDataService service = new YwDataService();
this.BeginTran();
try
{
service.DealJZ();
this.CommitTran();
}
catch (Exception ex)
{
this.RollbackTran();
}
break;
}
return(true);
}
//承保导出本月所有数据
private void ExportAll(Framework.Task.Task task, ref string errmsg)
{
YwData entity = task.Entity as YwData;
YwDataService service = new YwDataService();
YwData param = new YwData();
DateTime dtTemp = DateTime.Now.AddMonths(1);
param.BegD = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
param.EndD = new DateTime(dtTemp.Year, dtTemp.Month, 1);
param.GetOpType = "CbExportAll";
IWorkbook book = service.ExportData(param, ref errmsg);
if (task.paralist == null)
{
task.paralist = new System.Collections.ArrayList();
}
task.paralist.Add(book);
}
//承保新增保存
private bool CbCreateSave(Framework.Task.Task task, ref string errmsg)
{
bool result = true;
try
{
BaseDao baseDao = new BaseDao();
YwData entity = task.Entity as YwData;
YwDataService service = new YwDataService();
result = service.Validate("cbCreate", entity, ref errmsg);
if (result == false)
{
return(false);
}
if (entity.Sybf <= 0)
{
entity.Xz = "交强险";
}
else
{
entity.Xz = "商业险";
}
entity.Status = "4";
service.FirstCalculate(1, entity);
service.SeconeCalculate(entity);
entity.CbSubmit = DateTime.Now;
baseDao.Insert(entity);
errmsg = "新增成功";
task.ParentRebind = true;
task.IsClose = true;
}
catch (Exception ex)
{
errmsg = ex.Message;
return(false);
}
return(result);
}
//承保数据导入处理
private bool DealImport(Framework.Task.Task task, ref string errmsg)
{
bool result = true;
this.BeginTran();
try
{
string errType = "";
XSSFWorkbook errBook = new XSSFWorkbook();
using (FileStream fs = File.OpenRead(task.paralist[0].ToString()))
{
IWorkbook book = WorkbookFactory.Create(fs);
YwDataService service = new YwDataService();
result = service.DealCbImport(book, errBook, ref errType, ref errmsg);
}
task.paralist = new System.Collections.ArrayList();
if (result == false)
{
if (errType == "content")
{
task.paralist.Add(errBook);
}
this.RollbackTran();
return(false);
}
this.CommitTran();
errmsg = "上传成功";
task.ParentRebind = true;
task.IsClose = true;
}
catch (Exception ex)
{
errmsg = ex.Message;
this.RollbackTran();
return(false);
}
return(true);
}
private bool YwySubmit(Framework.Task.Task task, ref string errmsg)
{
bool result = true;
this.BeginTran();
try
{
YwData entity = task.Entity as YwData;
BaseDao baseDao = new BaseDao();
YwAttach att = new YwAttach();
att.Type = "1";
att.Dataid = entity.Did;
IList <YwAttach> attList = baseDao.List(att);
if (attList != null && attList.Count > 0)
{
entity.AttachmentCount = attList.Count;
}
else
{
entity.AttachmentCount = 0;
}
entity.Status = "3";
entity.YwySubmit = DateTime.Now;
if (entity.Bbr.Length <= 4)
{
if (entity.Sfypz == "是")
{
YwDataService service = new YwDataService();
service.FirstCalculate(1, entity);
service.SeconeCalculate(entity);
}
}
else
{
YwDataService service = new YwDataService();
service.FirstCalculate(1, entity);
service.SeconeCalculate(entity);
}
int count = baseDao.Update(entity);
if (count <= 0)
{
errmsg = "数据在页面显示后被其他人修改过，请重新打开编辑";
task.ParentRebind = true;
task.Rebind = true;
task.IsClose = true;
return(false);
}
//文件压缩
//删除压缩文件
att.Type = "2";
baseDao.DeleteUdf("YwAttachDeleteByType", att);
//重新压缩附件
if (attList != null && attList.Count > 0)
{
string zipdic = attList[0].Dic;
string zipFileN = Guid.NewGuid().ToString() + ".zip";
string path = zipdic + zipFileN;
using (ZipFile zip = ZipFile.Create(@path))
{
zip.BeginUpdate();
foreach (YwAttach attTemp in attList)
{
string pathT = attTemp.Dic + attTemp.FileN;
zip.Add(@pathT, attTemp.FileN);
}
zip.CommitUpdate();
}
att.Type = "2";
att.Dic = zipdic;
att.FileN = zipFileN;
att.RealName = zipFileN;
att.Dataid = entity.Did;
baseDao.Insert(att);
}
if (result == true)
{
errmsg = "保存成功";
task.ParentRebind = true;
task.IsClose = true;
}
this.CommitTran();
}
catch (Exception ex)
{
this.RollbackTran();
errmsg = ex.Message;
}
return(result);
}
