/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.DEVICEATTACH model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("insert into DEVICEATTACH(");
strSql.Append("DEVICECODE,SEAAREA,PROVINCE,BAY,BUREAUDEVICE,LOCALDEVICE,SERVICE");
strSql.Append(") values (");
strSql.Append(":DEVICECODE,:SEAAREA,:PROVINCE,:BAY,:BUREAUDEVICE,:LOCALDEVICE,:SERVICE");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":DEVICECODE", OracleType.Char, 6),
new OracleParameter(":SEAAREA", OracleType.VarChar, 50),
new OracleParameter(":PROVINCE", OracleType.VarChar, 50),
new OracleParameter(":BAY", OracleType.VarChar, 50),
new OracleParameter(":BUREAUDEVICE", OracleType.VarChar, 50),
new OracleParameter(":LOCALDEVICE", OracleType.VarChar, 50),
new OracleParameter(":SERVICE", OracleType.VarChar, 50)
};
parameters[0].Value = model.DEVICECODE;
parameters[1].Value = model.SEAAREA;
parameters[2].Value = model.PROVINCE;
parameters[3].Value = model.BAY;
parameters[4].Value = model.BUREAUDEVICE;
parameters[5].Value = model.LOCALDEVICE;
parameters[6].Value = model.SERVICE;
dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.DEVICEATTACH GetModel()
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("select DEVICECODE, SEAAREA, PROVINCE, BAY, BUREAUDEVICE, LOCALDEVICE, SERVICE ");
strSql.Append(" from DEVICEATTACH ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
};
Entity.DEVICEATTACH model = new Entity.DEVICEATTACH();
DataTable ds = dbHelper.GetDataTable(strSql.ToString(), parameters);
if (ds.Rows.Count > 0)
{
model.DEVICECODE = ds.Rows[0]["DEVICECODE"].ToString();
model.SEAAREA = ds.Rows[0]["SEAAREA"].ToString();
model.PROVINCE = ds.Rows[0]["PROVINCE"].ToString();
model.BAY = ds.Rows[0]["BAY"].ToString();
model.BUREAUDEVICE = ds.Rows[0]["BUREAUDEVICE"].ToString();
model.LOCALDEVICE = ds.Rows[0]["LOCALDEVICE"].ToString();
model.SERVICE = ds.Rows[0]["SERVICE"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.DEVICEATTACH model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("update DEVICEATTACH set ");
strSql.Append(" DEVICECODE = :DEVICECODE , ");
strSql.Append(" SEAAREA = :SEAAREA , ");
strSql.Append(" PROVINCE = :PROVINCE , ");
strSql.Append(" BAY = :BAY , ");
strSql.Append(" BUREAUDEVICE = :BUREAUDEVICE , ");
strSql.Append(" LOCALDEVICE = :LOCALDEVICE , ");
strSql.Append(" SERVICE = :SERVICE ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":DEVICECODE", OracleType.Char, 6),
new OracleParameter(":SEAAREA", OracleType.VarChar, 50),
new OracleParameter(":PROVINCE", OracleType.VarChar, 50),
new OracleParameter(":BAY", OracleType.VarChar, 50),
new OracleParameter(":BUREAUDEVICE", OracleType.VarChar, 50),
new OracleParameter(":LOCALDEVICE", OracleType.VarChar, 50),
new OracleParameter(":SERVICE", OracleType.VarChar, 50)
};
parameters[0].Value = model.DEVICECODE;
parameters[1].Value = model.SEAAREA;
parameters[2].Value = model.PROVINCE;
parameters[3].Value = model.BAY;
parameters[4].Value = model.BUREAUDEVICE;
parameters[5].Value = model.LOCALDEVICE;
parameters[6].Value = model.SERVICE;
int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
