public void InsertPipelineArchive(ModelPipelineArchive pModel)
{
if (pModel == null)
{
return;
}
string strCommand = @"INSERT INTO PTTOUR.PIPELINE_ARCHIVE (RC_NAME, MONTH, YEAR, UPLOAD_DATE, UPLOAD_BY, REGION,FLAG_ID, VELOCITY ,FLOW, DIAMETER, LENGTH,EFFICIENCY, ROUGHNESS, LOAD,OUTSIDE_DIAMETER, WALL_THICKNESS, SERVICE_STATE)
VALUES ( '{0}',{1} , {2} , sysdate , '{3}' , {4} , {5} , {6} , {7}, {8}, {9}, {10}, {11}, {12}, {13}, {14}, '{15}')";
strCommand = string.Format(strCommand,
pModel.RC_NAME.Trim().Replace("'", "''"),
pModel.MONTH,
pModel.YEAR,
pModel.UPLOAD_BY.Trim().Replace("'", "''"),
pModel.REGION.Trim().Replace("'", "''"),
pModel.FLAG_ID,
pModel.VELOCITY,
pModel.FLOW,
pModel.DIAMETER,
pModel.LENGTH,
pModel.EFFICIENCY,
pModel.ROUGHNESS,
pModel.LOAD,
pModel.OUTSIDE_DIAMETER,
pModel.WALL_THICKNESS,
pModel.SERVICE_STATE.Replace("'", "''"));
var dal = new DAL.DAL();
dal.ExecuteNonQuery(strCommand);
dal = null;
}
public void UpdatePipelineArchive(ModelPipelineArchive pModel)
{
if (pModel == null)
{
return;
}
string strCommand = @"UPDATE PIPELINE_ARCHIVE SET
RC_NAME = '{0}',
UPLOAD_DATE = sysdate,
UPLOAD_BY = '{1}',
REGION = '{2}',
FLOW = {3},
VELOCITY = {4},
DIAMETER = {8},
LENGTH = {9},
EFFICIENCY = {10},
ROUGHNESS = {11},
LOAD = {12},
OUTSIDE_DIAMETER = {13},
WALL_THICKNESS = {14},
SERVICE_STATE = '{15}'
WHERE 1=1
AND PIPELINE_ID = {5}
AND MONTH = {6}
AND YEAR = {7}" ;
strCommand = string.Format(strCommand,
pModel.RC_NAME.Trim().Replace("'", "''"),
pModel.UPLOAD_BY.Trim().Replace("'", "''"),
pModel.REGION.Trim().Replace("'", "''"),
pModel.FLOW,
pModel.VELOCITY,
pModel.PIPELINE_ID,
pModel.MONTH,
pModel.YEAR,
pModel.DIAMETER,
pModel.LENGTH,
pModel.EFFICIENCY,
pModel.ROUGHNESS,
pModel.LOAD,
pModel.OUTSIDE_DIAMETER,
pModel.WALL_THICKNESS,
pModel.SERVICE_STATE.Replace("'", "''"));
var dal = new DAL.DAL();
dal.ExecuteNonQuery(strCommand);
dal = null;
}
