コード例 #1
0
        /// <summary>
        /// Delete Street Light Description from Database
        /// </summary>
        /// <param name="stltDesc"></param>
        private void DelStreetLightDescription(StreetLightDescription stltDesc)
        {
            string sqlStmt = "Delete From STLT_DESC_VL Where  DESCRIPTION_ID={0}";

            sqlStmt = string.Format(sqlStmt, stltDesc.DescriptionID);
            CommonUtil.Execute(sqlStmt);
        }
コード例 #2
0
        /// <summary>
        /// Update Street Light Description
        /// </summary>
        /// <param name="stltDesc"></param>
        private void UpdStreetLightDescription(StreetLightDescription stltDesc)
        {
            string sqlStmt = "Update STLT_DESC_VL set DESCRIPTION='{0}',MSLA_DATE=TO_DATE('{1}','MM/DD/YYYY') Where DESCRIPTION_ID={2}";

            sqlStmt = string.Format(sqlStmt, stltDesc.DESCRIPTION, stltDesc.MSLA_Date.ToShortDateString(), stltDesc.DescriptionID);
            CommonUtil.Execute(sqlStmt);
        }
コード例 #3
0
        /// <summary>
        /// Insert Street Light Description
        /// </summary>
        /// <param name="stltDesc"></param>
        private void InsStreetLightDescription(StreetLightDescription stltDesc)
        {
            string sqlStmt = "Insert into STLT_DESC_VL(DESCRIPTION_ID,DESCRIPTION,MSLA_DATE) " +
                             "values((select nvl(max(DESCRIPTION_ID),0)+1 from STLT_DESC_VL),'{0}',TO_DATE('{1}','MM/DD/YYYY'))";

            sqlStmt = string.Format(sqlStmt, stltDesc.DESCRIPTION, stltDesc.MSLA_Date.ToShortDateString());
            CommonUtil.Execute(sqlStmt);
        }
コード例 #4
0
 /// <summary>
 /// Persist Street Light Description into Database
 /// </summary>
 /// <param name="stltDesc"></param>
 public void SaveStreetLightDesc(StreetLightDescription stltDesc)
 {
     if (stltDesc.EntityState == EntityMode.Add)
     {
         InsStreetLightDescription(stltDesc);
     }
     if (stltDesc.EntityState == EntityMode.Update)
     {
         UpdStreetLightDescription(stltDesc);
     }
     if (stltDesc.EntityState == EntityMode.Delete)
     {
         DelStreetLightDescription(stltDesc);
     }
 }