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 }