/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.PTFILE_CHECK model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update PTFILE_CHECK set ");
strSql.Append("CASENO=:CASENO,");
strSql.Append("NAME=:NAME,");
strSql.Append("PATH=:PATH,");
strSql.Append("TSIZE=:TSIZE,");
strSql.Append("CT=:CT,");
strSql.Append("MT=:MT,");
strSql.Append("LASTSEEN=:LASTSEEN,");
strSql.Append("LASTBKUP=:LASTBKUP,");
strSql.Append("LASTVERIFY=:LASTVERIFY");
strSql.Append(" where NAME=:NAME ");
OracleParameter[] parameters =
{
new OracleParameter(":CASENO", OracleType.VarChar, 80),
new OracleParameter(":NAME", OracleType.VarChar, 400),
new OracleParameter(":PATH", OracleType.VarChar, 200),
new OracleParameter(":TSIZE", OracleType.VarChar, 20),
new OracleParameter(":CT", OracleType.VarChar, 40),
new OracleParameter(":MT", OracleType.VarChar, 40),
new OracleParameter(":LASTSEEN", OracleType.VarChar, 40),
new OracleParameter(":LASTBKUP", OracleType.DateTime),
new OracleParameter(":LASTVERIFY", OracleType.DateTime)
};
parameters[0].Value = model.CASENO;
parameters[1].Value = model.NAME;
parameters[2].Value = model.PATH;
parameters[3].Value = model.TSIZE;
parameters[4].Value = model.CT;
parameters[5].Value = model.MT;
parameters[6].Value = model.LASTSEEN;
parameters[7].Value = model.LASTBKUP;
parameters[8].Value = model.LASTVERIFY;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.PTFILE_CHECK DataRowToModel(DataRow row)
{
Model.PTFILE_CHECK model = new Model.PTFILE_CHECK();
if (row != null)
{
if (row["CASENO"] != null)
{
model.CASENO = row["CASENO"].ToString();
}
if (row["NAME"] != null)
{
model.NAME = row["NAME"].ToString();
}
if (row["PATH"] != null)
{
model.PATH = row["PATH"].ToString();
}
if (row["TSIZE"] != null)
{
model.TSIZE = row["TSIZE"].ToString();
}
if (row["CT"] != null)
{
model.CT = row["CT"].ToString();
}
if (row["MT"] != null)
{
model.MT = row["MT"].ToString();
}
if (row["LASTSEEN"] != null)
{
model.LASTSEEN = row["LASTSEEN"].ToString();
}
if (row["LASTBKUP"] != null && row["LASTBKUP"].ToString() != "")
{
model.LASTBKUP = DateTime.Parse(row["LASTBKUP"].ToString());
}
if (row["LASTVERIFY"] != null && row["LASTVERIFY"].ToString() != "")
{
model.LASTVERIFY = DateTime.Parse(row["LASTVERIFY"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.PTFILE_CHECK model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PTFILE_CHECK(");
strSql.Append("CASENO,NAME,PATH,TSIZE,CT,MT,LASTSEEN,LASTBKUP,LASTVERIFY)");
strSql.Append(" values (");
strSql.Append(":CASENO,:NAME,:PATH,:TSIZE,:CT,:MT,:LASTSEEN,:LASTBKUP,:LASTVERIFY)");
OracleParameter[] parameters =
{
new OracleParameter(":CASENO", OracleType.VarChar, 80),
new OracleParameter(":NAME", OracleType.VarChar, 400),
new OracleParameter(":PATH", OracleType.VarChar, 200),
new OracleParameter(":TSIZE", OracleType.VarChar, 20),
new OracleParameter(":CT", OracleType.VarChar, 40),
new OracleParameter(":MT", OracleType.VarChar, 40),
new OracleParameter(":LASTSEEN", OracleType.VarChar, 40),
new OracleParameter(":LASTBKUP", OracleType.DateTime),
new OracleParameter(":LASTVERIFY", OracleType.DateTime)
};
parameters[0].Value = model.CASENO;
parameters[1].Value = model.NAME;
parameters[2].Value = model.PATH;
parameters[3].Value = model.TSIZE;
parameters[4].Value = model.CT;
parameters[5].Value = model.MT;
parameters[6].Value = model.LASTSEEN;
parameters[7].Value = model.LASTBKUP;
parameters[8].Value = model.LASTVERIFY;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.PTFILE_CHECK GetModel(string NAME)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select CASENO,NAME,PATH,TSIZE,CT,MT,LASTSEEN,LASTBKUP,LASTVERIFY from PTFILE_CHECK ");
strSql.Append(" where NAME=:NAME ");
OracleParameter[] parameters =
{
new OracleParameter(":NAME", OracleType.VarChar, 400)
};
parameters[0].Value = NAME;
Model.PTFILE_CHECK model = new Model.PTFILE_CHECK();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.PTFILE_CHECK model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.PTFILE_CHECK model)
{
return(dal.Add(model));
}
