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