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 InvokeResult NullifySelected(string strDeviceIds)
{
InvokeResult result = new InvokeResult {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
string[] arrDeviceIds = strDeviceIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (arrDeviceIds.Length == 0)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
string statementName = new FamilyCamera().GetUpdateMethodName();
foreach (string strDeviceId in arrDeviceIds)
{
FamilyCamera familyCamera = new FamilyCamera {
DeviceId = strDeviceId.ToGuid(), Status = 0
};
/***********************begin 自定义代码*******************/
familyCamera.OperatedBy = NormalSession.UserId.ToGuid();
familyCamera.OperatedOn = DateTime.Now;
familyCamera.DataSource = GlobalManager.DIKey_00012_ManualEdit;
/***********************end 自定义代码*********************/
statements.Add(new IBatisNetBatchStatement {
StatementName = statementName, ParameterObject = familyCamera.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
});
}
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public ModelInvokeResult <FamilyCameraPK> Nullify(string strDeviceId)
{
ModelInvokeResult <FamilyCameraPK> result = new ModelInvokeResult <FamilyCameraPK> {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
Guid?_DeviceId = strDeviceId.ToGuid();
if (_DeviceId == null)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
FamilyCamera familyCamera = new FamilyCamera {
DeviceId = _DeviceId, Status = 0
};
/***********************begin 自定义代码*******************/
familyCamera.OperatedBy = NormalSession.UserId.ToGuid();
familyCamera.OperatedOn = DateTime.Now;
familyCamera.DataSource = GlobalManager.DIKey_00012_ManualEdit;
/***********************end 自定义代码*********************/
statements.Add(new IBatisNetBatchStatement {
StatementName = familyCamera.GetUpdateMethodName(), ParameterObject = familyCamera.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
});
/***********************begin 自定义代码*******************/
/***********************此处添加自定义代码*****************/
/***********************end 自定义代码*********************/
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
result.instance = new FamilyCameraPK {
DeviceId = _DeviceId
};
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
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);
}