public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; context.Response.Charset = "utf-8"; HttpPostedFile file = context.Request.Files["Filedata"]; if (file != null) { string AreaId = context.Request.Form["AreaId"]; IList <StringObjectDictionary> datas = NPOIManager.GetSheetData(file.InputStream, 0, true); List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>(); FamilyCamera familyCamera = new FamilyCamera() { DataSource = GlobalManager.DIKey_00012_UploadFile, OperatedBy = NormalSession.UserId.ToGuid(), OperatedOn = DateTime.Now, AreaId = AreaId }; foreach (var data in datas) { familyCamera.DeviceId = Guid.NewGuid(); StringObjectDictionary sod = familyCamera.ToStringObjectDictionary(false); IDictionary <string, object> dataItem = sod.MixInObject(data, false, e0571.web.core.Other.CaseSensitive.NORMAL); statements.Add(new IBatisNetBatchStatement { StatementName = familyCamera.GetCreateMethodName(), ParameterObject = dataItem, Type = SqlExecuteType.INSERT }); } BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements); //下面这句代码缺少的话,上传成功后上传队列的显示不会自动消失 context.Response.Write("1"); } else { context.Response.Write("0"); } }
public ModelInvokeResult <FamilyCameraPK> Create(FamilyCamera familyCamera) { ModelInvokeResult <FamilyCameraPK> result = new ModelInvokeResult <FamilyCameraPK> { Success = true }; try { List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>(); if (familyCamera.DeviceId == GlobalManager.GuidAsAutoGenerate) { familyCamera.DeviceId = Guid.NewGuid(); } /***********************begin 自定义代码*******************/ familyCamera.OperatedBy = NormalSession.UserId.ToGuid(); familyCamera.OperatedOn = DateTime.Now; familyCamera.DataSource = GlobalManager.DIKey_00012_ManualEdit; /***********************end 自定义代码*********************/ statements.Add(new IBatisNetBatchStatement { StatementName = familyCamera.GetCreateMethodName(), ParameterObject = familyCamera.ToStringObjectDictionary(false), Type = SqlExecuteType.INSERT }); /***********************begin 自定义代码*******************/ /***********************此处添加自定义代码*****************/ /***********************end 自定义代码*********************/ BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements); result.instance = new FamilyCameraPK { DeviceId = familyCamera.DeviceId }; } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }