/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.GENERAL_INSTRUCTION model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update GENERAL_INSTRUCTION set ");
strSql.Append("PID=:PID,");
strSql.Append("CLIENT_NO=:CLIENT_NO,");
strSql.Append("RECEIVED=:RECEIVED,");
strSql.Append("RECEIVED_BY=:RECEIVED_BY,");
strSql.Append("RELATES_TO=:RELATES_TO,");
strSql.Append("CONTENT_CN=:CONTENT_CN,");
strSql.Append("CONTENT_ORIGIN=:CONTENT_ORIGIN,");
strSql.Append("INSTRUCTOR=:INSTRUCTOR,");
strSql.Append("STATUS=:STATUS,");
strSql.Append("EXPIRE_DATE=:EXPIRE_DATE,");
strSql.Append("COMMENTS=:COMMENTS");
strSql.Append(" where PID=:PID ");
OracleParameter[] parameters =
{
new OracleParameter(":PID", OracleType.VarChar, 40),
new OracleParameter(":CLIENT_NO", OracleType.VarChar, 10),
new OracleParameter(":RECEIVED", OracleType.DateTime),
new OracleParameter(":RECEIVED_BY", OracleType.VarChar, 20),
new OracleParameter(":RELATES_TO", OracleType.VarChar, 30),
new OracleParameter(":CONTENT_CN", OracleType.VarChar, 2000),
new OracleParameter(":CONTENT_ORIGIN", OracleType.VarChar, 2000),
new OracleParameter(":INSTRUCTOR", OracleType.VarChar, 300),
new OracleParameter(":STATUS", OracleType.VarChar, 20),
new OracleParameter(":EXPIRE_DATE", OracleType.DateTime),
new OracleParameter(":COMMENTS", OracleType.VarChar, 4000)
};
parameters[0].Value = model.PID;
parameters[1].Value = model.CLIENT_NO;
parameters[2].Value = model.RECEIVED;
parameters[3].Value = model.RECEIVED_BY;
parameters[4].Value = model.RELATES_TO;
parameters[5].Value = model.CONTENT_CN;
parameters[6].Value = model.CONTENT_ORIGIN;
parameters[7].Value = model.INSTRUCTOR;
parameters[8].Value = model.STATUS;
parameters[9].Value = model.EXPIRE_DATE;
parameters[10].Value = model.COMMENTS;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.GENERAL_INSTRUCTION DataRowToModel(DataRow row)
{
Model.GENERAL_INSTRUCTION model = new Model.GENERAL_INSTRUCTION();
if (row != null)
{
if (row["PID"] != null)
{
model.PID = row["PID"].ToString();
}
if (row["CLIENT_NO"] != null)
{
model.CLIENT_NO = row["CLIENT_NO"].ToString();
}
if (row["RECEIVED"] != null && row["RECEIVED"].ToString() != "")
{
model.RECEIVED = DateTime.Parse(row["RECEIVED"].ToString());
}
if (row["RECEIVED_BY"] != null)
{
model.RECEIVED_BY = row["RECEIVED_BY"].ToString();
}
if (row["RELATES_TO"] != null)
{
model.RELATES_TO = row["RELATES_TO"].ToString();
}
if (row["CONTENT_CN"] != null)
{
model.CONTENT_CN = row["CONTENT_CN"].ToString();
}
if (row["CONTENT_ORIGIN"] != null)
{
model.CONTENT_ORIGIN = row["CONTENT_ORIGIN"].ToString();
}
if (row["INSTRUCTOR"] != null)
{
model.INSTRUCTOR = row["INSTRUCTOR"].ToString();
}
if (row["STATUS"] != null)
{
model.STATUS = row["STATUS"].ToString();
}
if (row["EXPIRE_DATE"] != null && row["EXPIRE_DATE"].ToString() != "")
{
model.EXPIRE_DATE = DateTime.Parse(row["EXPIRE_DATE"].ToString());
}
if (row["COMMENTS"] != null)
{
model.COMMENTS = row["COMMENTS"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.GENERAL_INSTRUCTION model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into GENERAL_INSTRUCTION(");
strSql.Append("PID,CLIENT_NO,RECEIVED,RECEIVED_BY,RELATES_TO,CONTENT_CN,CONTENT_ORIGIN,INSTRUCTOR,STATUS,EXPIRE_DATE,COMMENTS)");
strSql.Append(" values (");
strSql.Append(":PID,:CLIENT_NO,:RECEIVED,:RECEIVED_BY,:RELATES_TO,:CONTENT_CN,:CONTENT_ORIGIN,:INSTRUCTOR,:STATUS,:EXPIRE_DATE,:COMMENTS)");
OracleParameter[] parameters =
{
new OracleParameter(":PID", OracleType.VarChar, 40),
new OracleParameter(":CLIENT_NO", OracleType.VarChar, 10),
new OracleParameter(":RECEIVED", OracleType.DateTime),
new OracleParameter(":RECEIVED_BY", OracleType.VarChar, 20),
new OracleParameter(":RELATES_TO", OracleType.VarChar, 30),
new OracleParameter(":CONTENT_CN", OracleType.VarChar, 2000),
new OracleParameter(":CONTENT_ORIGIN", OracleType.VarChar, 2000),
new OracleParameter(":INSTRUCTOR", OracleType.VarChar, 300),
new OracleParameter(":STATUS", OracleType.VarChar, 20),
new OracleParameter(":EXPIRE_DATE", OracleType.DateTime),
new OracleParameter(":COMMENTS", OracleType.VarChar, 4000)
};
parameters[0].Value = model.PID;
parameters[1].Value = model.CLIENT_NO;
parameters[2].Value = model.RECEIVED;
parameters[3].Value = model.RECEIVED_BY;
parameters[4].Value = model.RELATES_TO;
parameters[5].Value = model.CONTENT_CN;
parameters[6].Value = model.CONTENT_ORIGIN;
parameters[7].Value = model.INSTRUCTOR;
parameters[8].Value = model.STATUS;
parameters[9].Value = model.EXPIRE_DATE;
parameters[10].Value = model.COMMENTS;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.GENERAL_INSTRUCTION GetModel(string PID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select PID,CLIENT_NO,RECEIVED,RECEIVED_BY,RELATES_TO,CONTENT_CN,CONTENT_ORIGIN,INSTRUCTOR,STATUS,EXPIRE_DATE,COMMENTS from GENERAL_INSTRUCTION ");
strSql.Append(" where PID=:PID ");
OracleParameter[] parameters =
{
new OracleParameter(":PID", OracleType.VarChar, 40)
};
parameters[0].Value = PID;
Model.GENERAL_INSTRUCTION model = new Model.GENERAL_INSTRUCTION();
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.GENERAL_INSTRUCTION model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.GENERAL_INSTRUCTION model)
{
return(dal.Add(model));
}