public int UpdateFtpFileInfo(Neusoft.HISFC.Models.File.FtpFile info) { string strSql = ""; //update com_ftpfile set FILE_NAME = '{0}',UPDATE_FLAG='{1}',FILE_VERSION='{2}',LOCAL_DIRECTORY='{3}' if (this.Sql.GetSql("Management.File.UpdateFtpFileInfo", ref strSql) == -1) { return(-1); } try { strSql = string.Format(strSql, info.Name, info.UpdateFlag, info.FileVersion, info.LocalDirectory, this.Operator.ID, info.UpdateDate); } catch (Exception ee) { string Error = ee.Message; } return(this.ExecNoQuery(strSql)); }
public int DeleteFtpFileInfo(Neusoft.HISFC.Models.File.FtpFile info) { //delete com_ftpfile where FILE_NAME='{0}',FILE_VERSION ='{1}' string strSql = ""; if (this.Sql.GetSql("Management.File.DeleteFtpFileInfo", ref strSql) == -1) { return(-1); } try { strSql = string.Format(strSql, info.Name, info.FileVersion); } catch (Exception ee) { string Error = ee.Message; } return(this.ExecNoQuery(strSql)); }
public int InsertFtpFileInfo(Neusoft.HISFC.Models.File.FtpFile info) { string strSql = ""; string OPER_CODE = Operator.ID; //insert into com_ftpfile (FILE_NAME,UPDATE_FLAG ,FILE_VERSION,LOCAL_DIRECTORY,OPER_CODE,OPER_DATE)values('{0}','{1}','{2}','{3}','{4}',sysdate) if (this.Sql.GetSql("Management.File.InsertFtpFileInfo", ref strSql) == -1) { return(-1); } try { strSql = string.Format(strSql, info.Name, info.UpdateFlag, info.FileVersion, info.LocalDirectory, OPER_CODE); } catch (Exception ee) { string Error = ee.Message; } return(this.ExecNoQuery(strSql)); }
public ArrayList GetAllFtpFileInfo() { Neusoft.HISFC.Models.File.FtpFile file; ArrayList list = new ArrayList(); string strSql = ""; //select FILE_NAME,UPDATE_FLAG,FILE_VERSION,LOCAL_DIRECTORY,OPER_DATE from com_ftpfile if (this.Sql.GetSql("Management.File.GetAllFtpFileInfo", ref strSql) == -1) { return(null); } try { this.ExecQuery(strSql); while (this.Reader.Read()) { file = new Neusoft.HISFC.Models.File.FtpFile(); try { file.Name = this.Reader[0].ToString(); } catch (Exception ee) { string Error = ee.Message; } try { file.UpdateFlag = Reader[1].ToString(); } catch (Exception ee) { string Error = ee.Message; } try { file.FileVersion = Reader[2].ToString(); } catch (Exception ee) { string Error = ee.Message; } try { file.LocalDirectory = Reader[3].ToString(); } catch (Exception ee) { string Error = ee.Message; } if (Reader[4] != DBNull.Value) { file.UpdateDate = Convert.ToDateTime(Reader[4]); } list.Add(file); file = null; } } catch (Exception ee) { this.Reader.Close(); string Error = ee.Message; list = null; } this.Reader.Close(); return(list); }