/// <summary> /// Delete Street Light Owner from Database /// </summary> /// <param name="stltOwner"></param> public void DelStreetLightOwner(StreetLightOwner stltOwner) { string sqlStmt = "Delete From STLT_OWNER_VL Where OWNER_CODE='{0}'"; sqlStmt = string.Format(sqlStmt, stltOwner.OwnerCode); CommonUtil.Execute(sqlStmt); }
/// <summary> /// Update Street Light Owner /// </summary> /// <param name="stltOwner"></param> public void UpdStreetLightOwner(StreetLightOwner stltOwner) { string sqlStmt = "Update STLT_OWNER_VL set OWNER_CODE='{0}',OWNER_NAME='{1}' Where OWNER_CODE='{2}'"; sqlStmt = string.Format(sqlStmt, stltOwner.OwnerCode, stltOwner.OwnerName, stltOwner.PrevOwnerCodeVal); CommonUtil.Execute(sqlStmt); }
/// <summary> /// Insert Street Light Owner /// </summary> /// <param name="stltOwner"></param> public void InsStreetLightOwner(StreetLightOwner stltOwner) { string sqlStmt = "Insert into STLT_OWNER_VL(OWNER_CODE,OWNER_NAME) " + "values('{0}','{1}')"; sqlStmt = string.Format(sqlStmt, stltOwner.OwnerCode, stltOwner.OwnerName); CommonUtil.Execute(sqlStmt); }
/// <summary> /// Persist Street Light Owner into Database /// </summary> /// <param name="stltOwner"></param> public void SaveStreetLightOwner(StreetLightOwner stltOwner) { if (stltOwner.EntityState == EntityMode.Add) { InsStreetLightOwner(stltOwner); } if (stltOwner.EntityState == EntityMode.Update) { UpdStreetLightOwner(stltOwner); } if (stltOwner.EntityState == EntityMode.Delete) { DelStreetLightOwner(stltOwner); } }