private bool DealImport(Framework.Task.Task task, ref string errmsg)
{
bool result = true;
this.BeginTran();
try
{
using (FileStream fs = File.OpenRead(task.paralist[0].ToString())) //打开myxls.xls文件
{
IWorkbook book = WorkbookFactory.Create(fs);
YwCyhService specService = new YwCyhService();
result = specService.DealWorkbook(book, ref errmsg);
}
if (result == false)
{
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 Save(Framework.Task.Task task, ref string errmsg)
{
bool result = true;
YwCyhService service = new YwCyhService();
YwCyh entity = task.Entity as YwCyh;
if (service.Validate("all", entity, ref errmsg) == false)
{
return(false);
}
BaseDao baseDao = new BaseDao();
if (entity.Did > 0)
{
baseDao.Update(entity);
}
else
{
bool res = service.CheckExist(entity);
if (res == true)
{
errmsg = "该差异化数据已经被定义";
return(false);
}
baseDao.Insert(entity);
}
if (result == true)
{
errmsg = "保存成功";
task.ParentRebind = true;
task.IsClose = true;
}
return(result);
}
public override bool Execute(Framework.Task.Task task, ref string errmsg)
{
bool result = true;
switch (task.Command)
{
case "export":
YwCyhService epService2 = new YwCyhService();
IWorkbook book2 = epService2.Export();
if (task.paralist == null)
{
task.paralist = new System.Collections.ArrayList();
}
task.paralist.Add(book2);
break;
case "exportExample":
YwCyhService epService1 = new YwCyhService();
IWorkbook book1 = epService1.ExportExample();
if (task.paralist == null)
{
task.paralist = new System.Collections.ArrayList();
}
task.paralist.Add(book1);
break;
case "importSave":
result = DealImport(task, ref errmsg);
if (result == false)
{
return(false);
}
break;
case "import":
task.Width = 400;
task.Height = 250;
task.PagePath = "ChargeImport.aspx";
break;
case "ucreate":
task.Width = 1100;
task.Height = 500;
task.PagePath = "ChargeEdit.aspx";
break;
case "uedit":
task.Width = 1100;
task.Height = 500;
task.PagePath = "ChargeEdit.aspx";
task.PageParam = task.CommandArgument;
break;
case "ushow":
task.Width = 1100;
task.Height = 500;
task.PagePath = "ChargeEdit.aspx";
task.PageParam = task.CommandArgument;
break;
case "udelete":
Delete(task, ref errmsg);
break;
case "save":
Save(task, ref errmsg);
break;
}
return(true);
}