public int Update(YHFramework.SysModel.ApployInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ApployInfo 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,AutoCheck=@AutoCheck,CheckResult=@CheckResult ");
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("@AutoCheck", DbTool.FixSqlParameter(model.AutoCheck))
, new SqlParameter("@CheckResult", DbTool.FixSqlParameter(model.CheckResult))
, new SqlParameter("@ID", model.ID)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public int Add(YHFramework.SysModel.ApployInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [ApployInfo]");
strSql.Append("(Title,FileName,ApployTime,BathCode,Secret,CustomerEmail,Type,Url,Status,CreatedTime,UpdateTime,DownTime,CompleteTime,Remarks,AutoCheck,CheckResult)");
strSql.Append(" values (@Title,@FileName,@ApployTime,@BathCode,@Secret,@CustomerEmail,@Type,@Url,@Status,@CreatedTime,@UpdateTime,@DownTime,@CompleteTime,@Remarks,@AutoCheck,@CheckResult)");
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))
, new SqlParameter("@AutoCheck", DbTool.FixSqlParameter(model.AutoCheck))
, new SqlParameter("@CheckResult", DbTool.FixSqlParameter(model.CheckResult))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
public YHFramework.SysModel.ApployInfoModel GetModel(string sqlwhere)
{
string sql = "select top 1 * from ApployInfo where 1=1 " + sqlwhere;
YHFramework.SysModel.ApployInfoModel model = new YHFramework.SysModel.ApployInfoModel();
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);
}
public List <YHFramework.SysModel.ApployInfoModel> GetModelList()
{
List <YHFramework.SysModel.ApployInfoModel> result = new List <YHFramework.SysModel.ApployInfoModel>();
string sql = "select * from ApployInfo where 1=1";
YHFramework.SysModel.ApployInfoModel model = new YHFramework.SysModel.ApployInfoModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
//var fields = DbTool.GetReaderFieldNames(dr);
while (dr.Read())
{
//model = AutoBindDataReader(dr, fields);
model = new YHFramework.SysModel.ApployInfoModel();
BindDataReader(model, dr);
result.Add(model);
}
dr.Close();
return(result);
}
public string GetBagStatusInfo(object appid)
{
string _result = "";
int _appId = Common.Fun.ConvertTo <int>(appid, 0);
YHFramework.DAL.ApployInfoDal appdal = new ApployInfoDal();
YHFramework.SysModel.ApployInfoModel appinfodata = appdal.GetModel(_appId);
if (appinfodata.AutoCheck == false)
{
int datarow = appdal.GetCodeRowCountByAppId(_appId);
FileInfo file = new FileInfo(System.AppDomain.CurrentDomain.BaseDirectory + appinfodata.Url);
if (file.Exists)
{
_result = "大小：" + file.Length / 1024 / 1024 + ",串码数量：" + datarow;
}
else
{
_result = "文件不存在";
}
appdal.UpdateBagInfo(_appId, _result);
#region 写日志
new YHFramework.DAL.ApployCheckLogDal().Add(new YHFramework.SysModel.ApployCheckLogModel()
{
ApployId = _appId,
CreateOn = DateTime.Now,
FileName = appinfodata.FileName,
Message = _result,
Number = datarow,
TypeCode = "BagCheck"
});
#endregion
}
else
{
_result = appinfodata.CheckResult;
}
return(_result);
}
protected void BindDataReader(YHFramework.SysModel.ApployInfoModel 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"]);
model.AutoCheck = DbTool.ConvertObject <System.Boolean>(dr["AutoCheck"]);
model.CheckResult = DbTool.ConvertObject <System.String>(dr["CheckResult"]);
}
protected YHFramework.SysModel.ApployInfoModel AutoBindDataReader(SqlDataReader dr, params string[] fields)
{
var model = new YHFramework.SysModel.ApployInfoModel();
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"]);
}
if (DbTool.HasFields("AutoCheck", fields))
{
model.AutoCheck = DbTool.ConvertObject <System.Boolean>(dr["AutoCheck"]);
}
if (DbTool.HasFields("CheckResult", fields))
{
model.CheckResult = DbTool.ConvertObject <System.String>(dr["CheckResult"]);
}
return(model);
}
public void ExportFileByZip(int apployInfoId)
{
YHFramework.DAL.ApployInfoDal apployInfoDal = new ApployInfoDal();
YHFramework.SysModel.ApployInfoModel model = apployInfoDal.GetModel(apployInfoId);
OutFileFactory FileFactory = new OutFileFactory();
IOutFile outfile = FileFactory.CreateNewObj(OutFileType.XLSX2);
FileInfo fileinfo = new FileInfo(model.FileName);
string fileanme = fileinfo.Name.Replace(fileinfo.Extension, "");
string tempfilename = fileanme + outfile.ExtName;
string zipfilename = fileanme + ".zip";
string tempfilepath = System.AppDomain.CurrentDomain.BaseDirectory + "tempfile\\";
string zipfilepath = System.AppDomain.CurrentDomain.BaseDirectory + "down\\";
if (Directory.Exists(tempfilepath) == false)
{
Directory.CreateDirectory(tempfilepath);
}
#region 清理文件
if (File.Exists(tempfilepath + tempfilename))
{
File.Delete(tempfilepath + tempfilename);
}
if (File.Exists(zipfilepath + zipfilename))
{
File.Delete(zipfilepath + zipfilename);
}
#endregion
#region 写入临时文件
int pagezise = 20000;
int pagecount = 0;
int datacount = 0;
YHFramework.DAL.CodeDataDal codedatadal = new CodeDataDal();
string sqlwhere = " and ApployInfoId=" + apployInfoId + " ";
datacount = codedatadal.GetCount(sqlwhere, "");
if (datacount % pagezise == 0)
{
pagecount = datacount / pagezise;
}
else
{
pagecount = datacount / pagezise + 1;
}
//for (int i = 1; i <= pagecount; i++)
for (int i = 1; i <= pagecount; i++)
{
DataTable dt = codedatadal.GetPageList(" a.* ", "", sqlwhere, i, pagezise);
outfile.OutFilePath = tempfilepath;
outfile.FileName = tempfilename;
outfile.OutFile(dt);
}
#endregion
#region 压缩
bool result = ZipCommon.ZipFile(tempfilepath + tempfilename, zipfilepath, fileanme, 5, 2048, model.Secret);
if (result)
{
Response.Write("压缩成功");
}
else
{
Response.Write("压缩失败");
}
#endregion
#region 更新任务
#endregion
}
