public int Update(UpInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update UpInfo set ");
strSql.Append("Title=@Title,FileName=@FileName,ApployTime=@ApployTime,BathCode=@BathCode,Secret=@Secret,CustomerEmail=@CustomerEmail,Type=@Type,Url=@Url,Status=@Status,CreatedTime=@CreatedTime,UpdateTime=@UpdateTime,DownTime=@DownTime,CompleteTime=@CompleteTime,Remarks=@Remarks ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@Title", DbTool.FixSqlParameter(model.Title))
, new SqlParameter("@FileName", DbTool.FixSqlParameter(model.FileName))
, new SqlParameter("@ApployTime", DbTool.FixSqlParameter(model.ApployTime))
, new SqlParameter("@BathCode", DbTool.FixSqlParameter(model.BathCode))
, new SqlParameter("@Secret", DbTool.FixSqlParameter(model.Secret))
, new SqlParameter("@CustomerEmail", DbTool.FixSqlParameter(model.CustomerEmail))
, new SqlParameter("@Type", DbTool.FixSqlParameter(model.Type))
, new SqlParameter("@Url", DbTool.FixSqlParameter(model.Url))
, new SqlParameter("@Status", DbTool.FixSqlParameter(model.Status))
, new SqlParameter("@CreatedTime", DbTool.FixSqlParameter(model.CreatedTime))
, new SqlParameter("@UpdateTime", DbTool.FixSqlParameter(model.UpdateTime))
, new SqlParameter("@DownTime", DbTool.FixSqlParameter(model.DownTime))
, new SqlParameter("@CompleteTime", DbTool.FixSqlParameter(model.CompleteTime))
, new SqlParameter("@Remarks", DbTool.FixSqlParameter(model.Remarks))
, new SqlParameter("@ID", model.ID)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public int Add(UpInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [UpInfo]");
strSql.Append("(Title,FileName,ApployTime,BathCode,Secret,CustomerEmail,Type,Url,Status,CreatedTime,UpdateTime,DownTime,CompleteTime,Remarks)");
strSql.Append(" values (@Title,@FileName,@ApployTime,@BathCode,@Secret,@CustomerEmail,@Type,@Url,@Status,@CreatedTime,@UpdateTime,@DownTime,@CompleteTime,@Remarks)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@Title", DbTool.FixSqlParameter(model.Title))
, new SqlParameter("@FileName", DbTool.FixSqlParameter(model.FileName))
, new SqlParameter("@ApployTime", DbTool.FixSqlParameter(model.ApployTime))
, new SqlParameter("@BathCode", DbTool.FixSqlParameter(model.BathCode))
, new SqlParameter("@Secret", DbTool.FixSqlParameter(model.Secret))
, new SqlParameter("@CustomerEmail", DbTool.FixSqlParameter(model.CustomerEmail))
, new SqlParameter("@Type", DbTool.FixSqlParameter(model.Type))
, new SqlParameter("@Url", DbTool.FixSqlParameter(model.Url))
, new SqlParameter("@Status", DbTool.FixSqlParameter(model.Status))
, new SqlParameter("@CreatedTime", DbTool.FixSqlParameter(model.CreatedTime))
, new SqlParameter("@UpdateTime", DbTool.FixSqlParameter(model.UpdateTime))
, new SqlParameter("@DownTime", DbTool.FixSqlParameter(model.DownTime))
, new SqlParameter("@CompleteTime", DbTool.FixSqlParameter(model.CompleteTime))
, new SqlParameter("@Remarks", DbTool.FixSqlParameter(model.Remarks))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
public UpInfoModel GetModel(int Id)
{
string sql = "select top 1 * from UpInfo where ID =" + Id;
UpInfoModel model = new UpInfoModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
if (dr.Read())
{
//var fields = DbTool.GetReaderFieldNames(dr);
//model = AutoBindDataReader(dr, fields);
BindDataReader(model, dr);
}
dr.Close();
return(model);
}
protected void BindDataReader(UpInfoModel model, SqlDataReader dr)
{
model.ID = DbTool.ConvertObject <System.Int32>(dr["ID"]);
model.Title = DbTool.ConvertObject <System.String>(dr["Title"]);
model.FileName = DbTool.ConvertObject <System.String>(dr["FileName"]);
model.ApployTime = DbTool.ConvertObject <System.DateTime>(dr["ApployTime"]);
model.BathCode = DbTool.ConvertObject <System.String>(dr["BathCode"]);
model.Secret = DbTool.ConvertObject <System.String>(dr["Secret"]);
model.CustomerEmail = DbTool.ConvertObject <System.String>(dr["CustomerEmail"]);
model.Type = DbTool.ConvertObject <System.Int32>(dr["Type"]);
model.Url = DbTool.ConvertObject <System.String>(dr["Url"]);
model.Status = DbTool.ConvertObject <System.Int32>(dr["Status"]);
model.CreatedTime = DbTool.ConvertObject <System.DateTime>(dr["CreatedTime"]);
model.UpdateTime = DbTool.ConvertObject <System.DateTime>(dr["UpdateTime"]);
model.DownTime = DbTool.ConvertObject <System.DateTime>(dr["DownTime"]);
model.CompleteTime = DbTool.ConvertObject <System.DateTime>(dr["CompleteTime"]);
model.Remarks = DbTool.ConvertObject <System.String>(dr["Remarks"]);
}
public List <UpInfoModel> GetModelList()
{
List <UpInfoModel> result = new List <UpInfoModel>();
string sql = "select * from UpInfo where 1=1";
UpInfoModel model = new UpInfoModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
//var fields = DbTool.GetReaderFieldNames(dr);
while (dr.Read())
{
//model = AutoBindDataReader(dr, fields);
model = new UpInfoModel();
BindDataReader(model, dr);
result.Add(model);
}
dr.Close();
return(result);
}
protected UpInfoModel AutoBindDataReader(SqlDataReader dr, params string[] fields)
{
var model = new UpInfoModel();
if (DbTool.HasFields("ID", fields))
{
model.ID = DbTool.ConvertObject <System.Int32>(dr["ID"]);
}
if (DbTool.HasFields("Title", fields))
{
model.Title = DbTool.ConvertObject <System.String>(dr["Title"]);
}
if (DbTool.HasFields("FileName", fields))
{
model.FileName = DbTool.ConvertObject <System.String>(dr["FileName"]);
}
if (DbTool.HasFields("ApployTime", fields))
{
model.ApployTime = DbTool.ConvertObject <System.DateTime>(dr["ApployTime"]);
}
if (DbTool.HasFields("BathCode", fields))
{
model.BathCode = DbTool.ConvertObject <System.String>(dr["BathCode"]);
}
if (DbTool.HasFields("Secret", fields))
{
model.Secret = DbTool.ConvertObject <System.String>(dr["Secret"]);
}
if (DbTool.HasFields("CustomerEmail", fields))
{
model.CustomerEmail = DbTool.ConvertObject <System.String>(dr["CustomerEmail"]);
}
if (DbTool.HasFields("Type", fields))
{
model.Type = DbTool.ConvertObject <System.Int32>(dr["Type"]);
}
if (DbTool.HasFields("Url", fields))
{
model.Url = DbTool.ConvertObject <System.String>(dr["Url"]);
}
if (DbTool.HasFields("Status", fields))
{
model.Status = DbTool.ConvertObject <System.Int32>(dr["Status"]);
}
if (DbTool.HasFields("CreatedTime", fields))
{
model.CreatedTime = DbTool.ConvertObject <System.DateTime>(dr["CreatedTime"]);
}
if (DbTool.HasFields("UpdateTime", fields))
{
model.UpdateTime = DbTool.ConvertObject <System.DateTime>(dr["UpdateTime"]);
}
if (DbTool.HasFields("DownTime", fields))
{
model.DownTime = DbTool.ConvertObject <System.DateTime>(dr["DownTime"]);
}
if (DbTool.HasFields("CompleteTime", fields))
{
model.CompleteTime = DbTool.ConvertObject <System.DateTime>(dr["CompleteTime"]);
}
if (DbTool.HasFields("Remarks", fields))
{
model.Remarks = DbTool.ConvertObject <System.String>(dr["Remarks"]);
}
return(model);
}
public ReturnValue ProcessUpInfoData(int upInfoId, string password)
{
ReturnValue _result = new ReturnValue();
YHFramework.DAL.ActionLogDal actionlog = new YHFramework.DAL.ActionLogDal();
YHFramework.DAL.UpInfoDal upinfodal = new YHFramework.DAL.UpInfoDal();
IProcessFile processFile = ProcessFileFactory.CreateNewObj(ProcessFileType.DaNeng_Hongquan);
UpInfoModel upinfodata = upinfodal.GetModel(upInfoId);
if (upinfodata.ID == 0)
{
_result.Success = false;
_result.ErrMessage = "没有找到任何数据";
}
if (upinfodata.Status != 0)
{
_result.Success = false;
_result.ErrMessage = "文件已经被处理完毕";
}
upinfodata.Status = 1;
upinfodata.Remarks += "开始处理" + upinfodata.Status + DateTime.Now.ToString("yyyyMMddHHmmss");
upinfodata.UpdateTime = DateTime.Now;
upinfodal.Update(upinfodata);
#region 准备文件
string filename = System.AppDomain.CurrentDomain.BaseDirectory + upinfodata.Url.Replace("/", "\\").TrimStart("\\".ToCharArray());
#endregion
#region 解压文件
_result = processFile.UnZipFiles(filename, password);
if (_result.Success == false)
{
#region 日志
actionlog.Add(new ActionLogModel()
{
ActionName = "离线文件绑定-" + "解压文件",
Notes = _result.ErrMessage,
KeyData = upinfodata.ID.ToString(),
UserName = Right.UserId.ToString(),
ActionResult = "失败",
CreateOn = DateTime.Now
});
#endregion
return(_result);
}
#endregion
List <string> taskFiles = _result.ObjectValue as List <string>;
if (taskFiles.Count == 0)
{
_result.Success = false;
_result.ErrMessage = "压缩包文件没有找到任何文件" + filename;
#region 日志
actionlog.Add(new ActionLogModel()
{
ActionName = "离线文件绑定-" + "解压文件",
Notes = _result.ErrMessage,
KeyData = upinfodata.ID.ToString(),
UserName = Right.UserId.ToString(),
ActionResult = "失败",
CreateOn = DateTime.Now
});
#endregion
return(_result);
}
#region 处理文件
foreach (string item in taskFiles)
{
ReturnValue _itemResult = processFile.RealseDataFile(item);
if (_itemResult.Success == false)
{
_result.MessageList.Add(_itemResult.ErrMessage);
#region 日志
actionlog.Add(new ActionLogModel()
{
ActionName = "离线文件绑定-" + "解析文件",
Notes = item + _itemResult.ErrMessage,
KeyData = upinfodata.ID.ToString(),
UserName = Right.UserId.ToString(),
ActionResult = "失败",
CreateOn = DateTime.Now
});
#endregion
continue;
}
string xlsfilename = System.IO.Path.GetFileName(item);
List <RequestBindData> reqeustdatalist = _itemResult.ObjectValue as List <RequestBindData>;
foreach (RequestBindData requestdata in reqeustdatalist)
{
ReturnValue _bindResult = ProcessBindBox(requestdata, upinfodata.Url + "--" + xlsfilename, true, true);
if (_bindResult.Success == false)
{
_result.MessageList.Add(_bindResult.ErrMessage);
#region 日志
actionlog.Add(new ActionLogModel()
{
ActionName = "离线文件绑定-" + "绑定",
Notes = requestdata.BoxNumber + "-" + item + "-" + _bindResult.ErrMessage,
KeyData = upinfodata.ID.ToString(),
UserName = Right.UserId.ToString(),
ActionResult = "失败",
CreateOn = DateTime.Now
});
#endregion
}
}
}
#endregion
#region 更新任务状态
upinfodata.Status = 2;
upinfodata.Remarks += "更新完毕" + upinfodata.Status + DateTime.Now.ToString("yyyyMMddHHmmss");
upinfodata.UpdateTime = DateTime.Now;
upinfodal.Update(upinfodata);
#endregion
#region 日志
actionlog.Add(new ActionLogModel()
{
ActionName = "离线文件绑定-" + "完成",
Notes = _result.ErrMessage + string.Join("-", _result.MessageList.ToArray <string>()),
KeyData = upinfodata.ID.ToString(),
UserName = Right.UserId.ToString(),
ActionResult = "执行完毕成功",
CreateOn = DateTime.Now
});
#endregion
return(_result);
}
