public int UpdateFtpIni(Neusoft.HISFC.Models.File.Ftpini info)
{
string strSql = "";
//update com_ftpini set FTP_ADDRESS ='{0}',FTP_USERNAME='******',FTP_PASSWORD ='******',FTP_REMOTEDIRECTORY='{3}',CLIENT_IPBEGIN='{4}',CLIENT_IPEND='{5}'
if (this.Sql.GetSql("Management.File.UpdateFtpIni", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, info.FtpAddress, info.FtpUserName, info.FtpPassWord, info.FtpRemoteDirectory, info.FtpClientBegin, info.FtpClientEnd);
}
catch (Exception ee)
{
string Error = ee.Message;
}
return(this.ExecNoQuery(strSql));
}
public int DeleteFtpIni(Neusoft.HISFC.Models.File.Ftpini info)
{
string strSql = "";
//delete com_ftpini where FTP_ADDRESS ='{0}',FTP_REMOTEDIRECTORY='{1}',CLIENT_IPBEGIN='{2}'
if (this.Sql.GetSql("Management.File.DeleteFtpIni", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, info.FtpAddress, info.FtpClientBegin, info.FtpClientEnd);
}
catch (Exception ee)
{
string Error = ee.Message;
}
return(this.ExecNoQuery(strSql));
}
public int InsertFtpIni(Neusoft.HISFC.Models.File.Ftpini info)
{
string strSql = "";
//insert com_ftpini (FTP_ADDRESS,FTP_USERNAME ,FTP_PASSWORD ,FTP_REMOTEDIRECTORY,CLIENT_IPBEGIN ,CLIENT_IPEND,OPER_CODE,OPER_DATE) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}',sysdate)
if (this.Sql.GetSql("Management.File.InsertFtpIni", ref strSql) == -1)
{
return(-1);
}
try
{
string Opercode = this.Operator.ID;
strSql = string.Format(strSql, info.FtpAddress, info.FtpUserName, info.FtpPassWord, info.FtpRemoteDirectory, info.FtpClientBegin, info.FtpClientEnd, Opercode);
}
catch (Exception ee)
{
string Error = ee.Message;
}
return(this.ExecNoQuery(strSql));
}
public ArrayList GetAllFtpIni()
{
Neusoft.HISFC.Models.File.Ftpini info;
System.Collections.ArrayList list = new ArrayList();
string strSql = "";
//select FTP_ADDRESS ,FTP_USERNAME,FTP_PASSWORD,FTP_REMOTEDIRECTORY,CLIENT_IPBEGIN,CLIENT_IPEND ,OPER_CODE from com_ftpini
if (this.Sql.GetSql("Management.File.GetAllFtpFileIni", ref strSql) == -1)
{
return(null);
}
try
{
this.ExecQuery(strSql);
while (this.Reader.Read())
{
info = new Neusoft.HISFC.Models.File.Ftpini();
try
{
info.FtpAddress = Reader[0].ToString();
}
catch (Exception ee)
{
string Error = ee.Message;
}
try
{
info.FtpUserName = Reader[1].ToString();
}
catch (Exception ee)
{
string Error = ee.Message;
}
try
{
info.FtpPassWord = Reader[2].ToString();
}
catch (Exception ee)
{
string Error = ee.Message;
}
try
{
info.FtpRemoteDirectory = Reader[3].ToString();
}
catch (Exception ee)
{
string Error = ee.Message;
}
try
{
info.FtpClientBegin = Reader[4].ToString();
}
catch (Exception ee)
{
string Error = ee.Message;
}
try
{
info.FtpClientEnd = Reader[5].ToString();
}
catch (Exception ee)
{
string Error = ee.Message;
}
if (Reader[6] != DBNull.Value)
{
info.OperDate = Convert.ToDateTime(Reader[6]);
}
list.Add(info);
info = null;
}
}
catch (Exception ee)
{
string Error = ee.Message;
list = null;
}
this.Reader.Close();
return(list);
}
