public void InsertGateArchive(ModelGateStationArchive pModel)
{
if (pModel == null)
{
return;
}
string strCommand = "INSERT INTO PTTOUR.GATESTATION_ARCHIVE (GATE_NAME, FLOW,MONTH,YEAR, UPLOAD_DATE,UPLOAD_BY, REGION, FLAG_ID , PRESSURE) VALUES ('{0}'," + (pModel.FLOW != null ? pModel.FLOW.ToString() : "NULL") + ",{1},{2},sysdate,'{3}',NULL,{4} , " + (pModel.PRESSURE != null ? pModel.PRESSURE.ToString() : "NULL") + " )";
strCommand = string.Format(strCommand,
pModel.GATE_NAME.Trim().Replace("'", "''"),
pModel.MONTH,
pModel.YEAR,
pModel.UPLOAD_BY.Trim().Replace("'", "''"),
//pModel.REGION.Trim().Replace("'", "''"),
pModel.FLAG_ID);
var dal = new DAL.DAL();
dal.ExecuteNonQuery(strCommand);
dal = null;
}
public void UpdateGateArchive(ModelGateStationArchive pModel)
{
if (pModel == null)
{
return;
}
string strCommand = "UPDATE GATESTATION_ARCHIVE SET GATE_NAME = '{0}',FLOW = " + (pModel.FLOW != null ? pModel.FLOW.ToString() : "NULL") + ",UPLOAD_DATE = sysdate,UPLOAD_BY = '{1}',REGION = NULL,PRESSURE = " + (pModel.PRESSURE != null ? pModel.PRESSURE.ToString() : "NULL") + " WHERE 1=1 AND GATE_ID = {2} AND MONTH = {3} AND YEAR = {4}";
strCommand = string.Format(strCommand,
pModel.GATE_NAME.Trim().Replace("'", "''"),
pModel.UPLOAD_BY.Trim().Replace("'", "''"),
//pModel.REGION,
pModel.GATE_ID,
pModel.MONTH,
pModel.YEAR);
var dal = new DAL.DAL();
dal.ExecuteNonQuery(strCommand);
dal = null;
}
